I_ABOPVariant

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_ABOPVariant.
-- 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: IABOPVARIANT

CREATE VIEW I_ABOPVariant AS
SELECT
  ABOPVariantUUID,
  ABOPVariantName,
  ABOPVariantHRFProcedure,
  ABOPVariantProcedure,
  ABOPVariantSelOptnToolProced,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  ABOPFallbackVariantUUID,
  ABOPDeliveryGroupHandling,
  SalesDocumentsAreIncluded,
  StockTransportOrdsAreIncluded,
  NonDeliveryRlvtDocsAreIncluded,
  ABOPCheckingRule,
  ABOPExecutionMethod,
  ARunRuleUUID,
  ABOPStockSortRule,
  ABOPAllocReleaseIsRequired,
  ABOPSupplySelHorizonInDays,
  ABOPAssignmentPreviewIsActive,
  ABOPSupplyReassignmentIsReqd,
  ABOPExceptionBehavior,
  ABOPFallbackRqmtRstrcnBehvr,
  LastUsageUTCDateTime
FROM atp_bop_variant
LEFT OUTER JOIN I_ABOPVariantSegment AS _VariantSegment ON ABOPVariantUUID = _VariantSegment.ABOPVariantUUID  -- association [0..*]
LEFT OUTER JOIN I_ABOPVariantSimulation AS _Simulation ON ABOPVariantUUID = _Simulation.ABOPVariantUUID  -- association [0..*]
LEFT OUTER JOIN I_ABOPVariantText AS _Text ON ABOPVariantUUID = _Text.ABOPVariantUUID  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_ABOPVariant AS _Fallback ON ABOPFallbackVariantUUID = _Fallback.ABOPVariantUUID  -- association [0..1]
LEFT OUTER JOIN I_ABOPExceptionBehaviorText AS _ExceptionBehaviorText ON ABOPExceptionBehavior = _ExceptionBehaviorText.ABOPExceptionBehavior  -- association [0..*]
LEFT OUTER JOIN I_ABOPFallbackBehaviorText AS _FallbackBehaviorText ON ABOPFallbackRqmtRstrcnBehvr = _FallbackBehaviorText.ABOPFallbackRqmtRstrcnBehvr  -- association [0..*]
LEFT OUTER JOIN I_ARunRule AS _ARunRule ON ARunRuleUUID = _ARunRule.ARunRuleUUID  -- association [0..1]
LEFT OUTER JOIN I_ABOPAvailyChgLogFltr AS _AvailyChgLogFltr ON ABOPVariantUUID = _AvailyChgLogFltr.ABOPVariantUUID  -- association [0..*]
;