T7TW0ZT

Transparent Table Customizing Table
7 Fields 1 CDS Views

Text Table for ZIP code

T7TW0ZT is an SAP database table in S/4HANA. Text Table for ZIP code. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TW_HCMPostalCodeText view_entity from Taiwan ZIP Code Text

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY spras SPRAS Language
KEY zip03 PSTLZ_HR P.code/city
KEY endda ENDDA End Date
town PTW_TOWN Town
stret PTW_STRET Street
scope PTW_SCOPE House Number Range

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.

-- Text Table for ZIP code
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T7TW0ZT (
    MANDT,  -- Client [MANDT]
    SPRAS,  -- Language [SPRAS]
    ZIP03,  -- P.code/city [PSTLZ_HR]
    ENDDA,  -- End Date [ENDDA]
    TOWN,   -- Town [PTW_TOWN]
    STRET,  -- Street [PTW_STRET]
    SCOPE,  -- House Number Range [PTW_SCOPE]
    PRIMARY KEY (MANDT, SPRAS, ZIP03, ENDDA)
);

Learn More