IDKR_CUSTVAT

Transparent Table Application Table
8 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 8 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 (8)

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

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]
    PRIMARY KEY (MANDT, KUNNR, DATAB)
);

Learn More