I_HandlingUnitHeaderERPLocal

DDL: I_HANDLINGUNITHEADERERPLOCAL Type: view_entity COMPOSITE Package: LOHUM_VDM
35 Fields 1 Data Sources 1 Associations

Handling Units in ERP and not 3PL or EWM

I_HandlingUnitHeaderERPLocal is a Composite CDS View that provides data about "Handling Units in ERP and not 3PL or EWM" in SAP S/4HANA. It reads from 1 data source (I_HandlingUnitHeader) and exposes 35 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 I_HandlingUnitHeader from

Associations (1)

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

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Handling Units in ERP and not 3PL or EWM 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 (35)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitExternalID HandlingUnitExternalID Handling Unit
HandlingUnitCharUUID HandlingUnitCharUUID
HandlingUnitInternalCharUUID HandlingUnitCharUUID
HandlingUnitExternalIdType HandlingUnitExternalIdType ID Type
HandlingUnitInternalID HandlingUnitInternalID Internal HU no.
HandlingUnitHandle SourceHandlingUnitUUID TS handle
HandlingUnitSecondExternalId HandlingUnitSecondExternalId License Plate
HandlingUnitLowerLevelRefer HandlingUnitLowerLevelRefer Higher-level HU
ParentHandlingUnitNumber _HandlingUnitParentHdrID HandlingUnitExternalID Handling Unit
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
ShippingPoint ShippingPoint Shipping Point
PackagingMaterial PackagingMaterial Packaging Materials
PackagingMaterialType PackagingMaterialType Packaging Material Type
PackingInstruction PackingInstruction Instructions for Packer
GrossWeight GrossWeight Total Weight
NetWeight NetWeight Net weight
HandlingUnitMaxWeight HandlingUnitMaxWeight Allowed Weight
WeightUnit WeightUnit Weight unit
HandlingUnitTareWeight HandlingUnitTareWeight Tare Weight
HandlingUnitTareWeightUnit HandlingUnitTareWeightUnit Weight Unit
GrossVolume GrossVolume Total Volume
HandlingUnitNetVolume HandlingUnitNetVolume Loading Volume
HandlingUnitMaxVolume HandlingUnitMaxVolume Allowed Volume
VolumeUnit VolumeUnit Volume Unit
HandlingUnitTareVolume HandlingUnitTareVolume Tare Volume
HandlingUnitTareVolumeUnit HandlingUnitTareVolumeUnit Volume Unit
HandlingUnitLength HandlingUnitLength Length
HandlingUnitWidth HandlingUnitWidth Width
HandlingUnitHeight HandlingUnitHeight Height
HandlingUnitDimensionUnit UnitOfMeasureDimension Dimension
HandlingUnitPackingObjectType HandlingUnitPackingObjectType
HandlingUnitReferenceDocument HandlingUnitPackingObjectKey
CreatedByUser CreatedByUser User Name
HandlingUnitInternalStatus 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_HandlingUnitHeaderERPLocal.
-- 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_HandlingUnitHeaderERPLocal AS
SELECT
  HandlingUnitExternalID,
  HandlingUnitCharUUID,
  HandlingUnitCharUUID AS HandlingUnitInternalCharUUID,
  HandlingUnitExternalIdType,
  HandlingUnitInternalID,
  SourceHandlingUnitUUID AS HandlingUnitHandle,
  HandlingUnitSecondExternalId,
  HandlingUnitLowerLevelRefer,
  _HandlingUnitParentHdrID.HandlingUnitExternalID AS ParentHandlingUnitNumber,
  Plant,
  StorageLocation,
  ShippingPoint,
  PackagingMaterial,
  PackagingMaterialType,
  PackingInstruction,
  GrossWeight,
  NetWeight,
  HandlingUnitMaxWeight,
  WeightUnit,
  HandlingUnitTareWeight,
  HandlingUnitTareWeightUnit,
  GrossVolume,
  HandlingUnitNetVolume,
  HandlingUnitMaxVolume,
  VolumeUnit,
  HandlingUnitTareVolume,
  HandlingUnitTareVolumeUnit,
  HandlingUnitLength,
  HandlingUnitWidth,
  HandlingUnitHeight,
  UnitOfMeasureDimension AS HandlingUnitDimensionUnit,
  HandlingUnitPackingObjectType,
  HandlingUnitPackingObjectKey AS HandlingUnitReferenceDocument,
  CreatedByUser,
  HandlingUnitInternalStatus
FROM I_HandlingUnitHeader
LEFT OUTER JOIN I_HandlingUnitIDMapping AS _HandlingUnitParentHdrID ON _HandlingUnitParentHdrID.HandlingUnitInternalID = I_HandlingUnitHeader.HandlingUnitLowerLevelRefer  -- association [0..1]
;

Learn More