P_EWM_HandlingUnitHeader

DDL: P_EWM_HANDLINGUNITHEADER Type: view_entity COMPOSITE Package: VDM_EWM_CORE

Warehouse Handling Unit Header

P_EWM_HandlingUnitHeader is a Composite CDS View that provides data about "Warehouse Handling Unit Header" in SAP S/4HANA. It reads from 2 data sources (I_EWM_HandlingUnitHdr_2, I_Product) and exposes 15 fields with key field HandlingUnitUUID. It has 1 association to related views. Part of development package VDM_EWM_CORE.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_EWM_HandlingUnitHdr_2 _HUHeader from
I_Product _PackagingMaterial inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_EWM_HandlingUnitTypeT _HUTypeText $projection.HandlingUnitType = _HUTypeText.HandlingUnitType

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitUUID I_EWM_HandlingUnitHdr_2 HandlingUnitUUID
HandlingUnitNumber
EWMHghstLvlHandlingUnitUUID I_EWM_HandlingUnitHdr_2 EWMHghstLvlHandlingUnitUUID
HandlingUnitType I_EWM_HandlingUnitHdr_2 HandlingUnitType
HandlingUnitIndicator
EWMWarehouse I_EWM_HandlingUnitHdr_2 EWMWarehouse
NetWeight I_EWM_HandlingUnitHdr_2 NetWeight
GrossWeight I_EWM_HandlingUnitHdr_2 GrossWeight
WeightUnit I_EWM_HandlingUnitHdr_2 WeightUnit
HandlingUnitNetVolume I_EWM_HandlingUnitHdr_2 HandlingUnitNetVolume
GrossVolume I_EWM_HandlingUnitHdr_2 GrossVolume
VolumeUnit I_EWM_HandlingUnitHdr_2 VolumeUnit
PackagingMaterial
_PackagingMaterialText I_Product _Text
_HUTypeText _HUTypeText 
@AbapCatalog.viewEnhancementCategory: [ #NONE ]

@AccessControl.authorizationCheck: #NOT_REQUIRED

@Metadata.ignorePropagatedAnnotations: false

@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL }

@VDM.private: true
@VDM.viewType: #COMPOSITE

define view entity P_EWM_HandlingUnitHeader
  as select from I_EWM_HandlingUnitHdr_2 as _HUHeader

    inner join   I_Product               as _PackagingMaterial on _HUHeader.PackagingMaterialUUID = _PackagingMaterial.ProductUUID

  association [0..*] to I_EWM_HandlingUnitTypeT as _HUTypeText on $projection.HandlingUnitType = _HUTypeText.HandlingUnitType

{
  key _HUHeader.HandlingUnitUUID,

      cast(_HUHeader.HandlingUnitNumber as ewm_de_huident preserving type)                  as HandlingUnitNumber,
      _HUHeader.EWMHghstLvlHandlingUnitUUID,
      _HUHeader.HandlingUnitType,
      cast(_HUHeader.HandlingUnitIndicator as ewm_de_handlingunitindicator preserving type) as HandlingUnitIndicator,
      _HUHeader.EWMWarehouse,
      /*Weight*/
      _HUHeader.NetWeight,
      _HUHeader.GrossWeight,
      _HUHeader.WeightUnit,
      /*Volume*/
      _HUHeader.HandlingUnitNetVolume,
      _HUHeader.GrossVolume,
      _HUHeader.VolumeUnit,
      cast(_PackagingMaterial.Product as /scwm/de_pmat preserving type)                     as PackagingMaterial,
      _PackagingMaterial._Text                                                              as _PackagingMaterialText,
      _HUTypeText                                                                           as _HUTypeText
}

where _HUHeader.HandlingUnitIndicator = ' ' or _HUHeader.HandlingUnitIndicator = 'B'

Learn More