Table Abbreviation Description Module Activity code
UPORDERQ UOQ PO quantity history Purchasing  

Key Description Duplicates Activity code
POQ0 POHNUM+LINREVNUM+POPLIN+POQSEQ No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AMTTAXISS Issue tax amount   MD1         PTX
AMTTAXLIN1 Tax amount 1   MD1          
AMTTAXLIN2 Tax amount 2   MD1          
AMTTAXLIN3 Tax amount 3   MD1          
AMTTAXOTH1 Amount other tax 1   MD1         PTX
AMTTAXOTH2 Amount other tax 2   MD1         PTX
AMTTAXRCP Receipt tax amount   MD1         PTX
AUUID Single identifier   AUUID          
BASTAXLIN1 Tax basis 1   MD1          
BPAINV Billing address   ADR          
BPSINV Bill-by BP   BPS     [BPS]BPS0=[UOQ]BPSINV Other  
BPSNUM Supplier   BPS     [BPS]BPS0=[UOQ]BPSNUM Other  
CAD Sequencing   M 7 278      
CLCAMT1 Tax calculation basis 1   MD1          
CLCAMT2 Tax calculation basis 2   MD1          
CLCAMT3 Tax calculation basis 3   MD1          
CLCAMT4 Tax calculation basis 4   MD1         PTX
CLCAMT5 Tax calculation basis 5   MD1         PTX
CLCAMT6 Tax calculation basis 6   MD1         PTX
CLCAMT7 Tax calculation basis 7   MD1         PTX
CMMFLG Commitment indic   C 1        
CMMNUM Commitment no.   VCR          
CMMTAX Commitment type   M 25 578      
CPR Stock cost per unit   MD8          
CPRAMT Fixed cost per unit   MD5          
CPRCOE Landed cost coef.   COE          
CPRCUR Company currency   CUR     [TCU]TCU0=[UOQ]CPRCUR Block  
CPRPRI Production cost PUR   MD8          
CPY Company   CPY     [CPY]CPY0=[UOQ]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CSTPUR Purchase cost per unit   MD8          
DEDTAXISS Deductible tax   MD1         PTX
DEDTAXLIN1 Deductible tax 1   MD1          
DEDTAXLIN2 Deductible tax 2   MD1          
DEDTAXLIN3 Deductible tax 3   MD1          
DEDTAXOTH1 Deductible tax   MD1         PTX
DEDTAXOTH2 Deductible tax   MD1         PTX
DEDTAXRCP Deductible tax   MD1         PTX
DEMENDDAT Requesteded end date   D          
DEMENDHOU Requested end time   C 4        
DEMRCPDAT Requested receipt date   D          
DEMRCPHOU Requested delivery time   C 4        
DISBASLIN1 Rebate tax basis 1   MD1          
DISCRGAMT1 Discount/Charge 1   MD1          
DISCRGAMT2 Discount/Charge 2   MD1          
DISCRGAMT3 Discount/Charge 3   MD1          
DISCRGAMT4 Discount/Charge 4   MD1          
DISCRGAMT5 Discount/Charge 5   MD1          
DISCRGAMT6 Discount/Charge 6   MD1          
DISCRGAMT7 Discount/Charge 7   MD1          
DISCRGAMT8 Discount/Charge 8   MD1          
DISCRGAMT9 Discount/Charge 9   MD1          
ECCVALMAJ Major version   ECS         ECC
ECCVALMIN Minor version   EVL         ECC
EXPNUM Export number   L 8        
EXTRCPDAT Exp. receipt date   D          
FBUFLG Budget overrun   M 4 1      
FCSCPR Stock cost total   MD1          
FCSCSTPUR Purchase cost total   MD1          
FCYADD Receipt address   ADR          
INVQTYPUU Invoiced PUR   QTY          
INVQTYSTU Invoiced STU   QTY          
INVRCPNBR No. of invoice receipts   C 4        
ITMKND Product type   M 15 2513      
ITMREF Product   ITM     [ITM]ITM0=[UOQ]ITMREF Block  
ITMREFBPS Supplier product   A 20        
ITMREFORI Released product   ITM     [ITM]ITM0=[UOQ]ITMREFORI Block  
LASINVDAT Last invoice date   D          
LASRCPDAT Last receipt date   D          
LIKQTYCOE Link qty. coef.   COE          
LINAMT Line amount - tax   MD1          
LINAMTCPR Stock cost   MD8          
LINATI Line amount + tax   MD1          
LINATIAMT Line amount + tax   MD1          
LINCLEFLG Line closed   M 4 1      
LINCSTPUR Purchase cost   MD8          
LININVFLG Invoiced line   M 4 1      
LININVNBR Number of invoices   C 4        
LINOCNDAT Ack. date   D          
LINOCNFLG Acknowledgement flag   C 1        
LINOCNNUM Ack. ID   A 20        
LINPRNFLG Line printed   M 4 1      
LINPURTYP Purchase type   M 5 646      
LINRCPNBR Number of receipts   C 4        
LINREVNUM Revision no.   C 4        
LINSTA Line status   M 7 279      
LINSTOFCY Shipment site   FCY     [FCY]FCY0=[UOQ]LINSTOFCY Block  
LINTEX Text   TXC          
LINTYP Line type   M 20 570      
LINVOU Volume unit   UOM     [TUN]TUN0=[UOQ]LINVOU Block  
LINWEU Weight unit   UOM     [TUN]TUN0=[UOQ]LINWEU Block  
MON Months   C 2        
NETCUR Currency   CUR     [TCU]TCU0=[UOQ]NETCUR Block  
OCNLIN Interco. sales line   L 8        
OCNSEQ Interco. sales seq.   L 8        
OFS Reorder LT   LTI          
ORDDAT Order date   D          
ORI Request source   M 15 505      
POHFCY Order site   FCY     [FCY]FCY0=[UOQ]POHFCY Block  
POHNUM Order no.   VCR          
POHTYP Order type   M 20 506      
POPLIN Line   L 8        
POQLNK Line + sequence   A 16        
POQSEQ Sequence number   L 8        
PPDLIN Response line   L 8        
PQHNUM RFQ no.   VCR          
PRHFCY Receiving site   FCY     [FCY]FCY0=[UOQ]PRHFCY Block  
PTDLIN Line   L 8        
PTHNUM Receipt no.   VCR          
PUU Purchase unit   UOM     [TUN]TUN0=[UOQ]PUU Block  
QTYPUU PUR quantity   QTY          
QTYSTU STK quantity   QTY          
QTYUOM Ordered qty.   QTY          
QTYVOU Volume   QTY          
QTYWEU Weight   QTY          
RCPCLEFLG Closed by receipt   M 4 1      
RCPQTYPUU Received PUR   QTY          
RCPQTYSTU Received STK   QTY          
REACSTPUR Actual purchase cost   MD8          
RETQTYPUU Required PUR   QTY          
RETQTYSTU Required STK   QTY          
RETRCPDAT Requirement date   D          
REVCOD Revision code   A 1        
SCOADD Subcon. address   ADR          
SDDLIN Delivery line   L 8        
SDHNUM Delivery no.   VCR          
SHIQTYPUU PUR qty. being deliv.   QTY          
SHIQTYSTU STK qty. being deliv.   QTY          
SOHNUM Sales order no.   VCR          
SOPLIN Sales order line   L 8        
SOQSEQ Sequence number   L 8        
STCNUM Cost structure   VCR          
STU Stock unit   UOM     [TUN]TUN0=[UOQ]STU Block  
UOM Order unit   UOM     [TUN]TUN0=[UOQ]UOM Block  
UOMFLG Order in PAC   M 4 1      
UOMPUUCOE STK-PUR conversion   COE          
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
USEPLC Location reference   A 30        
VCRLINORI Source document line   L 8        
VCRNUMORI Original document   VCR          
VCRSEQORI Source document sequence no.   L 8        
VCRTYPORI Source document type   M 15 701      
WEE Week no.   C 2        
WIPNUM Order no.   VCR          
WIPSTA WIP status   M 15 317      
WIPTYP Order type   M 15 306      
YEA Year   C 4