Table Abbreviation Description Module Activity code
PINVOICEV PIV Costing purchase invoices Purchasing  

Key Description Duplicates Activity code
PIV0 NUM No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
BETCPY Intercompany   M 4 1      
BPCINV Bill-to customer   BPR     [BPR]BPR0=[PIV]BPCINV Block  
BPR BP   BPR     [BPR]BPR0=[PIV]BPR Block  
CLCLINAMT Calculated lines -tax   MD1          
CPY Company   CPY     [CPY]CPY0=[PIV]CPY Block  
CPYLAN Company language   LAN     [TLA]TLA0=[PIV]CPYLAN Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation author   A 5        
CUR Currency   CUR     [TCU]TCU0=[PIV]CUR Block  
DEP Settlement discount   TDA     [TDA]TDA0=DEP;[V]GSUPCLE Block  
DSPVOU Volume unit   UOM     [TUN]TUN0=[PIV]DSPVOU Block  
DSPWEU Weight unit   UOM     [TUN]TUN0=[PIV]DSPWEU Block  
EXPNUM Export number   L 8        
INVDTALIN1 Invoice line element   PFI     [PFI]PFI0=[PIV]INVDTALIN1 Block PPR
INVDTALIN2 Invoice line allocation elemen 9 PFI     [PFI]PFI0=[PIV]INVDTALIN2 Block  
INVDTAVAT1 Price line tax   VAT     [TVT]TVT0=INVDTAVAT1(indice);[V]GSUPCLE Block PPR
INVDTAVAT2 Distribution line tax 9 VAT     [TVT]TVT0=INVDTAVAT2(indice);[V]GSUPCLE Block  
INVTYP Invoice category   M 15 645      
LAN Language   LAN     [TLA]TLA0=[PIV]LAN Block  
LINNBR Number of lines   C 4        
NUM Document no.   VCR          
PIHTYP Purchase invoice cat.   M 20 533      
PIVTYP Usr invoice type   TPV     [TPV]TPV0=PIVTYP;[V]GSUPCLE Block  
PRILINNBR Number of different price line   C 4        
QTYLINNBR Number of different quantity L   C 4        
SIHNUM Sales invoice no.   VCR          
TEX1 Text   TXC          
TEX2 Text   TXC          
TOTLINAMT Invoice lines excluding tax   MD1          
TOTLINQTY Total quantity lines   DCB 11.6        
TOTLINVOU Line volume total   QTY          
TOTLINWEU Line weight total   QTY          
TOTTAXAMT Tax total   MD1          
TSSCOD Statistical group   ADI     [ADI]CODE=indice+40;TSSCOD(indice) Other STS
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change author   A 5