OIJLOCMAT

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]
    RDUOM,        -- Stock Proj. UoM [OIJ_RDUOM]
    RDCONV,       -- Conversion fac. [OIJ_RDCONV]
    PERIOD,       -- Rolling period [OIJ_PERIOD]
    PAST,         -- Days in past [OIJ_PAST]
    TOLPCT,       -- Under % [OIJ_BUTOL]
    TOLABS,       -- Abs.tol.Q under [OIJ_TOLABS]
    PASTDATA,     -- SftySt pstDays [OIJ_SFPAST]
    PHY_INV_FLG,  -- Phys.inv.input [OIJ_FLG]
    PHY_INV,      -- Physical inv. [OIJ_PHY_INV]
    PHY_DATE,     -- Phys. Inv. Date [OIJ_PHY_DATE]
    FCPAST,       -- Hist.HorizonFc [OIJ_FCPAST]
    FCOFFSET,     -- Offset days [OIJ_FCOFFSET]
    FCTYPE,       -- Forecast type [OIJ_FCTYPE]
    PHYTMS,       -- Physical Timestamp [OIJ_PHYTMS]
    SRCTYPE,      -- Phys.Inv.Source [OIJ_SRCTYPE]
    FCHORIZ,      -- Rack Iss FC [OIJ_FCHORIZ]
    RVP,          -- RVP [OIJ_RVP]
    PLTYP,        -- Plan.type [OIJ_PLTYP]
    CALFLG,       -- Calendar ind. [OIJ_CALFLG]
    PLCAL,        -- Plan.calendar [OIJ_PLCAL]
    COVER,        -- Safety cover. [OIJ_COVER]
    PLHOZ,        -- Plan.horizon [OIJ_PLHOZ]
    DATUOM,       -- Plan period UoM [OIJ_DATUOM]
    PTSYST,       -- Planning TS [OIJ_PTSYST]
    PLUOM,        -- Plan UoM [OIJ_PLUOM]
    CYCLE,        -- Cycle period [OIJ_CYCPER]
    CYCUOM,       -- Cycle UoM [OIJ_CYCUOM]
    MAXLOT,       -- Max batch size [OIJ_MAXLOT]
    MINLOT,       -- Min batch size [OIJ_MINLOT]
    INCLOT,       -- Increment [OIJ_INCLOT]
    INVUOM,       -- Inventory UoM [OIJ_INVUOM]
    MAXINV,       -- Max inventory [OIJ_MAXINV]
    TARGET,       -- Target inv. [OIJ_TGTINV]
    REORDER,      -- Reorder point [OIJ_REORD]
    SAFETY,       -- Safety level [OIJ_SFTINV]
    UNPUMP,       -- Unpumpable [OIJ_UNPUMP]
    MININV,       -- Min.inventory [OIJ_MININV]
    STSYST,       -- Source TS [OIJ_STSYST]
    SLOCID,       -- Source location [OIJ_SLOCID]
    SPART,        -- Source supplier [OIJ_SPART]
    SPOBJ,        -- Partner type [OIJ_SPOBJ]
    OFFPER,       -- Offset period [OIJ_OFFPER]
    OFFUOM,       -- Offset per.UoM [OIJ_OFFUOM]
    RADIONOSRC,   -- Radio button [OIJ_RADNSC]
    RADIOTSSRC,   -- Radio button [OIJ_RADTS]
    RADIOLOCSC,   -- Radio button [OIJ_RADLOC]
    PLANAMPEL,    -- Plan details [OIJ_PAMPEL]
    PLANFLAG,     -- Plan.run.flag [OIJ_PLFLAG]
    SCFLAG,       -- Source flag [OIJ_SCFLAG]
    SERVICE,      -- Service level [OIJ_SRVC]
    COVPROF,      -- Sfty.cov.prof. [OIJ_COVPRF]
    CALPROF,      -- Safety cal.prf [OIJ_CALPRF]
    FACTORY,      -- Factory cal. [OIJ_FACTRY]
    SFTTYPE,      -- Safety stock type [OIJ_SFTTYP]
    HISTHOZ,      -- Hist.horzn. [OIJ_HISTHZ]
    TSERVICE,     -- Service level [OIJ_TSRVC]
    TCOVPROF,     -- Tgt.cov.prof. [OIJ_TCOVPRF]
    TCALPROF,     -- Target cal.prf [OIJ_TCALPRF]
    TFACTORY,     -- Factory cal. [OIJ_TFACTRY]
    TGTTYPE,      -- Target stock ty [OIJ_TGTTYP]
    THISTHOZ,     -- Hist.horzn. [OIJ_THISTHZ]
    FCCAL,        -- Factory cal. [OIJ_FCCAL]
    FCPRF,        -- Rack fc profile [OIJ_FCPRF]
    TANKUPD,      -- Tank Inf Flag [OIJ_TANKUPD]
    SFTLVL,       -- PrefSafetyLvl [OIJ_SFTLVL]
    HRLVL,        -- Prefered Hdroom Lvl [OIJ_HRLVL]
    SFTTDIND,     -- Time dep. Sf [OIJ_SFTTDIND]
    TGTTDIND,     -- Time dep. Tg [OIJ_TGTTDIND]
    PPTYP,        -- PP type [OIJ_PPTYP]
    BALANCE,      -- Sup SP balance [OIJ_BALANCE]
    PVFLAG,       -- PV active [OIJ_PVFLAG]
    VERID,        -- Version ID [OIJ_VERID]
    TODAT,        -- To date [OIJ_TDATE]
    FROMDAT,      -- From date [OIJ_FDATE]
    BOMALT,       -- Alternative BOM [OIJ_BOMALT]
    BOMUSE,       -- BOM use [OIJ_BOMUSE]
    BOMMAT,       -- BOM matnr [OIJ_BOMMAT]
    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]
    TCONS,        -- Time Dep. Ind. [OIJ_TCONS]
    AUTOCONFIRM,  -- Autoconfirm [OIJ_AUTOCONF]
    VRMOD,        -- Consmption mode [VRMOD]
    VINT1,        -- Bwd cons. per. [VINT1]
    VINT2,        -- Fwd cons.period [VINT2]
    DEFSITYP,     -- Def. sched. type [OIJ_DEFSITYP]
    DEFDOCIND,    -- Ref.Doc.Ind. [OIJ_DOCIND]
    LBUOM,        -- Loc. Bal. UOM [OIJ_LBUOM]
    PROFILE,      -- Profile [OIJ05_BULKFRCT_PROFILE]
    PRIMARY KEY (MANDT, LOCID, PMATNR)
);