I_EWM_InbDeliveryItemBasic
Inbound Delivery Item Basic
I_EWM_InbDeliveryItemBasic is a Composite CDS View that provides data about "Inbound Delivery Item Basic" in SAP S/4HANA. It reads from 1 data source (I_EWM_WarehouseRequestInbItem) and exposes 62 fields with key fields InboundDeliveryUUID, InboundDeliveryItemUUID. It has 5 associations to related views. Part of development package VDM_EWM_DLV.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_EWM_WarehouseRequestInbItem | IbdDeliveryItemBasic | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_EWM_DeliveryStatus | _ItemStatus | $projection.InboundDeliveryUUID = _ItemStatus.DeliveryUUID and $projection.InboundDeliveryItemUUID = _ItemStatus.DeliveryItemUUID and _ItemStatus.EWMDeliveryDocumentCategory = 'PDI' |
| [0..*] | I_EWM_DeliveryQuantity_2 | _Quantity | $projection.InboundDeliveryUUID = _Quantity.DeliveryUUID and $projection.InboundDeliveryItemUUID = _Quantity.DeliveryItemUUID and _Quantity.EWMDeliveryDocumentCategory = 'PDI' |
| [0..*] | I_EWM_DeliveryDateAndTime | _DeliveryItemDateTime | $projection.InboundDeliveryUUID = _DeliveryItemDateTime.DeliveryOrderUUID and $projection.InboundDeliveryItemUUID = _DeliveryItemDateTime.DeliveryOrderItemUUID and _DeliveryItemDateTime.DeliveryDocumentCategory = 'PDI' |
| [0..*] | I_EWM_WhseReqItmExtProdBatch | _ExtProdBatch | $projection.InboundDeliveryUUID = _ExtProdBatch.EWMWarehouseRequestUUID and $projection.InboundDeliveryItemUUID = _ExtProdBatch.EWMWarehouseRequestItemUUID and $projection.DeliveryDocumentCategory = 'PDI' |
| [1] | I_EWM_SerialNumberHeader_2 | _SerialNumberLevel | $projection.EWMWarehouse = _SerialNumberLevel.EWMWarehouse and $projection.EntitledToDisposeParty = _SerialNumberLevel.EntitledToDisposeParty and $projection.ProductUUID = _SerialNumberLevel.ProductUUID |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| EndUserText.label | Inbound Delivery Item Basic | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| VDM.viewType | #COMPOSITE | view |
Fields (62)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InboundDeliveryUUID | EWMWarehouseRequestUUID | ||
| KEY | InboundDeliveryItemUUID | EWMWarehouseRequestItemUUID | ||
| Warehouse | EWMWarehouse | |||
| EWMWarehouse | EWMWarehouse | |||
| InboundDelivery | EWMWarehouseRequest | |||
| EWMInboundDelivery | EWMWarehouseRequest | |||
| InboundDeliveryItem | EWMWarehouseRequestItem | |||
| EWMInboundDeliveryItem | EWMWarehouseRequestItem | |||
| DeliveryDocumentCategory | EWMWhseRequestDocumentCategory | |||
| DeliveryItemCategory | EWMWhseRequestItemCategory | |||
| EWMInboundDeliveryItemCategory | EWMWhseRequestItemCategory | |||
| InboundDeliveryItemType | EWMWarehouseRequestItemType | |||
| EWMInboundDeliveryItemType | EWMWarehouseRequestItemType | |||
| WarehouseProcessType | WarehouseProcessType | |||
| WarehouseDoor | WarehouseDoor | |||
| StagingAreaGroup | StagingAreaGroup | |||
| StagingArea | StagingArea | |||
| StagingBay | StagingBay | |||
| ProductionSupplyArea | EWMProductionSupplyArea | |||
| EWMProductionSupplyArea | EWMProductionSupplyArea | |||
| GoodsMovementBin | GoodsMovementBin | |||
| Product | Product | |||
| ProductUUID | ProductUUID | |||
| ProductExternalID | ProductExternalID | |||
| Batch | ||||
| SerialNumberRequiredLevel | _SerialNumberLevel | SerialNumberRequiredLevel | ||
| RequirementSegment | RequirementSegment | |||
| StockSegment | StockSegment | |||
| CountryOfOrigin | CountryOfOrigin | |||
| EntitledToDisposeParty | EntitledToDisposeParty | |||
| StockOwner | EWMStockOwner | |||
| EWMStockOwner | EWMStockOwner | |||
| StockType | EWMStockType | |||
| EWMStockType | EWMStockType | |||
| StockUsage | StockUsage | |||
| StockDocumentCategory | StockDocumentCategory | |||
| StockDocumentNumber | StockDocumentNumber | |||
| StockItemNumber | StockItemNumber | |||
| EWMGoodsRecipient | EWMGoodsRecipient | |||
| EWMRecipientLocationName | EWMRecipientLocationName | |||
| DeliveryItemStockTypeDetnCode | EWMWhseReqItmStockTypeDetnCode | |||
| ProductQuantity | ProductQuantity | |||
| CompletionStatus | CompletionStatus | |||
| GoodsReceiptStatus | GoodsReceiptStatus | |||
| FldLogsStatus | FldLogsStatus | |||
| LastChangeTime | EWMWhseReqLastChangeUTCDteTme | |||
| EWMDelivLastChangeUTCDateTime | EWMWhseReqLastChangeUTCDteTme | |||
| QuantityUnit | QuantityUnit | |||
| InbDelivItemCrtnUTCDateTime | EWMWhseReqCreationUTCDateTime | |||
| PlndGREndWhseTmznDateTime | PlndGREndWhseTmznDateTime | |||
| UnloadingEndWhseTmznDateTime | UnloadingEndWhseTmznDateTime | |||
| PutawayEndWhseTmznDateTime | PutawayEndWhseTmznDateTime | |||
| ActualGREndWhseTmznDateTime | ActualGREndWhseTmznDateTime | |||
| InbDelivItmCmpltWhseTmznDteTme | EWMItmCmpltWhseTmznDteTme | |||
| PurchasingDocument | PurchasingDocument | |||
| PurchasingDocumentItem | PurchasingDocumentItem | |||
| PurchaseOrder | PurchaseOrder | |||
| PurchaseOrderItem | PurchaseOrderItem | |||
| _ItemStatus | _ItemStatus | |||
| _Quantity | _Quantity | |||
| _DeliveryItemDateTime | _DeliveryItemDateTime | |||
| _ExtProdBatch | _ExtProdBatch |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Inbound Delivery Item Basic'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking :#REQUIRED
@VDM.viewType:#COMPOSITE
define view entity I_EWM_InbDeliveryItemBasic
as select from I_EWM_WarehouseRequestInbItem as IbdDeliveryItemBasic
association [0..*] to I_EWM_DeliveryStatus as _ItemStatus on $projection.InboundDeliveryUUID = _ItemStatus.DeliveryUUID
and $projection.InboundDeliveryItemUUID = _ItemStatus.DeliveryItemUUID
and _ItemStatus.EWMDeliveryDocumentCategory = 'PDI'
association [0..*] to I_EWM_DeliveryQuantity_2 as _Quantity on $projection.InboundDeliveryUUID = _Quantity.DeliveryUUID
and $projection.InboundDeliveryItemUUID = _Quantity.DeliveryItemUUID
and _Quantity.EWMDeliveryDocumentCategory = 'PDI'
association [0..*] to I_EWM_DeliveryDateAndTime as _DeliveryItemDateTime on $projection.InboundDeliveryUUID = _DeliveryItemDateTime.DeliveryOrderUUID
and $projection.InboundDeliveryItemUUID = _DeliveryItemDateTime.DeliveryOrderItemUUID
and _DeliveryItemDateTime.DeliveryDocumentCategory = 'PDI'
association [0..*] to I_EWM_WhseReqItmExtProdBatch as _ExtProdBatch on $projection.InboundDeliveryUUID = _ExtProdBatch.EWMWarehouseRequestUUID
and $projection.InboundDeliveryItemUUID = _ExtProdBatch.EWMWarehouseRequestItemUUID
and $projection.DeliveryDocumentCategory = 'PDI'
association [1] to I_EWM_SerialNumberHeader_2 as _SerialNumberLevel on $projection.EWMWarehouse = _SerialNumberLevel.EWMWarehouse
and $projection.EntitledToDisposeParty = _SerialNumberLevel.EntitledToDisposeParty
and $projection.ProductUUID = _SerialNumberLevel.ProductUUID
{
key EWMWarehouseRequestUUID as InboundDeliveryUUID,
key EWMWarehouseRequestItemUUID as InboundDeliveryItemUUID,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMWarehouse'
EWMWarehouse as Warehouse,
EWMWarehouse as EWMWarehouse,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMInboundDelivery'
EWMWarehouseRequest as InboundDelivery,
EWMWarehouseRequest as EWMInboundDelivery,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMInboundDeliveryItem'
EWMWarehouseRequestItem as InboundDeliveryItem,
EWMWarehouseRequestItem as EWMInboundDeliveryItem,
EWMWhseRequestDocumentCategory as DeliveryDocumentCategory,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMInboundDeliveryItemCategory'
EWMWhseRequestItemCategory as DeliveryItemCategory,
EWMWhseRequestItemCategory as EWMInboundDeliveryItemCategory,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMInboundDeliveryItemType'
EWMWarehouseRequestItemType as InboundDeliveryItemType,
EWMWarehouseRequestItemType as EWMInboundDeliveryItemType,
WarehouseProcessType,
WarehouseDoor,
StagingAreaGroup,
StagingArea,
StagingBay,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMProductionSupplyArea'
EWMProductionSupplyArea as ProductionSupplyArea,
EWMProductionSupplyArea,
GoodsMovementBin,
Product,
ProductUUID,
ProductExternalID,
cast(ProductBatch as charg_d) as Batch,
_SerialNumberLevel.SerialNumberRequiredLevel as SerialNumberRequiredLevel,
RequirementSegment,
StockSegment,
CountryOfOrigin,
EntitledToDisposeParty,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMStockOwner'
EWMStockOwner as StockOwner,
EWMStockOwner,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMStockType'
EWMStockType as StockType,
EWMStockType,
StockUsage,
StockDocumentCategory,
StockDocumentNumber,
StockItemNumber,
EWMGoodsRecipient,
EWMRecipientLocationName,
/* Special Stock - Sales Order */
case StockDocumentCategory
when 'SOS' then cast(substring(StockDocumentNumber,26,10) as vbeln preserving type)
else cast( ' ' as vbeln preserving type ) end as SpecialStockIdfgSalesOrder, // SOS -> Valuated Sales Order
/* Special Stock - Sales Order Item */
case StockDocumentCategory
when 'SOS' then cast(substring(StockItemNumber, 5,6) as abap.numc( 6 ))
else cast( '000000' as numc06 preserving type ) end as SpecialStockIdfgSalesOrderItem,
EWMWhseReqItmStockTypeDetnCode as DeliveryItemStockTypeDetnCode,
ProductQuantity,
CompletionStatus,
GoodsReceiptStatus,
FldLogsStatus, // Introduced with 2202 CE for Field Logistic colleagues
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'EWMDelivLastChangeUTCDateTime'
EWMWhseReqLastChangeUTCDteTme as LastChangeTime,
EWMWhseReqLastChangeUTCDteTme as EWMDelivLastChangeUTCDateTime,
/* Product Attributes */
cast( case when EWMWhseReqItmProdnEndDteTme is not initial
then EWMWhseReqItmProdnEndDteTme
else EWMWhseReqItmProdnStrtDteTme end as ewm_de_whsereqitm_prod_tst preserving type ) as EWMWhseReqItmProdnDteTme,
cast( case when EWMWhseReqItmBBDEndUTCDteTme is not initial
then EWMWhseReqItmBBDEndUTCDteTme
else case when EWMWhseReqItmSLEDEndUTCDteTme is not initial
then EWMWhseReqItmSLEDEndUTCDteTme
else case when EWMWhseReqItmBBDStrtUTCDteTme is not initial
then EWMWhseReqItmBBDStrtUTCDteTme
else EWMWhseReqItmSLEDStrtUTCDteTme end end end as ewm_de_whsereqitm_bbdsled_tst preserving type ) as EWMWhseReqItmBBDSLEDUTCDteTme,
QuantityUnit,
EWMWhseReqCreationUTCDateTime as InbDelivItemCrtnUTCDateTime,
PlndGREndWhseTmznDateTime,
UnloadingEndWhseTmznDateTime,
PutawayEndWhseTmznDateTime,
ActualGREndWhseTmznDateTime,
EWMItmCmpltWhseTmznDteTme as InbDelivItmCmpltWhseTmznDteTme,
/* Reference Documents */
PurchasingDocument,
PurchasingDocumentItem,
PurchaseOrder,
PurchaseOrderItem,
_ItemStatus,
_Quantity,
_DeliveryItemDateTime,
_ExtProdBatch
}
where
EWMWhseRequestDocumentCategory = 'PDI'
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- 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