IDKR_CUSTVAT

Transparent Table Application Table
19 Fields 1 CDS Views

VAT registration number against customer on a time basis

IDKR_CUSTVAT is an SAP database table in S/4HANA. VAT registration number against customer on a time basis. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_KR_CustVAT view from BASIC VAT registration by time

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kunnr KUNNR Customer
KEY datab DATAB Valid From
stcd1 STCD1 Tax Number 1
stcd2 STCD2 Tax Number 2
gestyp GESTYPN Type of Business
indtyp INDTYPN Type of Industry
repres REPRESN Rep's Name
business_place IDKR_CUST_VAT_BP Business Place
department_name RDEPNAME_KR Department Name
person_name RPERNAME_KR Name of Persn Resp.
person_email1 RPERMAIL Email of Persn Resp.
person_email2 RPERMAIL2 Eml of Persn Resp. 2
person_phone1 PERSON_PHONE1 Tel. of Person Resp.
person_phone2 PERSON_PHONE2 Person Resp. Tel. 2
rdepname2 RDEPNAME2 Persn Resp. Dept. 2
rpername2 RPERNAME2 Person Resp. Name 2
selfbilling SELFBILLING SelfBilling Customer
monthtax MONTHTAX Mnth. Tax Inv. Cust.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- VAT registration number against customer on a time basis
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IDKR_CUSTVAT (
    MANDT,            -- Client [MANDT]
    KUNNR,            -- Customer [KUNNR]
    DATAB,            -- Valid From [DATAB]
    STCD1,            -- Tax Number 1 [STCD1]
    STCD2,            -- Tax Number 2 [STCD2]
    GESTYP,           -- Type of Business [GESTYPN]
    INDTYP,           -- Type of Industry [INDTYPN]
    REPRES,           -- Rep's Name [REPRESN]
    BUSINESS_PLACE,   -- Business Place [IDKR_CUST_VAT_BP]
    DEPARTMENT_NAME,  -- Department Name [RDEPNAME_KR]
    PERSON_NAME,      -- Name of Persn Resp. [RPERNAME_KR]
    PERSON_EMAIL1,    -- Email of Persn Resp. [RPERMAIL]
    PERSON_EMAIL2,    -- Eml of Persn Resp. 2 [RPERMAIL2]
    PERSON_PHONE1,    -- Tel. of Person Resp. [PERSON_PHONE1]
    PERSON_PHONE2,    -- Person Resp. Tel. 2 [PERSON_PHONE2]
    RDEPNAME2,        -- Persn Resp. Dept. 2 [RDEPNAME2]
    RPERNAME2,        -- Person Resp. Name 2 [RPERNAME2]
    SELFBILLING,      -- SelfBilling Customer [SELFBILLING]
    MONTHTAX,         -- Mnth. Tax Inv. Cust. [MONTHTAX]
    PRIMARY KEY (MANDT, KUNNR, DATAB)
);

Learn More