I_JITSupplyControlHeader

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_JITSupplyControlHeader.
-- 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_JITSupplyControlHeader AS
SELECT
  SupplyControlUUID,
  SupplyControlID,
  ShipToParty,
  CustomerUUID,
  BusinessPartnerUUID,
  Plant,
  CustSupplyArea,
  SupplyAreaUUID,
  Material,
  JITActionCtrl,
  JITCallType,
  JITSupplyControlStatus,
  PartialDeliveryIsAllowed,
  JITUnderDeliveryToleranceInPct,
  JITOverDeliveryToleranceInPct,
  JITUnlimitedOverDelivIsAllowed,
  RepetitiveManufacturingIsAllwd,
  ProductionVersion,
  JITExternalProcessingStatus,
  JITProdnConfirmationControl,
  JITEntryPointForScheduling,
  AddressID,
  SchedulingSchema,
  JITDelivConfControl,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM njit_d_sc_hdr
LEFT OUTER JOIN I_Customer AS _Customer ON ShipToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_JITCustomerSupplyArea AS _JITCustomerSupplyArea ON SupplyAreaUUID = _JITCustomerSupplyArea.SupplyAreaUUID  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Material ON Material = _Material.Product  -- association [0..1]
LEFT OUTER JOIN I_JITActionCtrl AS _JITActionCtrl ON JITActionCtrl = _JITActionCtrl.JITActionCtrl  -- association [0..1]
LEFT OUTER JOIN I_JITCallType AS _JITCallType ON JITCallType = _JITCallType.JITCallType  -- association [0..1]
LEFT OUTER JOIN I_JITPartialDelivery AS _JITPartialDelivery ON PartialDeliveryIsAllowed = _JITPartialDelivery.PartialDeliveryIsAllowed  -- association [0..1]
LEFT OUTER JOIN I_JITSupplyControlStatus AS _JITSupplyControlStatus ON JITSupplyControlStatus = _JITSupplyControlStatus.JITSupplyControlStatus  -- association [0..1]
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_ProductionVersion AS _ProductionVersion ON Material = _ProductionVersion.Material AND Plant = _ProductionVersion.Plant AND ProductionVersion = _ProductionVersion.ProductionVersion  -- association [0..1]
LEFT OUTER JOIN I_JITRepetitiveMfg AS _JITRepetitiveMfg ON RepetitiveManufacturingIsAllwd = _JITRepetitiveMfg.RepetitiveManufacturingIsAllwd  -- association [0..1]
LEFT OUTER JOIN I_JITProdnConfControl AS _JITProdnConfirmationControl ON JITProdnConfirmationControl = _JITProdnConfirmationControl.JITProdnConfirmationControl  -- association [0..1]
LEFT OUTER JOIN I_JITDelivConfControl AS _JITDelivConfControl ON JITDelivConfControl = _JITDelivConfControl.JITDelivConfControl  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerAddress AS _BusinessPartnerAddress ON AddressID = _BusinessPartnerAddress.AddressNumber AND ShipToParty = _BusinessPartnerAddress.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_JITCustomer AS _JITCustomer ON CustomerUUID = _JITCustomer.CustomerUUID  -- association [0..1]
LEFT OUTER JOIN I_SupplierExtStatus AS _SupplierExtStatus ON JITExternalProcessingStatus = _SupplierExtStatus.JITExtStatusAtSupplier  -- association [0..1]
LEFT OUTER JOIN I_JITEntryPointForSchedg AS _JITEntryPointForSchedg ON JITEntryPointForScheduling = _JITEntryPointForSchedg.JITEntryPoint  -- association [0..1]
LEFT OUTER JOIN I_JITSchedulingSchema AS _JITSchedulingSchema ON Plant = _JITSchedulingSchema.Plant AND JITCallType = _JITSchedulingSchema.JITCallType AND SchedulingSchema = _JITSchedulingSchema.SchedulingSchema  -- association [0..1]
LEFT OUTER JOIN I_JITSupplyControlDesc AS _Description ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITSupplyControlTolLvl AS _ToleranceLevel ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITSupplyControlOffset AS _JITSupplyControlOffset ON /* condition not available in parsed metadata */  -- association [0..*]
;