Table Abbreviation Description Module Activity code
SDELIVERYD SDD Delivery detail Sales  

Key Description Duplicates Activity code
SDD0 SDHNUM+SDDLIN No  
SDD1 SOHNUM+SOPLIN+SOQSEQ Yes  
SDD2 ITMREF+SHIDAT+SDHNUM Yes  
SDD3 BPCORD+BPAADD+ITMREF Yes  
SDD4 SDHNUM-SDDLIN Yes  
PJMPJT1 PJT Yes PJM

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
BASTAXLIN Taxable amount   MD1         KUS
BPAADD Delivery address   BPD     [BPD]BPD0=BPCORD;BPAADD Other  
BPCORD Sold-to   BPC     [BPC]BPC0=[SDD]BPCORD Other  
CLCAMT1 Tax calculation basis 1   MD1          
CLCAMT2 Tax calculation basis 2   MD1          
CPRPRI Cost price   MD8          
CPY Company   CPY     [CPY]CPY0=[SDD]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
DDTANOT Invoice line allocation elemen   MD1         SFL
DDTANUM Invoice line allocation elemen   SFI     [SFI]SFI0=[SDD]DDTANUM Block SFL
DISCRGREN1 Discount 1 reason   SPR     [SPR]SPR0=[SDD]DISCRGREN1 Block SP1
DISCRGREN2 Discount 2 reason   SPR     [SPR]SPR0=[SDD]DISCRGREN2 Block SP2
DISCRGREN3 Discount 3 reason   SPR     [SPR]SPR0=[SDD]DISCRGREN3 Block SP3
DISCRGREN4 Discount 4 reason   C 4       SP4
DISCRGREN5 Discount 5 reason   C 4       SP5
DISCRGREN6 Discount 6 reason   C 4       SP6
DISCRGREN7 Discount 7 reason   C 4       SP7
DISCRGREN8 Discount 8 reason   C 4       SP8
DISCRGREN9 Discount 9 reason   C 4       SP9
DISCRGVAL1 Discount/Charge 1   MD8         SP1
DISCRGVAL2 Discount/Charge 2   MD8         SP2
DISCRGVAL3 Discount/Charge 3   MD8         SP3
DISCRGVAL4 Discount/Charge 4   DCB 19.8       SP4
DISCRGVAL5 Discount/Charge 5   DCB 19.8       SP5
DISCRGVAL6 Discount/Charge 6   DCB 19.8       SP6
DISCRGVAL7 Discount/Charge 7   DCB 19.8       SP7
DISCRGVAL8 Discount/Charge 8   DCB 19.8       SP8
DISCRGVAL9 Discount/Charge 9   DCB 19.8       SP9
DSPLINFLG Distribution   M 4 1      
DSPLINVOL Line volume   QTY          
DSPLINWEI Line weight   QTY          
DSPVOU Volume unit   UOM     [TUN]TUN0=[SDD]DSPVOU Block  
DSPWEU Weight unit   UOM     [TUN]TUN0=[SDD]DSPWEU Block  
ECCVALMAJ Major version   ECS         ECC
ECCVALMIN Minor version   EVL         ECC
EXPNUM Export number   L 8        
FOCFLG Free   M 10 439      
GEOCOD Geographic code   GEO         KUS
GROPRI Gross price   MD8          
IMPNUMLIG Import line   L 8        
INSCTYFLG City interior flag   A 1       KUS
INVPRNBOM Print component on invoice   M 4 1      
ITMDES Description   DES          
ITMDES1 Description   DES          
ITMREF Product   ITM     [ITM]ITM0=[SDD]ITMREF Block  
LINCFMFLG Validated line   M 4 1      
LINTYP Line type   M 15 423      
LOC Location filter   LOC     [STC]STC0=STOFCY;LOC Other  
LOT Filter lot   LOT          
NDEPRNBOM PS print component   M 4 1      
NETPRI Net price   MD8          
NETPRIATI Net price + tax   MD8          
NETPRINOT Net price - tax   MD8          
OALQTYSTU Order qty alloc. STU   QTY          
ORILIN Free line source   L 8        
PACQTYSTU Qty packed SAL   QTY          
PCK Packaging   PCK     [TPA]TPA0=[SDD]PCK Block  
PCKCAP Packaging capacity   COE          
PCKFLG Packing   M 4 1      
PFM Margin   MD1          
PJT Project   PJT     [PIM]PIM0=[SDD]PJT Block  
PRELIN Preparation line   L 8        
PRHNUM Pick ticket   VCR          
PRIREN Price reason   SPR     [SPR]SPR0=[SDD]PRIREN Block  
PRPTEX Picking ticket line text   TXC          
QTY Delivered quantity   QTY          
QTYSTU Delivered quantity STU   QTY          
RATTAXLIN Tax rates   RAT         KUS
RCPFLG Shipment inquiry   C 1        
RCPQTYSTU Received STK   QTY          
REP1 Sales rep 1   REP     [REP]REP0=[SDD]REP1 Block RE1
REP2 Sales rep 2   REP     [REP]REP0=[SDD]REP2 Block RE2
REPCOE Commission factor   CCR          
REPRAT1 Commission rate 1   RAT         RE1
REPRAT2 Commission rate 2   RAT         RE2
RTNQTY Return quantity   QTY          
RTNQTYSTU Return quantity STK   QTY          
SAU Sales unit   UOM     [TUN]TUN0=[SDD]SAU Block  
SAUSTUCOE SAL-STK conv.   COE          
SDDLIN Delivery line   L 8        
SDDTEX Packing slip line text   TXC          
SDHCAT Delivery category   M 20 490      
SDHNUM Delivery no.   VCR          
SHIDAT Shipment date   D          
SOHCAT Order category   M 15 412      
SOHNUM Order no.   VCR          
SOPLIN Order line   L 8        
SOQSEQ Sequence number   L 8        
SSTCOD SST tax code   ADI     [ADI]CODE=203;SSTCOD Block LTA
STA Filter status   A 12        
STOFCY Shipment site   FCY     [FCY]FCY0=[SDD]STOFCY Block  
STOMGTCOD Stock management   M 15 215      
STU Stock unit   UOM     [TUN]TUN0=[SDD]STU Block  
TAXFLG Taxable flag   M 4 1     KUS
TAXGEOFLG Taxed geo flag   A 1       KUS
TAXREGFLG Recorded tax flag   M 4 1     KUS
TSICOD Statistical group   ADI     [ADI]CODE=indice+20;TSICOD(indice) Other STI
UNTWEI Unit weight   WEI          
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
USEPLC Location reference   A 30        
VACITM Tax level 3 TVI     [TVI]TVI0=VACITM(indice);[V]GSUPCLE Block  
VAT Tax 3 VAT     [TVT]TVT0=VAT(indice);[V]GSUPCLE Block  
VCRLINORI Source document line   L 8        
VCRNUMORI Original document   VCR          
VCRSEQORI Source document sequence no.   L 8        
VCRTYPORI Source document type   M 15 701      
VTC Vertex transaction code   A 1       KUS
VTS Vertex transaction sub-type   A 1       KUS
WEU Weight unit   UOM     [TUN]TUN0=[SDD]WEU Block  
WRH Warehouse   WRH     [WRH]WRH0=WRH Other WRH
WRTQTY Qty waiting return   QTY          
WRTQTYSTU Qty wtg ret STK   QTY