A4AV

Transparent Table Application Table
8 Fields 3 CDS Views

Country/Tax Code

A4AV is an SAP database table in S/4HANA. Country/Tax Code. It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_CndnTypeTaxClassification view union_all BASIC Condition Type Classification
P_GB_TaxCodeCustomizing view_entity from BASIC Great Britain Tax customizing
R_TimeDependentTaxCode view_entity from BASIC TDT Tax Codes per Country

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kappl kappl Application
KEY kschl kscha Condition Type
KEY aland aland Dep. Ctry/Reg.
KEY mwskz mwskz Tax Code
KEY datbi kodatbi Valid To
datab kodatab Valid From
knumh knumh Cond.Record No.

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.

-- Country/Tax Code
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE A4AV (
    MANDT,  -- Client [mandt]
    KAPPL,  -- Application [kappl]
    KSCHL,  -- Condition Type [kscha]
    ALAND,  -- Dep. Ctry/Reg. [aland]
    MWSKZ,  -- Tax Code [mwskz]
    DATBI,  -- Valid To [kodatbi]
    DATAB,  -- Valid From [kodatab]
    KNUMH,  -- Cond.Record No. [knumh]
    PRIMARY KEY (MANDT, KAPPL, KSCHL, ALAND, MWSKZ, DATBI)
);

Learn More