R_HandlingUnitItemTP

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 R_HandlingUnitItemTP.
-- 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 R_HandlingUnitItemTP AS
SELECT
  HandlingUnitExternalID,
  Warehouse,
  StockItemUUID,
  HandlingUnitItem,
  Material,
  HandlingUnitInternalID,
  HandlingUnitTypeOfContent,
  cast( '00000000000000000000' as exidv) AS HandlingUnitNestedExternalID,
  HandlingUnitReferenceDocument,
  HandlingUnitRefDocumentItem,
  cast ( HandlingUnitQuantity as vemng ) AS HandlingUnitQuantity,
  HandlingUnitQuantityUnit,
  HandlingUnitAltUnitOfMeasure,
  HndlgUnitQuantityUnitISOCode,
  HndlgUnitQuantityUnitSAPCode,
  MaterialName,
  Batch,
  Plant,
  StorageLocation,
  ShelfLifeExpirationDate,
  HandlingUnitGoodsReceiptDate,
  CountryOfOrigin,
  HandlingUnitNrOfAuxPackgMat,
  HandlingUnitNumberOfSerialNumb,
  SerialNumberProfile,
  InternalJITCallNumber,
  JITCallComponentGrpItemNumber
FROM I_HandlingUnitItemCombined
LEFT OUTER JOIN R_HandlingUnitItemSerialNoTP AS _HandlingUnitItemSerialNumber ON /* condition not available in parsed metadata */  -- association [0..*]
;