I_EWM_OutbDelivOrdItemBasic

DDL: I_EWM_OUTBDELIVORDITEMBASIC Type: view_entity COMPOSITE

Outbound Delivery Order Item Basic

I_EWM_OutbDelivOrdItemBasic is a Composite CDS View (Fact) that provides data about "Outbound Delivery Order Item Basic" in SAP S/4HANA. It reads from 1 data source (I_EWM_WarehouseRequestOutItem) and exposes 76 fields with key fields OutboundDeliveryOrderUUID, OutboundDeliveryOrderItemUUID. It has 2 associations to related views.

1 data source(s) 76 fields

Data Sources (1)

SourceAliasJoin Type
I_EWM_WarehouseRequestOutItem odo_item from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_EWM_DeliveryTransportation _Transportation $projection.OutboundDeliveryOrderUUID = _Transportation.DeliveryUUID and _Transportation.EWMDeliveryDocumentCategory = 'PDO'
[0..*] I_EWM_SplitItemWaveAssgmt _SplitWaveAssign $projection.OutboundDeliveryOrderUUID = _SplitWaveAssign.OutboundDeliveryOrderUUID and $projection.OutboundDeliveryOrderItemUUID = _SplitWaveAssign.OutboundDeliveryOrderItemUUID and _SplitWaveAssign.WaveStatus = 'X'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Outbound Delivery Order Item Basic view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #FACT view

Fields (76)

KeyFieldSource TableSource FieldDescription
KEY OutboundDeliveryOrderUUID EWMWarehouseRequestUUID
KEY OutboundDeliveryOrderItemUUID EWMWarehouseRequestItemUUID
DeliveryCategory EWMWhseRequestDocumentCategory
EWMDeliveryDocumentCategory EWMWhseRequestDocumentCategory
OutboundDeliveryOrderItem EWMWarehouseRequestItem
EWMOutboundDeliveryOrderItem EWMWarehouseRequestItem
OutbDeliveryOrderItemCategory EWMWhseRequestItemCategory
EWMOutbDelivOrderItemCategory EWMWhseRequestItemCategory
OutboundDeliveryOrderItemType EWMWarehouseRequestItemType
EWMOutbDeliveryOrderItemType EWMWarehouseRequestItemType
ProductUUID ProductUUID
Product Product
ProductExternalID ProductExternalID
ProductBatch ProductBatch
Batch
RequirementSegment RequirementSegment
StockSegment StockSegment
Warehouse EWMWarehouse
EWMWarehouse EWMWarehouse
WarehouseDoor WarehouseDoor
StagingArea StagingArea
StagingAreaGroup StagingAreaGroup
StagingBay StagingBay
GoodsIssueStatus GoodsIssueStatus
WarehouseActivityStatus WarehouseActivityStatus
CompletionStatus CompletionStatus
OutboundDeliveryOrder EWMWarehouseRequest
EWMOutboundDeliveryOrder EWMWarehouseRequest
EntitledToDisposeParty EntitledToDisposeParty
WarehouseProcessType WarehouseProcessType
ShippingCondition ShippingCondition
PlannedPickingStatus PlannedPickingStatus
StorageBin EWMStorageBin
EWMStorageBin EWMStorageBin
GoodsMovementBin GoodsMovementBin
ProductionSupplyArea EWMProductionSupplyArea
EWMProductionSupplyArea EWMProductionSupplyArea
CreationDateTime EWMWhseReqCreationUTCDateTime
EWMDeliveryCreationUTCDateTime EWMWhseReqCreationUTCDateTime
LastChangeDateTime EWMWhseReqLastChangeUTCDteTme
EWMDelivLastChangeUTCDateTime EWMWhseReqLastChangeUTCDteTme
StorageType EWMStorageType
EWMStorageType EWMStorageType
StorageSection EWMStorageSection
EWMStorageSection EWMStorageSection
ActivityArea ActivityArea
WaveSplitNumber _SplitWaveAssign SplitNumber
WrhsTimeZonePlannedGIDate WrhsTimeZonePlannedGIDate
WrhsTimeZonePlannedGITime WrhsTimeZonePlannedGITime
WrhsTmznPlndGIStrtDateTime WrhsTmznPlndGIStrtDateTime
PlndGoodsIssueStartUTCDateTime PlndGoodsIssueStartUTCDateTime
ActlGoodsIssueStartUTCDateTime ActlGoodsIssueStartUTCDateTime
WrhsTmznActlGIStrtDateTime WrhsTmznActlGIStrtDateTime
WrhsTimeZoneActualGIDate WrhsTimeZoneActualGIDate
WrhsTimeZoneActualGITime WrhsTimeZoneActualGITime
EWMActlGIEndUTCDateTime EWMActlGIEndUTCDateTime
EWMWhseTmznActlGIEndDateTime EWMWhseTmznActlGIEndDateTime
MeansOfTransportType _Transportation MeansOfTransportType
EWMMeansOfTransportType _Transportation EWMMeansOfTransportType
RouteSchedule _Transportation RouteSchedule
StockUsage EWMStockUsage
EWMStockUsage EWMStockUsage
WarehouseStockCategory EWMStockType
EWMStockType EWMStockType
StockOwner EWMStockOwner
EWMStockOwner EWMStockOwner
StockOwnerPartnerRole StockOwnerPartnerRole
DeliveryItemStockTypeDetnCode EWMWhseReqItmStockTypeDetnCode
StockDocumentCategory StockDocumentCategory
StockDocumentNumber StockDocumentNumber
StockItemNumber StockItemNumber
CountryOfOrigin CountryOfOrigin
EWMGoodsRecipient EWMGoodsRecipient
EWMRecipientLocationName EWMRecipientLocationName
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Outbound Delivery Order Item Basic'

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XL

