C_AltvBsdConfSubstnStrgyTP

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 C_AltvBsdConfSubstnStrgyTP.
-- 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 C_AltvBsdConfSubstnStrgyTP AS
SELECT
  AltvBsdConfSubstnStrgyUUID,
  AltvBsdConfSubstnStrgyName,
  AltvBsdConfAltvConsdtnMode,
  _AltvConsiderationMode._AltvConsiderationModeText[1:Language = $session.system_language].AltvBsdConfAltvConsdtnModeText AS AltvBsdConfAltvConsdtnModeText,
  AltvBsdConfSubstnStrgyItemType,
  _SubstitutionItemType._SubstitutionItemTypeText[1:Language = $session.system_language].AltvBsdConfStrgyItemTypeText AS AltvBsdConfStrgyItemTypeText,
  NumberOfRelatedAltvControls,
  AltvBsdConfRmngQtyAssgmtMsgTgt,
  AltvBsdConfStrgyHasSrcgPrfl,
  AltvBsdConfStrgyHasFUPStrgy,
  AltvBsdConfStrgyHasBusAddIn,
  AltvBsdConfSubstnStrategyType,
  AltvConfEnrcdSubstnImplmtnName,
  cast( '' as boole_d preserving type ) AS AnyConfEnrcdSubstnIsImplmtd,
  cast( '' as atp_abc_badi_detn_constcy_sts ) AS AltvConfEnrcdSubstnConstcySts,
  cast( '' as atp_abc_badi_detn_constcy_stst ) AS ConfEnrcdSubstnConstcyStsDesc,
  cast( 0 as int1 preserving type ) AS ConfEnrcdSubstnConstcyCritlty,
  ATPSourcingProfileUUID,
  _SourcingProfile.ATPSourcingProfile AS ATPSourcingProfile,
  _SourcingProfile._Text[1:Language = $session.system_language].ATPSourcingProfileDescription AS ATPSourcingProfileDescription,
  _SourcingProfile.ATPIsContrAllwdSrceOfSup AS ATPIsContrAllwdSrceOfSup,
  _SourcingProfile.ATPIsInfoRecdAllwdSrceOfSup AS ATPIsInfoRecdAllwdSrceOfSup,
  _SourcingProfile.ATPSourcingProfileOrigin AS ATPSourcingProfileOrigin,
  _SourcingProfile._ATPSourcingProfileOrigin._Text[1:Language = $session.system_language].ATPSourcingProfileOriginDesc AS ATPSourcingProfileOriginDesc,
  _SourcingProfile.ATPThirdPartyShipmentType AS ATPThirdPartyShipmentType,
  _SourcingProfile._ATPThirdPartyShipmentType._Text[1:Language = $session.system_language].ATPThirdPartyShipmentTypeDesc AS ATPThirdPartyShipmentTypeDesc,
  CreationDateTime,
  CreatedByUser,
  cast(_CreatedByUser.UserDescription as atp_crted_by_user_description) AS CreatedByUserDescription,
  cast(CreatedByUser as atp_created_by_user_id) AS AltvBsdConfStrgyCreatedByUser,
  _TextInSessionLanguage.AltvBsdConfSubstnStrgyText AS AltvBsdConfSubstnStrgyText,
  LastChangeDateTime,
  LastChangedByUser,
  cast(_LastChangedByUser.UserDescription as atp_chgd_by_user_description) AS LastChangedByUserDescription,
  cast(LastChangedByUser as atp_changed_by_user_id) AS AltvBsdConfStrgyLastChgdByUser
FROM I_AltvBsdConfSubstnStrgyTP
LEFT OUTER JOIN C_AltvBsdConfSubstnMethodTP AS _Method ON AltvBsdConfSubstnStrgyUUID = _Method.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN C_AltvBsdConfBuildingRuleTP AS _BuildingRule ON AltvBsdConfSubstnStrgyUUID = _BuildingRule.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN C_AltvConfFUPStrgyChnElementTP AS _FUPChainElement ON AltvBsdConfSubstnStrgyUUID = _FUPChainElement.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN C_SubstnStrgyAssgmtByAccUUID AS _UsageInAltvCtrl ON AltvBsdConfSubstnStrgyUUID = _UsageInAltvCtrl.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN C_AltvConfAltvConsdtnByCntxtTP AS _AltvConsiderationByContext ON AltvBsdConfSubstnStrgyUUID = _AltvConsiderationByContext.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN C_AltvBsdConfSubstnStrgyTextTP AS _Text ON AltvBsdConfSubstnStrgyUUID = _Text.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN C_AltvBsdConfSubstnStrgyTextTP AS _TextInSessionLanguage ON AltvBsdConfSubstnStrgyUUID = _TextInSessionLanguage.AltvBsdConfSubstnStrgyUUID AND _TextInSessionLanguage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_AltvBsdConfRmngQtyAssgmtTP AS _RemainingQtyAssgmtMode ON AltvBsdConfSubstnStrgyUUID = _RemainingQtyAssgmtMode.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_ATPSourcingProfileVH AS _ATPSourcingProfileVH ON ATPSourcingProfileUUID = _ATPSourcingProfileVH.ATPSourcingProfileUUID  -- association [0..1]
LEFT OUTER JOIN C_AltvConfEnrcdSubstnImplmtn AS _EnrichedSubstnImplementation ON AltvConfEnrcdSubstnImplmtnName = _EnrichedSubstnImplementation.AltvConfEnrcdSubstnImplmtnName  -- association [0..*]
;