I_HandlingUnitTP

DDL: I_HANDLINGUNITTP Type: view_entity TRANSACTIONAL Package: LOHUM_STEAMPUNK_HU
47 Fields 1 Data Sources

Handling Unit - TP

I_HandlingUnitTP is a Transactional CDS View that provides data about "Handling Unit - TP" in SAP S/4HANA. It reads from 1 data source (R_HandlingUnitTP) and exposes 47 fields with key fields HandlingUnitExternalID, Warehouse. Part of development package LOHUM_STEAMPUNK_HU.

Data Sources (1)

SourceAliasJoin Type
R_HandlingUnitTP R_HandlingUnitTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Handling Unit - TP view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name HandlingUnit view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitExternalID HandlingUnitExternalID Handling Unit
KEY Warehouse Warehouse Warehouse No.
HandlingUnitExternalIdType HandlingUnitExternalIdType
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
ShippingPoint ShippingPoint Shipping Point
HandlingUnitLowerLevelRefer HandlingUnitLowerLevelRefer
ParentHandlingUnitNumber ParentHandlingUnitNumber
PackagingMaterial PackagingMaterial Packaging Materials
PackagingMaterialType PackagingMaterialType Packaging Material Type
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
HandlingUnitPackingObjectType HandlingUnitPackingObjectType Reference Document Type
HandlingUnitReferenceDocument HandlingUnitReferenceDocument Reference Document
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
HandlingUnitInternalStatus HandlingUnitInternalStatus Handling Unit Status
HandlingUnitProcessStatus HandlingUnitProcessStatus
SourceHandlingUnitUUID SourceHandlingUnitUUID
PackingInstruction PackingInstruction Instructions for Packer
HandlingUnitSecondExternalId HandlingUnitSecondExternalId
StorageType StorageType Storage Type
StorageSection StorageSection
StorageBin StorageBin Storage Bin
EWMConsolidationGroup EWMConsolidationGroup Cons.Grp
HandlingUnitHasCrossRefDoc HandlingUnitHasCrossRefDoc
EWMHandlingUnitType EWMHandlingUnitType HUTyp
HandlingUnitMaxLength HandlingUnitMaxLength
HandlingUnitMaxWidth HandlingUnitMaxWidth
HandlingUnitMaxHeight HandlingUnitMaxHeight
HandlingUnitMaxDimensionUnit HandlingUnitMaxDimensionUnit

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_HandlingUnitTP.
-- 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_HandlingUnitTP AS
SELECT
  HandlingUnitExternalID,
  Warehouse,
  HandlingUnitExternalIdType,
  Plant,
  StorageLocation,
  ShippingPoint,
  HandlingUnitLowerLevelRefer,
  ParentHandlingUnitNumber,
  PackagingMaterial,
  PackagingMaterialType,
  GrossWeight,
  NetWeight,
  HandlingUnitMaxWeight,
  WeightUnit,
  HandlingUnitTareWeight,
  HandlingUnitTareWeightUnit,
  GrossVolume,
  HandlingUnitNetVolume,
  HandlingUnitMaxVolume,
  VolumeUnit,
  HandlingUnitTareVolume,
  HandlingUnitTareVolumeUnit,
  HandlingUnitLength,
  HandlingUnitWidth,
  HandlingUnitHeight,
  UnitOfMeasureDimension,
  HandlingUnitPackingObjectType,
  HandlingUnitReferenceDocument,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  HandlingUnitInternalStatus,
  HandlingUnitProcessStatus,
  SourceHandlingUnitUUID,
  PackingInstruction,
  HandlingUnitSecondExternalId,
  StorageType,
  StorageSection,
  StorageBin,
  EWMConsolidationGroup,
  HandlingUnitHasCrossRefDoc,
  EWMHandlingUnitType,
  HandlingUnitMaxLength,
  HandlingUnitMaxWidth,
  HandlingUnitMaxHeight,
  HandlingUnitMaxDimensionUnit
FROM R_HandlingUnitTP
;

Learn More