SAP Table J_1IMOCUST
Customer Master Excise Additional Data
J_1IMOCUST (Customer Master Excise Additional Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link J_1IMOCUST to other SAP tables.
J_1IMOCUST table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 | 0 | ||
J_1IEXCD | ECC Number | J_1IEXCD | CHAR | 40 | 0 | |||
J_1IEXRN | Excise Registration Number | J_1IEXRN | CHAR | 40 | 0 | |||
J_1IEXRG | Excise Range | J_1IEXRG | CHAR | 60 | 0 | |||
J_1IEXDI | Excise Division | J_1IEXDI | CHAR | 60 | 0 | |||
J_1IEXCO | Excise Commissionerate | J_1IEXCO | CHAR | 60 | 0 | |||
J_1ICSTNO | Central Sales Tax Number | J_1ICSTNO | CHAR | 40 | 0 | |||
J_1ILSTNO | Local Sales Tax Number | J_1ILSTNO | CHAR | 40 | 0 | |||
J_1IPANNO | Permanent Account Number | J_1IPANNO | CHAR | 40 | 0 | |||
J_1IEXCICU | Excise tax indicator for customer | J_1IEXCICU | J_1ITAXIND | CHAR | 1 | 0 | ||
AEDAT | Changed On | AEDAT | DATS | 8 | 0 | |||
USNAM | Changed by the user | J_1IUSNAMC | CHAR | 12 | 0 | |||
J_1ISERN | Service Tax Registration Number | J_1ISERN | CHAR | 40 | 0 | |||
J_1IPANREF | PAN Reference Number | J_1IPANREF | CHAR | 40 | 0 |
J_1IMOCUST foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
J_1IMOCUST | J_1IEXCICU | J_1IMOCUST | MANDT | J_1ITAXIND | Excise Tax Indicator | MANDT |
J_1IMOCUST | J_1IEXCICU | J_1IMOCUST | J_1IEXCICU | J_1ITAXIND | Excise Tax Indicator | J_1IINDTAX |
J_1IMOCUST | J_1IEXCICU | * | J_1ITAXIND | Excise Tax Indicator | J_1IINDDES | |
J_1IMOCUST | KUNNR | J_1IMOCUST | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
J_1IMOCUST | KUNNR | J_1IMOCUST | MANDT | KNA1 | General Data in Customer Master | MANDT |
J_1IMOCUST | MANDT | J_1IMOCUST | MANDT | T000 | Clients | MANDT |