SAP table IDKR_CUSTVAT (VAT registration number against customer on a time basis)

SAP table IDKR_CUSTVAT has 3 primary key fields being MANDT,KUNNR,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
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
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 Customers CHAR 4 0 IDKR_CUST_VAT_BP
DEPARTMENT_NAME Responsible Department Name for Electronic Tax Invoice CHAR 100 0 RDEPNAME_KR
PERSON_NAME Responsible Person Name for Electronic Tax Invoice CHAR 100 0 RPERNAME_KR
PERSON_EMAIL1 Responsible Person’s E-mail Address CHAR 100 0 RPERMAIL
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 Customer CHAR 1 0 SELFBILLING
MONTHTAX Monthly Tax Invoice Customer CHAR 1 0 MONTHTAX

IDKR_CUSTVAT foreign key relationships

Table Field Check Table Check Field
0 IDKR_CUSTVAT KUNNR KNA1 General Data in Customer Master MANDT
0 IDKR_CUSTVAT KUNNR KNA1 General Data in Customer Master KUNNR