TSTL

Transparent Table Customizing Table
5 Fields 3 CDS Views

Taxes: Valid Tax Categories for Each Country/Region

TSTL is an SAP database table in S/4HANA. Taxes: Valid Tax Categories for Each Country/Region. It contains 5 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ProductSalesTax view inner BASIC Product Sales Tax
P_Dchain_Salestax view inner BASIC
P_TaxCategory view from BASIC Tax Categories for Each Country/Region

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY talnd TALND Tax ctry/reg.
KEY lfdnr TAFOL Tax sequence
tatyp TATYP Tax Cndn Type
stprz STPRZ % from T007

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.

-- Taxes: Valid Tax Categories for Each Country/Region
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TSTL (
    MANDT,  -- Client [MANDT]
    TALND,  -- Tax ctry/reg. [TALND]
    LFDNR,  -- Tax sequence [TAFOL]
    TATYP,  -- Tax Cndn Type [TATYP]
    STPRZ,  -- % from T007 [STPRZ]
    PRIMARY KEY (MANDT, TALND, LFDNR)
);

Learn More