OIJLOC

Transparent Table Application Table
36 Fields 23 CDS Views

Location table

OIJLOC is an SAP database table in S/4HANA. Location table. It contains 36 fields. 23 CDS views read from this table.

CDS Views using this table (23)

ViewTypeJoinVDMDescription
/dmbe/i_Location view from Location Basic View
I_ACMLocation view from BASIC ACM Location details
I_ACMPlantSearchVH view inner BASIC Plant Search Help
I_ACMTrdgContrCtptyOptnty view_entity inner BASIC Optionality values for Counterparty
I_DCBLocation view_entity from BASIC Deal Capture Location
I_NominationLocation view from BASIC Nomination Location
I_NominationLocationVH view from BASIC Interface View for Location Value Help
I_Oij06_Myeventss1_Object view left_outer BASIC Mass Change Events - events interface view
I_OIL_LocationTSWBasic view_entity from BASIC Traders And Schedulers Workbench Loc
I_OilLocMatlPlanning view from BASIC View For OIJLOC and OIJLOCMAT
Oij05_GNominations view left_outer To fetch nominations
OIJ05_GSCHED view left_outer CDS for Global Sim in OIJ_SCHED
OIJ05_GSCHED_LO view left_outer CDS for Location Balancing Global Sim in OIJ_SCHED
OIJ05_ICSCHED view left_outer To fetch global simulation of type IC
Oij05_Nominations view left_outer To fetch nominations
Oij05_Oijgsched view left_outer CDSV for GSched
Oij05_Oijgsched_Sim view left_outer CDS View for Oij05_Oijgsched_Sim
Oij05_Oijsched view left_outer CDSV for OIJSCHED
Oij05_Oijsched_Sim view left_outer CDSV for OIJ05_SCHED_SIM
Oij05_Sched view left_outer CDS for OIJ_SCHED
OIJ09_SourceNominationSchedule view from Source Schedule
OIJ09_SourceNominationSchedule view inner Source Schedule
OIJ09_SourceNominationSchedule view union Source Schedule

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY locid OIJ_LOCID Location ID
loctyp OIJ_LOCTYP Location type
locnam OIJ_LOCNAM Location name
knote OIJ_KNOTE Connect point
planloc abap.char
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
rdact OIJ_RDACT Loc SP Act
maxrate OIJ_MAXRATE Maximum rate
minrate OIJ_MINRATE Minimum rate
operate OIJ_OPERATE operating rate
rateuom OIJ_RATEUOM Rate unit
rateperd OIJ_RATEPERD Time UoM
maxusage OIJ_MAXUSAGE Max Volume
minusage OIJ_MINUSAGE Min Volume
opeusage OIJ_OPEUSAGE Oper. Volume
usageuom OIJ_USAGEUOM Usage unit
usageperd OIJ_USAGEPERD Time UoM
ss_rt OIJ_DE_SS_RT MeasrComp Rt. Type
bschflag OIJ_BSCHFLAG Berth Sched. Rel
bschperd OIJ_BSCHPERD Berth sch. per.
bschpuom OIJ_BSCHPUOM Time UoM
tankagg OIJ_TANKAGG Agg Tank Constraints
pblnr OIF_PBLNR Location ID
schema_busconf OIJ_SCHEMA Schema
schema_techsch OIJ_SCHEMA Schema
schema_alloc OIJ_SCHEMA Schema
external_ind OIJ_EXTIND Third Party Terminal

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.

-- Location table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJLOC (
    MANDT,           -- Client [MANDT]
    LOCID,           -- Location ID [OIJ_LOCID]
    LOCTYP,          -- Location type [OIJ_LOCTYP]
    LOCNAM,          -- Location name [OIJ_LOCNAM]
    KNOTE,           -- Connect point [OIJ_KNOTE]
    PLANLOC,         -- abap.char
    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]
    RDACT,           -- Loc SP Act [OIJ_RDACT]
    MAXRATE,         -- Maximum rate [OIJ_MAXRATE]
    MINRATE,         -- Minimum rate [OIJ_MINRATE]
    OPERATE,         -- operating rate [OIJ_OPERATE]
    RATEUOM,         -- Rate unit [OIJ_RATEUOM]
    RATEPERD,        -- Time UoM [OIJ_RATEPERD]
    MAXUSAGE,        -- Max Volume [OIJ_MAXUSAGE]
    MINUSAGE,        -- Min Volume [OIJ_MINUSAGE]
    OPEUSAGE,        -- Oper. Volume [OIJ_OPEUSAGE]
    USAGEUOM,        -- Usage unit [OIJ_USAGEUOM]
    USAGEPERD,       -- Time UoM [OIJ_USAGEPERD]
    SS_RT,           -- MeasrComp Rt. Type [OIJ_DE_SS_RT]
    BSCHFLAG,        -- Berth Sched. Rel [OIJ_BSCHFLAG]
    BSCHPERD,        -- Berth sch. per. [OIJ_BSCHPERD]
    BSCHPUOM,        -- Time UoM [OIJ_BSCHPUOM]
    TANKAGG,         -- Agg Tank Constraints [OIJ_TANKAGG]
    PBLNR,           -- Location ID [OIF_PBLNR]
    SCHEMA_BUSCONF,  -- Schema [OIJ_SCHEMA]
    SCHEMA_TECHSCH,  -- Schema [OIJ_SCHEMA]
    SCHEMA_ALLOC,    -- Schema [OIJ_SCHEMA]
    EXTERNAL_IND,    -- Third Party Terminal [OIJ_EXTIND]
    PRIMARY KEY (MANDT, LOCID)
);

Learn More