C_AltvBsdConfFUPStrategyTP

DDL: C_ALTVBSDCONFFUPSTRATEGYTP Type: view_entity CONSUMPTION
30 Fields 1 Data Sources 5 Associations

FUP Strategy Transactional Processing

C_AltvBsdConfFUPStrategyTP is a Consumption CDS View that provides data about "FUP Strategy Transactional Processing" in SAP S/4HANA. It reads from 1 data source (I_AltvBsdConfSubstnStrgyTP) and exposes 30 fields with key field AltvBsdConfSubstnStrgyUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_AltvBsdConfSubstnStrgyTP I_AltvBsdConfSubstnStrgyTP from

Associations (5)

CardinalityTargetAliasCondition
[0..*] C_AltvConfFUPSubstnMethodTP _Method $projection.AltvBsdConfSubstnStrgyUUID = _Method.AltvBsdConfSubstnStrgyUUID
[0..*] C_AltvConfFUPBuildingRuleTP _BuildingRule $projection.AltvBsdConfSubstnStrgyUUID = _BuildingRule.AltvBsdConfSubstnStrgyUUID
[0..*] C_AltvConfFUPSubstnStrgyTextTP _Text $projection.AltvBsdConfSubstnStrgyUUID = _Text.AltvBsdConfSubstnStrgyUUID
[0..1] C_AltvConfFUPSubstnStrgyTextTP _TextInSessionLanguage $projection.AltvBsdConfSubstnStrgyUUID = _TextInSessionLanguage.AltvBsdConfSubstnStrgyUUID and _TextInSessionLanguage.Language = $session.system_language
[0..1] I_ATPSourcingProfileVH _ATPSourcingProfileVH $projection.ATPSourcingProfileUUID = _ATPSourcingProfileVH.ATPSourcingProfileUUID

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.representativeKey AltvBsdConfSubstnStrgyUUID view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.draftEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
EndUserText.label FUP Strategy Transactional Processing view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY AltvBsdConfSubstnStrgyUUID AltvBsdConfSubstnStrgyUUID Substitution Strategy UUID
AltvBsdConfSubstnStrgyName AltvBsdConfSubstnStrgyName Strategy Name
AltvBsdConfStrgyHasSrcgPrfl AltvBsdConfStrgyHasSrcgPrfl
AltvBsdConfSubstnStrategyType AltvBsdConfSubstnStrategyType Strategy Type
ATPSourcingProfileUUID ATPSourcingProfileUUID Sourcing Profile
ATPSourcingProfileDescription
ATPSourcingProfile _SourcingProfile ATPSourcingProfile Sourcing Profile
ATPIsContrAllwdSrceOfSup _SourcingProfile ATPIsContrAllwdSrceOfSup Contracts
ATPIsInfoRecdAllwdSrceOfSup _SourcingProfile ATPIsInfoRecdAllwdSrceOfSup Info Records as Sources of Supply
ATPSourcingProfileOrigin _SourcingProfile ATPSourcingProfileOrigin Profile Origin
ATPSourcingProfileOriginDesc
ATPThirdPartyShipmentType _SourcingProfile ATPThirdPartyShipmentType Third-Party Shipment Type
ATPThirdPartyShipmentTypeDesc
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreatedByUserDescription
AltvBsdConfStrgyCreatedByUser User Name
AltvBsdConfSubstnStrgyText _TextInSessionLanguage AltvBsdConfSubstnStrgyText Strategy Description
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription
AltvBsdConfStrgyLastChgdByUser User Name
_Method _Method
_BuildingRule _BuildingRule
_Text _Text
_TextInSessionLanguage _TextInSessionLanguage
_SourcingProfile _SourcingProfile
_ATPSourcingProfileVH _ATPSourcingProfileVH
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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._Text[1:Language = $session.system_language].ATPSourcingProfileDescription AS ATPSourcingProfileDescription,
  _SourcingProfile.ATPSourcingProfile AS ATPSourcingProfile,
  _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_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]
;

Learn More