SAP Table J_1IMOVEND

Vendor Master Excise Additional Data

J_1IMOVEND (Vendor 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_1IMOVEND to other SAP tables.

J_1IMOVEND table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 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_1IEXCIVE Excise tax indicator for vendor J_1IEXCIVE J_1ITAXIND CHAR 1 0
J_1ISSIST SSI Status J_1ISSIST CHAR 1 0
NULL
0
J_1IVTYP Type of Vendor J_1IVTYP CHAR 2 0
M Manufacturer
MD Manufacturer's Depot or Consignment Agent
FD First Stage Dealer of indigenous excisable goods
SD Second Stage Dealer of indigenous excisable goods
I Importer, from his depot or his consignment agent
DI First Stage or Second Stage dealer of imported goods
J_1IVENCRE CENVAT Scheme Participant J_1IVENCRE CHAR 1 0
X Yes
NULL No
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_1IPANVALDT PAN Valid From Date J_1IPANVALDT DATS 8 0
J_1I_CUSTOMS Customs Vendor J_1I_CUSTOMS CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set

J_1IMOVEND foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1IMOVEND J_1IEXCIVE J_1IMOVEND MANDT J_1ITAXIND Excise Tax Indicator MANDT
J_1IMOVEND J_1IEXCIVE J_1IMOVEND J_1IEXCIVE J_1ITAXIND Excise Tax Indicator J_1IINDTAX
J_1IMOVEND J_1IEXCIVE * J_1ITAXIND Excise Tax Indicator J_1IINDDES
J_1IMOVEND LIFNR J_1IMOVEND MANDT LFA1 Vendor Master (General Section) MANDT
J_1IMOVEND LIFNR J_1IMOVEND LIFNR LFA1 Vendor Master (General Section) LIFNR
J_1IMOVEND MANDT J_1IMOVEND MANDT T000 Clients MANDT