V_T005T

8 Fields 1 CDS Views

Generated Table for View

V_T005T is an SAP database table in S/4HANA. Generated Table for View. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_VisualLocations view left_outer COMPOSITE Location Master Data

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY spras SPRAS Language
KEY land1 LAND1 Country/Reg.
landx LANDX Country/Region
natio NATIO Nationality
landx50 LANDX50 Country/Region
natio50 NATIO50 Nationality
prq_spregt PRQ_SPREGT Super Region

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE V_T005T (
    MANDT,       -- Client [MANDT]
    SPRAS,       -- Language [SPRAS]
    LAND1,       -- Country/Reg. [LAND1]
    LANDX,       -- Country/Region [LANDX]
    NATIO,       -- Nationality [NATIO]
    LANDX50,     -- Country/Region [LANDX50]
    NATIO50,     -- Nationality [NATIO50]
    PRQ_SPREGT,  -- Super Region [PRQ_SPREGT]
    PRIMARY KEY (MANDT, SPRAS, LAND1)
);

Learn More