C_EWM_WhseKPIGlobFltr_2

DDL: C_EWM_WHSEKPIGLOBFLTR_2 Type: view_entity CONSUMPTION
15 Fields

Global Filters for Warehoues KPIs

C_EWM_WhseKPIGlobFltr_2 is a Consumption CDS View that provides data about "Global Filters for Warehoues KPIs" in SAP S/4HANA.

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Global Filters for Warehoues KPIs view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
Search.searchable true view
OData.publish true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY EWMWarehouse task EWMWarehouse Warehouse
KEY WarehouseTask task WarehouseTask Warehouse Task
KEY WarehouseTaskItem task WarehouseTaskItem
ActivityArea task ActivityArea Activity Area
WarehouseProcessType task WarehouseProcessType Warehouse Process Type
WhseTaskCrtnWhseTmznDate Creation Date of Warehouse Task
WhseTaskConfWhseTmznDate Confirmation Date of Warehouse Task
WhseTskPlndClsgWhseTmznDate Planned Closing Date of Warehouse Task
WhseOrderCrtnWhseTmznDate Creation Date of Warehouse Order
WhseOrdLtstStrtWhseTmznDate Latest Start Date of Warehouse Order
WhseOrderConfWhseTmznDate Confirmation Date of Warehouse Order
EWMOutboundDeliveryOrderType odo EWMDeliveryDocumentType Type of Outbound Delivery Order
WrhsTimeZonePlannedGIDate odoItem WrhsTimeZonePlannedGIDate Planned Goods Issue Date
WrhsTimeZoneActualGIDate odoItem WrhsTimeZoneActualGIDate Actual Goods Issue Date
WrhsTmZnCreationDate odo WrhsTmZnCreationDate Creation Date of ODO

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 C_EWM_WhseKPIGlobFltr_2.
-- 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 C_EWM_WhseKPIGlobFltr_2 AS
SELECT
  task.EWMWarehouse AS EWMWarehouse,
  task.WarehouseTask AS WarehouseTask,
  task.WarehouseTaskItem AS WarehouseTaskItem,
  task.ActivityArea AS ActivityArea,
  task.WarehouseProcessType AS WarehouseProcessType,
  cast(substring(cast(task.WhseTaskCrtnUTCDateTime as abap.char( 17 )), 1, 8) as abap.dats) AS WhseTaskCrtnWhseTmznDate,
  cast(substring(cast(task.WhseTaskConfWhseTmznDateTime as abap.char( 17 )), 1, 8) as abap.dats) AS WhseTaskConfWhseTmznDate,
  cast(substring(cast(task.WhseTskPlndClsgWhseTmznDteTme as abap.char( 17 )), 1, 8) as abap.dats) AS WhseTskPlndClsgWhseTmznDate,
  cast(substring(cast(who.WrhsOrdCrtnUTCDateTime as abap.char( 17 )), 1, 8) as abap.dats) AS WhseOrderCrtnWhseTmznDate,
  cast(substring(cast(who.WhseOrderLatestStartDateTime as abap.char( 17 )), 1, 8) as abap.dats) AS WhseOrdLtstStrtWhseTmznDate,
  cast(substring(cast(who.WhseOrderConfirmedDateTime as abap.char( 17 )), 1, 8) as abap.dats) AS WhseOrderConfWhseTmznDate,
  odo.EWMDeliveryDocumentType AS EWMOutboundDeliveryOrderType,
  odoItem.WrhsTimeZonePlannedGIDate AS WrhsTimeZonePlannedGIDate,
  odoItem.WrhsTimeZoneActualGIDate AS WrhsTimeZoneActualGIDate,
  odo.WrhsTmZnCreationDate AS WrhsTmZnCreationDate
;

Learn More