SAP table J_1IMOCOMP (Company and Plant - Excise Additional Data)

SAP table J_1IMOCOMP has 3 primary key fields being MANDT,BUKRS,WERKS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
WERKS Plant CHAR 4 0 T001W WERKS_D
J_1IEYSMON First Month in Excise Year NUMC 2 0 J_1IEYSMON
NRNR Number range number CHAR 2 0 NRNR
J_1IEXCD ECC Number CHAR 40 0 J_1IEXCD
J_1IEXRN Excise Registration Number CHAR 40 0 J_1IEXRN
J_1IEXRG Excise Range CHAR 60 0 J_1IEXRG
J_1IEXDI Excise Division CHAR 60 0 J_1IEXDI
J_1IEXCO Excise Commissionerate CHAR 60 0 J_1IEXCO
J_1ICSTNO Central Sales Tax Number CHAR 40 0 J_1ICSTNO
J_1ILSTNO Local Sales Tax Number CHAR 40 0 J_1ILSTNO
J_1IPANNO Permanent Account Number CHAR 40 0 J_1IPANNO
J_1IEXCICO Excise tax indicator for company CHAR 1 0 J_1ITAXIND J_1IEXCICO
AEDAT Last Changed On DATS 8 0 AEDAT
USNAM Changed by the user CHAR 12 0 J_1IUSNAMC
J_1ISERN Service Tax Registration Number CHAR 40 0 J_1ISERN

J_1IMOCOMP foreign key relationships

Table Field Check Table Check Field
0 J_1IMOCOMP BUKRS T001 Company Codes BUKRS
1 J_1IMOCOMP J_1IEXCICO J_1ITAXIND Excise Tax Indicator MANDT
0 J_1IMOCOMP MANDT T000 Clients MANDT
1 J_1IMOCOMP WERKS T001W Plants/Branches MANDT
1 J_1IMOCOMP WERKS T001W Plants/Branches WERKS