P_EWM_TopHandlingUnitLocation

DDL: P_EWM_TOPHANDLINGUNITLOCATION Type: view_entity COMPOSITE
8 Fields 1 Data Sources 1 Associations

Prototype HU Location

P_EWM_TopHandlingUnitLocation is a Composite CDS View that provides data about "Prototype HU Location" in SAP S/4HANA. It reads from 1 data source (P_EWM_LocationUnion) and exposes 8 fields with key fields EWMLocationUUID, HandlingUnitUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_EWM_LocationUnion P_EWM_LocationUnion from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_EWM_HndlgUnitLocHierarchy _Hierarchy $projection.EWMLocationUUID = _Hierarchy.ParentHandlingUnitUUID and _Hierarchy.EWMHndlgUnitLocTreeOverflowVal = 0

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Prototype HU Location view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY EWMLocationUUID EWMLocationUUID
KEY HandlingUnitUUID _Hierarchy HandlingUnitUUID
EWMHndlgUnitLocParentNodeType _Hierarchy EWMHndlgUnitLocParentNodeType
EWMParentLocationIndexCode _Hierarchy EWMParentLocationIndexCode
EWMStorageType EWMStorageType Storage Type
EWMStorageBin EWMStorageBin Storage Bin
EWMResource EWMResource
TranspUnitInternalNumber TranspUnitInternalNumber

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 P_EWM_TopHandlingUnitLocation.
-- 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 P_EWM_TopHandlingUnitLocation AS
SELECT
  EWMLocationUUID,
  _Hierarchy.HandlingUnitUUID AS HandlingUnitUUID,
  _Hierarchy.EWMHndlgUnitLocParentNodeType AS EWMHndlgUnitLocParentNodeType,
  _Hierarchy.EWMParentLocationIndexCode AS EWMParentLocationIndexCode,
  EWMStorageType,
  EWMStorageBin,
  EWMResource,
  TranspUnitInternalNumber
FROM P_EWM_LocationUnion
LEFT OUTER JOIN I_EWM_HndlgUnitLocHierarchy AS _Hierarchy ON EWMLocationUUID = _Hierarchy.ParentHandlingUnitUUID AND _Hierarchy.EWMHndlgUnitLocTreeOverflowVal = 0  -- association [1..1]
;

Learn More