I_EWM_HANDLINGUNITHDR_2
Handling Unit Header
I_EWM_HANDLINGUNITHDR_2 is a CDS View in S/4HANA. Handling Unit Header. It contains 70 fields. 17 CDS views read from this table.
CDS Views using this table (17)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_FldLogsShptItemHandlingUnit | view_entity | union | CONSUMPTION | Field Logistics Shipment Item Handling Unit |
| I_EWM_HandlingUnitHdrCmbnd_2 | view_entity | from | COMPOSITE | HU Header Combined |
| I_EWM_HandlingUnitHdrVH | view_entity | from | COMPOSITE | Handling Unit Header |
| I_FldLogsEWMHndlgUnitHdr | view_entity | from | BASIC | EWM Handling unit headers for FL |
| I_FldLogsHandlingUnits | view_entity | inner | COMPOSITE | Handling Units |
| I_FldLogsHndlgUnitHdrCombined | view_entity | union_all | COMPOSITE | Handling Unit Header combined data from LO and EWM storages |
| I_FldLogsSuplrItmEWMHndlgUnt | view_entity | inner | COMPOSITE | EWM Handling Unit Numbers related to a Supplier Item |
| P_EWM_HandlingUnitAltvId | view_entity | inner | COMPOSITE | |
| P_EWM_HandlingUnitHeader01 | view | from | COMPOSITE | |
| P_EWM_HandlingUnitHeader01_2 | view_entity | from | COMPOSITE | |
| P_EWM_HandlingUnitHeader04_2 | view_entity | from | COMPOSITE | |
| P_EWM_HandlingUnitHistory06_2 | view_entity | from | COMPOSITE | |
| P_EWM_HandlingUnitKeyMapping | view_entity | from | COMPOSITE | |
| P_EWM_HghstHndlgUnitHdr | view_entity | from | COMPOSITE | |
| P_EWM_HNDLGUNITHDRDELIVREF02 | view_entity | inner | BASIC | |
| P_EWM_TopHandlingUnit | view_entity | from | COMPOSITE | Top Handling Unit |
| P_EWM_WhseHndlgUntRef | view_entity | inner | COMPOSITE | Handling Unit Reference |
Fields (70)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | EWMWarehouse | EWMWarehouse,Warehouse | 5 |
| KEY | HandlingUnitIndicator | HandlingUnitIndicator | 2 |
| KEY | HandlingUnitNumber | HandlingUnitExternalID,HandlingUnitNumber | 4 |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDateTime | CreationUTCDateTime | 1 | |
| DistrEquipmentLogicalPos | DistrEquipmentLogicalPos | 1 | |
| EntitledToDisposeParty | EntitledToDisposeParty | 1 | |
| EWMConsolidationGroup | EWMConsolidationGroup | 1 | |
| EWMDimensionUnit | UnitOfMeasureDimension | 1 | |
| EWMHandlingUnitExternalUUID | EWMHandlingUnitExternalUUID | 2 | |
| EWMHghstLvlHandlingUnitUUID | EWMHghstLvlHandlingUnitUUID | 1 | |
| EWMHndlgUnitPickingCriteria | EWMHndlgUnitPickingCriteria | 1 | |
| EWMHUProcessStepIsCompleted | EWMHUProcessStepIsCompleted | 1 | |
| EWMPackingInstructionUUID | EWMPackingInstructionUUID | 1 | |
| EWMStorageBin | StorageBin | 1 | |
| EWMStorageSection | StorageSection | 1 | |
| EWMStorageType | StorageType | 1 | |
| ExternalStorageProcessStep | ExternalStorageProcessStep | 1 | |
| GrossVolume | GrossVolume | 1 | |
| GrossWeight | GrossWeight | 1 | |
| HandlingUnitAutoCreationLevel | HandlingUnitAutoCreationLevel | 1 | |
| HandlingUnitBottomInd | HandlingUnitBottomInd | 1 | |
| HandlingUnitCapacityTolerance | HandlingUnitCapacityTolerance | 1 | |
| HandlingUnitContentInd | HandlingUnitContentInd | 1 | |
| HandlingUnitDefectCode | HandlingUnitDefectCode | 1 | |
| HandlingUnitGrossCapacity | HandlingUnitGrossCapacity | 1 | |
| HandlingUnitHasAvailQty | HandlingUnitHasAvailQty | 1 | |
| HandlingUnitHeight | HandlingUnitHeight | 1 | |
| HandlingUnitIsClosed | HandlingUnitIsClosed | 1 | |
| HandlingUnitLength | HandlingUnitLength | 1 | |
| HandlingUnitLogicalPosition | HandlingUnitLogicalPosition | 1 | |
| HandlingUnitMaxDimensionUnit | HandlingUnitMaxDimensionUnit | 1 | |
| HandlingUnitMaxHeight | HandlingUnitMaxHeight | 1 | |
| HandlingUnitMaxLength | HandlingUnitMaxLength | 1 | |
| HandlingUnitMaxVolume | HandlingUnitMaxVolume | 1 | |
| HandlingUnitMaxWeight | HandlingUnitMaxWeight | 1 | |
| HandlingUnitMaxWidth | HandlingUnitMaxWidth | 1 | |
| HandlingUnitNetCapacity | HandlingUnitNetCapacity | 1 | |
| HandlingUnitNetVolume | HandlingUnitNetVolume | 1 | |
| HandlingUnitObjRefInd | HandlingUnitObjRefInd | 1 | |
| HandlingUnitOpenTaskInd | HandlingUnitOpenTaskInd | 1 | |
| HandlingUnitPackingGroup | HandlingUnitPackingGroup | 1 | |
| HandlingUnitStatus | HandlingUnitStatus | 1 | |
| HandlingUnitTareCapacity | HandlingUnitTareCapacity | 1 | |
| HandlingUnitTareVolume | HandlingUnitTareVolume | 1 | |
| HandlingUnitTareVolumeUnit | HandlingUnitTareVolumeUnit | 1 | |
| HandlingUnitTareWeight | HandlingUnitTareWeight | 1 | |
| HandlingUnitTareWeightUnit | HandlingUnitTareWeightUnit | 1 | |
| HandlingUnitTopLevelInd | HandlingUnitTopLevelInd | 1 | |
| HandlingUnitType | HandlingUnitType | 2 | |
| HandlingUnitUUID | HandlingUnitUUID | 3 | |
| HandlingUnitVolumeTolerance | HandlingUnitVolumeTolerance | 1 | |
| HandlingUnitWeightTolerance | HandlingUnitWeightTolerance | 1 | |
| HandlingUnitWidth | HandlingUnitWidth | 1 | |
| HasVariableTareWeight | HasVariableTareWeight | 1 | |
| HazardousSubstanceIndicator | HazardousSubstanceIndicator | 1 | |
| LastChangeDateTime | LastChangeUTCDateTime | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| MaximumCapacity | MaximumCapacity | 1 | |
| NetWeight | NetWeight | 1 | |
| PackagingMaterialType | PackagingMaterialType | 1 | |
| PackagingMaterialUUID | PackagingMaterialUUID | 3 | |
| PackagingSpecificationLevel | PackagingSpecificationLevel | 1 | |
| PackagingSpecificationUUID | PackagingSpecificationUUID | 1 | |
| StatusProfile | StatusProfile | 1 | |
| StorageProcess | StorageProcess | 1 | |
| VolumeUnit | VolumeUnit | 1 | |
| WarehouseOrderCreationRule | WarehouseOrderCreationRule | 1 | |
| WeightUnit | WeightUnit | 1 | |
| WorkloadIdentification | WorkloadIdentification | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Handling Unit Header
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EWM_HANDLINGUNITHDR_2 (
EWMWAREHOUSE,
HANDLINGUNITINDICATOR,
HANDLINGUNITNUMBER,
CREATEDBYUSER,
CREATIONDATETIME,
DISTREQUIPMENTLOGICALPOS,
ENTITLEDTODISPOSEPARTY,
EWMCONSOLIDATIONGROUP,
EWMDIMENSIONUNIT,
EWMHANDLINGUNITEXTERNALUUID,
EWMHGHSTLVLHANDLINGUNITUUID,
EWMHNDLGUNITPICKINGCRITERIA,
EWMHUPROCESSSTEPISCOMPLETED,
EWMPACKINGINSTRUCTIONUUID,
EWMSTORAGEBIN,
EWMSTORAGESECTION,
EWMSTORAGETYPE,
EXTERNALSTORAGEPROCESSSTEP,
GROSSVOLUME,
GROSSWEIGHT,
HANDLINGUNITAUTOCREATIONLEVEL,
HANDLINGUNITBOTTOMIND,
HANDLINGUNITCAPACITYTOLERANCE,
HANDLINGUNITCONTENTIND,
HANDLINGUNITDEFECTCODE,
HANDLINGUNITGROSSCAPACITY,
HANDLINGUNITHASAVAILQTY,
HANDLINGUNITHEIGHT,
HANDLINGUNITISCLOSED,
HANDLINGUNITLENGTH,
HANDLINGUNITLOGICALPOSITION,
HANDLINGUNITMAXDIMENSIONUNIT,
HANDLINGUNITMAXHEIGHT,
HANDLINGUNITMAXLENGTH,
HANDLINGUNITMAXVOLUME,
HANDLINGUNITMAXWEIGHT,
HANDLINGUNITMAXWIDTH,
HANDLINGUNITNETCAPACITY,
HANDLINGUNITNETVOLUME,
HANDLINGUNITOBJREFIND,
HANDLINGUNITOPENTASKIND,
HANDLINGUNITPACKINGGROUP,
HANDLINGUNITSTATUS,
HANDLINGUNITTARECAPACITY,
HANDLINGUNITTAREVOLUME,
HANDLINGUNITTAREVOLUMEUNIT,
HANDLINGUNITTAREWEIGHT,
HANDLINGUNITTAREWEIGHTUNIT,
HANDLINGUNITTOPLEVELIND,
HANDLINGUNITTYPE,
HANDLINGUNITUUID,
HANDLINGUNITVOLUMETOLERANCE,
HANDLINGUNITWEIGHTTOLERANCE,
HANDLINGUNITWIDTH,
HASVARIABLETAREWEIGHT,
HAZARDOUSSUBSTANCEINDICATOR,
LASTCHANGEDATETIME,
LASTCHANGEDBYUSER,
MAXIMUMCAPACITY,
NETWEIGHT,
PACKAGINGMATERIALTYPE,
PACKAGINGMATERIALUUID,
PACKAGINGSPECIFICATIONLEVEL,
PACKAGINGSPECIFICATIONUUID,
STATUSPROFILE,
STORAGEPROCESS,
VOLUMEUNIT,
WAREHOUSEORDERCREATIONRULE,
WEIGHTUNIT,
WORKLOADIDENTIFICATION,
PRIMARY KEY (EWMWAREHOUSE, HANDLINGUNITINDICATOR, HANDLINGUNITNUMBER)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- 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
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA