I_JITDelivSqncGrpHeaderBasic

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_JITDelivSqncGrpHeaderBasic.
-- 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_JITDelivSqncGrpHeaderBasic AS
SELECT
  JITDelivSqncGrpUUID,
  JITDelivSqncGrpID,
  ExtJITDelivSqncGrpID,
  JITDelivSqncGrpStatus,
  Plant,
  Customer,
  CustSupplyArea,
  ShippingStorageLocation,
  JITCompMatlStorageLocation,
  EWMStorageBinForPacking,
  EWMStorageBinForStaging,
  EWMWarehouse,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  JITLogsIntegRlvtEntity,
  JITSqncNumberCheckLevel
FROM njit_d_dsg_hdr
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_JITDelivSqncGrpStatus AS _DelivSqncGrpStatus ON JITDelivSqncGrpStatus = _DelivSqncGrpStatus.JITDelivSqncGrpStatus  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_JITLogsIntegRlvtEntity AS _JITLogsIntegRlvtEntity ON JITLogsIntegRlvtEntity = _JITLogsIntegRlvtEntity.JITLogsIntegRlvtEntity  -- association [0..1]
LEFT OUTER JOIN I_JITCustomer AS _JITCustomer ON Customer = _JITCustomer.ShipToParty  -- association [0..*]
LEFT OUTER JOIN I_JITSqncNumberCheckLevel AS _JITSqncNumberCheckLevel ON JITSqncNumberCheckLevel = _JITSqncNumberCheckLevel.JITSqncNumberCheckLevel  -- association [0..1]
LEFT OUTER JOIN I_JITDelivSqncDefBasic AS _JITDelivSqncDefBasic ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITDelivSqncGrpDescBasic AS _Description ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITDelivSqncSupCtrlBasic AS _DelivSqncSupCtrl ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITDelivSqncNmbrSttgBasic AS _JITDelivSqncNmbrSttg ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITDelivSqncGrpSqncNmbrChk AS _JITDelivSqncGrpSqncNmbrChk ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITDelivSqncGrpSchedgEntry AS _JITDelivSqncGrpSchedgEntry ON /* condition not available in parsed metadata */  -- association [0..*]
;