I_HandlingUnitItem

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_HandlingUnitItem.
-- 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_HandlingUnitItem AS
SELECT
  venum AS HandlingUnitInternalID,
  vepos AS HandlingUnitItem,
  _HandlingUnitHeader.HandlingUnitExternalID AS HandlingUnitExternalID,
  velin AS HandlingUnitTypeOfContent,
  vbeln AS HandlingUnitReferenceDocument,
  posnr AS HandlingUnitRefDocumentItem,
  vbtyp AS SDDocumentCategory,
  unvel AS HandlingUnitNestedInternalID,
  vemng AS HandlingUnitQuantity,
  vemeh AS HandlingUnitQuantityUnit,
  _BaseUnitOfMeasure.UnitOfMeasureISOCode AS HndlgUnitQuantityUnitISOCode,
  _BaseUnitOfMeasure.UnitOfMeasureSAPCode AS HndlgUnitQuantityUnitSAPCode,
  altme AS HandlingUnitAltUnitOfMeasure,
  veanz AS HandlingUnitNrOfAuxPackgMat,
  kzbei AS HandlingUnitItemIsSupplement,
  matnr AS Material,
  charg AS Batch,
  werks AS Plant,
  lgort AS StorageLocation,
  cuobj AS ConfigurationObject,
  sobkz AS InventorySpecialStockType,
  sonum AS SpecialStockNumber,
  qplos AS HandlingUnitInspectLotNumber,
  anzsn AS HandlingUnitNumberOfSerialNumb,
  serail AS SerialNumberProfile,
  pstyv AS SalesDocumentItemCategory,
  posnr_gen AS HandlingUnitGenDeliveryItem,
  p_material AS MaterialByCustomer,
  wdatu AS HandlingUnitGoodsReceiptDate,
  vfdat AS ShelfLifeExpirationDate,
  sgt_scat AS StockSegment,
  handle_vepo AS HandlingUnitItemUUID,
  int_call_num AS InternalJITCallNumber,
  compgroup_item_num AS JITCallComponentGrpItemNumber
FROM vepo AS HandlingUnitItem
LEFT OUTER JOIN I_HandlingUnitHeader AS _HandlingUnitHeader ON HandlingUnitInternalID = _HandlingUnitHeader.HandlingUnitInternalID  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnitOfMeasure ON _BaseUnitOfMeasure.UnitOfMeasure = HandlingUnitQuantityUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _AlternativeUnitOfMeasure ON _AlternativeUnitOfMeasure.UnitOfMeasure = HandlingUnitAltUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_SerialNumberHandlingUnit AS _HandlingUnitSerialNumber ON _HandlingUnitSerialNumber.HandlingUnitInternalID = HandlingUnitInternalID AND HandlingUnitItem = _HandlingUnitSerialNumber.HandlingUnitItem  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _SalesDocumentItemCategory ON SalesDocumentItemCategory = _SalesDocumentItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_BatchCrossPlant AS _Batch ON Batch = _Batch.Batch AND Material = _Batch.Material  -- association [0..1]
LEFT OUTER JOIN I_JITCallCompMaterialBasic AS _JITCallCompMaterialBasic ON HandlingUnitReferenceDocument = _JITCallCompMaterialBasic.SalesOrder AND HandlingUnitRefDocumentItem = _JITCallCompMaterialBasic.SalesOrderItem  -- association [0..*]
;