Table Abbreviation Description Module Activity code
SINVOICE SIH Sales invoices Common Data  

Key Description Duplicates Activity code
SIH0 NUM No  
SIH1 BPR+BPRVCR Yes  
SIH2 GTE+NUM No  
SIH3 ACCDAT+BPR Yes  
SIH4 BPRFCT+FCTVCR+FCTVCRFLG Yes FCT
SIH5 CUR+BPR+NUM No SVC
SIH6 STA+ORIMOD+INVTYP+NUM Yes  
SIH7 CPY+EECNUMDEB+ACCDAT Yes DEB
SIH8 RCRNUM+RCRDAT Yes  
SIH9 BVRREFNUM Yes KSW

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACCDAT Accounting date   D          
ACCNUM Internal number   L 8        
ADRVAL Address   M 4 1     LTA
AMTATI Amount + tax   MD1          
AMTATIL Invoice amt. + tax (co)   MD1          
AMTNOT Amount - tax   MD1          
AMTNOTL Amount - tax (co)   MD1          
AMTTAX Tax amount 10 MD1          
AMTTAXUSA Tax amount 10 MD1         KUS
AUUID Single identifier   AUUID          
BASDEP Early disc/late charge calc basis   MD1          
BASTAX Tax basis 10 MD1          
BELVCS VCS number   VCS         KBE
BILVCR Draft no.   VCR          
BPAADDLIG Address line 3 ADL          
BPAINV Address   ADR          
BPAPAY Business partner address   ADR          
BPR BP   BPR     [BPR]BPR0=[SIH]BPR Block  
BPRDAT Source date   D          
BPRFCT Factor   FCT     [FCT]FCT0=[SIH]BPRFCT Block FCT
BPRNAM Company name 2 NAM          
BPRPAY Pay-by   BPR     [BPR]BPR0=[SIH]BPRPAY Block  
BPRSAC Control   SAC          
BPRVCR Source document   A 30        
BPYADDLIG Address line 3 ADL          
BPYCRY Country   CRY     [TCY]TCY0=[SIH]BPYCRY Block  
BPYCRYNAM Country name   NCY          
BPYCTY City   CTY          
BPYNAM Company name 2 NAM          
BPYPOSCOD Postal code   POS          
BPYSAT County   SAT          
BUSPROTYP Business process type   ADI     [ADI]CODE=207;BUSPROTYP Block EINV
BVRREFNUM Reference number   A 27       KSW
CAI CAI number   A 10       KAG
CCE Dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CPY Company   CPY     [CPY]CPY0=[SIH]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation author   A 5        
CRN Site tax ID no.   CRT          
CRY Country   CRY     [TCY]TCY0=[SIH]CRY Block  
CRYNAM Country name   NCY          
CSHVAT Cash VAT tax rule   M 4 1     KSP
CTY City   CTY          
CUR Currency   CUR     [TCU]TCU0=[SIH]CUR Block  
CURLED Ledger currency 10 CUR     [TCU]TCU0=[SIH]CURLED Block  
CURTYP Rate type   M 15 202      
DATVLYCAI CAI validity date   D 1       KAG
DCLEECNUM VAT declaration no.   EEC         VATTN
DEP Early discount/Late charge   TDA     [TDA]TDA0=DEP;[V]GSUPCLE Block  
DEPRAT Early discount rate   RAT          
DES Comments 5 DES          
DIE Dimension type code   DIE     [DIE]DIE0=[SIH]DIE Block ANA
DIRINVFLG Direct inv   M 4 1      
EECNUMDEB EU Intrastat   C 4       DEB
ENDDATSVC End service   D         SVC
EXEAMTTAX Exemption amount 10 MD1          
EXPNUM Export number   L 8        
FCTVCR Receipt   VCR         FCT
FCTVCRFLG Validated receipt   C 1       FCT
FCY Site   FCY     [FCY]FCY0=[SIH]FCY 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
GTE Entry type   GTE     [GTE]GTE0=GTE;[V]GSUPCLE Block  
INVNUM Invoice number   VCR          
INVTYP Invoice category   M 15 645      
INVTYPSPA Spanish invoice type   M 20 2109     KSP
ISEXTDOC External document   M 4 1     DKS
ISSAUTGEN Automatic flows   M 4 1     CTSW
ISSBYREC Autoinvoicing   M 4 1     CTSW
ISSBYRECG Autoinv. generated   M 4 1     CTSW
JOU Journal   JOU     [JOU]JOU0=JOU;[V]GSUPCLE Block  
LASDATSVC Accruals. revn. pstd   D         SVC
LED Ledger 10 LED     [LED]LED0=[SIH]LED Block  
METCOR Method of correction   M 20 2069     KSP
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      
PAYBAN Payment bank   BAN     [BAN]BAN0=[SIH]PAYBAN Block KSW
PER Period   C 2        
PERDEB Period start date   D         KPO
PERFIN To   D         KPO
PJTH Project   PJT     [PIM]PIM0=PJTH Block PJM
POREXPDCL Export declaration   VCR         KPO
POSCOD Postal code   POS          
PTE Payment term   PTE     [TPT]TPT0=PTE;[V]GCURLEG;1 Block  
QTCACCNUM Receipt actng. entry no.   L 8       FCT
RATDAT Rate date   D          
RATDIV Dividing rate 10 RCU          
RATMLT Multiplying rate 10 RCU          
RCRDAT Recurrence date   D          
RCRNUM Recurring number   VCR          
REVCANSTA Cancellation status   C 1       INVCA
SALPRITYP Amount type   M 10 243      
SAT County   SAT          
SINUM Integrale part no.   A 10       SMI
SIVTYP Invoice type   TSV     [TSV]TSV0=SIVTYP;[V]GSUPCLE Block  
SNS Sign   C 2        
SPADERNUM DER code   A 60       KSP
SSTENTCOD Entity/Use   ADI     [ADI]CODE=202;SSTENTCOD Block LTA
STA Status   M 15 2261      
STARPT Printing   M 4 1      
STRDATSVC Start service   D         SVC
STRDUDDAT Due date basis   D          
TAX Taxes 10 VAT     [TVT]TVT0=TAX(indice);[V]GSUPCLE Block  
THEAMTTAX Theor. tax amt   DCB 19.8       KAG
TRSFAM Transaction group   ADI     [ADI]CODE=9;TRSFAM RTZ  
UMRNUM Mandate reference   MDT     [MDT]MDT0=CPY;UMRNUM Block SDD
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          
WRHE Warehouse   WRH     [WRH]WRH0=WRHE Other WRH