OIJTSLOC

Transparent Table Application Table
21 Fields 3 CDS Views

OIL-TSW: transport system/location assignment table

OIJTSLOC is an SAP database table in S/4HANA. OIL-TSW: transport system/location assignment table. It contains 21 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
/dmbe/i_TransportSystLocation view from Transport Syst. and Location assignment
I_OIL_TransptSystLocAssgmt view_entity from BASIC Transport system location assignment
OIJ09_SourceNominationSchedule view inner Source Schedule

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tsyst OIJ_TSYST Trans system
KEY locid OIJ_LOCID Location ID
locnam OIJ_LOCNAM Location name
tslocid OIJ_TSLCID TS loc. ID
tslocnam OIJ_TSLCNM TS loc. name
odindo OIJ_ODINDO Origin
odindd OIJ_ODINDD Destination
consind OIJ_CONSIND Consumption Loc.
erdat ERDAT Created On
erzeit OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aezeit OI0_AETIM Changed
aenam AENAM Changed By
bloind OIJ_BLOIND Blocking ind.
delind OIJ_DELIND Deletion ind.
tktselect OIJ_TKTSELECT Flag to Select Tkt
locid_parent OIJ_LOCID_PARENT Parent Loc of Branch
branch_nr OIJ_BRANCH_NR Number of Branch
branch_seq OIJ_SEQNR Sequence number

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: transport system/location assignment table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJTSLOC (
    MANDT,         -- Client [MANDT]
    TSYST,         -- Trans system [OIJ_TSYST]
    LOCID,         -- Location ID [OIJ_LOCID]
    LOCNAM,        -- Location name [OIJ_LOCNAM]
    TSLOCID,       -- TS loc. ID [OIJ_TSLCID]
    TSLOCNAM,      -- TS loc. name [OIJ_TSLCNM]
    ODINDO,        -- Origin [OIJ_ODINDO]
    ODINDD,        -- Destination [OIJ_ODINDD]
    CONSIND,       -- Consumption Loc. [OIJ_CONSIND]
    ERDAT,         -- Created On [ERDAT]
    ERZEIT,        -- Created [OI0_ERTIM]
    ERNAM,         -- Created By [ERNAM]
    AEDAT,         -- Changed On [AEDAT]
    AEZEIT,        -- Changed [OI0_AETIM]
    AENAM,         -- Changed By [AENAM]
    BLOIND,        -- Blocking ind. [OIJ_BLOIND]
    DELIND,        -- Deletion ind. [OIJ_DELIND]
    TKTSELECT,     -- Flag to Select Tkt [OIJ_TKTSELECT]
    LOCID_PARENT,  -- Parent Loc of Branch [OIJ_LOCID_PARENT]
    BRANCH_NR,     -- Number of Branch [OIJ_BRANCH_NR]
    BRANCH_SEQ,    -- Sequence number [OIJ_SEQNR]
    PRIMARY KEY (MANDT, TSYST, LOCID)
);

Learn More