C_EWM_InboundDeliveryItemQ
Warehouse Inbound Delivery Item - Query
C_EWM_InboundDeliveryItemQ (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_InboundDeliveryItemQ is a Consumption CDS View that provides data about "Warehouse Inbound Delivery Item - Query" in SAP S/4HANA. It reads from 1 data source (I_EWM_InboundDeliveryItemC) and exposes 173 fields with key fields Warehouse, InboundDelivery, InboundDeliveryItem.
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 (16)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CEWMINBDELIVQ | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| EndUserText.label | Warehouse Inbound Delivery Item - Query | view | |
| AbapCatalog.preserveKey | true | view | |
| ClientHandling.type | #INHERITED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | 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 | |
| ObjectModel.supportedCapabilities | #ANALYTICAL_QUERY | view | |
| VDM.viewType | #CONSUMPTION | view | |
| OData.publish | true | view | |
| Analytics.query | true | view |
Fields (173)
| Key | Field | Source Table | 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 | ||
| ReceivingOffice | ReceivingOffice | Goods Receipt Office | ||
| MeansOfTransportType | MeansOfTransportType | Means of Transport Type | ||
| MeansOfTransportTypeName | MeansOfTransportTypeName | Desc. of Means of Transport Type | ||
| MeansOfTransport | MeansOfTransport | Means-of-Transport ID | ||
| DeliveryItemCategory | DeliveryItemCategory | Inbound Delivery Item Category | ||
| DeliveryItemCategoryName | DeliveryItemCategoryName | Description of Inb. Deliv. Item Category | ||
| DeliveryDocumentCategory | DeliveryDocumentCategory | Inbound Delivery Document Category | ||
| InboundDeliveryDocumentType | InboundDeliveryDocumentType | Inbound Delivery Document Type | ||
| InbDeliveryDocumentTypeName | InbDeliveryDocumentTypeName | Description of Inb. Deliv. Document Type | ||
| 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 | ||
| WarehouseDoor | WarehouseDoor | Warehouse Door | ||
| StagingAreaGroup | StagingAreaGroup | Staging Area Group | ||
| StagingArea | StagingArea | Staging Area | ||
| StagingBay | StagingBay | Staging Bay | ||
| GoodsMovementBin | GoodsMovementBin | Storage Bin of Goods Movement Posting | ||
| Product | Product | Product | ||
| ProductName | ProductName | Product Description | ||
| Batch | Batch | Product Batch | ||
| RequirementSegment | RequirementSegment | Requirement Segment | ||
| StockSegment | StockSegment | Stock Segment | ||
| 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 | ||
| IsBusinessPurposeCompleted | IsBusinessPurposeCompleted | Business Purpose Is Completed | ||
| Carrier | Carrier | Business Partner Number | ||
| CarrierName | CarrierName | Carrier Description | ||
| StockOwner | StockOwner | Owner | ||
| StockOwnerName | StockOwnerName | 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 | ||
| CompletionStatus | CompletionStatus | Completion Status | ||
| CompletionStatusName | CompletionStatusName | Individual Status of an Object | ||
| UnloadingStatus | UnloadingStatus | Unloading Status | ||
| UnloadingStatusName | UnloadingStatusName | Individual Status of an Object | ||
| PutawayStatus | PutawayStatus | Putaway Status | ||
| PutawayStatusName | PutawayStatusName | Individual Status of an Object | ||
| GoodsReceiptStatus | GoodsReceiptStatus | Goods Receipt Status | ||
| GoodsReceiptStatusName | GoodsReceiptStatusName | Description of Goods Receipt Status | ||
| QualityMgmtCountPlngStatus | QualityMgmtCountPlngStatus | QM Count Planning Status | ||
| QualityMgmtCountPlngStatusName | QualityMgmtCountPlngStatusName | Desc. of QM Count Planning Status | ||
| QualityMgmtInspPlngStatus | QualityMgmtInspPlngStatus | Quality Inspection Planning Sts | ||
| QualityMgmtInspPlngStsName | QualityMgmtInspPlngStsName | Desc. of Quality Inspection Planning Sts | ||
| QualityMgmtInspectionStatus | QualityMgmtInspectionStatus | Quality Inspection Status | ||
| QualityMgmtInspectionStsName | QualityMgmtInspectionStsName | Desc. of Quality Inspection Status | ||
| GoodsMovementBlockStatus | GoodsMovementBlockStatus | Goods Movement Blocking Status | ||
| GoodsMovementBlockStatusName | GoodsMovementBlockStatusName | Desc. of Goods Movement Blocking Status | ||
| CheckToleranceStatus | CheckToleranceStatus | Tolerance Check Status | ||
| CheckToleranceStatusName | CheckToleranceStatusName | Description of Tolerance Check Status | ||
| PlanningPutawayStatus | PlanningPutawayStatus | Planning Putaway Status | ||
| PlanningPutawayStatusName | PlanningPutawayStatusName | Description of Planning Putaway Status | ||
| TransportationUnitAssgmtStatus | TransportationUnitAssgmtStatus | Status of Transportation Unit Assignment | ||
| TranspUnitAssgmtStatusName | TranspUnitAssgmtStatusName | Desc. of Transp. Unit Assignment Status | ||
| ValueAddedServiceOrderStatus | ValueAddedServiceOrderStatus | Status of Value-Added Service Order | ||
| ValueAddedDelivStsName | ValueAddedDelivStsName | Desc. of Value-Added Service Order Sts | ||
| ValuationQtyAssignmentStatus | ValuationQtyAssignmentStatus | Status of Valuation Quantity Assgmt | ||
| ValuationQtyAssgmtStatusName | ValuationQtyAssgmtStatusName | Desc. of Valuation Qty Assgmt Status | ||
| WarehouseActivityStatus | WarehouseActivityStatus | Warehouse Activity Status | ||
| WarehouseActivityStatusName | WarehouseActivityStatusName | Description of Warehouse Activity Status | ||
| TransitStatus | TransitStatus | Transit Status | ||
| TransitStatusName | TransitStatusName | Individual Status of an Object | ||
| TransitProcedureStatus | TransitProcedureStatus | Transit Procedure Status | ||
| TransitProcedureStatusName | TransitProcedureStatusName | Description of Transit Procedure Status | ||
| TransportationPlanningStatus | TransportationPlanningStatus | Transportation Planning Status | ||
| TranspPlngStatusName | TranspPlngStatusName | Desc. of Transportation Planning Status | ||
| 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 | ||
| TranspPlanBlockStatus | TranspPlanBlockStatus | Blocked (Transp. Plan) Status | ||
| TranspPlanBlockStatusName | TranspPlanBlockStatusName | Desc. of Blocked (Transp. Plan) Status | ||
| InbDelivItemCrtnUTCDateTime | InbDelivItemCrtnUTCDateTime | Inbound Delivery Item Created On (UTC) | ||
| PlannedGRStartUTCDateTime | PlannedGRStartUTCDateTime | Planned Goods Receipt Started On (UTC) | ||
| PlannedGREndUTCDateTime | PlannedGREndUTCDateTime | Planned Goods Receipt Ended On (UTC) | ||
| UnloadingEndUTCDateTime | UnloadingEndUTCDateTime | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| ActualPutawayEndUTCDateTime | ActualPutawayEndUTCDateTime | Putaway Ended On (UTC) | ||
| ActualGRStartUTCDateTime | ActualGRStartUTCDateTime | Goods Receipt Started On (UTC) | ||
| ActualGREndUTCDateTime | ActualGREndUTCDateTime | Goods Receipt Ended On (UTC) | ||
| InbDelivCompltnEndUTCDateTime | InbDelivCompltnEndUTCDateTime | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| PlndArrivalInYardUTCDateTime | PlndArrivalInYardUTCDateTime | Planned Arrival in Yard On (UTC) | ||
| ActualArrivalInYardUTCDateTime | ActualArrivalInYardUTCDateTime | Actual Arrival in Yard On (UTC) | ||
| PlndDeliveryWhseTmznDateTime | PlndDeliveryWhseTmznDateTime | Planned Delivery Date and Time | ||
| ActualDeliveryWhseTmznDateTime | ActualDeliveryWhseTmznDateTime | Delivery Date and Time | ||
| PlndArrvlInYardWhseTmznDteTme | PlndArrvlInYardWhseTmznDteTme | Date and Time of Plnd Arrival in Yard | ||
| ActlArrvlInYardWhseTmznDteTme | ActlArrvlInYardWhseTmznDteTme | Date and Time of Arrival in Yard | ||
| PutawayEndWhseTmznDateTime | PutawayEndWhseTmznDateTime | End Date and Time of Putaway | ||
| ActualGREndWhseTmznDateTime | ActualGREndWhseTmznDateTime | Goods Receipt Ended On | ||
| UnloadingEndWhseTmznDateTime | UnloadingEndWhseTmznDateTime | End Date and Time of Unloading | ||
| InbDelivItmCmpltWhseTmznDteTme | InbDelivItmCmpltWhseTmznDteTme | Inbound Delivery Item Completed On | ||
| InbDelivCrtnWhseTmznDateTime | InbDelivCrtnWhseTmznDateTime | Inbound Delivery Created On | ||
| PlndGREndWhseTmznDateTime | PlndGREndWhseTmznDateTime | Date and Time of Planned Goods Receipt | ||
| GoodsReceiptDurationInMinutes | Average Receiving Time (Minute) | |||
| WaitInYardDurationInMinutes | Total Wait Time in Yard (Minute) | |||
| ArrivalInYardOvrdDurnInMinutes | ArrivalInYardOvrdDurnInMinutes | Overdue Time (Minute) of Arrival | ||
| NoWhseActivityTimeInMinutes | NoWhseActivityTimeInMinutes | Time Without Whse Activities (Minute) | ||
| 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 | ||
| UnloadingEndWhseTmznYear | UnloadingEndWhseTmznYear | Unloading End Date (Year) | ||
| UnloadingEndWhseTmznMonth | UnloadingEndWhseTmznMonth | Unloading End Date (Month) | ||
| UnloadingEndWhseTmznDate | UnloadingEndWhseTmznDate | Unloading End Date | ||
| UnloadingEndWhseTmznHour | UnloadingEndWhseTmznHour | Unloading End Time (Hour) | ||
| UnloadingEndWhseTmznTime | UnloadingEndWhseTmznTime | Unloading End 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 | ||
| 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 | ||
| ActualDeliveryWhseTmznYear | ActualDeliveryWhseTmznYear | Delivery Date (Year) | ||
| ActualDeliveryWhseTmznMonth | ActualDeliveryWhseTmznMonth | Delivery Date (Month) | ||
| ActualDeliveryWhseTmznDate | ActualDeliveryWhseTmznDate | Delivery Date | ||
| ActualDeliveryWhseTmznHour | ActualDeliveryWhseTmznHour | Delivery Time (Hour) | ||
| ActualDeliveryWhseTmznTime | ActualDeliveryWhseTmznTime | Delivery Time | ||
| PlndArrvlInYardWhseTmznYear | PlndArrvlInYardWhseTmznYear | Date (Year) of Planned Arrival in Yard | ||
| PlndArrvlInYardWhseTmznMonth | PlndArrvlInYardWhseTmznMonth | Date (Month) of Planned Arrival in Yard | ||
| PlndArrvlInYardWhseTmznDate | PlndArrvlInYardWhseTmznDate | Date of Planned Arrival in Yard | ||
| PlndArrvlInYardWhseTmznHour | PlndArrvlInYardWhseTmznHour | Time (Hour) of Planned Arrival in Yard | ||
| PlndArrvlInYardWhseTmznTime | PlndArrvlInYardWhseTmznTime | Time of Planned Arrival in Yard | ||
| ActlArrvlInYardWhseTmznYear | ActlArrvlInYardWhseTmznYear | Date (Year) of Arrival in Yard | ||
| ActlArrvlInYardWhseTmznMonth | ActlArrvlInYardWhseTmznMonth | Date (Month) of Arrival in Yard | ||
| ActlArrvlInYardWhseTmznDate | ActlArrvlInYardWhseTmznDate | Arrival Date in Yard | ||
| ActlArrvlInYardWhseTmznHour | ActlArrvlInYardWhseTmznHour | Arrival Time (Hour) in Yard | ||
| ActlArrvlInYardWhseTmznTime | ActlArrvlInYardWhseTmznTime | Arrival Time in Yard | ||
| PlndDelivTo30MinsWhseDteTme | PlndDelivTo30MinsWhseDteTme | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| PlndDelivTo60MinsWhseDteTme | PlndDelivTo60MinsWhseDteTme | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| PlndArrvlTo30MinsWhseDteTme | PlndArrvlTo30MinsWhseDteTme | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| PlndArrvlTo60MinsWhseDteTme | PlndArrvlTo60MinsWhseDteTme | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| ActlDelivTo30MinsWhseDteTme | ActlDelivTo30MinsWhseDteTme | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| ActlDelivTo60MinsWhseDteTme | ActlDelivTo60MinsWhseDteTme | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| ActlArrvlTo30MinsWhseDteTme | ActlArrvlTo30MinsWhseDteTme | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| ActlArrvlTo60MinsWhseDteTme | ActlArrvlTo60MinsWhseDteTme | 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) | ||
| UnldgEndRnddTo30MinsWhseDteTme | UnldgEndRnddTo30MinsWhseDteTme | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| UnldgEndRnddTo60MinsWhseDteTme | UnldgEndRnddTo60MinsWhseDteTme | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| NumberOfInboundDeliveries | 1 | Number of Inbound Deliveries | ||
| NumberOfInbDelivItems | NumberOfInbDelivItems | Number of Inbound Delivery Items |
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_InboundDeliveryItemQ.
-- 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: CEWMINBDELIVQ
CREATE VIEW C_EWM_InboundDeliveryItemQ AS
SELECT
Warehouse,
InboundDelivery,
InboundDeliveryItem,
_Warehouse._Text[1:Language = $parameters.P_Language].WarehouseName AS WarehouseName,
TimeZoneID,
ReceivingOffice,
MeansOfTransportType,
MeansOfTransportTypeName,
MeansOfTransport,
DeliveryItemCategory,
DeliveryItemCategoryName,
DeliveryDocumentCategory,
InboundDeliveryDocumentType,
InbDeliveryDocumentTypeName,
InboundDeliveryItemType,
InboundDeliveryItemTypeName,
WarehouseProcessType,
WarehouseProcessTypeName,
WarehouseDoor,
StagingAreaGroup,
StagingArea,
StagingBay,
GoodsMovementBin,
Product,
ProductName,
Batch,
RequirementSegment,
StockSegment,
EntitledToDisposeParty,
NameOfEntitledToDisposeParty,
ShipFromParty,
ShipFromPartyName,
IsBusinessPurposeCompleted,
Carrier,
CarrierName,
StockOwner,
StockOwnerName,
StockType,
StockTypeName,
ProductQuantity,
QuantityUnit,
ItemVolume,
DisplayVolumeUnit,
ItemNetWeight,
ItemGrossWeight,
DisplayWeightUnit,
CompletionStatus,
CompletionStatusName,
UnloadingStatus,
UnloadingStatusName,
PutawayStatus,
PutawayStatusName,
GoodsReceiptStatus,
GoodsReceiptStatusName,
QualityMgmtCountPlngStatus,
QualityMgmtCountPlngStatusName,
QualityMgmtInspPlngStatus,
QualityMgmtInspPlngStsName,
QualityMgmtInspectionStatus,
QualityMgmtInspectionStsName,
GoodsMovementBlockStatus,
GoodsMovementBlockStatusName,
CheckToleranceStatus,
CheckToleranceStatusName,
PlanningPutawayStatus,
PlanningPutawayStatusName,
TransportationUnitAssgmtStatus,
TranspUnitAssgmtStatusName,
ValueAddedServiceOrderStatus,
ValueAddedDelivStsName,
ValuationQtyAssignmentStatus,
ValuationQtyAssgmtStatusName,
WarehouseActivityStatus,
WarehouseActivityStatusName,
TransitStatus,
TransitStatusName,
TransitProcedureStatus,
TransitProcedureStatusName,
TransportationPlanningStatus,
TranspPlngStatusName,
OverallBlockStatus,
OverallBlockStatusName,
ItemInconsistencyBlkStatus,
ItemInconsistencyBlkStatusName,
TranspPlanBlockStatus,
TranspPlanBlockStatusName,
InbDelivItemCrtnUTCDateTime,
PlannedGRStartUTCDateTime,
PlannedGREndUTCDateTime,
UnloadingEndUTCDateTime,
ActualPutawayEndUTCDateTime,
ActualGRStartUTCDateTime,
ActualGREndUTCDateTime,
InbDelivCompltnEndUTCDateTime,
PlndArrivalInYardUTCDateTime,
ActualArrivalInYardUTCDateTime,
PlndDeliveryWhseTmznDateTime,
ActualDeliveryWhseTmznDateTime,
PlndArrvlInYardWhseTmznDteTme,
ActlArrvlInYardWhseTmznDteTme,
PutawayEndWhseTmznDateTime,
ActualGREndWhseTmznDateTime,
UnloadingEndWhseTmznDateTime,
InbDelivItmCmpltWhseTmznDteTme,
InbDelivCrtnWhseTmznDateTime,
PlndGREndWhseTmznDateTime,
GoodsReceiptDurationInMinutes / NumberOfInbDelivItems AS GoodsReceiptDurationInMinutes,
WaitInYardDurationInMinutes / NumberOfInbDelivItems AS WaitInYardDurationInMinutes,
ArrivalInYardOvrdDurnInMinutes,
NoWhseActivityTimeInMinutes,
PlndGoodsReceiptWhseTmznYear,
PlndGoodsReceiptWhseTmznMonth,
PlndGoodsReceiptWhseTmznDate,
PlndGoodsReceiptWhseTmznHour,
PlndGoodsReceiptWhseTmznTime,
UnloadingEndWhseTmznYear,
UnloadingEndWhseTmznMonth,
UnloadingEndWhseTmznDate,
UnloadingEndWhseTmznHour,
UnloadingEndWhseTmznTime,
PutawayEndWhseTmznYear,
PutawayEndWhseTmznMonth,
PutawayEndWhseTmznDate,
PutawayEndWhseTmznHour,
PutawayEndWhseTmznTime,
GoodsReceiptEndWhseTmznYear,
GoodsReceiptEndWhseTmznMonth,
GoodsReceiptEndWhseTmznDate,
GoodsReceiptEndWhseTmznHour,
GoodsReceiptEndWhseTmznTime,
InbDelivCompltnEndWhseTmznYear,
InbDelivCompltnEndWhseTmznMnth,
InbDelivCompltnEndWhseTmznDate,
InbDelivCompltnEndWhseTmznHour,
InbDelivCompltnEndWhseTmznTime,
PlannedDeliveryWhseTmznYear,
PlannedDeliveryWhseTmznMonth,
PlannedDeliveryWhseTmznDate,
PlannedDeliveryWhseTmznHour,
PlannedDeliveryWhseTmznTime,
ActualDeliveryWhseTmznYear,
ActualDeliveryWhseTmznMonth,
ActualDeliveryWhseTmznDate,
ActualDeliveryWhseTmznHour,
ActualDeliveryWhseTmznTime,
PlndArrvlInYardWhseTmznYear,
PlndArrvlInYardWhseTmznMonth,
PlndArrvlInYardWhseTmznDate,
PlndArrvlInYardWhseTmznHour,
PlndArrvlInYardWhseTmznTime,
ActlArrvlInYardWhseTmznYear,
ActlArrvlInYardWhseTmznMonth,
ActlArrvlInYardWhseTmznDate,
ActlArrvlInYardWhseTmznHour,
ActlArrvlInYardWhseTmznTime,
PlndDelivTo30MinsWhseDteTme,
PlndDelivTo60MinsWhseDteTme,
PlndArrvlTo30MinsWhseDteTme,
PlndArrvlTo60MinsWhseDteTme,
ActlDelivTo30MinsWhseDteTme,
ActlDelivTo60MinsWhseDteTme,
ActlArrvlTo30MinsWhseDteTme,
ActlArrvlTo60MinsWhseDteTme,
CompltnEndTo30MinsWhseDteTme,
CompltnEndTo60MinsWhseDteTme,
GREndRnddTo30MinsWhseDteTme,
GREndRnddTo60MinsWhseDteTme,
PtwyEndRnddTo30MinsWhseDteTme,
PtwyEndRnddTo60MinsWhseDteTme,
UnldgEndRnddTo30MinsWhseDteTme,
UnldgEndRnddTo60MinsWhseDteTme,
1 AS NumberOfInboundDeliveries,
NumberOfInbDelivItems
FROM I_EWM_InboundDeliveryItemC
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA