OIJLOCMAT

Transparent Table Application Table
8 Fields 2 CDS Views

OIL-TSW: Location Rundown/Planning material table

OIJLOCMAT is an SAP database table in S/4HANA. OIL-TSW: Location Rundown/Planning material table. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_OilLocMatlPlanning view left_outer BASIC View For OIJLOC and OIJLOCMAT
OIJ09_SourceNominationSchedule view inner Source Schedule

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY locid oij_locid Location ID
KEY pmatnr matnr Material
locname oij_locnam Location name
pmatname maktx Description
pwerk oij_pwerk Loc. plant
charg oij_charg Batch / Val.
tcons oij_tcons Time Dep. Ind.

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 Rundown/Planning material table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJLOCMAT (
    MANDT,     -- Client [mandt]
    LOCID,     -- Location ID [oij_locid]
    PMATNR,    -- Material [matnr]
    LOCNAME,   -- Location name [oij_locnam]
    PMATNAME,  -- Description [maktx]
    PWERK,     -- Loc. plant [oij_pwerk]
    CHARG,     -- Batch / Val. [oij_charg]
    TCONS,     -- Time Dep. Ind. [oij_tcons]
    PRIMARY KEY (MANDT, LOCID, PMATNR)
);

Learn More