C_HandlingUnitMonitor

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 C_HandlingUnitMonitor.
-- 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.
-- SQL view name: CHUMO

CREATE VIEW C_HandlingUnitMonitor AS
SELECT
  / _HandlingUnitItem AS _HandlingUnitItem
FROM I_HandlingUnitHeaderCombined AS _I_HandlingUnitHeader
LEFT OUTER JOIN I_HandlingUnitItemCombined AS _HandlingUnitItem ON HandlingUnitInternalID = _HandlingUnitItem.HandlingUnitInternalID  -- association [0..*]
LEFT OUTER JOIN I_PackingInstructionStdVH AS _I_PackingInstructionStdVH ON PackingInstruction = _I_PackingInstructionStdVH.PackingInstructionSystemUUID  -- association [0..1]
LEFT OUTER JOIN I_HandlingUnitProcessStatus AS _I_HandlingUnitProcessStatus ON HandlingUnitProcessStatus = _I_HandlingUnitProcessStatus.HandlingUnitProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocument AS _I_DeliveryDocument ON HandlingUnitReferenceDocument = _I_DeliveryDocument.DeliveryDocument  -- association [0..1]
LEFT OUTER JOIN I_HandlingUnitRefDocTypeText AS _I_HandlingUnitRefDocTypeText ON HandlingUnitPackingObjectType = _I_HandlingUnitRefDocTypeText.HandlingUnitRefDocType  -- association [0..*]
LEFT OUTER JOIN C_HandlingUnitJITCall AS _HandlingUnitJITCall ON HandlingUnitReferenceDocument = _HandlingUnitJITCall.BusinessTransactionDocument  -- association [1..*]
LEFT OUTER JOIN C_ShippingPointVH AS _ShippingPointVH ON ShippingPoint = _ShippingPointVH.ShippingPoint  -- 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_StorageLocationStdVH AS _StorageLocationVH ON StorageLocation = _StorageLocationVH.StorageLocation  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN C_PlantVH AS _PlantVH ON Plant = _PlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _PackagingMaterialText ON PackagingMaterial = _PackagingMaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_PackagingMaterialType AS _I_PackagingMaterialType ON PackagingMaterialType = _I_PackagingMaterialType.PackagingMaterialType  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseNumber AS _WarehouseVH ON Warehouse = _WarehouseVH.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_User AS _I_User ON CreatedByUser = _I_User.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _I_UserCreatedBy ON CreatedByUser = _I_UserCreatedBy.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _I_UserChangedBy ON LastChangedByUser = _I_UserChangedBy.UserID  -- association [1..1]
LEFT OUTER JOIN E_HandlingUnitHeader AS _Extension ON HandlingUnitExternalID = _Extension.HandlingUnitExternalID AND _I_HandlingUnitHeader.HandlingUnitInternalID = _Extension.HandlingUnitInternalID  -- association [0..1]
;