What is C_EWM_InbDelivItemLeanQ_2 in SAP S/4HANA?

C_EWM_InbDelivItemLeanQ_2 is a consumption CDS view in SAP S/4HANA. Whse Inbound Delivery Item Lean - Query It contains 114 fields.

Which tables does C_EWM_InbDelivItemLeanQ_2 read from?

C_EWM_InbDelivItemLeanQ_2 reads data from: I_EWM_InbDeliveryItemC_2.

What VDM layer is C_EWM_InbDelivItemLeanQ_2?

C_EWM_InbDelivItemLeanQ_2 is classified as a Consumption view optimized for specific business scenarios and reporting.

C_EWM_InbDelivItemLeanQ_2

DDL: C_EWM_INBDELIVITEMLEANQ_2 Type: view_entity CONSUMPTION

114 Fields 1 Data Sources

Whse Inbound Delivery Item Lean - Query

C_EWM_InbDelivItemLeanQ_2 (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Supply Chain

C_EWM_InbDelivItemLeanQ_2 is a Consumption CDS View that provides data about "Whse Inbound Delivery Item Lean - Query" in SAP S/4HANA. It reads from 1 data source (I_EWM_InbDeliveryItemC_2) and exposes 114 fields with key fields EWMWarehouse, EWMInboundDelivery, EWMInboundDeliveryItem.

SAP Help Documentation

Category	CDS Views for Deliveries
Data Category	Query
Corresponding DataSource	2CCEWMINBDELIVLQ

Purpose
This CDS view provides the prerequisites for answering the following business questions: How many inbound delivery items are there in my warehouse? How many products are there for my inbound delivery items? How many blocked inbound delivery items are there? What are the warehouse process types of my inbound delivery items? What is the goods receipt status of my inbound delivery items? What is the average goods receipt time of my inbound delivery items? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations One of the following business catalogs needs to be assigned to a user to be able to use this CDS view: SAP_SCM_BC_EWM_MON_PC : WM – Monitoring Users who want to use this CDS view must have a role that includes authorization based on at least one of the business catalogs listed above. In this role, the following restriction types must be set to read access: Warehouse Number / Warehouse Complex These restriction types are edited in the Maintain Business Roles app.

Structure
Parameters The parameters of the CDS view are as follows: P_Language used to specify the system language. The default value is the logon language. Fields used for filtering The main filters are as follows: Warehouse Inbound Delivery Inbound Delivery Document Type Planned Delivery Date Planned Goods Receipt Date Further important fields Important fields in this view include the following: Field Name Description Measure or Attribute NumberOfInboundDeliveries Number of Inbound Deliveries Measure NumberOfInbDelivItems Number of Inbound Delivery Items Measure ItemGrossWeight Gross Weight of Inbound Delivery Items Measure ItemNetWeight Net Weight of Inbound Delivery Items Measure ItemVolume Volume of Inbound Delivery Items Measure ProductQuantity Product Quantity Measure GoodsReceiptDurationInMinutes Average Receiving Time Measure

SAP Business Warehouse (SAP BW) Extraction
Data extraction type Full (physical deletions are possible in source tables) Corresponding DataSource (Extractor) 2CIEWMINBDELIVC Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

Constraints
You select inbound delivery items with the item categories Standard Delivery Item ( DLV ), Returns Item ( RET ), or Packing Item ( PAC ).

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Supply Chain
Application Component	SCM-EWM-DLP
Capabilities	Analytical Query
Package	Supply Chain for SAP S/4HANA Cloud Private Edition
Description	This CDS view provides the prerequisites for answering the following business questions:<ul> <li><p>How many inbound delivery items are there in my warehouse?</p></li> <li><p>How many products are there for my inbound delivery items?</p></li> <li><p>How many blocked inbound delivery items are there?</p></li> <li><p>What are the warehouse process types of my inbound delivery items?</p></li> <li><p>What is the goods receipt status of my inbound delivery items?</p></li> <li><p>What is the average goods receipt time of my inbound delivery items?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_EWM_InbDeliveryItemC_2	I_EWM_InbDeliveryItemC_2	from

Annotations (12)

Name	Value	Level
EndUserText.label	Whse Inbound Delivery Item Lean - Query	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view
VDM.viewType	#CONSUMPTION	view
OData.publish	true	view
Analytics.query	true	view
Analytics.technicalName	CEWMINBDELIVLQ2	view
Analytics.internalName	#LOCAL	view

Fields (114)

Key	Field	Source Field	Description
KEY	EWMWarehouse	EWMWarehouse	Warehouse Number/Warehouse Complex
KEY	EWMInboundDelivery	EWMInboundDelivery	Document No. of Inbound Delivery
KEY	EWMInboundDeliveryItem	EWMInboundDeliveryItem	No. of Inbound Delivery Items
	EWMWarehouseDescription		Warehouse Description
	TimeZoneID	TimeZoneID	Warehouse Time Zone
	DeliveryDocumentCategory	DeliveryDocumentCategory	Inbound Delivery Document Category
	EWMInboundDeliveryItemCategory	EWMInboundDeliveryItemCategory	Inbound Delivery Item Category
	DeliveryItemCategoryName	DeliveryItemCategoryName	Description of Inb. Deliv. Item Category
	InboundDeliveryDocumentType	InboundDeliveryDocumentType	Inbound Delivery Document Type
	InbDeliveryDocumentTypeName	InbDeliveryDocumentTypeName	Docu. Type of Inbound Delivery (Desc.)
	EWMInboundDeliveryItemType	EWMInboundDeliveryItemType	Inbound Delivery Item Type
	InboundDeliveryItemTypeName	InboundDeliveryItemTypeName	Desc. of Inbound Delivery Item Type
	WarehouseProcessType	WarehouseProcessType	Warehouse Process Type
	WarehouseProcessTypeName	WarehouseProcessTypeName	Description of Warehouse Process Type
	Product	Product	Product
	ProductName	ProductName	Product Description
	Batch	Batch	Product Batch Number
	EntitledToDisposeParty	EntitledToDisposeParty	Party Entitled to Dispose
	NameOfEntitledToDisposeParty	NameOfEntitledToDisposeParty	Description of Party Entitled to Dispose
	ShipFromParty	ShipFromParty	Business Partner Number
	ShipFromPartyName	ShipFromPartyName	Description of Ship-From Party
	EWMStockOwner	EWMStockOwner	Stock Owner
	StockOwner	StockOwner	Stock Owner
	StockOwnerName	StockOwnerName	Stock Owner Description
	EWMStockType	EWMStockType	Stock Type
	EWMStockTypeName	EWMStockTypeName	Stock Type Description
	ProductQuantity	ProductQuantity	Product Quantity
	QuantityUnit	QuantityUnit	Unit of Measure
	ItemVolume	ItemVolume	Volume on Item Level
	DisplayVolumeUnit	DisplayVolumeUnit	Display Volume Unit
	ItemNetWeight	ItemNetWeight	Net Weight on Item Level
	ItemGrossWeight	ItemGrossWeight	Gross Weight on Item Level
	DisplayWeightUnit	DisplayWeightUnit	Display Weight Unit
	OverallBlockStatus	OverallBlockStatus	Blocked (Overall Status)
	OverallBlockStatusName	OverallBlockStatusName	Description of Blocked (Overall Status)
	ItemInconsistencyBlkStatus	ItemInconsistencyBlkStatus	Blocked (Inconsist. Item) Status
	ItemInconsistencyBlkStatusName	ItemInconsistencyBlkStatusName	Desc. of Blocked (Inconsist. Item) Sts
	CompletionStatus	CompletionStatus	Completion Status
	CompletionStatusName	CompletionStatusName	Description of Completion Status
	PlanningPutawayStatus	PlanningPutawayStatus	Planning Putaway Status
	PlanningPutawayStatusName	PlanningPutawayStatusName	Description of Planning Putaway Status
	GoodsReceiptStatus	GoodsReceiptStatus	Goods Receipt Status
	GoodsReceiptStatusName	GoodsReceiptStatusName	Description of Goods Receipt Status
	PutawayStatus	PutawayStatus	Putaway Status
	PutawayStatusName	PutawayStatusName	Individual Status of an Object
	QualityMgmtCountPlngStatus	QualityMgmtCountPlngStatus	QM Count Planning Status
	QualityMgmtCountPlngStatusName	QualityMgmtCountPlngStatusName	Desc. of QM Count Planning Sts
	QualityMgmtInspPlngStatus	QualityMgmtInspPlngStatus	Quality Inspection Planning Sts
	QualityMgmtInspPlngStsName	QualityMgmtInspPlngStsName	Desc. of Quality Inspctn Planning Sts
	CheckToleranceStatus	CheckToleranceStatus	Tolerance Check Status
	CheckToleranceStatusName	CheckToleranceStatusName	Description of Tolerance Check Status
	ValuationQtyAssignmentStatus	ValuationQtyAssignmentStatus	Valuation Quantity Assignment Status
	ValuationQtyAssgmtStatusName	ValuationQtyAssgmtStatusName	Desc. of Valuation Qty Assignment Status
	WarehouseActivityStatus	WarehouseActivityStatus	Warehouse Activity Status
	WarehouseActivityStatusName	WarehouseActivityStatusName	Description of Warehouse Activity Status
	InbDelivItemCrtnUTCDateTime	InbDelivItemCrtnUTCDateTime	Inbound Delivery Item Created On (UTC)
	ActualGRStartUTCDateTime	ActualGRStartUTCDateTime	GR Started On (UTC)
	PlannedGRStartUTCDateTime	PlannedGRStartUTCDateTime	Planned GR Started On (UTC)
	PlannedGREndUTCDateTime	PlannedGREndUTCDateTime	Planned GR Ended On (UTC)
	ActualPutawayEndUTCDateTime	ActualPutawayEndUTCDateTime	Putaway Ended On (UTC)
	ActualGREndUTCDateTime	ActualGREndUTCDateTime	Creation Date/Time
	NoWhseActivityTimeInMinutes	NoWhseActivityTimeInMinutes	Time Without Whse Activities (Minute)
	GoodsReceiptDurationInMinutes		Average Receiving Time (Minute)
	PlndDeliveryWhseTmznDateTime	PlndDeliveryWhseTmznDateTime	Date and Time of Planned Delivery
	PlndGREndWhseTmznDateTime	PlndGREndWhseTmznDateTime	Date and Time of Planned Goods Receipt
	PutawayEndWhseTmznDateTime	PutawayEndWhseTmznDateTime	End Date and Time of Putaway
	ActualGREndWhseTmznDateTime	ActualGREndWhseTmznDateTime	Goods Receipts Ended On
	InbDelivItmCmpltWhseTmznDteTme	InbDelivItmCmpltWhseTmznDteTme	Inbound Delivery Item Completed On
	PlannedDeliveryWhseTmznYear	PlannedDeliveryWhseTmznYear	Planned Delivery Date (Year)
	PlannedDeliveryWhseTmznMonth	PlannedDeliveryWhseTmznMonth	Planned Delivery Date (Month)
	PlannedDeliveryWhseTmznDate	PlannedDeliveryWhseTmznDate	Planned Delivery Date
	PlannedDeliveryWhseTmznHour	PlannedDeliveryWhseTmznHour	Planned Delivery Time (Hour)
	PlannedDeliveryWhseTmznTime	PlannedDeliveryWhseTmznTime	Planned Delivery Time
	PlndGoodsReceiptWhseTmznYear	PlndGoodsReceiptWhseTmznYear	Planned Goods Receipt Date (Year)
	PlndGoodsReceiptWhseTmznMonth	PlndGoodsReceiptWhseTmznMonth	Planned Goods Receipt Date (Month)
	PlndGoodsReceiptWhseTmznDate	PlndGoodsReceiptWhseTmznDate	Planned Goods Receipt Date
	PlndGoodsReceiptWhseTmznHour	PlndGoodsReceiptWhseTmznHour	Planned Goods Receipt Time (Hour)
	PlndGoodsReceiptWhseTmznTime	PlndGoodsReceiptWhseTmznTime	Planned Goods Receipt Time
	PutawayEndWhseTmznYear	PutawayEndWhseTmznYear	Putaway End Date (Year)
	PutawayEndWhseTmznMonth	PutawayEndWhseTmznMonth	Putaway End Date (Month)
	PutawayEndWhseTmznDate	PutawayEndWhseTmznDate	Putaway End Date
	PutawayEndWhseTmznHour	PutawayEndWhseTmznHour	Putaway End Time (Hour)
	PutawayEndWhseTmznTime	PutawayEndWhseTmznTime	Putaway End Time
	GoodsReceiptEndWhseTmznYear	GoodsReceiptEndWhseTmznYear	Goods Receipt End Date (Year)
	GoodsReceiptEndWhseTmznMonth	GoodsReceiptEndWhseTmznMonth	Goods Receipt End Date (Month)
	GoodsReceiptEndWhseTmznDate	GoodsReceiptEndWhseTmznDate	Goods Receipt End Date
	GoodsReceiptEndWhseTmznHour	GoodsReceiptEndWhseTmznHour	Goods Receipt End Time (Hour)
	GoodsReceiptEndWhseTmznTime	GoodsReceiptEndWhseTmznTime	Goods Receipt End Time
	InbDelivCompltnEndWhseTmznYear	InbDelivCompltnEndWhseTmznYear	Completion Date (Year)
	InbDelivCompltnEndWhseTmznMnth	InbDelivCompltnEndWhseTmznMnth	Completion Date (Month)
	InbDelivCompltnEndWhseTmznDate	InbDelivCompltnEndWhseTmznDate	Completion Date
	InbDelivCompltnEndWhseTmznHour	InbDelivCompltnEndWhseTmznHour	Completion Time (Hour)
	InbDelivCompltnEndWhseTmznTime	InbDelivCompltnEndWhseTmznTime	Completion Time
	PlndDelivTo30MinsWhseDteTme	PlndDelivTo30MinsWhseDteTme	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	PlndDelivTo60MinsWhseDteTme	PlndDelivTo60MinsWhseDteTme	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	CompltnEndTo30MinsWhseDteTme	CompltnEndTo30MinsWhseDteTme	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	CompltnEndTo60MinsWhseDteTme	CompltnEndTo60MinsWhseDteTme	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	GREndRnddTo30MinsWhseDteTme	GREndRnddTo30MinsWhseDteTme	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	GREndRnddTo60MinsWhseDteTme	GREndRnddTo60MinsWhseDteTme	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	PtwyEndRnddTo30MinsWhseDteTme	PtwyEndRnddTo30MinsWhseDteTme	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	PtwyEndRnddTo60MinsWhseDteTme	PtwyEndRnddTo60MinsWhseDteTme	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	NumberOfInboundDeliveries	1	Number of Inbound Deliveries
	NumberOfInbDelivItems	NumberOfInbDelivItems	Number of Inbound Delivery Items
	EWMPlndGRWhseTmznHour	EWMPlndGRWhseTmznHour	Planned GR Time in Hours (Whse Time Zone)
	EWMQuantityHasAdjustment	EWMQuantityHasAdjustment	Delivery Quantity Has Adjustments
	EWMPlndGRDateIsInPast	EWMPlndGRDateIsInPast	Planned Goods Receipt Date Is in Past
	EWMActualGRDateIsOnTime	EWMActualGRDateIsOnTime	Actual Goods Receipt Is on Time
	EWMPlndGoodsReceiptDateIsToday	EWMPlndGoodsReceiptDateIsToday	Planned Goods Receipt Date Is Today (Whse Time Zone)
	EWMActualPutawayDateIsToday	EWMActualPutawayDateIsToday	Actual Putaway Date Is Today (Warehouse Time Zone)
	EWMPlndOrActGRIsToday	EWMPlndOrActGRIsToday	Planned/Actual Goods Receipt Date Is Today
	EWMPlndDeliveryTimeIsInPast	EWMPlndDeliveryTimeIsInPast	Planned Delivery Time Is in Past
	EWMActGRIsBeforePlndDelivTime	EWMActGRIsBeforePlndDelivTime	Actual Goods Receipt Date Is Before Planned Delivery Date
	EWMPlndDeliveryDateIsToday	EWMPlndDeliveryDateIsToday	Planned Delivery Date Is Today (Warehouse Time Zone)
	EWMPlndDeliveryWhseTmznHour	EWMPlndDeliveryWhseTmznHour	Planned Delivey Time in Hours (Warehouse Time Zone)

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_InbDelivItemLeanQ_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_InbDelivItemLeanQ_2 AS
SELECT
  EWMWarehouse,
  EWMInboundDelivery,
  EWMInboundDeliveryItem,
  _Warehouse._Text[1:Language = $parameters.P_Language].EWMWarehouseDescription AS EWMWarehouseDescription,
  TimeZoneID,
  DeliveryDocumentCategory,
  EWMInboundDeliveryItemCategory,
  DeliveryItemCategoryName,
  InboundDeliveryDocumentType,
  InbDeliveryDocumentTypeName,
  EWMInboundDeliveryItemType,
  InboundDeliveryItemTypeName,
  WarehouseProcessType,
  WarehouseProcessTypeName,
  Product,
  ProductName,
  Batch,
  EntitledToDisposeParty,
  NameOfEntitledToDisposeParty,
  ShipFromParty,
  ShipFromPartyName,
  EWMStockOwner,
  StockOwner,
  StockOwnerName,
  EWMStockType,
  EWMStockTypeName,
  ProductQuantity,
  QuantityUnit,
  ItemVolume,
  DisplayVolumeUnit,
  ItemNetWeight,
  ItemGrossWeight,
  DisplayWeightUnit,
  OverallBlockStatus,
  OverallBlockStatusName,
  ItemInconsistencyBlkStatus,
  ItemInconsistencyBlkStatusName,
  CompletionStatus,
  CompletionStatusName,
  PlanningPutawayStatus,
  PlanningPutawayStatusName,
  GoodsReceiptStatus,
  GoodsReceiptStatusName,
  PutawayStatus,
  PutawayStatusName,
  QualityMgmtCountPlngStatus,
  QualityMgmtCountPlngStatusName,
  QualityMgmtInspPlngStatus,
  QualityMgmtInspPlngStsName,
  CheckToleranceStatus,
  CheckToleranceStatusName,
  ValuationQtyAssignmentStatus,
  ValuationQtyAssgmtStatusName,
  WarehouseActivityStatus,
  WarehouseActivityStatusName,
  InbDelivItemCrtnUTCDateTime,
  ActualGRStartUTCDateTime,
  PlannedGRStartUTCDateTime,
  PlannedGREndUTCDateTime,
  ActualPutawayEndUTCDateTime,
  ActualGREndUTCDateTime,
  NoWhseActivityTimeInMinutes,
  GoodsReceiptDurationInMinutes / NumberOfInbDelivItems AS GoodsReceiptDurationInMinutes,
  PlndDeliveryWhseTmznDateTime,
  PlndGREndWhseTmznDateTime,
  PutawayEndWhseTmznDateTime,
  ActualGREndWhseTmznDateTime,
  InbDelivItmCmpltWhseTmznDteTme,
  PlannedDeliveryWhseTmznYear,
  PlannedDeliveryWhseTmznMonth,
  PlannedDeliveryWhseTmznDate,
  PlannedDeliveryWhseTmznHour,
  PlannedDeliveryWhseTmznTime,
  PlndGoodsReceiptWhseTmznYear,
  PlndGoodsReceiptWhseTmznMonth,
  PlndGoodsReceiptWhseTmznDate,
  PlndGoodsReceiptWhseTmznHour,
  PlndGoodsReceiptWhseTmznTime,
  PutawayEndWhseTmznYear,
  PutawayEndWhseTmznMonth,
  PutawayEndWhseTmznDate,
  PutawayEndWhseTmznHour,
  PutawayEndWhseTmznTime,
  GoodsReceiptEndWhseTmznYear,
  GoodsReceiptEndWhseTmznMonth,
  GoodsReceiptEndWhseTmznDate,
  GoodsReceiptEndWhseTmznHour,
  GoodsReceiptEndWhseTmznTime,
  InbDelivCompltnEndWhseTmznYear,
  InbDelivCompltnEndWhseTmznMnth,
  InbDelivCompltnEndWhseTmznDate,
  InbDelivCompltnEndWhseTmznHour,
  InbDelivCompltnEndWhseTmznTime,
  PlndDelivTo30MinsWhseDteTme,
  PlndDelivTo60MinsWhseDteTme,
  CompltnEndTo30MinsWhseDteTme,
  CompltnEndTo60MinsWhseDteTme,
  GREndRnddTo30MinsWhseDteTme,
  GREndRnddTo60MinsWhseDteTme,
  PtwyEndRnddTo30MinsWhseDteTme,
  PtwyEndRnddTo60MinsWhseDteTme,
  1 AS NumberOfInboundDeliveries,
  NumberOfInbDelivItems,
  EWMPlndGRWhseTmznHour,
  EWMQuantityHasAdjustment,
  EWMPlndGRDateIsInPast,
  EWMActualGRDateIsOnTime,
  EWMPlndGoodsReceiptDateIsToday,
  EWMActualPutawayDateIsToday,
  EWMPlndOrActGRIsToday,
  EWMPlndDeliveryTimeIsInPast,
  EWMActGRIsBeforePlndDelivTime,
  EWMPlndDeliveryDateIsToday,
  EWMPlndDeliveryWhseTmznHour
FROM I_EWM_InbDeliveryItemC_2
;

Depth:

C_EWM_InbDelivItemLeanQ_2 view_entity

I_EWM_InbDeliveryItemC_2 view_entity