C_EWM_LoadListHndlgUnit
Form Prvdr for Loading Instruction HUs
C_EWM_LoadListHndlgUnit is a Consumption CDS View that provides data about "Form Prvdr for Loading Instruction HUs" in SAP S/4HANA. It reads from 4 data sources (I_EWM_HandlingUnitHdr, I_EWM_HandlingUnitRef, mara, I_EWM_OutbDelivOrdHdrWithBP) and exposes 66 fields with key fields OutboundDeliveryOrderUUID, HandlingUnitNumber.
Data Sources (4)
| Source | Alias | Join Type |
|---|---|---|
| I_EWM_HandlingUnitHdr | huhdr | left_outer |
| I_EWM_HandlingUnitRef | huref | inner |
| mara | material | left_outer |
| I_EWM_OutbDelivOrdHdrWithBP | odo_hdr | from |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| VDM.viewType | #CONSUMPTION | view | |
| EndUserText.label | Form Prvdr for Loading Instruction HUs | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.sizeCategory | #L | view |
Fields (66)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | OutboundDeliveryOrderUUID | I_EWM_OutbDelivOrdHdrWithBP | OutboundDeliveryOrderUUID | Document ID |
| KEY | HandlingUnitNumber | I_EWM_HandlingUnitHdr | HandlingUnitNumber | HU ID |
| OutboundDeliveryOrder | I_EWM_OutbDelivOrdHdrWithBP | OutboundDeliveryOrder | ||
| Warehouse | I_EWM_HandlingUnitHdr | Warehouse | Warehouse No. | |
| HandlingUnitIndicator | I_EWM_HandlingUnitHdr | HandlingUnitIndicator | Virtual HU | |
| HandlingUnitUUID | I_EWM_HandlingUnitHdr | HandlingUnitUUID | Parent | |
| PackagingMaterialUUID | I_EWM_HandlingUnitHdr | PackagingMaterialUUID | Product | |
| CreatedByUser | I_EWM_HandlingUnitHdr | CreatedByUser | User Name | |
| CreationDateTime | I_EWM_HandlingUnitHdr | CreationDateTime | Timestamp | |
| LastChangedByUser | I_EWM_HandlingUnitHdr | LastChangedByUser | User Name | |
| LastChangeDateTime | I_EWM_HandlingUnitHdr | LastChangeDateTime | Timestamp | |
| GrossWeight | I_EWM_HandlingUnitHdr | GrossWeight | Total Weight | |
| NetWeight | I_EWM_HandlingUnitHdr | NetWeight | Net weight | |
| WeightUnit | I_EWM_HandlingUnitHdr | WeightUnit | Weight unit | |
| HandlingUnitTareWeight | I_EWM_HandlingUnitHdr | HandlingUnitTareWeight | HU Tare Weight | |
| HandlingUnitTareWeightUnit | I_EWM_HandlingUnitHdr | HandlingUnitTareWeightUnit | Weight Unit | |
| GrossVolume | I_EWM_HandlingUnitHdr | GrossVolume | Total Volume | |
| HandlingUnitNetVolume | I_EWM_HandlingUnitHdr | HandlingUnitNetVolume | Loading Volume | |
| VolumeUnit | I_EWM_HandlingUnitHdr | VolumeUnit | Volume Unit | |
| HandlingUnitTareVolume | I_EWM_HandlingUnitHdr | HandlingUnitTareVolume | Tare Volume | |
| HandlingUnitTareVolumeUnit | I_EWM_HandlingUnitHdr | HandlingUnitTareVolumeUnit | Volume Unit | |
| HandlingUnitGrossCapacity | I_EWM_HandlingUnitHdr | HandlingUnitGrossCapacity | Total Capacity | |
| HandlingUnitNetCapacity | I_EWM_HandlingUnitHdr | HandlingUnitNetCapacity | Net Capacity | |
| HandlingUnitTareCapacity | I_EWM_HandlingUnitHdr | HandlingUnitTareCapacity | Tare Cap. | |
| HandlingUnitLength | I_EWM_HandlingUnitHdr | HandlingUnitLength | Text Length | |
| HandlingUnitWidth | I_EWM_HandlingUnitHdr | HandlingUnitWidth | Width | |
| HandlingUnitHeight | I_EWM_HandlingUnitHdr | HandlingUnitHeight | Height | |
| UnitOfMeasureDimension | I_EWM_HandlingUnitHdr | UnitOfMeasureDimension | Dimension | |
| HandlingUnitMaxWeight | I_EWM_HandlingUnitHdr | HandlingUnitMaxWeight | Maximum Weight | |
| HandlingUnitWeightTolerance | I_EWM_HandlingUnitHdr | HandlingUnitWeightTolerance | Excess Wgt Tolerance | |
| HasVariableTareWeight | I_EWM_HandlingUnitHdr | HasVariableTareWeight | Variable TW | |
| HandlingUnitMaxVolume | I_EWM_HandlingUnitHdr | HandlingUnitMaxVolume | Max. Volume | |
| HandlingUnitVolumeTolerance | I_EWM_HandlingUnitHdr | HandlingUnitVolumeTolerance | Excess Volume Tol. | |
| HandlingUnitIsClosed | I_EWM_HandlingUnitHdr | HandlingUnitIsClosed | Closed Pack. | |
| MaximumCapacity | I_EWM_HandlingUnitHdr | MaximumCapacity | Max. Capacity | |
| HandlingUnitCapacityTolerance | I_EWM_HandlingUnitHdr | HandlingUnitCapacityTolerance | Excess Cap. Tol. | |
| HandlingUnitMaxLength | I_EWM_HandlingUnitHdr | HandlingUnitMaxLength | Maximal Length | |
| HandlingUnitMaxWidth | I_EWM_HandlingUnitHdr | HandlingUnitMaxWidth | Width | |
| HandlingUnitMaxHeight | I_EWM_HandlingUnitHdr | HandlingUnitMaxHeight | Max. Height | |
| HandlingUnitMaxDimensionUnit | I_EWM_HandlingUnitHdr | HandlingUnitMaxDimensionUnit | Unit of Measure | |
| HandlingUnitType | I_EWM_HandlingUnitHdr | HandlingUnitType | HUTyp | |
| HandlingUnitHasAvailQty | I_EWM_HandlingUnitHdr | HandlingUnitHasAvailQty | Avail.Qty | |
| HandlingUnitOpenTaskInd | I_EWM_HandlingUnitHdr | HandlingUnitOpenTaskInd | Open HU WT | |
| ExternalStorageProcessStep | I_EWM_HandlingUnitHdr | ExternalStorageProcessStep | Process Step | |
| ProcessStepCompletedInd | I_EWM_HandlingUnitHdr | ProcessStepCompletedInd | HU Step Completed | |
| StorageProcess | I_EWM_HandlingUnitHdr | StorageProcess | Storage Process | |
| ConsolidationGroup | I_EWM_HandlingUnitHdr | ConsolidationGroup | Cons. Group | |
| WorkloadIdentification | I_EWM_HandlingUnitHdr | WorkloadIdentification | Workload ID | |
| EntitledToDisposeParty | I_EWM_HandlingUnitHdr | EntitledToDisposeParty | Disposal Party | |
| StorageType | I_EWM_HandlingUnitHdr | StorageType | Storage Type | |
| StorageSection | I_EWM_HandlingUnitHdr | StorageSection | Storage Section | |
| StorageBin | I_EWM_HandlingUnitHdr | StorageBin | Storage Bin | |
| WarehouseOrderCreationRule | I_EWM_HandlingUnitHdr | WarehouseOrderCreationRule | WO Creatn Rule | |
| HandlingUnitDefectCode | I_EWM_HandlingUnitHdr | HandlingUnitDefectCode | Defect | |
| HandlingUnitContentInd | I_EWM_HandlingUnitHdr | HandlingUnitContentInd | Content Indicator | |
| PackagingMaterialType | I_EWM_HandlingUnitHdr | PackagingMaterialType | Packaging Material Type | |
| HandlingUnitPackingGroup | I_EWM_HandlingUnitHdr | HandlingUnitPackingGroup | Packing Group | |
| HandlingUnitStatus | I_EWM_HandlingUnitHdr | HandlingUnitStatus | Int. Status | |
| HandlingUnitTopLevelInd | I_EWM_HandlingUnitHdr | HandlingUnitTopLevelInd | ||
| HandlingUnitBottomInd | I_EWM_HandlingUnitHdr | HandlingUnitBottomInd | ||
| StatusProfile | I_EWM_HandlingUnitHdr | StatusProfile | Status Profile | |
| PackagingSpecificationLevel | I_EWM_HandlingUnitHdr | PackagingSpecificationLevel | Level Seq. No. | |
| HandlingUnitObjRefInd | I_EWM_HandlingUnitHdr | HandlingUnitObjRefInd | Obj. Reference | |
| HazardousSubstanceIndicator | I_EWM_HandlingUnitHdr | HazardousSubstanceIndicator | Hazardous Subs. | |
| HandlingUnitLogicalPosition | I_EWM_HandlingUnitHdr | HandlingUnitLogicalPosition | Logical Pos. | |
| PackagingMaterial | mara | matnr | Vehicle Model |
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 C_EWM_LoadListHndlgUnit.
-- 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 C_EWM_LoadListHndlgUnit AS
SELECT
odo_hdr.OutboundDeliveryOrderUUID AS OutboundDeliveryOrderUUID,
huhdr.HandlingUnitNumber AS HandlingUnitNumber,
odo_hdr.OutboundDeliveryOrder AS OutboundDeliveryOrder,
huhdr.Warehouse AS Warehouse,
huhdr.HandlingUnitIndicator AS HandlingUnitIndicator,
huhdr.HandlingUnitUUID AS HandlingUnitUUID,
huhdr.PackagingMaterialUUID AS PackagingMaterialUUID,
huhdr.CreatedByUser AS CreatedByUser,
huhdr.CreationDateTime AS CreationDateTime,
huhdr.LastChangedByUser AS LastChangedByUser,
huhdr.LastChangeDateTime AS LastChangeDateTime,
huhdr.GrossWeight AS GrossWeight,
huhdr.NetWeight AS NetWeight,
huhdr.WeightUnit AS WeightUnit,
huhdr.HandlingUnitTareWeight AS HandlingUnitTareWeight,
huhdr.HandlingUnitTareWeightUnit AS HandlingUnitTareWeightUnit,
huhdr.GrossVolume AS GrossVolume,
huhdr.HandlingUnitNetVolume AS HandlingUnitNetVolume,
huhdr.VolumeUnit AS VolumeUnit,
huhdr.HandlingUnitTareVolume AS HandlingUnitTareVolume,
huhdr.HandlingUnitTareVolumeUnit AS HandlingUnitTareVolumeUnit,
huhdr.HandlingUnitGrossCapacity AS HandlingUnitGrossCapacity,
huhdr.HandlingUnitNetCapacity AS HandlingUnitNetCapacity,
huhdr.HandlingUnitTareCapacity AS HandlingUnitTareCapacity,
huhdr.HandlingUnitLength AS HandlingUnitLength,
huhdr.HandlingUnitWidth AS HandlingUnitWidth,
huhdr.HandlingUnitHeight AS HandlingUnitHeight,
huhdr.UnitOfMeasureDimension AS UnitOfMeasureDimension,
huhdr.HandlingUnitMaxWeight AS HandlingUnitMaxWeight,
huhdr.HandlingUnitWeightTolerance AS HandlingUnitWeightTolerance,
huhdr.HasVariableTareWeight AS HasVariableTareWeight,
huhdr.HandlingUnitMaxVolume AS HandlingUnitMaxVolume,
huhdr.HandlingUnitVolumeTolerance AS HandlingUnitVolumeTolerance,
huhdr.HandlingUnitIsClosed AS HandlingUnitIsClosed,
huhdr.MaximumCapacity AS MaximumCapacity,
huhdr.HandlingUnitCapacityTolerance AS HandlingUnitCapacityTolerance,
huhdr.HandlingUnitMaxLength AS HandlingUnitMaxLength,
huhdr.HandlingUnitMaxWidth AS HandlingUnitMaxWidth,
huhdr.HandlingUnitMaxHeight AS HandlingUnitMaxHeight,
huhdr.HandlingUnitMaxDimensionUnit AS HandlingUnitMaxDimensionUnit,
huhdr.HandlingUnitType AS HandlingUnitType,
huhdr.HandlingUnitHasAvailQty AS HandlingUnitHasAvailQty,
huhdr.HandlingUnitOpenTaskInd AS HandlingUnitOpenTaskInd,
huhdr.ExternalStorageProcessStep AS ExternalStorageProcessStep,
huhdr.ProcessStepCompletedInd AS ProcessStepCompletedInd,
huhdr.StorageProcess AS StorageProcess,
huhdr.ConsolidationGroup AS ConsolidationGroup,
huhdr.WorkloadIdentification AS WorkloadIdentification,
huhdr.EntitledToDisposeParty AS EntitledToDisposeParty,
huhdr.StorageType AS StorageType,
huhdr.StorageSection AS StorageSection,
huhdr.StorageBin AS StorageBin,
huhdr.WarehouseOrderCreationRule AS WarehouseOrderCreationRule,
huhdr.HandlingUnitDefectCode AS HandlingUnitDefectCode,
huhdr.HandlingUnitContentInd AS HandlingUnitContentInd,
huhdr.PackagingMaterialType AS PackagingMaterialType,
huhdr.HandlingUnitPackingGroup AS HandlingUnitPackingGroup,
huhdr.HandlingUnitStatus AS HandlingUnitStatus,
huhdr.HandlingUnitTopLevelInd AS HandlingUnitTopLevelInd,
huhdr.HandlingUnitBottomInd AS HandlingUnitBottomInd,
huhdr.StatusProfile AS StatusProfile,
huhdr.PackagingSpecificationLevel AS PackagingSpecificationLevel,
huhdr.HandlingUnitObjRefInd AS HandlingUnitObjRefInd,
huhdr.HazardousSubstanceIndicator AS HazardousSubstanceIndicator,
huhdr.HandlingUnitLogicalPosition AS HandlingUnitLogicalPosition,
material.matnr AS PackagingMaterial
FROM I_EWM_OutbDelivOrdHdrWithBP AS odo_hdr
INNER JOIN I_EWM_HandlingUnitRef AS huref ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EWM_HandlingUnitHdr AS huhdr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mara AS material ON /* join condition not captured in parsed metadata */
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA