I_EWMHandlingUnitItemHierNode

DDL: I_EWMHANDLINGUNITITEMHIERNODE Type: view_entity COMPOSITE

EWM HU Item Hierarchy

I_EWMHandlingUnitItemHierNode is a Composite CDS View that provides data about "EWM HU Item Hierarchy" in SAP S/4HANA. It reads from 2 data sources (P_EWM_HandlingUnitHeader02, P_EWM_HandlingUnitItem05) and exposes 17 fields with key fields HandlingUnitCharUUID, HandlingUnitItemCharUUID. It has 3 associations to related views.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
P_EWM_HandlingUnitHeader02 HandlingUnitHeader inner
P_EWM_HandlingUnitItem05 HandlingUnitItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Plant _I_Plant $projection.Plant = _I_Plant.Plant
[0..1] I_StorageLocation _I_StorageLocation $projection.Plant = _I_StorageLocation.Plant and $projection.StorageLocation = _I_StorageLocation.StorageLocation
[0..*] I_EWM_DeliveryCategoryText _I_EWM_DeliveryCategoryText $projection.EWMDocumentCategory = _I_EWM_DeliveryCategoryText.EWMDeliveryDocumentCategory

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label EWM HU Item Hierarchy view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitCharUUID
KEY HandlingUnitItemCharUUID
HandlingUnitExternalID P_EWM_HandlingUnitHeader02 HandlingUnitExternalID
Product P_EWM_HandlingUnitItem05 Product
ProductName P_EWM_HandlingUnitItem05 ProductName
EWMDocumentCategory P_EWM_HandlingUnitItem05 EWMDocumentCategory
HandlingUnitRefDocTypeName
EWMRefDeliveryDocumentNumber P_EWM_HandlingUnitItem05 EWMRefDeliveryDocumentNumber
EWMRefDeliveryDocumentItem P_EWM_HandlingUnitItem05 EWMRefDeliveryDocumentItem
HandlingUnitQuantity P_EWM_HandlingUnitItem05 HandlingUnitQuantity
HandlingUnitQuantityUnit P_EWM_HandlingUnitItem05 HandlingUnitBaseUnitOfMeasure
Plant P_EWM_HandlingUnitItem05 Plant
PlantName _I_Plant PlantName
StorageLocation P_EWM_HandlingUnitItem05 StorageLocation
StorageLocationName _I_StorageLocation StorageLocationName
Batch P_EWM_HandlingUnitItem05 Batch
EWMWarehouse P_EWM_HandlingUnitHeader02 Warehouse 
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'EWM HU Item Hierarchy'
define view entity I_EWMHandlingUnitItemHierNode
  as select from P_EWM_HandlingUnitItem05   as HandlingUnitItem
    inner join   P_EWM_HandlingUnitHeader02 as HandlingUnitHeader on HandlingUnitHeader.HandlingUnitUUID = HandlingUnitItem.ParentHandlingUnitUUID
  association [0..1] to I_Plant                    as _I_Plant                    on  $projection.Plant = _I_Plant.Plant
  association [0..1] to I_StorageLocation          as _I_StorageLocation          on  $projection.Plant           = _I_StorageLocation.Plant
                                                                                  and $projection.StorageLocation = _I_StorageLocation.StorageLocation
  association [0..*] to I_EWM_DeliveryCategoryText as _I_EWM_DeliveryCategoryText on  $projection.EWMDocumentCategory = _I_EWM_DeliveryCategoryText.EWMDeliveryDocumentCategory
{
             @Semantics.uuid
  key        bintohex(HandlingUnitItem.ParentHandlingUnitUUID)                                            as HandlingUnitCharUUID,
             @Semantics.uuid
  key        bintohex(HandlingUnitItem.StockItemUUID)                                                     as HandlingUnitItemCharUUID,
             HandlingUnitHeader.HandlingUnitExternalID                                                    as HandlingUnitExternalID,
             HandlingUnitItem.Product,
             HandlingUnitItem.ProductName,
             HandlingUnitItem.EWMDocumentCategory,
             _I_EWM_DeliveryCategoryText[1: Language=$session.system_language].EWMDeliveryDocumentCatName as HandlingUnitRefDocTypeName,
             HandlingUnitItem.EWMRefDeliveryDocumentNumber,
             HandlingUnitItem.EWMRefDeliveryDocumentItem,
             HandlingUnitItem.HandlingUnitQuantity                                                        as HandlingUnitQuantity,
             HandlingUnitItem.HandlingUnitBaseUnitOfMeasure                                               as HandlingUnitQuantityUnit,
             HandlingUnitItem.Plant                                                                       as Plant,
             _I_Plant.PlantName,
             HandlingUnitItem.StorageLocation,
             _I_StorageLocation.StorageLocationName,
             HandlingUnitItem.Batch,
             HandlingUnitHeader.Warehouse                                                                 as EWMWarehouse
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EWM_DELIVERYCATEGORYTEXT",
"I_PLANT",
"I_STORAGELOCATION",
"P_EWM_HANDLINGUNITHEADER02",
"P_EWM_HANDLINGUNITITEM05"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More