OIJPHYINV

Transparent Table Application Table
19 Fields 2 CDS Views

Physical inventory

OIJPHYINV is an SAP database table in S/4HANA. Physical inventory. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
Oij07_Oijphyinv view from Physical inventory
OIJ09_PhysicalInventoryRecent view from Most Recent Physical Inventory

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY locid OIJ_LOCID Location ID
KEY socnr OII_SOCNR SOCSEG number
KEY matnr MATNR Material
KEY charg OIJ_CHARG Batch / Val.
KEY timest OII_TIMEST Time stamp field with 14 digits and NUMC data type
KEY srctype OIJ_SRCTYPE Phys.Inv.Source
phy_inv OIJ_PHY_INV Physical inv.
rduom OIJ_RDUOM Stock Proj. UoM
rvp OIJ_RVP RVP
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.

-- Physical inventory
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJPHYINV (
    MANDT,      -- Client [MANDT]
    LOCID,      -- Location ID [OIJ_LOCID]
    SOCNR,      -- SOCSEG number [OII_SOCNR]
    MATNR,      -- Material [MATNR]
    CHARG,      -- Batch / Val. [OIJ_CHARG]
    TIMEST,     -- Time stamp field with 14 digits and NUMC data type [OII_TIMEST]
    SRCTYPE,    -- Phys.Inv.Source [OIJ_SRCTYPE]
    PHY_INV,    -- Physical inv. [OIJ_PHY_INV]
    RDUOM,      -- Stock Proj. UoM [OIJ_RDUOM]
    RVP,        -- RVP [OIJ_RVP]
    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, SOCNR, MATNR, CHARG, TIMEST, SRCTYPE)
);

Learn More