OIJLOCTS

Transparent Table Customizing Table
5 Fields 1 CDS Views

OIL-TSW: Location type texts

OIJLOCTS is an SAP database table in S/4HANA. OIL-TSW: Location type texts. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_LocationTypeTSWT view_entity from BASIC Location Type - Text

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY spras SPRAS Language
KEY loctyp OIJ_LOCTYP Location type
stext OIJ_TXT15 Short text
ltext OIJ_TXT60 Long text

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.

-- OIL-TSW: Location type texts
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJLOCTS (
    MANDT,   -- Client [MANDT]
    SPRAS,   -- Language [SPRAS]
    LOCTYP,  -- Location type [OIJ_LOCTYP]
    STEXT,   -- Short text [OIJ_TXT15]
    LTEXT,   -- Long text [OIJ_TXT60]
    PRIMARY KEY (MANDT, SPRAS, LOCTYP)
);

Learn More