I_PHYSINVTRYVOLMASSRDNGFLD
Physical Inventory VMR Table Fields
I_PHYSINVTRYVOLMASSRDNGFLD is a CDS View in S/4HANA. Physical Inventory VMR Table Fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PhysInvtryVolMassRdng | view | from | BASIC | Physical Inventory for VMR |
| I_PhysParamVolMassRdng | view | from | BASIC | Physical Parameters VMR |
@AbapCatalog.sqlViewName: 'IPHYINVVMRFLD'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{
usageType.serviceQuality: #C,
usageType.sizeCategory: #L,
usageType.dataClass: #TRANSACTIONAL
}
@EndUserText.label: 'Physical Inventory VMR Table Fields'
define view I_PhysInvtryVolMassRdngFld
as select from oib_phyinv
{
key timestamp as CreationDateTime,
key werks as Plant,
key cwerks as ExternalPlant,
key matnr as Material,
key cmatnr as ExternalMaterial,
lgort as Location,
cast( seqnr as abap.char( 10 ) ) as SequenceNumber,
smevk as EventOfInventory,
totalheight as TankDipTotalHeight,
tothuom as TankDipUnitOfMeasure,
cast('' as abap.char(3)) as TankDipUnitOfMeasureChar,
waterheight as TankDipWaterHeight,
wathuom as TankDipWaterHeightUoM,
cast('' as abap.char(3)) as TankDipWaterHeightUoMChar,
ul_in_ind as DippingMethodInnageUllage,
(case smevk
when 'M' then mass
else volume end )
as PhyInvQuantity,
(case smevk
when 'M' then mass_uom
else vol_uom end )
as PhyInvQuantityUoM,
cast('' as abap.char(3)) as PhyInvQuantityExtUoM,
volume as MaterialVolume,
vol_uom as MaterialVolumeUoM,
cast('' as abap.char(3)) as MaterialVolumeUoMChar,
mass as MaterialMass,
mass_uom as MaterialMassUoM,
cast('' as abap.char(3)) as MaterialMassUoMChar,
erdat as DateRecordCreated,
erzeit as TimeRecordCreated,
ernam as CreatedByUser,
delind as IsDeleted,
status_a as IsAllocationCompletion,
status_r as IsReconciliationCompletion,
cast('' as text40) as MaterialDescription,
timestamp as OilTimeStampDisplay,
cast(timestamp as abap.dec(15,0) ) as CreationDateTimeDcml,
tstmp_current_utctimestamp() as CurrentSystemUTCDateTime,
cast($session.system_date as abap.dats) as StartDate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"OIB_PHYINV"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/