What is C_EWM_InbDelivItemLeanQ in SAP S/4HANA?

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

Which tables does C_EWM_InbDelivItemLeanQ read from?

C_EWM_InbDelivItemLeanQ reads data from: I_EWM_InboundDeliveryItemC.

What VDM layer is C_EWM_InbDelivItemLeanQ?

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

C_EWM_InbDelivItemLeanQ

DDL: C_EWM_INBDELIVITEMLEANQ SQL: CEWMINBDELIVLQ Type: view CONSUMPTION

113 Fields 1 Data Sources

Whse Inbound Delivery Item Lean - Query

C_EWM_InbDelivItemLeanQ (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 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_InboundDeliveryItemC) and exposes 113 fields with key fields Warehouse, InboundDelivery, InboundDeliveryItem.

SAP Help Documentation

Category	CDS Views for Deliveries
Data Category	Query
Status	Released
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?

Prerequisites
Users who want to run reports using this CDS view must have a role based on the business role template listed in the table 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
Main CDS parameters and Filters This view has no mandatory input parameters. The main filters are as follows: Warehouse Inbound Delivery Inbound Delivery Document Type Planned Delivery Date Planned Goods Receipt Date Measures and Attributes Some important measures and attributes are as follows: Number of Inbound Deliveries Number of Inbound Delivery Items Gross Weight of Inbound Delivery Items Net Weight of Inbound Delivery Items Volume of Inbound Delivery Items Product Quantity Total Receiving Time Average Putaway Time

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Application Help SAP Library BI Content . For more information on extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

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

View on SAP Help Portal →

SAP API Hub

State	Deprecated
Line of Business	Supply Chain
Application Component	SCM-EWM-DLP
Capabilities	Analytical Query
Package	Supply Chain for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides the prerequisites for answering the following business questions:</p> <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>

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_InboundDeliveryItemC	I_EWM_InboundDeliveryItemC	from

Annotations (17)

Name	Value	Level
AbapCatalog.sqlViewName	CEWMINBDELIVLQ	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Whse Inbound Delivery Item Lean - Query	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
Metadata.ignorePropagatedAnnotations	true	view
ClientHandling.type	#INHERITED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view
ObjectModel.supportedCapabilities	#ANALYTICAL_QUERY	view
VDM.viewType	#CONSUMPTION	view
OData.publish	true	view
Analytics.query	true	view
Analytics.internalName	#LOCAL	view

Fields (113)

Key	Field	Source Field	Description
KEY	Warehouse	Warehouse	Warehouse Number/Warehouse Complex
KEY	InboundDelivery	InboundDelivery	Document No. of Inbound Delivery
KEY	InboundDeliveryItem	InboundDeliveryItem	No. of Inbound Delivery Items
	WarehouseName		Warehouse Description
	TimeZoneID	TimeZoneID	Warehouse Time Zone
	DeliveryDocumentCategory	DeliveryDocumentCategory	Inbound Delivery Document Category
	DeliveryItemCategory	DeliveryItemCategory	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.)
	InboundDeliveryItemType	InboundDeliveryItemType	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
	StockOwner	StockOwner	Stock Owner
	StockOwnerName	StockOwnerName	Stock Owner Description
	StockType	StockType	Stock Type
	StockTypeName	StockTypeName	Description of Stock Type
	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.
-- 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.
-- SQL view name: CEWMINBDELIVLQ

CREATE VIEW C_EWM_InbDelivItemLeanQ AS
SELECT
  Warehouse,
  InboundDelivery,
  InboundDeliveryItem,
  _Warehouse._Text[1:Language = $parameters.P_Language].WarehouseName AS WarehouseName,
  TimeZoneID,
  DeliveryDocumentCategory,
  DeliveryItemCategory,
  DeliveryItemCategoryName,
  InboundDeliveryDocumentType,
  InbDeliveryDocumentTypeName,
  InboundDeliveryItemType,
  InboundDeliveryItemTypeName,
  WarehouseProcessType,
  WarehouseProcessTypeName,
  Product,
  ProductName,
  Batch,
  EntitledToDisposeParty,
  NameOfEntitledToDisposeParty,
  ShipFromParty,
  ShipFromPartyName,
  StockOwner,
  StockOwnerName,
  StockType,
  StockTypeName,
  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_InboundDeliveryItemC
;

Depth:

C_EWM_InbDelivItemLeanQ view

I_EWM_InboundDeliveryItemC view