I_ATPResultRequirement

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_ATPResultRequirement.
-- 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: IATPRESULTRQMT

CREATE VIEW I_ATPResultRequirement AS
SELECT
  cid AS ATPCheckUUID,
  atpcat AS ATPRelevantDocumentCategory,
  delnr AS ATPRelevantDocument,
  delps AS ATPRelevantDocumentItem,
  delet AS ATPRelevantDocScheduleLine,
  item_type AS ATPCheckItemType,
  Material,
  Plant,
  sobkz AS InventorySpecialStockType,
  lgort AS StorageLocation,
  Batch,
  prreg AS ATPCheckingRule,
  trtyp AS ATPDocumentTransactionType,
  bop_strategy AS ABOPConfirmationStrategy,
  cast (bop_segment_id as atp_bop_segment_uuid) AS ABOPSegmentUUID,
  cast (status as atp_item_status) AS ATPCheckItemStatus,
  sequence AS ATPCheckRqmtEvaluationSequence,
  base_uom AS BaseUnit,
  arun_relevant AS ATPRlvtDocItmIsSupAssgmtRlvt,
  arun_status_reason AS SupAssgmtItemStatus
FROM atp_result_item
LEFT OUTER JOIN I_ATPResultHeader AS _Header ON ATPCheckUUID = _Header.ATPCheckUUID  -- association [1..1]
LEFT OUTER JOIN I_ATPResultDetail AS _Details ON ATPCheckUUID = _Details.ATPCheckUUID AND ATPRelevantDocument = _Details.ATPRelevantDocument AND ATPRelevantDocumentItem = _Details.ATPRelevantDocumentItem AND ATPRelevantDocScheduleLine = _Details.ATPRelevantDocScheduleLine AND ATPRelevantDocumentCategory = _Details.ATPRelevantDocumentCategory AND ATPCheckItemType = _Details.ATPCheckItemType  -- association [0..*]
LEFT OUTER JOIN I_ATPRlvtDocumentCategory AS _ATPRlvtDocumentCategory ON ATPRelevantDocumentCategory = _ATPRlvtDocumentCategory.ATPRelevantDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Material ON Material = _Material.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Material = _Batch.Material AND Plant = _Batch.Plant AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_ABOPSegment AS _Segment ON ABOPSegmentUUID = _Segment.ABOPSegmentUUID  -- association [0..1]
LEFT OUTER JOIN I_ABOPStrategy AS _ConfirmationStrategy ON ABOPConfirmationStrategy = _ConfirmationStrategy.ABOPConfirmationStrategy  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
;