P_ABOPRunRequirement_2

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 P_ABOPRunRequirement_2.
-- 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 P_ABOPRunRequirement_2 AS
SELECT
  ATPRequirementUUID,
  ATPSummaryRequirementUUID,
  ATPCheckIterationUUID,
  ATPCheckUUID AS ABOPRunUUID,
  ChosenATPConfCompositionUUID,
  ATPRelevantDocument,
  ATPRelevantDocumentItem,
  ATPRelevantDocScheduleLine,
  ATPRelevantDocumentCategory,
  RqmtIsABOPRunItrtnRelevant,
  cast(right(ATPRelevantDocumentItem, 5) as vdm_purchaseorderitem ) AS PurchaseOrderItem,
  Product AS Material,
  Plant,
  StorageLocation,
  IsSalesDocument,
  IsStockTransportDocument,
  AssgdABOPConfirmationStrategy AS ABOPConfirmationStrategy,
  ATPRqmtProcessingSqncPosition AS ABOPRqmtEvaluationSequence,
  ATPCheckItemStatus,
  ATPRqmtSelectionChangeType,
  RqmtIsProcessed,
  cast(case ATPProcessingExclusionReason when 'A01' then 'X' when 'A02' then 'X' else '' end as boole_d preserving type) AS RqmtIsLocked,
  MatchingABOPSegmentUUID AS ABOPSegmentUUID,
  ATPRlvtDocItmIsSupAssgmtRlvt AS RqmtIsSupAssgmtRelevant,
  SupAssgmtItemStatus,
  ReqdProdAvailabilityUTCDateTme,
  ReqdProdAvailabilityTimeZone,
  RequestedQuantityInBaseUnit,
  RequestedQuantityInComBaseUnit,
  confirmation_before_atp.ErlstConfdProdAvailyDteTme AS ErlstConfdProdAvailyDteTmeBfr,
  confirmation_before_atp.ErlstConfdProdAvailyTimeZone AS ErlstConfdProdAvailyTmznBfr,
  confirmation_before_atp.LatestConfdProdAbailyDteTme AS LatestConfdProdAvailyDteTmeBfr,
  confirmation_before_atp.LatestConfdProdAvailyTimeZone AS LatestConfdProdAvailyTmznBfr,
  confirmation_after_atp.ErlstConfdProdAvailyDteTme AS ErlstConfdProdAvailyDteTmeAft,
  confirmation_after_atp.ErlstConfdProdAvailyTimeZone AS ErlstConfdProdAvailyTmznAft,
  confirmation_after_atp.LatestConfdProdAbailyDteTme AS LatestConfdProdAvailyDteTmeAft,
  confirmation_after_atp.LatestConfdProdAvailyTimeZone AS LatestConfdProdAvailyTmznAft,
  _SupplyAssignmentBeforeRun.ErlstSupAssgmtDteTmeBeforeRun AS ErlstSupAssgmtDteTmeBeforeRun,
  _SupplyAssignmentBeforeRun.LatestSupAssgmtDteTmeBeforeRun AS LatestSupAssgmtDteTmeBeforeRun,
  _SupplyAssignmentAfterRun.ErlstSupAssgmtDteTmeAfterRun AS ErlstSupAssgmtDteTmeAfterRun,
  _SupplyAssignmentAfterRun.LatestSupAssgmtDteTmeAfterRun AS LatestSupAssgmtDteTmeAfterRun,
  BaseUnit,
  BaseToCommonBaseQtyNumerator,
  BaseToCommonBaseQtyDenominator
FROM P_ABOPCheckRequirement
LEFT OUTER JOIN P_ABOPRunRqmtQuantityBefore AS confirmation_before_atp ON ATPSummaryRequirementUUID = confirmation_before_atp.ATPRequirementUUID  -- association [1..1]
LEFT OUTER JOIN P_ABOPRunRqmtQuantityAfter AS confirmation_after_atp ON ChosenATPConfCompositionUUID = confirmation_after_atp.ATPConfirmationCompositionUUID  -- association [1..1]
LEFT OUTER JOIN P_ABOPSupAssgmtBeforeRunByRqmt AS _SupplyAssignmentBeforeRun ON ATPRequirementUUID = _SupplyAssignmentBeforeRun.ATPRequirementUUID  -- association [0..1]
LEFT OUTER JOIN P_ABOPSupAssgmtAfterRunByRqmt AS _SupplyAssignmentAfterRun ON ATPRequirementUUID = _SupplyAssignmentAfterRun.ATPRequirementUUID  -- association [0..1]
;