I_HndlgUntWhseOutbOrNonConfDpl

DDL: I_HNDLGUNTWHSEOUTBORNONCONFDPL Type: view_entity COMPOSITE Package: LOHUM_VDM
36 Fields 1 Data Sources 1 Associations

ERP managed HUs in EWM with duplicates

I_HndlgUntWhseOutbOrNonConfDpl is a Composite CDS View that provides data about "ERP managed HUs in EWM with duplicates" in SAP S/4HANA. It reads from 1 data source (I_HandlingUnitHeader) and exposes 36 fields with key field HandlingUnitExternalID. It has 1 association to related views. Part of development package LOHUM_VDM.

Data Sources (1)

SourceAliasJoin Type
I_HandlingUnitHeader huhdr from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_HandlingUnitIDMapping _HandlingUnitParentHdrID _HandlingUnitParentHdrID.HandlingUnitInternalID = huhdr.HandlingUnitLowerLevelRefer

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label ERP managed HUs in EWM with duplicates view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitExternalID I_HandlingUnitHeader HandlingUnitExternalID Handling Unit
HandlingUnitCharUUID I_HandlingUnitHeader HandlingUnitCharUUID
HandlingUnitInternalCharUUID I_HandlingUnitHeader HandlingUnitCharUUID
HandlingUnitExternalIdType I_HandlingUnitHeader HandlingUnitExternalIdType ID Type
HandlingUnitInternalID I_HandlingUnitHeader HandlingUnitInternalID Internal HU no.
HandlingUnitHandle I_HandlingUnitHeader SourceHandlingUnitUUID TS handle
HandlingUnitSecondExternalId I_HandlingUnitHeader HandlingUnitSecondExternalId License Plate
HandlingUnitLowerLevelRefer I_HandlingUnitHeader HandlingUnitLowerLevelRefer Higher-level HU
ParentHandlingUnitNumber _HandlingUnitParentHdrID HandlingUnitExternalID Handling Unit
Plant I_HandlingUnitHeader Plant Valuation Area
StorageLocation I_HandlingUnitHeader StorageLocation StorageLocation
ShippingPoint I_HandlingUnitHeader ShippingPoint Shipping Point
PackagingMaterial I_HandlingUnitHeader PackagingMaterial Packaging Materials
PackagingMaterialType I_HandlingUnitHeader PackagingMaterialType Packaging Material Type
PackingInstruction I_HandlingUnitHeader PackingInstruction Instructions for Packer
GrossWeight I_HandlingUnitHeader GrossWeight Total Weight
NetWeight I_HandlingUnitHeader NetWeight Net weight
HandlingUnitMaxWeight I_HandlingUnitHeader HandlingUnitMaxWeight Allowed Weight
WeightUnit I_HandlingUnitHeader WeightUnit Weight unit
HandlingUnitTareWeight I_HandlingUnitHeader HandlingUnitTareWeight Tare Weight
HandlingUnitTareWeightUnit I_HandlingUnitHeader HandlingUnitTareWeightUnit Weight Unit
GrossVolume I_HandlingUnitHeader GrossVolume Total Volume
HandlingUnitNetVolume I_HandlingUnitHeader HandlingUnitNetVolume Loading Volume
HandlingUnitMaxVolume I_HandlingUnitHeader HandlingUnitMaxVolume Allowed Volume
VolumeUnit I_HandlingUnitHeader VolumeUnit Volume Unit
HandlingUnitTareVolume I_HandlingUnitHeader HandlingUnitTareVolume Tare Volume
HandlingUnitTareVolumeUnit I_HandlingUnitHeader HandlingUnitTareVolumeUnit Volume Unit
HandlingUnitLength I_HandlingUnitHeader HandlingUnitLength Length
HandlingUnitWidth I_HandlingUnitHeader HandlingUnitWidth Width
HandlingUnitHeight I_HandlingUnitHeader HandlingUnitHeight Height
HandlingUnitDimensionUnit I_HandlingUnitHeader UnitOfMeasureDimension Dimension
HandlingUnitPackingObjectType I_HandlingUnitHeader HandlingUnitPackingObjectType
HandlingUnitReferenceDocument I_HandlingUnitHeader HandlingUnitPackingObjectKey
CreatedByUser I_HandlingUnitHeader CreatedByUser User Name
LastChangedByUserendasLastChangedByUser
HandlingUnitInternalStatus I_HandlingUnitHeader HandlingUnitInternalStatus Workflow Status

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_HndlgUntWhseOutbOrNonConfDpl.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_HndlgUntWhseOutbOrNonConfDpl AS
SELECT
  huhdr.HandlingUnitExternalID AS HandlingUnitExternalID,
  huhdr.HandlingUnitCharUUID AS HandlingUnitCharUUID,
  huhdr.HandlingUnitCharUUID AS HandlingUnitInternalCharUUID,
  huhdr.HandlingUnitExternalIdType AS HandlingUnitExternalIdType,
  huhdr.HandlingUnitInternalID AS HandlingUnitInternalID,
  huhdr.SourceHandlingUnitUUID AS HandlingUnitHandle,
  huhdr.HandlingUnitSecondExternalId AS HandlingUnitSecondExternalId,
  huhdr.HandlingUnitLowerLevelRefer AS HandlingUnitLowerLevelRefer,
  _HandlingUnitParentHdrID.HandlingUnitExternalID AS ParentHandlingUnitNumber,
  huhdr.Plant AS Plant,
  huhdr.StorageLocation AS StorageLocation,
  huhdr.ShippingPoint AS ShippingPoint,
  huhdr.PackagingMaterial AS PackagingMaterial,
  huhdr.PackagingMaterialType AS PackagingMaterialType,
  huhdr.PackingInstruction AS PackingInstruction,
  huhdr.GrossWeight AS GrossWeight,
  huhdr.NetWeight AS NetWeight,
  huhdr.HandlingUnitMaxWeight AS HandlingUnitMaxWeight,
  huhdr.WeightUnit AS WeightUnit,
  huhdr.HandlingUnitTareWeight AS HandlingUnitTareWeight,
  huhdr.HandlingUnitTareWeightUnit AS HandlingUnitTareWeightUnit,
  huhdr.GrossVolume AS GrossVolume,
  huhdr.HandlingUnitNetVolume AS HandlingUnitNetVolume,
  huhdr.HandlingUnitMaxVolume AS HandlingUnitMaxVolume,
  huhdr.VolumeUnit AS VolumeUnit,
  huhdr.HandlingUnitTareVolume AS HandlingUnitTareVolume,
  huhdr.HandlingUnitTareVolumeUnit AS HandlingUnitTareVolumeUnit,
  huhdr.HandlingUnitLength AS HandlingUnitLength,
  huhdr.HandlingUnitWidth AS HandlingUnitWidth,
  huhdr.HandlingUnitHeight AS HandlingUnitHeight,
  huhdr.UnitOfMeasureDimension AS HandlingUnitDimensionUnit,
  huhdr.HandlingUnitPackingObjectType AS HandlingUnitPackingObjectType,
  huhdr.HandlingUnitPackingObjectKey AS HandlingUnitReferenceDocument,
  huhdr.CreatedByUser AS CreatedByUser,
  case when huhdr.LastChangedByUser is initial then huhdr.CreatedByUser else huhdr.LastChangedByUser end as LastChangedByUser AS LastChangedByUserendasLastChangedByUser,
  huhdr.HandlingUnitInternalStatus AS HandlingUnitInternalStatus
FROM I_HandlingUnitHeader AS huhdr
LEFT OUTER JOIN I_HandlingUnitIDMapping AS _HandlingUnitParentHdrID ON _HandlingUnitParentHdrID.HandlingUnitInternalID = huhdr.HandlingUnitLowerLevelRefer  -- association [0..1]
;

Learn More