I_PhysInvtryVolMassRdng

DDL: I_PHYSINVTRYVOLMASSRDNG SQL: IPIVMR Type: view BASIC

Physical Inventory for VMR

I_PhysInvtryVolMassRdng is a Basic CDS View that provides data about "Physical Inventory for VMR" in SAP S/4HANA. It reads from 4 data sources (oib_map_uom, oib_matwerkst, makt, I_PhysInvtryVolMassRdngFld) and exposes 36 fields with key fields CreationDateTime, Plant, ExternalPlant, Material, ExternalMaterial.

4 data source(s) 36 fields

Data Sources (4)

SourceAliasJoin Type
oib_map_uom _ExternalUoM left_outer
oib_matwerkst _MaterialDescription_E left_outer
makt _MaterialDescription_I left_outer
I_PhysInvtryVolMassRdngFld _PhysInvtryFld from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPIVMR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Physical Inventory for VMR view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY CreationDateTime CreationDateTime
KEY Plant Plant
KEY ExternalPlant ExternalPlant
KEY Material Material
KEY ExternalMaterial ExternalMaterial
MaterialDescription
Location Location
SequenceNumber SequenceNumber
EventOfInventory EventOfInventory
TankDipTotalHeight TankDipTotalHeight
TankDipUnitOfMeasure TankDipUnitOfMeasure
TankDipUnitOfMeasureChar TankDipUnitOfMeasureChar
TankDipWaterHeight TankDipWaterHeight
TankDipWaterHeightUoM TankDipWaterHeightUoM
TankDipWaterHeightUoMChar TankDipWaterHeightUoMChar
DippingMethodInnageUllage DippingMethodInnageUllage
PhyInvQuantity PhyInvQuantity
PhyInvQuantityUoM PhyInvQuantityUoM
PhyInvQuantityExtUoM PhyInvQuantityExtUoM
MaterialVolume MaterialVolume
MaterialVolumeUoM MaterialVolumeUoM
MaterialVolumeUoMChar MaterialVolumeUoMChar
MaterialMass MaterialMass
MaterialMassUoM MaterialMassUoM
MaterialMassUoMChar MaterialMassUoMChar
DateRecordCreated DateRecordCreated
TimeRecordCreated TimeRecordCreated
CreatedByUser CreatedByUser
IsDeleted IsDeleted
IsAllocationCompletion IsAllocationCompletion
IsReconciliationCompletion IsReconciliationCompletion
OilTimeStampDisplay OilTimeStampDisplay
CreationDateTimeDcml CreationDateTimeDcml
StartDate StartDate
InventoryIsAllocated
InventorySourceType 
@AbapCatalog.sqlViewName: 'IPIVMR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Physical Inventory for VMR'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass     : #TRANSACTIONAL,
                         sizeCategory  : #L}
@VDM.viewType: #BASIC

define view I_PhysInvtryVolMassRdng 
  as select from    I_PhysInvtryVolMassRdngFld as _PhysInvtryFld
    left outer join oib_map_uom                as _ExternalUoM           on  _ExternalUoM.bname = $session.user
                                                                         and _ExternalUoM.msehi = _PhysInvtryFld.PhyInvQuantityUoM
    left outer join oib_matwerkst              as _MaterialDescription_E on  _MaterialDescription_E.langu  = $session.system_language
                                                                         and _MaterialDescription_E.bname  = $session.user
                                                                         and _MaterialDescription_E.cwerks = _PhysInvtryFld.ExternalPlant
                                                                         and _MaterialDescription_E.cmatnr = _PhysInvtryFld.ExternalMaterial
    left outer join makt                       as _MaterialDescription_I on  _MaterialDescription_I.matnr = _PhysInvtryFld.Material
                                                                         and _MaterialDescription_I.spras = $session.system_language
{
  key CreationDateTime,
  key Plant,
  key ExternalPlant,
  key Material,
  key ExternalMaterial,
      coalesce( _MaterialDescription_E.cmatnr_desc , _MaterialDescription_I.maktx )     as MaterialDescription,
      Location,
      SequenceNumber,
      EventOfInventory,
      TankDipTotalHeight,
      TankDipUnitOfMeasure,
      TankDipUnitOfMeasureChar,
      TankDipWaterHeight,
      TankDipWaterHeightUoM,
      TankDipWaterHeightUoMChar,
      DippingMethodInnageUllage,
      PhyInvQuantity,
      PhyInvQuantityUoM,
      PhyInvQuantityExtUoM,
      MaterialVolume,
      MaterialVolumeUoM,
      MaterialVolumeUoMChar,
      MaterialMass,
      MaterialMassUoM,
      MaterialMassUoMChar,
      DateRecordCreated,
      TimeRecordCreated,
      CreatedByUser,
      IsDeleted,
      IsAllocationCompletion,
      IsReconciliationCompletion,
      OilTimeStampDisplay,
      CreationDateTimeDcml,
      StartDate,
      cast('' as abap.char(1))                                as  InventoryIsAllocated,
      cast('' as abap.char(1))                                as  InventorySourceType

}
where
      DateRecordCreated >= DATS_ADD_DAYS(
    StartDate, - 7, 'UNCHANGED'
  )
  and CreatedByUser     = $session.user

  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PHYSINVTRYVOLMASSRDNGFLD",
"MAKT",
"OIB_MAP_UOM",
"OIB_MATWERKST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More