Table Abbreviation Description Module Activity code
SORDERP SOP Sales orders - price Sales  

Key Description Duplicates Activity code
SOP0 SOHNUM+SOPLIN+SOPSEQ No  
SOP1 BPCORD+BPAADD+ITMREF+ENDDAT Yes  
SOP2 SOQSTA+SOHCAT+STOFCY+BPCORD+BPAADD Yes  
SOP3 SOHNUM+SOPLIN Yes  
SOP4 SOQSTA+SOHCAT+SALFCY+BPCINV Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
BPAADD Delivery address   BPD     [BPD]BPD0=BPCORD;BPAADD Block  
BPCINV Bill-to customer   BPC     [BPC]BPC0=[SOP]BPCINV Other  
BPCORD Sold-to   BPC     [BPC]BPC0=[SOP]BPCORD Other  
BPCSALPRI Consumer sales price   MD8         EDIX3
CLCAMT1 Tax calculation basis 1   MD1          
CLCAMT2 Tax calculation basis 2   MD1          
CNDNAM Delivery contact   AIN     [AIN]AIN0=CNDNAM Block  
CONNUM Service contract no.   VCR          
CPRPRI Cost price   MD8          
CPY Company   CPY     [CPY]CPY0=[SOP]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
DISCRGREN1 Discount 1 reason   SPR     [SPR]SPR0=[SOP]DISCRGREN1 Block SP1
DISCRGREN2 Discount 2 reason   SPR     [SPR]SPR0=[SOP]DISCRGREN2 Block SP2
DISCRGREN3 Discount 3 reason   SPR     [SPR]SPR0=[SOP]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
ENDDAT Validity end date   D          
EXPNUM Export number   L 8        
FOCFLG Free   M 10 439      
GROPRI Gross price   MD8          
INVCND Invoic. term   INVCND     [INVCND]INVCND0=INVCND;[V]GSUPCLE Block  
ITMDES Description   DES          
ITMDES1 Description   DES          
ITMREF Product   ITM     [ITM]ITM0=[SOP]ITMREF Block  
ITMREFBPC Customer product   A 20        
LINREVNUM Revision no.   C 4        
LINTYP Line type   M 15 423      
NETPRI Net price   MD8          
NETPRIATI Net price + tax   MD8          
NETPRINOT Net price - tax   MD8          
ORILIN Free line source   L 8        
PCNTNUM Contract number   PREPI     [PREPI]PREPI0=[SOP]PCNTNUM RTZ PREPM
PFM Margin   MD1          
PRIREN Price reason   SPR     [SPR]SPR0=[SOP]PRIREN Block  
REP1 Sales rep 1   REP     [REP]REP0=[SOP]REP1 Block RE1
REP2 Sales rep 2   REP     [REP]REP0=[SOP]REP2 Block RE2
REPCOE Commission factor   CCR          
REPRAT1 Commission rate 1   RAT         RE1
REPRAT2 Commission rate 2   RAT         RE2
SALFCY Sales site   FCY     [FCY]FCY0=[SOP]SALFCY Other  
SAU Sales unit   UOM     [TUN]TUN0=[SOP]SAU Block  
SAUSTUCOE SAL-STK conv.   COE          
SOHCAT Order category   M 15 412      
SOHNUM Order no.   VCR          
SOPLIN Line   L 8        
SOPSEQ Sequence   L 8        
SOQSTA Line status   M 7 279      
SQDLIN Quote line   L 8        
SQHNUM Quote no.   VCR          
SSTCOD SST tax code   ADI     [ADI]CODE=203;SSTCOD Block LTA
STOFCY Shipment site   FCY     [FCY]FCY0=[SOP]STOFCY Other  
STRDAT Validity start date   D          
STU Stock unit   UOM     [TUN]TUN0=[SOP]STU Block  
TSICOD Statistical group   ADI     [ADI]CODE=indice+20;TSICOD(indice) Other STI
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
VACITM Tax level 3 TVI     [TVI]TVI0=VACITM(indice);[V]GSUPCLE Block  
VAT Tax 3 VAT     [TVT]TVT0=VAT(indice);[V]GSUPCLE Block