TE011

Transparent Table Customizing Table

Mehrwertsteuerermittlungstabelle

TE011 is an SAP database table in S/4HANA. Mehrwertsteuerermittlungstabelle. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CATaxDeterminationCode view_entity from BASIC Tax Determination Code

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY land1 land1 Country/Reg.
KEY ermwskz ermwskz Tax Determination
KEY ab abzeitsch Valid From
bis biszeitsch Valid to
mwskz mwskz Tax Code

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.

-- Mehrwertsteuerermittlungstabelle
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TE011 (
    MANDT,    -- Client [mandt]
    LAND1,    -- Country/Reg. [land1]
    ERMWSKZ,  -- Tax Determination [ermwskz]
    AB,       -- Valid From [abzeitsch]
    BIS,      -- Valid to [biszeitsch]
    MWSKZ,    -- Tax Code [mwskz]
    PRIMARY KEY (MANDT, LAND1, ERMWSKZ, AB)
);