KNVI

Transparent Table Application Table
5 Fields 6 CDS Views

Customer Master Tax Indicator

KNVI is an SAP database table in S/4HANA. Customer Master Tax Indicator. It contains 5 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
CIC_CUSTOMER_TAX view_entity from Domestic Tax Percentage (Industry Cloud Solutions)
FISTRPGSTR1ITEM view left_outer
FISTRPGSTR3BITEM view left_outer
I_BPCustomerTaxIndicator view_entity from BASIC BP Customer Tax Indicator Active Data
I_BusinessPartnerSlsAreaTax view left_outer BASIC Business Partner Sls Area Tax Core View
I_CustSalesAreaTax view left_outer BASIC Customer Sales Area Tax

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kunnr KUNNR Customer
KEY aland ALAND Dep. Ctry/Reg.
KEY tatyp TATYP Tax Cndn Type
taxkd TAKLD Tax Classific.

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.

-- Customer Master Tax Indicator
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVI (
    MANDT,  -- Client [MANDT]
    KUNNR,  -- Customer [KUNNR]
    ALAND,  -- Dep. Ctry/Reg. [ALAND]
    TATYP,  -- Tax Cndn Type [TATYP]
    TAXKD,  -- Tax Classific. [TAKLD]
    PRIMARY KEY (MANDT, KUNNR, ALAND, TATYP)
);

Learn More