I_IntactvABOPRequirement

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_IntactvABOPRequirement.
-- 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_IntactvABOPRequirement AS
SELECT
  IntactvABOPRequirementUUID,
  IntactvABOPUUID,
  ATPRelevantDocumentCategory,
  ATPRelevantDocument,
  ATPRelevantDocumentItem,
  ATPRelevantDocScheduleLine,
  Product,
  Plant,
  RequestedDeliveryDate,
  RequestedQuantityInBaseUnit,
  BaseUnit,
  SchedLineIsProdAvailyCheckRlvt,
  SchedLineIsProdAllocationRlvt,
  SchedLineIsSupplyProtRlvt,
  RqmtIsATPChecked,
  ABOPRunRequirementPriorityVal,
  DeliveryGroup,
  AltvBsdConfSubstitutionStatus,
  AltvBsdConfIsDeactivated,
  ATPCheckingGroup,
  ATPCheckingRule,
  OrderedQuantityInBaseUnit,
  OrderQuantityUnit,
  ProductAvailabilityDate
FROM atp_ibop_rqmts
LEFT OUTER JOIN I_IntactvABOPHeader AS _IntactvABOPHeader ON IntactvABOPUUID = _IntactvABOPHeader.IntactvABOPUUID  -- association [0..1]
LEFT OUTER JOIN I_IntactvABOPConfirmation AS _IntactvABOPConfirmation ON IntactvABOPRequirementUUID = _IntactvABOPConfirmation.IntactvABOPRequirementUUID  -- association [1..*]
LEFT OUTER JOIN I_ATPRelevantDocumentCategory AS _ATPRlvtDocumentCategory ON ATPRelevantDocumentCategory = _ATPRlvtDocumentCategory.ATPRelevantDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON ATPRelevantDocument = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_StockTransportOrder AS _StockTransportOrder ON ATPRelevantDocument = _StockTransportOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_AltvBsdConfSubstitutionSts AS _AltvBsdConfSubstnSts ON AltvBsdConfSubstitutionStatus = _AltvBsdConfSubstnSts.AltvBsdConfSubstitutionStatus  -- association [0..1]
;