SAP table IDKR_VENVAT (VAT registration number against vendor on a time basis)

SAP table IDKR_VENVAT has 3 primary key fields being MANDT,LIFNR,DATAB.

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 MANDT
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
DATAB Valid-From Date DATS 8 0 DATAB
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
GESTYP Type of Business CHAR 100 0 GESTYPN
INDTYP Type of Industry CHAR 100 0 INDTYPN
REPRES Name of Representative CHAR 100 0 REPRESN
BUSINESS_PLACE Business Place in VAT for South Korean Vendors CHAR 4 0 IDKR_VEND_VAT_BP
DEPARTMENT_NAME Responsible Department Name for Electronic Tax Invoice CHAR 100 0 RDEPNAME
PERSON_NAME Responsible Person Name for Electronic Tax Invoice CHAR 100 0 RPERNAME
PERSON_EMAIL1 Responsible Person’s E-mail Address CHAR 100 0 RPERMAIL1
PERSON_EMAIL2 Responsible Person’s E-mail Address 2 CHAR 100 0 RPERMAIL2
PERSON_PHONE1 Responsible Person’s Telephone No. 1 CHAR 100 0 PERSON_PHONE1
PERSON_PHONE2 Responsible Person’s Telephone No. 2 CHAR 100 0 PERSON_PHONE2
RDEPNAME2 Responsible Department Name for e-Tax Invoice 2 CHAR 100 0 RDEPNAME2
RPERNAME2 Responsible Person Name for e-Tax Invoice 2 CHAR 100 0 RPERNAME2
SELFBILLING Self-Billing Vendor CHAR 1 0 SELFBILLINGVEN
MONTHTAX Monthly Tax Invoice Vendor CHAR 1 0 MONTHTAXVEN

IDKR_VENVAT foreign key relationships

Table Field Check Table Check Field
0 IDKR_VENVAT LIFNR LFA1 Supplier Master (General Section) MANDT
0 IDKR_VENVAT LIFNR LFA1 Supplier Master (General Section) LIFNR