OIJSDLOC

Transparent Table Application Table
21 Fields 1 CDS Views

OIL-TSW: Multiple sources/destinations of location

OIJSDLOC is an SAP database table in S/4HANA. OIL-TSW: Multiple sources/destinations of location. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_LocMatlSourceDestBasic view_entity from BASIC Location Multiple Sources Destination

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY locid OIJ_LOCID Location ID
KEY matnr MATNR Material
KEY rtsyst OIJ_RTSYST Ref TS
KEY rlocid OIJ_RLOCID Ref Loc ID
KEY usageind OIJ_USAGEIND Usage Ind
sdind OIJ_SDIND S or D Ind
docind OIJ_DOCIND Ref.Doc.Ind.
sityp OIJ_SITYP Sched.type
quota OIJ_QUOTA Quota in Prcent
priority OIJ_PRIORITY Priority
locbalind OIJ_LOCBALIND Loc. Bal. Ind.
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

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: Multiple sources/destinations of location
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJSDLOC (
    MANDT,      -- Client [MANDT]
    LOCID,      -- Location ID [OIJ_LOCID]
    MATNR,      -- Material [MATNR]
    RTSYST,     -- Ref TS [OIJ_RTSYST]
    RLOCID,     -- Ref Loc ID [OIJ_RLOCID]
    USAGEIND,   -- Usage Ind [OIJ_USAGEIND]
    SDIND,      -- S or D Ind [OIJ_SDIND]
    DOCIND,     -- Ref.Doc.Ind. [OIJ_DOCIND]
    SITYP,      -- Sched.type [OIJ_SITYP]
    QUOTA,      -- Quota in Prcent [OIJ_QUOTA]
    PRIORITY,   -- Priority [OIJ_PRIORITY]
    LOCBALIND,  -- Loc. Bal. Ind. [OIJ_LOCBALIND]
    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]
    PRIMARY KEY (MANDT, LOCID, MATNR, RTSYST, RLOCID, USAGEIND)
);

Learn More