C_JITSupplyToProductionOvwFltr

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_JITSupplyToProductionOvwFltr.
-- 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: CJITSTOPOVWFLTR

CREATE VIEW C_JITSupplyToProductionOvwFltr AS
SELECT
  InternalJITCallNumber,
  JITLifecycleStatus,
  _JITOutbCallOvwBySupplier.Supplier AS Supplier,
  _JITOutbCallCompGroup.JITIntProcessingStatus AS JITIntProcessingStatus,
  _JITOutbCallCompGroup.Plant AS Plant,
  cast('0' as njit_req_date_time ) AS RequirementDateTime,
  cast('0' as njit_planned_shipping_date_tim) AS PlannedShippingDateTime,
  cast('0' as timestampl) AS CreationDateTime,
  cast('NJIT_S2P' as balsubobj) AS ApplicationLogObject
FROM I_JITOutbCallHeader
LEFT OUTER JOIN C_JITOutbCallAlertOverview AS _JITOutbCallAlertOverview ON InternalJITCallNumber = _JITOutbCallAlertOverview.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN C_JITOutbCallOverviewByStatus AS _JITOutbCallOverviewByStatus ON InternalJITCallNumber = _JITOutbCallOverviewByStatus.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN C_JITOutbCallOvwExtStatus AS _JITOutbCallOvwExtStatus ON InternalJITCallNumber = _JITOutbCallOvwExtStatus.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN C_JITOutbCallOvwByMissingPart AS _JITOutbCallOvwByMissingPart ON InternalJITCallNumber = _JITOutbCallOvwByMissingPart.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN C_JITOutbCallOvwByPriority AS _JITOutbCallOvwByPriority ON InternalJITCallNumber = _JITOutbCallOvwByPriority.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN C_JITOutbStockTransferStatOvw AS _JITOutbStockTransferStatOvw ON InternalJITCallNumber = _JITOutbStockTransferStatOvw.InternalJITCallNumber  -- association [1..*]
LEFT OUTER JOIN C_JITOutbCallOvwBySupplier AS _JITOutbCallOvwBySupplier ON InternalJITCallNumber = _JITOutbCallOvwBySupplier.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN C_JITOutbCallOvwByDateTime AS _JITOutbCallOvwByDateTime ON InternalJITCallNumber = _JITOutbCallOvwByDateTime.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN C_JITOutbCallOvwByProcgStsInt AS _JITOutbCallOvwByProcgStsInt ON InternalJITCallNumber = _JITOutbCallOvwByProcgStsInt.InternalJITCallNumber  -- association [1..*]
LEFT OUTER JOIN C_JITOutbCallOvwByProcgStsExt AS _JITOutbCallOvwByProcgStsExt ON InternalJITCallNumber = _JITOutbCallOvwByProcgStsExt.InternalJITCallNumber  -- association [1..*]
LEFT OUTER JOIN C_JITOutbControlCycleStatusLog AS _JITOutbControlCycleStatusLog ON ApplicationLogObject = _JITOutbControlCycleStatusLog.ApplicationLogObject AND _JITOutbControlCycleStatusLog.ApplicationLogSubobject='CC_STATUS_CHANGE'  -- association [1..*]
LEFT OUTER JOIN C_JITOutbCallsStatusLog AS _JITOutbCallsStatusLog ON ApplicationLogObject = _JITOutbCallsStatusLog.ApplicationLogObject AND _JITOutbCallsStatusLog.ApplicationLogSubobject = 'S2L_PLANNING'  -- association [1..*]
;