C_AltvBsdConfFUPStrategyTP

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_AltvBsdConfFUPStrategyTP.
-- 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_AltvBsdConfFUPStrategyTP AS
SELECT
  AltvBsdConfSubstnStrgyUUID,
  AltvBsdConfSubstnStrgyName,
  AltvBsdConfStrgyHasSrcgPrfl,
  AltvBsdConfSubstnStrategyType,
  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,
  _UsgeCntInSubstnStrgy.NumberOfSubstitutionStrgies AS NmbrOfRelatedAltvSubstnStrgies,
  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_AltvConfFUPSubstnMethodTP AS _Method ON AltvBsdConfSubstnStrgyUUID = _Method.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN C_AltvConfFUPBuildingRuleTP AS _BuildingRule ON AltvBsdConfSubstnStrgyUUID = _BuildingRule.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN C_AltvConfFUPSubstnStrgyTextTP AS _Text ON AltvBsdConfSubstnStrgyUUID = _Text.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN C_AltvConfFUPSubstnStrgyTextTP AS _TextInSessionLanguage ON AltvBsdConfSubstnStrgyUUID = _TextInSessionLanguage.AltvBsdConfSubstnStrgyUUID AND _TextInSessionLanguage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ATPSourcingProfileVH AS _ATPSourcingProfileVH ON ATPSourcingProfileUUID = _ATPSourcingProfileVH.ATPSourcingProfileUUID  -- association [0..1]
LEFT OUTER JOIN C_AltvConfFUPStrgyUsageInStrgy AS _UsageInStrategy ON AltvBsdConfSubstnStrgyUUID = _UsageInStrategy.FUPAltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN P_FUPStrgyUsgeCntInSubstnStrgy AS _UsgeCntInSubstnStrgy ON AltvBsdConfSubstnStrgyUUID = _UsgeCntInSubstnStrgy.FUPAltvBsdConfSubstnStrgyUUID  -- association [0..1]
;