Table Abbreviation Description Module Activity code
SORDER SOH Sales orders - header Sales  

Key Description Duplicates Activity code
SOH0 SOHNUM No  
SOH1 BPCORD+CUSORDREF Yes  
SOH2 CUSORDREF+BPCORD Yes  
SOH3 ORDSTA+BPCORD Yes  
SOH4 ORDSTA+SOHNUM No  
SOH5 ORDSTA+INVSTA+SOHCAT Yes  
SOH7 SOHNUMEND Yes KPO

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ADRVAL Validated   M 4 1     LTA
ALLLINNBR No. of lines to allocate   C 4        
ALLSTA Allocation status   M 15 416      
ALLTYP Allocation type   M 15 450      
AMTTAX Tax amount   MD1         KUS
APPFLG Signed   M 15 280      
AUUID Single identifier   AUUID          
BASTAX Tax basis   MD1         KUS
BETCPY Intercompany   M 4 1      
BETFCY Intersite   M 4 1      
BPAADD Delivery address   BPD     [BPD]BPD0=BPCORD;BPAADD Block  
BPAINV Invoice address code   ADR          
BPAORD Order addr code   ADR          
BPAPYR Address pay-by   ADR          
BPCADDLIG Order address 3 ADL          
BPCCRY Country of order   CRY     [TCY]TCY0=[SOH]BPCCRY Block  
BPCCRYNAM Order country name   NCY          
BPCCTY Order city   CTY          
BPCGRU Group customer   BPR     [BPR]BPR0=[SOH]BPCGRU Block  
BPCINV Bill-to customer   BPR     [BPR]BPR0=[SOH]BPCINV Block  
BPCNAM Sold-to customer name 2 NAM          
BPCORD Sold-to   BPR     [BPR]BPR0=[SOH]BPCORD Block  
BPCPOSCOD Order postal code   POS          
BPCPYR Pay-by   BPR     [BPR]BPR0=[SOH]BPCPYR Block  
BPCSAT Order state   SAT          
BPDADDLIG Delivery address 3 ADL          
BPDCRY Delivery country   CRY     [TCY]TCY0=[SOH]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=[SOH]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=[SOH]BPTNUM Block  
CCE Dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CCLDAT Date closed   D          
CCLREN Closing reason   ADI     [ADI]CODE=201;CCLREN Block  
CDTSTA Credit status   M 15 419      
CDTSTAP Previous credit status   M 15 419      
CHGRAT Currency rate   DCB 5.6        
CHGTYP Rate type   M 15 202      
CLELINNBR No. closed lines   C 4        
CMGNUM Marketing campaign   CMG     [CMG]CMG0=[SOH]CMGNUM RTZ  
CNDNAM Delivery contact   AIN     [AIN]AIN0=CNDNAM Block  
CNINAM Invoice contact   AIN     [AIN]AIN0=CNINAM Block  
CNTNAM Person to contact   AIN     [AIN]AIN0=CNTNAM Block  
COPNBR No. copies acknowledgement of receipt   C 1        
CPY Company   CPY     [CPY]CPY0=[SOH]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CUR Currency   CUR     [TCU]TCU0=[SOH]CUR Block  
CUSORDREF Customer order ref   A 20        
DAYLTI Delivery lead time   C 3        
DEMDLVDAT Req. delivery date   D          
DEMDLVHOU Exp. delivery time   HM         EDIX3
DEP Settlement discount   TDA     [TDA]TDA0=DEP;[V]GSUPCLE Block  
DIE Dimension type code   DIE     [DIE]DIE0=[SOH]DIE Block ANA
DISCRGTYP Discount / charge type   M 10 255     SPR
DLRATI Amount to deliver +tax   MD1          
DLRNOT Amount to deliver -tax   MD1          
DLVLINNBR No. of delivered lines   C 4        
DLVPIO Delivery priority   M 15 410      
DLVSTA Delivery status   M 15 417      
DME Partial delivery   M 15 414      
DRAFTREJ Reject draft   M 4 1      
DRAFTREJREN Draft rej. reason   A 60        
DRAFTSTATUS Draft   C 2        
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=[SOH]DSPVOU Block  
DSPWEU Weight unit   UOM     [TUN]TUN0=[SOH]DSPWEU Block  
EECICT Incoterm   ICT     [ICTH]ICT0=[SOH]EECICT Block  
EECLOC Intrastat transport location   M 15 236     DEB
EXPNUM Export number   L 8        
FFWADD Forwarding agent address   ADR          
FFWNUM Freight agent   BPT     [BPT]BPT0=[SOH]FFWNUM Block  
GEOCOD Geographic code   GEO         KUS
HLDCOD Block code   ADI     [ADI]CODE=204;HLDCOD Block  
HLDCODP Previous block code   ADI     [ADI]CODE=204;HLDCODP Block  
HLDDAT Block/Release date   D          
HLDDATP Previous block date   D          
HLDSTA Block status   M 10 491      
HLDTIM Block/Release time   HM          
HLDTIMP Previous block time   HM          
HLDUSR Block/Release user   AUS     [AUS]CODUSR=[SOH]HLDUSR Block  
HLDUSRP Previous block user   AUS     [AUS]CODUSR=[SOH]HLDUSRP Block  
ICTCTY Incoterm town   CTY          
IME Invoicing mode   M 15 408      
INRATI To invoice including tax   MD1          
INRNOT To invoice excluding tax   MD1          
INRSCHATI Scheduled invoice including tax   MD1          
INRSCHNOT Scheduled invoice excluding tax   MD1          
INSCTYFLG City interior flag   A 1       KUS
INVCND Invoic. term   INVCND     [INVCND]INVCND0=INVCND;[V]GSUPCLE Block  
INVDTA Invoicing element   SFI     [SFI]SFI0=[SOH]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 3 2227     SFI
INVLINNBR No. invoiced lines   C 4        
INVSTA Invoice status   M 15 418      
LAN Language   LAN     [TLA]TLA0=[SOH]LAN Block  
LASDLVDAT Last delivery date   D          
LASDLVNUM Last delivery no.   VCR          
LASINVDAT Last invoice date   D          
LASINVNUM Last invoice no.   VCR          
LINNBR Number of lines   C 4        
LNDRTNDAT Loan return date   D          
MDL Delivery mode   MDL     [TMD]TMD0=[SOH]MDL Block  
OCNFLG Print acknowledgment   M 4 1      
OCNPRN Acknowledgment printed   M 4 1      
ODL One order per delivery   M 4 1      
OPGNUM Marketing operation   VCR          
OPGTYP Operation type   A 3        
ORDATI Line amt. + tax   MD1          
ORDATIL Line amt. + tax (company)   MD1          
ORDCLE Close unfilled lines   M 4 1      
ORDDAT Order date   D          
ORDINVATI Valuation + tax   MD1          
ORDINVATIL Costing tax incl. cy   MD1          
ORDINVNOT Valuation - tax   MD1          
ORDINVNOTL Costing tax excl. cy   MD1          
ORDNOT Line amt. - tax   MD1          
ORDNOTL Line amt. - tax (company)   MD1          
ORDSTA Order state   M 15 415      
ORIFCY Original site   FCY     [FCY]FCY0=[SOH]ORIFCY Block  
PFMTOT Total margin   MD1          
PJT Project   PJT     [PIM]PIM0=[SOH]PJT Block  
PLISTC Structure code   PRS     [PRS]PRS0=1;PLISTC Other  
PRFNUM Proforma invoice no.   VCR          
PRITYP Price - / +tax   M 6 243      
PTE Payment term   PTE     [TPT]TPT0=PTE;[V]GCURLEG;1 Block  
REP Sales rep   REP     [REP]REP0=[SOH]REP Block REP
REVNUM Revision no.   C 4        
SALFCY Sales site   FCY     [FCY]FCY0=[SOH]SALFCY Block  
SDHTYP Delivery type   TSD     [TSD]TSD0=SDHTYP;[V]GSUPCLE Block  
SFISSTCOD SST tax code   ADI     [ADI]CODE=203;SFISSTCOD Block SFI
SHIADECOD Shipper / receiver code   A 35        
SHIDAT Shipment date   D          
SINUM Integrale part no.   A 10       SMI
SOHCAT Order category   M 15 412      
SOHCFMFLG Electronic signature   M 4 1     KPO
SOHNUM Order no.   VCR          
SOHNUMEND Final number   VCR         KPO
SOHTEX1 Ord header text   TXC          
SOHTEX2 Ord footer text   TXC          
SOHTYP Order type   TSO     [TSO]TSO0=SOHTYP;[V]GSUPCLE Block  
SOHVALDAT Validation date   D         KPO
SQHNUM Quote no.   VCR          
SRENUM Service request   SRE     [SRE]SRE0=[SOH]SRENUM RTZ  
SSTENTCOD Entity/Use   ADI     [ADI]CODE=202;SSTENTCOD Block LTA
STOFCY Shipment site   FCY     [FCY]FCY0=[SOH]STOFCY Block  
TSCCOD Statistical group   ADI     [ADI]CODE=indice+30;TSCCOD(indice) Other STC
UNL Release   M 4 1      
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
VACBPR Tax rule   TVB     [TVB]TVB0=VACBPR;[V]GSUPCLE Block  
VCRINVCNDDAT Beginning due date   D          
VLYDATCON Validity date   D          
VTT Vertex transaction type   A 1       KUS