Table Abbreviation Description Module Activity code
SPRICLIST SPL Customer price lists Common Data  

Key Description Duplicates Activity code
SPL0 PLI+PLICRD+PLILIN No  
SPL1 PLI+PLICRI+PLISTRDAT Yes  
SPL2 PLI+PLICRI1+PLISTRDAT Yes  
SPL3 PLI+PLICRI2+PLISTRDAT Yes  
SPL4 PLI+PLICRI1+PLICRI2+PLICRI3+PLICRI4+PLICRI5 Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
COMCOE Comm factor   CCR          
CPNITMREF Component   ITM     [ITM]ITM0=[SPL]CPNITMREF Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CUR Currency   CUR     [TCU]TCU0=[SPL]CUR Block  
DCGVAL Charge/discount value   MD8         SPR
EXPNUM Export number   L 8        
FOCAMTBKT Free Class   MD1          
FOCAMTMIN Free threshold   MD1          
FOCITMREF Free product   ITM     [ITM]ITM0=[SPL]FOCITMREF Block  
FOCQTY Free quantity   QTY          
FOCQTYBKT Free Class   QTY          
FOCQTYMIN Free threshold   QTY          
FOCUOM Unit   UOM     [TUN]TUN0=[SPL]FOCUOM Block  
IMPNUMLIG Import line   L 8        
LTI Lead time   C 3        
MAXAMT Maximum value   MD1          
MAXQTY Maximum quantity   QTY          
MINAMT Minimum value   MD1          
MINQTY Minimum quantity   QTY          
PLI Price list code   SPC     [SPC]SPC0=[SPL]PLI Delete  
PLICRD Price list record   VCR          
PLICRI Criteria   SPX          
PLICRI1 Criteria 1   SPU          
PLICRI2 Criteria 2   SPU          
PLICRI3 Criterion 3   SPU          
PLICRI4 Criterion 4   SPU          
PLICRI5 Criterion 5   SPU          
PLIENDDAT Validity end date   D          
PLILIN Line   L 8        
PLISTRDAT Validity start date   D          
PRI Price   MD8          
PRIDIV Price factor   C 4        
UOM Unit   UOM     [TUN]TUN0=[SPL]UOM Block  
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5