I_AltvBsdConfSubstnStrgy

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_AltvBsdConfSubstnStrgy.
-- 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_AltvBsdConfSubstnStrgy AS
SELECT
  AltvBsdConfSubstnStrgyUUID,
  AltvBsdConfSubstnStrgyName,
  AltvBsdConfAltvConsdtnMode,
  AltvBsdConfSubstnStrgyItemType,
  AltvBsdConfSubstnStrategyType,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  AltvConfEnrcdSubstnImplmtnName
FROM abcsubstnstrgy
LEFT OUTER JOIN I_AltvBsdConfAltvCtrl AS _AltvBsdConfAltvCtrl ON AltvBsdConfSubstnStrgyUUID = _AltvBsdConfAltvCtrl.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_AltvBsdConfSubstnMethod AS _Method ON AltvBsdConfSubstnStrgyUUID = _Method.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_AltvBsdConfBuildingRule AS _BuildingRule ON AltvBsdConfSubstnStrgyUUID = _BuildingRule.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_AltvConfFUPStrgyChnElement AS _FUPChainElement ON AltvBsdConfSubstnStrgyUUID = _FUPChainElement.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_AltvConfAltvConsdtnByCntxt AS _AltvConsiderationByContext ON AltvBsdConfSubstnStrgyUUID = _AltvConsiderationByContext.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_AltvBsdConfSubstnStrgyText AS _Text ON AltvBsdConfSubstnStrgyUUID = _Text.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_AltvBsdConfStrgyItemType AS _SubstitutionItemType ON AltvBsdConfSubstnStrgyItemType = _SubstitutionItemType.AltvBsdConfSubstnStrgyItemType  -- association [0..1]
LEFT OUTER JOIN I_AltvBsdConfAltvConsdtnMode AS _AltvConsiderationMode ON AltvBsdConfAltvConsdtnMode = _AltvConsiderationMode.AltvBsdConfAltvConsdtnMode  -- association [0..1]
LEFT OUTER JOIN R_ATPSourcingProfile AS _SourcingProfile ON ATPSourcingProfileUUID = _SourcingProfile.ATPSourcingProfileUUID  -- association [1..1]
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]
;