A_HandlingUnit_2

DDL: A_HANDLINGUNIT_2 Type: view_entity CONSUMPTION
58 Fields 1 Data Sources 1 OData Services

Handling Unit

A_HandlingUnit_2 is a Consumption CDS View that provides data about "Handling Unit" in SAP S/4HANA. It reads from 1 data source (R_HandlingUnitTP) and exposes 58 fields with key fields HandlingUnitExternalID, Warehouse. It is exposed through 1 OData service (API_HANDLINGUNIT).

Data Sources (1)

SourceAliasJoin Type
R_HandlingUnitTP R_HandlingUnitTP projection

Annotations (10)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entitySet.name HandlingUnit view
EndUserText.label Handling Unit view

OData Services (1)

ServiceBindingVersionContractRelease
API_HANDLINGUNIT API_HANDLINGUNIT V4 C2 C1

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitExternalID HandlingUnitExternalID Handling Unit
KEY Warehouse Warehouse Warehouse No.
PackagingMaterial PackagingMaterial Packaging Materials
PackagingMaterialType PackagingMaterialType Packaging Material Type
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
ShippingPoint ShippingPoint Shipping Point
ParentHandlingUnitNumber ParentHandlingUnitNumber
HighestLevelHandlingUnitNumber HighestLevelHandlingUnitNumber
GrossWeight GrossWeight Total Weight
NetWeight NetWeight Net weight
HandlingUnitMaxWeight HandlingUnitMaxWeight
WeightUnit WeightUnit Weight unit
HandlingUnitTareWeight HandlingUnitTareWeight
HandlingUnitTareWeightUnit HandlingUnitTareWeightUnit
GrossVolume GrossVolume Total Volume
HandlingUnitNetVolume HandlingUnitNetVolume
HandlingUnitMaxVolume HandlingUnitMaxVolume
VolumeUnit VolumeUnit Volume Unit
HandlingUnitTareVolume HandlingUnitTareVolume
HandlingUnitTareVolumeUnit HandlingUnitTareVolumeUnit
HandlingUnitLength HandlingUnitLength
HandlingUnitWidth HandlingUnitWidth
HandlingUnitHeight HandlingUnitHeight
UnitOfMeasureDimension UnitOfMeasureDimension Dimension
HandlingUnitReferenceDocument HandlingUnitReferenceDocument
HandlingUnitRefDocType HandlingUnitPackingObjectType Reference document for handling unit
HandlingUnitHasCrossRefDoc HandlingUnitHasCrossRefDoc
PackingInstruction PackingInstruction Instructions for Packer
HandlingUnitSecondExternalId HandlingUnitSecondExternalId Packing Instruction
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser Date and time of creation
LastChangeDateTime LastChangeDateTime Timestamp
StorageType StorageType Date and time of last change
StorageSection StorageSection
StorageBin StorageBin Storage Bin
EWMResource EWMResource
EWMConsolidationGroup EWMConsolidationGroup Cons.Grp
HandlingUnitIsClosed HandlingUnitIsClosed
ExternalStorageProcessStep ExternalStorageProcessStep
StorageProcess StorageProcess
EWMHUProcessStepIsCompleted EWMHUProcessStepIsCompleted
EWMSrlNmbrForPackagingMaterial EWMSrlNmbrForPackagingMaterial
EWMHandlingUnitIsPlanned EWMHandlingUnitIsPlanned
EWMHandlingUnitIsInStock EWMHandlingUnitIsInStock
EWMHandlingUnitIsUnloaded EWMHandlingUnitIsUnloaded
EWMHandlingUnitIsLoaded EWMHandlingUnitIsLoaded
EWMTranspUnitIsAssigned EWMTranspUnitIsAssigned
EWMHUContentChangeIsBlocked EWMHUContentChangeIsBlocked
EWMHUMovementChangeIsBlocked EWMHUMovementChangeIsBlocked
EWMHUAttributeChangeIsBlocked EWMHUAttributeChangeIsBlocked
EWMHUPostingChangeIsBlocked EWMHUPostingChangeIsBlocked
EWMHUIsBlockedByCustoms EWMHUIsBlockedByCustoms
EWMHUIsPackedForShipping EWMHUIsPackedForShipping
EWMHUIsJITUpdateRelevant EWMHUIsJITUpdateRelevant
EWMHUDestinationProdnSupArea EWMHUDestinationProdnSupArea
EWMHUDestinationStorageBin EWMHUDestinationStorageBin

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 A_HandlingUnit_2.
-- 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 A_HandlingUnit_2 AS
SELECT
  HandlingUnitExternalID,
  Warehouse,
  PackagingMaterial,
  PackagingMaterialType,
  Plant,
  StorageLocation,
  ShippingPoint,
  ParentHandlingUnitNumber,
  HighestLevelHandlingUnitNumber,
  GrossWeight,
  NetWeight,
  HandlingUnitMaxWeight,
  WeightUnit,
  HandlingUnitTareWeight,
  HandlingUnitTareWeightUnit,
  GrossVolume,
  HandlingUnitNetVolume,
  HandlingUnitMaxVolume,
  VolumeUnit,
  HandlingUnitTareVolume,
  HandlingUnitTareVolumeUnit,
  HandlingUnitLength,
  HandlingUnitWidth,
  HandlingUnitHeight,
  UnitOfMeasureDimension,
  HandlingUnitReferenceDocument,
  HandlingUnitPackingObjectType AS HandlingUnitRefDocType,
  HandlingUnitHasCrossRefDoc,
  PackingInstruction,
  HandlingUnitSecondExternalId,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  StorageType,
  StorageSection,
  StorageBin,
  EWMResource,
  EWMConsolidationGroup,
  HandlingUnitIsClosed,
  ExternalStorageProcessStep,
  StorageProcess,
  EWMHUProcessStepIsCompleted,
  EWMSrlNmbrForPackagingMaterial,
  EWMHandlingUnitIsPlanned,
  EWMHandlingUnitIsInStock,
  EWMHandlingUnitIsUnloaded,
  EWMHandlingUnitIsLoaded,
  EWMTranspUnitIsAssigned,
  EWMHUContentChangeIsBlocked,
  EWMHUMovementChangeIsBlocked,
  EWMHUAttributeChangeIsBlocked,
  EWMHUPostingChangeIsBlocked,
  EWMHUIsBlockedByCustoms,
  EWMHUIsPackedForShipping,
  EWMHUIsJITUpdateRelevant,
  EWMHUDestinationProdnSupArea,
  EWMHUDestinationStorageBin
FROM R_HandlingUnitTP
;

Learn More