I_SeqJITOutbDelivBasic

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_SeqJITOutbDelivBasic.
-- 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_SeqJITOutbDelivBasic AS
SELECT
  JITPckgGrpUUID,
  JITPckgGrpID,
  JITPckgGrpDefUUID,
  JITPckgGrpStatus,
  CustomerUUID,
  ShipToParty,
  UnloadingPointName,
  ShippingPoint,
  PlannedShippingDateTime,
  RequirementDateTime,
  DeliveryCreationDate,
  GrossWeight,
  CustSupplyArea,
  CustAssemblyLoc,
  Plant,
  LastChangedByUser,
  CreatedByUser,
  CreationDateTime,
  ChangedOnDateTime,
  WeightUnit,
  cast( '' as njit_pckg_grp_desc ) AS JITPckgGrpDesc,
  cast( '' as njit_sup_area_desc ) AS SupplyAreaDesc,
  cast( '' as bezei30 ) AS ShippingPointName,
  JITAltvHndlgUnitID,
  JITAltvHndlgUnitIDShrt
FROM I_JITPckgGrpHeader
LEFT OUTER JOIN I_ShippingPointText AS _ShippingPointText ON ShippingPoint = _ShippingPointText.ShippingPoint  -- association [0..*]
LEFT OUTER JOIN I_JITCustomerSupplyArea AS _JITCustomerSupplyArea ON ShipToParty = _JITCustomerSupplyArea.ShipToParty AND CustSupplyArea = _JITCustomerSupplyArea.CustSupplyArea AND UnloadingPointName = _JITCustomerSupplyArea.UnloadingPointName  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;