P_EWM_LDPWorkloadMerge

DDL: P_EWM_LDPWORKLOADMERGE Type: view_entity CONSUMPTION
45 Fields 1 Data Sources 1 Associations

P_EWM_LDPWorkloadMerge is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_EWM_LDPWorkloadAggregate) and exposes 45 fields. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_EWM_LDPWorkloadAggregate LDPWorkloadAggregate from

Associations (1)

CardinalityTargetAliasCondition
[1] I_EWM_WarehouseControl_2 _warehouseunits LDPWorkloadAggregate.EWMWarehouse = _warehouseunits.EWMWarehouse

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (45)

KeyFieldSource TableSource FieldDescription
EWMWarehouse P_EWM_LDPWorkloadAggregate EWMWarehouse Warehouse No.
ActivityArea P_EWM_LDPWorkloadAggregate ActivityArea
InternalStorageProcessStep P_EWM_LDPWorkloadAggregate InternalStorageProcessStep
ExternalStorageProcessStep P_EWM_LDPWorkloadAggregate ExternalStorageProcessStep
EWMWorkloadCombineDate P_EWM_LDPWorkloadAggregate EWMWorkloadCombineDate
EWMWorkloadFcstFTEFactorVal
EWMHistlWrkldAggrgdDuration P_EWM_LDPWorkloadAggregate EWMHistlWrkldAggrgdDuration
EWMPlndWrkldWhseTskDurn P_EWM_LDPWorkloadAggregate EWMPlndWrkldWhseTskDurn
EWMPlndWrkldWhseReqItmDurn P_EWM_LDPWorkloadAggregate EWMPlndWrkldWhseReqItmDurn
DisplayTimeUnit _warehouseunits DisplayTimeUnit
EWMHistlWrkldAggrgdVolume P_EWM_LDPWorkloadAggregate EWMHistlWrkldAggrgdVolume
EWMPlndWrkldWhseTskVolume P_EWM_LDPWorkloadAggregate EWMPlndWrkldWhseTskVolume
EWMPlndWrkldWhseReqItmVolume P_EWM_LDPWorkloadAggregate EWMPlndWrkldWhseReqItmVolume
DisplayVolumeUnit _warehouseunits DisplayVolumeUnit
EWMHistlWrkldAggrgdWeight P_EWM_LDPWorkloadAggregate EWMHistlWrkldAggrgdWeight
EWMPlndWrkldWhseTskWeight P_EWM_LDPWorkloadAggregate EWMPlndWrkldWhseTskWeight
EWMPlndWrkldWhseReqItmWeight P_EWM_LDPWorkloadAggregate EWMPlndWrkldWhseReqItmWeight
DisplayWeightUnit _warehouseunits DisplayWeightUnit
EWMHistlWrkldCapCnsmpnVal P_EWM_LDPWorkloadAggregate EWMHistlWrkldCapCnsmpnVal
EWMWrkldWhseTskCapCnsmpnVal P_EWM_LDPWorkloadAggregate EWMWrkldWhseTskCapCnsmpnVal
EWMWrkldWhseReqItmCapCnsmpnVal P_EWM_LDPWorkloadAggregate EWMWrkldWhseReqItmCapCnsmpnVal
EWMWrkldFcstCapCnsmpnVal P_EWM_LDPWorkloadAggregate EWMWrkldFcstCapCnsmpnVal
EWMHistlWrkldAggrgdNrOfItms P_EWM_LDPWorkloadAggregate EWMHistlWrkldAggrgdNrOfItms
EWMPlndWrkldWhseTskNrOfItms P_EWM_LDPWorkloadAggregate EWMPlndWrkldWhseTskNrOfItms
EWMPlndWrkldWhseReqItmNrOfItms P_EWM_LDPWorkloadAggregate EWMPlndWrkldWhseReqItmNrOfItms
EWMWrkldLowrBoundIntvl1Durn
EWMWrkldUprBoundIntvl1Durn
EWMWrkldLowrBoundIntvl2Durn
EWMWrkldUprBoundIntvl2Durn
EWMWrkldLowrBoundIntvl1Weight
EWMWrkldUprBoundIntvl1Weight
EWMWrkldLowrBoundIntvl2Weight
EWMWrkldUprBoundIntvl2Weight
EWMWrkldLowrBoundIntvl1Volume
EWMWrkldUprBoundIntvl1Volume
EWMWrkldLowrBoundIntvl2Volume
EWMWrkldUprBoundIntvl2Volume
EWMWrkldLowrIntvl1CapCnsmpnVal
EWMWrkldUprIntvl1CapCnsmpnVal
EWMWrkldLowrIntvl2CapCnsmpnVal
EWMWrkldUprIntvl2CapCnsmpnVal
EWMWrkldLowrIntvl1NrOfItms
EWMWrkldUprBoundIntvl1NrOfItms
EWMWrkldLowrIntvl2NrOfItms
EWMWrkldUprBoundIntvl2NrOfItms

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_EWM_LDPWorkloadMerge.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_EWM_LDPWorkloadMerge AS
SELECT
  LDPWorkloadAggregate.EWMWarehouse AS EWMWarehouse,
  LDPWorkloadAggregate.ActivityArea AS ActivityArea,
  LDPWorkloadAggregate.InternalStorageProcessStep AS InternalStorageProcessStep,
  LDPWorkloadAggregate.ExternalStorageProcessStep AS ExternalStorageProcessStep,
  LDPWorkloadAggregate.EWMWorkloadCombineDate AS EWMWorkloadCombineDate,
  cast (case when LDPWorkloadAggregate.EWMWorkloadForecastFTEValue > 0 then (LDPWorkloadAggregate.EWMWorkloadForecastDuration / LDPWorkloadAggregate.EWMWorkloadForecastFTEValue) else 0 end as abap.dec(15,3)) AS EWMWorkloadFcstFTEFactorVal,
  LDPWorkloadAggregate.EWMHistlWrkldAggrgdDuration AS EWMHistlWrkldAggrgdDuration,
  LDPWorkloadAggregate.EWMPlndWrkldWhseTskDurn AS EWMPlndWrkldWhseTskDurn,
  LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmDurn AS EWMPlndWrkldWhseReqItmDurn,
  _warehouseunits.DisplayTimeUnit AS DisplayTimeUnit,
  LDPWorkloadAggregate.EWMHistlWrkldAggrgdVolume AS EWMHistlWrkldAggrgdVolume,
  LDPWorkloadAggregate.EWMPlndWrkldWhseTskVolume AS EWMPlndWrkldWhseTskVolume,
  LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmVolume AS EWMPlndWrkldWhseReqItmVolume,
  _warehouseunits.DisplayVolumeUnit AS DisplayVolumeUnit,
  LDPWorkloadAggregate.EWMHistlWrkldAggrgdWeight AS EWMHistlWrkldAggrgdWeight,
  LDPWorkloadAggregate.EWMPlndWrkldWhseTskWeight AS EWMPlndWrkldWhseTskWeight,
  LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmWeight AS EWMPlndWrkldWhseReqItmWeight,
  _warehouseunits.DisplayWeightUnit AS DisplayWeightUnit,
  LDPWorkloadAggregate.EWMHistlWrkldCapCnsmpnVal AS EWMHistlWrkldCapCnsmpnVal,
  LDPWorkloadAggregate.EWMWrkldWhseTskCapCnsmpnVal AS EWMWrkldWhseTskCapCnsmpnVal,
  LDPWorkloadAggregate.EWMWrkldWhseReqItmCapCnsmpnVal AS EWMWrkldWhseReqItmCapCnsmpnVal,
  LDPWorkloadAggregate.EWMWrkldFcstCapCnsmpnVal AS EWMWrkldFcstCapCnsmpnVal,
  LDPWorkloadAggregate.EWMHistlWrkldAggrgdNrOfItms AS EWMHistlWrkldAggrgdNrOfItms,
  LDPWorkloadAggregate.EWMPlndWrkldWhseTskNrOfItms AS EWMPlndWrkldWhseTskNrOfItms,
  LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmNrOfItms AS EWMPlndWrkldWhseReqItmNrOfItms,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskDurn+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmDurn) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdWeight <= LDPWorkloadAggregate.EWMWorkloadForecastDuration then LDPWorkloadAggregate.EWMWrkldLowrBoundIntvl1Durn else 0 end AS EWMWrkldLowrBoundIntvl1Durn,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskDurn+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmDurn) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdWeight <= LDPWorkloadAggregate.EWMWorkloadForecastDuration then LDPWorkloadAggregate.EWMWrkldUprBoundIntvl1Durn else 0 end AS EWMWrkldUprBoundIntvl1Durn,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskDurn+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmDurn) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdWeight <= LDPWorkloadAggregate.EWMWorkloadForecastDuration then LDPWorkloadAggregate.EWMWrkldLowrBoundIntvl2Durn else 0 end AS EWMWrkldLowrBoundIntvl2Durn,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskDurn+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmDurn) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdWeight <= LDPWorkloadAggregate.EWMWorkloadForecastDuration then LDPWorkloadAggregate.EWMWrkldUprBoundIntvl2Durn else 0 end AS EWMWrkldUprBoundIntvl2Durn,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskWeight+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmWeight) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdWeight <= LDPWorkloadAggregate.EWMWorkloadForecastWeight then LDPWorkloadAggregate.EWMWrkldLowrBoundIntvl1Weight else 0 end AS EWMWrkldLowrBoundIntvl1Weight,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskWeight+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmWeight) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdWeight <= LDPWorkloadAggregate.EWMWorkloadForecastWeight then LDPWorkloadAggregate.EWMWrkldUprBoundIntvl1Weight else 0 end AS EWMWrkldUprBoundIntvl1Weight,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskWeight+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmWeight) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdWeight <= LDPWorkloadAggregate.EWMWorkloadForecastWeight then LDPWorkloadAggregate.EWMWrkldLowrBoundIntvl2Weight else 0 end AS EWMWrkldLowrBoundIntvl2Weight,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskWeight+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmWeight) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdWeight <= LDPWorkloadAggregate.EWMWorkloadForecastWeight then LDPWorkloadAggregate.EWMWrkldUprBoundIntvl2Weight else 0 end AS EWMWrkldUprBoundIntvl2Weight,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskVolume+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmVolume) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdVolume <= LDPWorkloadAggregate.EWMWorkloadForecastVolume then LDPWorkloadAggregate.EWMWrkldLowrBoundIntvl1Volume else 0 end AS EWMWrkldLowrBoundIntvl1Volume,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskVolume+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmVolume) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdVolume <= LDPWorkloadAggregate.EWMWorkloadForecastVolume then LDPWorkloadAggregate.EWMWrkldUprBoundIntvl1Volume else 0 end AS EWMWrkldUprBoundIntvl1Volume,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskVolume+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmVolume) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdVolume <= LDPWorkloadAggregate.EWMWorkloadForecastVolume then LDPWorkloadAggregate.EWMWrkldLowrBoundIntvl2Volume else 0 end AS EWMWrkldLowrBoundIntvl2Volume,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskVolume+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmVolume) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdVolume <= LDPWorkloadAggregate.EWMWorkloadForecastVolume then LDPWorkloadAggregate.EWMWrkldUprBoundIntvl2Volume else 0 end AS EWMWrkldUprBoundIntvl2Volume,
  case when (LDPWorkloadAggregate.EWMWrkldWhseTskCapCnsmpnVal+LDPWorkloadAggregate.EWMWrkldWhseReqItmCapCnsmpnVal) + LDPWorkloadAggregate.EWMHistlWrkldCapCnsmpnVal <= LDPWorkloadAggregate.EWMWrkldFcstCapCnsmpnVal then LDPWorkloadAggregate.EWMWrkldLowrIntvl1CapCnsmpnVal else 0 end AS EWMWrkldLowrIntvl1CapCnsmpnVal,
  case when (LDPWorkloadAggregate.EWMWrkldWhseTskCapCnsmpnVal+LDPWorkloadAggregate.EWMWrkldWhseReqItmCapCnsmpnVal) + LDPWorkloadAggregate.EWMHistlWrkldCapCnsmpnVal <= LDPWorkloadAggregate.EWMWrkldFcstCapCnsmpnVal then LDPWorkloadAggregate. EWMWrkldUprIntvl1CapCnsmpnVal else 0 end AS EWMWrkldUprIntvl1CapCnsmpnVal,
  case when (LDPWorkloadAggregate.EWMWrkldWhseTskCapCnsmpnVal+LDPWorkloadAggregate.EWMWrkldWhseReqItmCapCnsmpnVal) + LDPWorkloadAggregate.EWMHistlWrkldCapCnsmpnVal <= LDPWorkloadAggregate.EWMWrkldFcstCapCnsmpnVal then LDPWorkloadAggregate. EWMWrkldLowrIntvl2CapCnsmpnVal else 0 end AS EWMWrkldLowrIntvl2CapCnsmpnVal,
  case when (LDPWorkloadAggregate.EWMWrkldWhseTskCapCnsmpnVal+LDPWorkloadAggregate.EWMWrkldWhseReqItmCapCnsmpnVal) + LDPWorkloadAggregate.EWMHistlWrkldCapCnsmpnVal <= LDPWorkloadAggregate.EWMWrkldFcstCapCnsmpnVal then LDPWorkloadAggregate. EWMWrkldUprIntvl2CapCnsmpnVal else 0 end AS EWMWrkldUprIntvl2CapCnsmpnVal,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskNrOfItms+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmNrOfItms) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdNrOfItms <= LDPWorkloadAggregate.EWMWrkldForecastNumberOfItems then LDPWorkloadAggregate.EWMWrkldLowrIntvl1NrOfItms else 0 end AS EWMWrkldLowrIntvl1NrOfItms,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskNrOfItms+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmNrOfItms) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdNrOfItms <= LDPWorkloadAggregate.EWMWrkldForecastNumberOfItems then LDPWorkloadAggregate.EWMWrkldUprBoundIntvl1NrOfItms else 0 end AS EWMWrkldUprBoundIntvl1NrOfItms,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskNrOfItms+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmNrOfItms) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdNrOfItms <= LDPWorkloadAggregate.EWMWrkldForecastNumberOfItems then LDPWorkloadAggregate.EWMWrkldLowrIntvl2NrOfItms else 0 end AS EWMWrkldLowrIntvl2NrOfItms,
  case when (LDPWorkloadAggregate.EWMPlndWrkldWhseTskNrOfItms+LDPWorkloadAggregate.EWMPlndWrkldWhseReqItmNrOfItms) + LDPWorkloadAggregate.EWMHistlWrkldAggrgdNrOfItms <= LDPWorkloadAggregate.EWMWrkldForecastNumberOfItems then LDPWorkloadAggregate.EWMWrkldUprBoundIntvl2NrOfItms else 0 end AS EWMWrkldUprBoundIntvl2NrOfItms
FROM P_EWM_LDPWorkloadAggregate AS LDPWorkloadAggregate
LEFT OUTER JOIN I_EWM_WarehouseControl_2 AS _warehouseunits ON LDPWorkloadAggregate.EWMWarehouse = _warehouseunits.EWMWarehouse  -- association [1]
;

Learn More