Table Abbreviation Description Module Activity code
PINVOICE PIH Purchase invoices Common Data  

Key Description Duplicates Activity code
PIH0 NUM No  
PIH1 BPR+BPRVCR Yes  
PIH2 GTE+NUM No  
PIH3 ACCDAT+BPR Yes  
PIH4 CUR+BPR+NUM No SVC
PIH5 CPY+EECNUMDEB+ACCDAT Yes DEB
PIH6 RCRNUM+RCRDAT Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACCDAT Accounting date   D          
ACCNUM Internal number   L 8        
AMTATI Amount + tax   MD1          
AMTATIL Invoice amt. + tax (co)   MD1          
AMTNOT Amount - tax   MD1          
AMTNOTL Amount - tax (co)   MD1          
AMTSUBJ1099 Amt. subject to 1099   MD1         S1099
AMTTAX Tax amount 20 MD1          
AUUID Single identifier   AUUID          
BASDEP Early disc/late charge calc basis   MD1          
BASTAX Tax basis 20 MD1          
BELVCS VCS number   VCS         KBE
BOX1099 1099 box   A 4       S1099
BPAADDLIG Address line 3 ADL          
BPAINV Address   ADR          
BPAPAY Pay-to BP address   ADR          
BPR BP   BPR     [BPR]BPR0=[PIH]BPR Block  
BPRDAT Source date   D          
BPRNAM Company name 2 NAM          
BPRPAY Pay-by   BPR     [BPR]BPR0=[PIH]BPRPAY Block  
BPRSAC Control   SAC          
BPRVCR Source document   A 20        
BPRVCRID Identifier   A 36        
BPYADDLIG Address line 3 ADL          
BPYCRY Country   CRY     [TCY]TCY0=[PIH]BPYCRY Block  
BPYCRYNAM Country name   NCY          
BPYCTY City   CTY          
BPYNAM Company name 2 NAM          
BPYPOSCOD Postal code   POS          
BPYSAT County   SAT          
BVRBID Bank account number   BID         KSW
BVRREFLINE ISR reference line   A 55       KSW
CAI CAI number   A 10       KAG
CCE Dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CEEFLG EU invoice   M 4 1      
CLSVCR Class   A 10       KAG
CPY Company   CPY     [CPY]CPY0=[PIH]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation author   A 5        
CRY Country   CRY     [TCY]TCY0=[PIH]CRY Block  
CRYNAM Country name   NCY          
CSHVAT Cash VAT tax rule   M 4 1     KSP
CTY City   CTY          
CUR Currency   CUR     [TCU]TCU0=[PIH]CUR Block  
CURLED Ledger currency 10 CUR     [TCU]TCU0=[PIH]CURLED Block  
CURTYP Rate type   M 15 202      
DAS2 Fees declaration   M 4 1     FEE2
DATVLYCAI CAI validity date   D 1       KAG
DEDTAX Deductible tax 20 MD1          
DEP Early discount/Late charge   TDA     [TDA]TDA0=DEP;[V]GSUPCLE Block  
DEPRAT Early discount rate   RAT          
DEPTYP Price - / +tax   M 6 243      
DES Comments 5 DES          
DIE Dimension type code   DIE     [DIE]DIE0=[PIH]DIE Block ANA
EECICT Incoterm   ICT     [ICTH]ICT0=[PIH]EECICT Block  
EECLOC Intrastat transport location   M 15 236     DEB
EECNAT Transaction nature   TEC     [TEC]TEC0=EECNAT;[V]GSUPCLE Block DEB
EECNUM EU identification   A 20       DEB
EECNUMDEB EU Intrastat   C 4       DEB
EECSCH Intrastat rule   TSC     [TSC]TSC0=EECSCH;[V]GSUPCLE Block DEB
EECTRN Intrastat transp. mode   M 15 237     DEB
ENDDATSVC End service   D         SVC
EXPNUM Export number   L 8        
FCY Site   FCY     [FCY]FCY0=[PIH]FCY Block  
FFWADD Forwarding agent address   ADR          
FFWNUM Freight agent   BPT     [BPT]BPT0=[PIH]FFWNUM Block  
FIY Fiscal year   C 2        
FLD40REN Field 40 - reason   ADI     [ADI]CODE=8300;FLD40REN Block KPO
FLD41REN Field 41 - reason   ADI     [ADI]CODE=8301;FLD41REN Block KPO
FRM1099 1099 form   M 15 3601     S1099
GTE Entry type   GTE     [GTE]GTE0=GTE;[V]GSUPCLE Block  
ICTCTY Incoterm town   CTY          
INVNUM Invoice number   VCR          
INVREF Internal reference   REF          
INVTYP Invoice category   M 15 645      
ISSBYREC Autoinvoicing   M 4 1     CTSW
ISSBYRECG Autoinv. generated   M 4 1     CTSW
JOU Journal   JOU     [JOU]JOU0=JOU;[V]GSUPCLE Block  
LASDATSVC Accrued costs posted   D         SVC
LED Ledger 10 LED     [LED]LED0=[PIH]LED Block  
NBRCPY Number of companies   C 2        
NBRTAX Number of taxes   C 2        
NUM Document no.   VCR          
ORIDOCNUM Original document no.   A 30       KPO
ORIMOD Source module   M 10 14      
PAZ Pay approval   M 15 510      
PER Period   C 2        
PIHTYP Purchase invoice cat.   M 20 533      
PIVTYP Invoice type   TPV     [TPV]TPV0=PIVTYP;[V]GSUPCLE Block  
PJTH Project   PJT     [PIM]PIM0=[PIH]PJTH Block  
PORIMPLIQNUM Import tax pmt no   VCR         KPO
POSCOD Postal code   POS          
PTE Payment term   PTE     [TPT]TPT0=PTE;[V]GCURLEG;1 Block  
PURPRITYP Supplier amount type   M 10 243      
PURTYP Purchase type 20 M 5 646      
RATDAT Rate date   D          
RATDIV Dividing rate 10 RCU          
RATMLT Multiplying rate 10 RCU          
RCRDAT Recurrence date   D          
RCRNUM Recurring number   VCR          
RITAMT Amount 10 DCB 9.2       WTHMG
RITAMTDED Amount deducted 10 DCB 9.2       WTHMG
RITBAS Bases 10 DCB 9.2       WTHMG
RITBASDED Deducted basis 10 DCB 9.2       WTHMG
RITCOD Withholding code 10 RTZ     [RTZ]RTZ0=[PIH]RITCOD Block WTHMG
RITINV Proforma   VCR         WTHMG
RITNBR No. of withholdings   C 4       WTHMG
RITPAY Payment   VCR         WTHMG
SAT County   SAT          
SCUVCR Branch   A 10       KAG
SEQVCR Sequence   A 10       KAG
SINUM Integrale part no.   A 10       SMI
SNS Sign   C 2        
SPACUS SCD reference   A 40       KSP
SPACUSBPR SCD BP code   BPS     [BPS]BPS0=[PIH]SPACUSBPR Block KSP
SPACUSDAT SCD date   D         KSP
SPADERNUM DER code   A 60       KSP
STA Status   M 15 509      
STRDATSVC Start service   D         SVC
STRDUDDAT Due date basis   D          
TAX Taxes 20 VAT     [TVT]TVT0=TAX(indice);[V]GSUPCLE Block  
TWMSTA Match status   M 15 585      
TYPVCR Document type   A 10       KAG
UBLAMT Unblock amount   MD8          
UBLDAT Unblock date   D          
UBLUSR Unblock user   AUS     [AUS]CODUSR=[PIH]UBLUSR Block  
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change author   A 5        
VAC Tax rule   TVB     [TVB]TVB0=VAC;[V]GSUPCLE Block  
VATDAT Tax date on credit   D