I_EWM_HANDLINGUNITITEM

CDS View

EWM Handling Unit Item

I_EWM_HANDLINGUNITITEM is a CDS View in S/4HANA. EWM Handling Unit Item. It contains 12 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 12 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_EWM_HandlingUnitItemSrlNmbr view_entity inner COMPOSITE HndlgUnit Item Srl Nmbr
I_FldLogsHandlingUnits view inner COMPOSITE Handling Units
I_FldLogsOpenPackQty view inner COMPOSITE Open Quantity Hu Packing
P_EWM_HandlingUnitItem01 view from COMPOSITE
P_EWM_HandlingUnitItem01_2 view_entity from COMPOSITE

Fields (12)

KeyField CDS FieldsUsed in Views
KEY StockItemUUID StockItemUUID 2
CountryOfOrigin CountryOfOrigin 1
DeliveryCategory DeliveryCategory 1
DeliveryItemUUID DeliveryItemUUID 1
DeliveryUUID DeliveryUUID 1
EWMStockIndexCode EWMStockIndexCode 1
GoodsReceiptUTCDateTime GoodsReceiptUTCDateTime 1
HandlingUnitAltUnitOfMeasure HandlingUnitAltUnitOfMeasure 1
HandlingUnitBaseUnitOfMeasure HandlingUnitBaseUnitOfMeasure,HandlingUnitQuantityUnit 2
HandlingUnitQuantity HandlingUnitQuantity 1
ParentHandlingUnitUUID ParentHandlingUnitUUID 2
ShelfLifeExpirationDate ShelfLifeExpirationDate 1 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'EWM Handling Unit Item'
@VDM.viewType:#BASIC

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L
define view entity I_EWM_HandlingUnitItem
  as select from I_EWM_StockItemAttributes as _HandlingUnitItem
  // Get the Physical Quantity for a Handling Unit Item

    inner join   I_EWM_StockItemQuantity   as _HandlingUnitPhysicalQuantity on  _HandlingUnitItem.ParentHandlingUnitUUID       = _HandlingUnitPhysicalQuantity.ParentHandlingUnitUUID
                                                                            and _HandlingUnitItem.StockItemUUID                = _HandlingUnitPhysicalQuantity.StockItemUUID
                                                                            and _HandlingUnitItem.EWMStockQuantityBaseUnit     = _HandlingUnitPhysicalQuantity.EWMStockQuantityUnit
                                                                            and _HandlingUnitPhysicalQuantity.EWMStockQuantity > 0
{
  key _HandlingUnitItem.ParentHandlingUnitUUID,
  key _HandlingUnitItem.StockItemUUID,
      @VDM.lifecycle.status: #DEPRECATED
      _HandlingUnitItem.EWMStockIndexCode                                            as CurrentNumberOfKeyTable,
      @VDM.lifecycle.successor: 'EWMStockIndexCode'
      _HandlingUnitItem.EWMStockIndexCode,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'EWMDocumentCategory'
      _HandlingUnitItem.EWMStockReferenceDocCategory                                 as DeliveryCategory,
      _HandlingUnitItem.EWMStockReferenceDocCategory                                 as EWMDocumentCategory,
      _HandlingUnitItem.EWMStockRefDocumentUUID                                      as DeliveryUUID,
      _HandlingUnitItem.EWMStockRefDocItemUUID                                       as DeliveryItemUUID,
      @Semantics.quantity.unitOfMeasure: 'EWMStockQuantityUnit'
      _HandlingUnitPhysicalQuantity.EWMStockQuantity                                 as HandlingUnitQuantity,
      _HandlingUnitPhysicalQuantity.EWMStockQuantityUnit                             as EWMStockQuantityUnit,
      _HandlingUnitItem.EWMStockQuantityBaseUnit                                     as HandlingUnitBaseUnitOfMeasure,
      _HandlingUnitItem.EWMStockQuantityAltvUnit                                     as HandlingUnitAltUnitOfMeasure,
      _HandlingUnitItem.ShelfLifeExpirationDate,
      cast( _HandlingUnitItem.EWMGoodsReceiptDateTime as tzntstmps preserving type ) as GoodsReceiptUTCDateTime,
      _HandlingUnitItem.CountryOfOrigin
}
where
     _HandlingUnitPhysicalQuantity.EWMVirtualStockIndicatorCode = 'D' //Planned Stock --> Inbound Dlv with planned HU

  or _HandlingUnitPhysicalQuantity.EWMVirtualStockIndicatorCode = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EWM_STOCKITEMATTRIBUTES",
"I_EWM_STOCKITEMQUANTITY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More