@VDM.viewType:#COMPOSITE
@Analytics: { dataCategory: #FACT }

define view entity I_EWM_OutbDelivOrdItemBasic
  as select from I_EWM_WarehouseRequestOutItem as odo_item
  association [0..1] to I_EWM_DeliveryTransportation as _Transportation  on  $projection.OutboundDeliveryOrderUUID       = _Transportation.DeliveryUUID
                                                                         and _Transportation.EWMDeliveryDocumentCategory = 'PDO'
  association [0..*] to I_EWM_SplitItemWaveAssgmt    as _SplitWaveAssign on  $projection.OutboundDeliveryOrderUUID     = _SplitWaveAssign.OutboundDeliveryOrderUUID
                                                                         and $projection.OutboundDeliveryOrderItemUUID = _SplitWaveAssign.OutboundDeliveryOrderItemUUID
                                                                         and _SplitWaveAssign.WaveStatus               = 'X'
{
  key EWMWarehouseRequestUUID                                                                                  as OutboundDeliveryOrderUUID,
  key EWMWarehouseRequestItemUUID                                                                              as OutboundDeliveryOrderItemUUID,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'EWMDeliveryDocumentCategory'
      EWMWhseRequestDocumentCategory                                                                           as DeliveryCategory,
      EWMWhseRequestDocumentCategory                                                                           as EWMDeliveryDocumentCategory,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'EWMOutboundDeliveryOrderItem'
      EWMWarehouseRequestItem                                                                                  as OutboundDeliveryOrderItem,
      EWMWarehouseRequestItem                                                                                  as EWMOutboundDeliveryOrderItem,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'EWMOutbDelivOrderItemCategory'
      EWMWhseRequestItemCategory                                                                               as OutbDeliveryOrderItemCategory,
      EWMWhseRequestItemCategory                                                                               as EWMOutbDelivOrderItemCategory,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'EWMOutbDeliveryOrderItemType'
      EWMWarehouseRequestItemType                                                                              as OutboundDeliveryOrderItemType,
      EWMWarehouseRequestItemType                                                                              as EWMOutbDeliveryOrderItemType,
      ProductUUID,
      Product,
      ProductExternalID,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'Batch'
      ProductBatch                                                                                             as ProductBatch,
      cast(ProductBatch as charg_d)                                                                            as Batch,
      RequirementSegment,
      StockSegment,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'EWMWarehouse'
      EWMWarehouse                                                                                             as Warehouse,
      EWMWarehouse,
      WarehouseDoor,
      StagingArea,
      StagingAreaGroup,
      StagingBay, // Added for A2X Service

      GoodsIssueStatus,
      WarehouseActivityStatus, // Added for A2X Service

      CompletionStatus,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'EWMOutboundDeliveryOrder'
      EWMWarehouseRequest                                                                                      as OutboundDeliveryOrder,
      EWMWarehouseRequest                                                                                      as EWMOutboundDeliveryOrder,
      EntitledToDisposeParty,
      WarehouseProcessType,
      ShippingCondition,
      PlannedPickingStatus,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'EWMStorageBin'
      EWMStorageBin                                                                                            as StorageBin,
      EWMStorageBin,
      /* Added for A2X Serivce Outb. Dlv Ord */
      GoodsMovementBin,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'EWMProductionSupplyArea'
      EWMProductionSupplyArea                                                                                  as ProductionSupplyArea,
      EWMProductionSupplyArea,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'EWMDeliveryCreationUTCDateTime'
      EWMWhseReqCreationUTCDateTime                                                                            as CreationDateTime,
      EWMWhseReqCreationUTCDateTime                                                                            as EWMDeliveryCreationUTCDateTime,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'EWMDelivLastChangeUTCDateTime'
      EWMWhseReqLastChangeUTCDteTme                                                                            as LastChangeDateTime,
      EWMWhseReqLastChangeUTCDteTme                                                                            as EWMDelivLastChangeUTCDateTime,

      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'EWMStorageType'
      EWMStorageType                                                                                           as StorageType,
      EWMStorageType,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor:  'EWMStorageSection'
      EWMStorageSection                                                                                        as StorageSection,
      EWMStorageSection,
      ActivityArea,

      _SplitWaveAssign.SplitNumber                                                                             as WaveSplitNumber,

      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      case when ProductQuantity <> 0
        then case when _SplitWaveAssign.EWMWhseReqSplitItemQty  <> 0
          then cast(_SplitWaveAssign.EWMWhseReqSplitItemQty as /scdl/dl_quantity )
          else ProductQuantity
        end
        else ProductQuantity
      end                                                                                                      as ProductQuantity,

      case when ProductQuantity <> 0
        then case when _SplitWaveAssign.EWMWhseReqSplitItemQty  <> 0
          then cast(_SplitWaveAssign.EWMWhseReqSplitItemQtyUnit as /scdl/dl_uom preserving type )
          else cast(QuantityUnit as /scdl/dl_uom preserving type )
        end
        else cast(QuantityUnit as /scdl/dl_uom preserving type )
      end                                                                                                      as QuantityUnit,

      -- Split Wave Assignment
      case when EWMPickingBinDataIsSplit = 'X'
        then case when _SplitWaveAssign.WaveStatus = '' then 'X' else '' end
        else case when EWMWhseReqItemIsWaveRelevant = 'X' then ''  else 'X' end
      end                                                                                                      as ItemWaveAssignmentIsIncomplete,

      WrhsTimeZonePlannedGIDate,
      WrhsTimeZonePlannedGITime,
      WrhsTmznPlndGIStrtDateTime,
      PlndGoodsIssueStartUTCDateTime,
      ActlGoodsIssueStartUTCDateTime,
      WrhsTmznActlGIStrtDateTime,
      WrhsTimeZoneActualGIDate,
      WrhsTimeZoneActualGITime,
      EWMActlGIEndUTCDateTime,
      EWMWhseTmznActlGIEndDateTime,

      /* Product Attributes */
      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,


      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: '_Transportation.EWMMeansOfTransportType'
      _Transportation.MeansOfTransportType,
      _Transportation.EWMMeansOfTransportType,
      _Transportation.RouteSchedule,

      /* Stock Information - added for A2X Outb Dlv Order API */
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'EWMStockUsage'
      EWMStockUsage                                                                                            as StockUsage,
      EWMStockUsage,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'EWMStockType'
      EWMStockType                                                                                             as WarehouseStockCategory,
      EWMStockType,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'EWMStockOwner'
      EWMStockOwner                                                                                            as StockOwner,
      EWMStockOwner,
      StockOwnerPartnerRole,
      EWMWhseReqItmStockTypeDetnCode                                                                           as DeliveryItemStockTypeDetnCode,
      StockDocumentCategory,
      StockDocumentNumber,
      StockItemNumber,

      /* 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, // Added for A2X Service to fulfill Guideline


      case StockDocumentCategory
        when 'SOS' then cast(substring(StockItemNumber, 5,6 ) as abap.numc( 6 ) )
        else cast( '000000' as num06 preserving type ) end                                                     as SpecialStockIdfgSalesOrderItem, // Added for A2X Service to fulfill Guideline



      CountryOfOrigin,

      EWMGoodsRecipient,
      EWMRecipientLocationName,

      /* Sales Order - added for A2X Outb Dlv Order API */
      SalesOrder,
      SalesOrderItem
}
where
  EWMWhseRequestDocumentCategory = 'PDO'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EWM_DELIVERYTRANSPORTATION",
"I_EWM_SPLITITEMWAVEASSGMT",
"I_EWM_WAREHOUSEREQUESTOUTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More