Table Abbreviation Description Module Activity code
SDELIVERY SDH Delivery header Sales  

Key Description Duplicates Activity code
SDH0 SDHNUM No  
SDH1 BPCORD+BPAADD+DLVDAT Yes  
SDH2 DLVDAT+SDHNUM No  
SDH3 INVFLG+CFMFLG+SALFCY+BPCINV Yes  
SDH4 CPY+EECNUMDEB+DLVDAT Yes DEB

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ADRVAL Validated   M 4 1     LTA
AMTTAX Tax amount   MD1         KUS
ARVDAT Arrival date   D          
ATDTCOD AT code   A 100       KPO
AUUID Single identifier   AUUID          
BASTAX Tax basis   MD1         KUS
BETCPY Intercompany   M 4 1      
BETFCY Intersite   M 4 1      
BOLNUM BOL number   VCR          
BPAADD Delivery address   BPD     [BPD]BPD0=BPCORD;BPAADD Block  
BPAINV Invoice address code   ADR          
BPCGRU Group customer   BPR     [BPR]BPR0=[SDH]BPCGRU Block  
BPCINV Bill-to customer   BPR     [BPR]BPR0=[SDH]BPCINV Block  
BPCLOC Customer location   LOC     [STC]STC0=STOFCY;BPCLOC Other  
BPCORD Sold-to   BPR     [BPR]BPR0=[SDH]BPCORD Block  
BPCPYR Pay-by   BPR     [BPR]BPR0=[SDH]BPCPYR Block  
BPDADDLIG Delivery address 3 ADL          
BPDCRY Delivery country   CRY     [TCY]TCY0=[SDH]BPDCRY Block  
BPDCRYNAM Delivery country name   NCY          
BPDCTY Delivery city   CTY          
BPDNAM Ship-to customer name 2 NAM          
BPDPOSCOD Deliv postal code   POS          
BPDSAT Delivery country   SAT          
BPIADDLIG Billing address 3 ADL          
BPICRY Country of invoice   CRY     [TCY]TCY0=[SDH]BPICRY Block  
BPICRYNAM Invoice country name   NCY          
BPICTY Invoice city   CTY          
BPIEECNUM EU identification   A 20       DEB
BPINAM Bill-to customer name 2 NAM          
BPIPOSCOD Invoice postal code   POS          
BPISAT Invoice state   SAT          
BPTNUM Carrier   BPT     [BPT]BPT0=[SDH]BPTNUM Block  
CAI CAI number   A 10       KAG
CCE Dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CFMFLG Validated   M 4 1      
CHGRAT Currency rate   DCB 5.6        
CHGTYP Rate type   M 15 202      
CNDNAM Delivery contact   AIN     [AIN]AIN0=CNDNAM Block  
CNINAM Invoice contact   AIN     [AIN]AIN0=CNINAM Block  
COPNBR No. pckg slip copies   C 1        
CPY Company   CPY     [CPY]CPY0=[SDH]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CUR Currency   CUR     [TCU]TCU0=[SDH]CUR Block  
DATVLYCAI CAI validity date   D 1       KAG
DAYLTI Delivery lead time   C 3        
DEP Settlement discount   TDA     [TDA]TDA0=DEP;[V]GSUPCLE Block  
DIE Dimension type code   DIE     [DIE]DIE0=[SDH]DIE Block ANA
DISCRGTYP Discount / charge type   M 10 255     SPR
DLVATI Book amount +tax   MD1          
DLVATIL Dy amount tax incl. cy   MD1          
DLVDAT Delivery date   D          
DLVHOU Delivery time   HM          
DLVINVATI Valuation + tax   MD1          
DLVINVATIL Costing tax incl. cy   MD1          
DLVINVNOT Valuation - tax   MD1          
DLVINVNOTL Costing tax excl. cy   MD1          
DLVNOT Book amount -tax   MD1          
DLVNOTL Dy amount tax excl. cy   MD1          
DPEDAT Departure date   D          
DRN Route no.   M 15 409      
DSPTOTQTY Quantity total   DCB 9.6        
DSPTOTVOL Volume aggregation   QTY          
DSPTOTWEI Weight aggregation   QTY          
DSPVOU Volume unit   UOM     [TUN]TUN0=[SDH]DSPVOU Block  
DSPWEU Weight unit   UOM     [TUN]TUN0=[SDH]DSPWEU Block  
DUDCLC Due date origin   M 15 407      
EECICT Incoterm   ICT     [ICTH]ICT0=[SDH]EECICT Block  
EECLOC Intrastat transport location   M 15 236     DEB
EECNAT Transaction nature   TEC     [TEC]TEC0=EECNAT;[V]GSUPCLE Block DEB
EECNUMDEB EU Intrastat   C 4       DEB
EECSCH Intrastat rule   TSC     [TSC]TSC0=EECSCH;[V]GSUPCLE Block DEB
EECTRN Intrastat transp. mode   M 15 237     DEB
ENTCOD Stock auto journal   GAU     [GAU]GAU0=[SDH]ENTCOD Block  
ETA Arrival time   HM          
ETD Departure time   HM          
EXPNUM Export number   L 8        
FFWADD Forwarding agent address   ADR          
FFWNUM Freight agent   BPT     [BPT]BPT0=[SDH]FFWNUM Block  
GEOCOD Geographic code   GEO         KUS
GLBDOC Global document   M 4 1     KPO
GLBDOCDAT Global document date   D         KPO
GLBDOCNUM Global document no.   VCR         KPO
GLBDOCTYP Global document type   M 15 2047     KPO
GROWEI Gross weight   WEI          
HOULTI Delivery LT in hours   C 2        
ICTCTY Incoterm town   CTY          
IME Invoicing mode   M 15 408      
INSCTYFLG City interior flag   A 1       KUS
INVDTA Invoicing element   SFI     [SFI]SFI0=[SDH]INVDTA Other SFI
INVDTAAMT % or amt inv el   DCB 11.4       SFI
INVDTADSP Distrib key   DSP     [DSP]DSP0=INVDTADSP;1 Other SFI
INVDTALIN Invoice line element   C 2       SPR
INVDTATYP Value type   M 6 2227     SFI
INVFLG Invoiced   M 4 1      
INVORN Invoice sequence no.   C 3        
INVPER Invoice period   M 15 406      
LAN Language   LAN     [TLA]TLA0=[SDH]LAN Block  
LBENUM Label no.   A 10        
LICPLATE Registration   REGLIC          
LINNBR Number of lines   C 4        
LND Loan   M 4 1      
LNDRTNDAT Loan return date   D          
MANDOC Manual document   DOC         KPO
MDL Delivery mode   MDL     [TMD]TMD0=[SDH]MDL Block  
NDEFLG Print packing slip   M 4 1      
NETWEI Net weight   WEI          
NPRFLG Print pick ticket   M 4 1      
NTRFLG Print BOL   M 4 1      
ORIFCY Original site   FCY     [FCY]FCY0=[SDH]ORIFCY Block  
PACFLG Packing completed   M 4 1      
PACNBR Number of packages   C 4        
PJT Project   PJT     [PIM]PIM0=[SDH]PJT Block  
PLISTC Structure code   PRS     [PRS]PRS0=1;PLISTC Other  
PRFNUM Proforma invoice no.   VCR          
PRHFCY Receiving site   FCY     [FCY]FCY0=[SDH]PRHFCY Block  
PRITYP Price - / +tax   M 6 243      
PRNNDE Packing slip printed   M 4 1      
PRNNPR Printed pick ticket   M 4 1      
PRPTEX1 Picking header text   TXC          
PRPTEX2 Picking footer text   TXC          
PTE Payment term   PTE     [TPT]TPT0=PTE;[V]GCURLEG;1 Block  
REP Sales rep   REP     [REP]REP0=[SDH]REP Block REP
RTNLINNBR No. of lines returned   C 4        
RTNSTA Return status   M 15 451      
SALFCY Sales site   FCY     [FCY]FCY0=[SDH]SALFCY Block  
SCO For subcontract   M 4 1      
SDHCAT Delivery category   M 20 490      
SDHNUM Delivery no.   VCR          
SDHTEX1 Deliv header text   TXC          
SDHTEX2 Delivery footer text   TXC          
SDHTYP Delivery type   TSD     [TSD]TSD0=SDHTYP;[V]GSUPCLE Block  
SFISSTCOD SST tax code   ADI     [ADI]CODE=203;SFISSTCOD Block SFI
SHIDAT Shipment date   D          
SHIHOU Shipment time   HM          
SIHNUM Invoice no.   VCR          
SISDAT Reversal date   D          
SISNUM No. invoice to be issued   VCR          
SOHNUM Order no.   VCR          
SSTENTCOD Entity/Use   ADI     [ADI]CODE=202;SSTENTCOD Block LTA
STOFCY Shipment site   FCY     [FCY]FCY0=[SDH]STOFCY Block  
TMPSDHNUM Delivery no.   VCR          
TRLLICPLATE Trailer license plate   REGLIC          
TRSCOD Movement code   ADI     [ADI]CODE=14;TRSCOD RTZ  
TRSFAM Transaction group   ADI     [ADI]CODE=9;TRSFAM RTZ  
TSCCOD Statistical group   ADI     [ADI]CODE=indice+30;TSCCOD(indice) Other STC
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
VACBPR Tax rule   TVB     [TVB]TVB0=VACBPR;[V]GSUPCLE Block  
VOL Volume   VOL          
VOU Volume unit   UOM     [TUN]TUN0=[SDH]VOU Block  
VTT Vertex transaction type   A 1       KUS
WEU Weight unit   UOM     [TUN]TUN0=[SDH]WEU Block  
WRHE Warehouse   WRH     [WRH]WRH0=WRHE Other WRH