Oij07_Oijphyinv

Physical inventory | view: V_OIJPHYINV | TRAN | Extraction: Not supported | Component: Downstream
Tables used: OIJPHYINV
Column Name Description
locid FK Location ID
socnr SOC: Storage object characteristic segment number
matnr FK Material Number
charg Batch / Valuation type
timest Time stamp field with 14 digits and NUMC data type
srctype FK OIL-TSW: Physical inventory type / source
Column Name Description
Column Name Description
📏 Stock Projection unit of measure (UoM) (rduom):
phy_inv OIL-TSW: Phy inventory at loc.(from external source)
Column Name Description
erdat Date on which the record was created
erzeit Time of creation
aedat Last Changed On
aezeit Time of day the record was changed
Column Name Description
bloind Blocking indicator Show values
delind Deletion indicator Show values
Column Name Description Domain name
rvp RVP value DEC3_1
ernam Name of Person Responsible for Creating the Object USNAM
aenam Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Location ID
  • Location ID
  • Client
  • OIJ07_OIJPHYINV.LOCID == OIJLOC.LOCID
  • OIJ07_OIJPHYINV.MANDT == OIJLOC.MANDT
Material Number
  • Client
  • Material Number
  • OIJ07_OIJPHYINV.MANDT == MARA.MANDT
  • OIJ07_OIJPHYINV.MATNR == MARA.MATNR
OIL-TSW: Physical inventory type / source
  • Client
  • OIL-TSW: Physical inventory type / source