I_AltvBsdConfSubstnStrgyTP

DDL: I_ALTVBSDCONFSUBSTNSTRGYTP Type: view_entity TRANSACTIONAL Package: ATP_ABC_SUBSTITUTION_STRATEGY
23 Fields 1 Data Sources 9 Associations

Substn Strategy Transactional Processing

I_AltvBsdConfSubstnStrgyTP is a Transactional CDS View that provides data about "Substn Strategy Transactional Processing" in SAP S/4HANA. It reads from 1 data source (I_AltvBsdConfSubstnStrgy) and exposes 23 fields with key field AltvBsdConfSubstnStrgyUUID. It has 9 associations to related views. Part of development package ATP_ABC_SUBSTITUTION_STRATEGY.

Data Sources (1)

SourceAliasJoin Type
I_AltvBsdConfSubstnStrgy I_AltvBsdConfSubstnStrgy from

Associations (9)

CardinalityTargetAliasCondition
[0..1] P_SubstnStrgyUsgeCntInAltvCtrl _UsageInAlternativeControl $projection.AltvBsdConfSubstnStrgyUUID = _UsageInAlternativeControl.AltvBsdConfSubstnStrgyUUID
[0..*] I_AltvBsdConfAltvCtrlTP _AltvBsdConfAltvCtrl $projection.AltvBsdConfSubstnStrgyUUID = _AltvBsdConfAltvCtrl.AltvBsdConfSubstnStrgyUUID
[0..*] I_AltvBsdConfSubstnMethodTP _Method $projection.AltvBsdConfSubstnStrgyUUID = _Method.AltvBsdConfSubstnStrgyUUID
[0..*] I_AltvBsdConfBuildingRuleTP _BuildingRule $projection.AltvBsdConfSubstnStrgyUUID = _BuildingRule.AltvBsdConfSubstnStrgyUUID
[0..*] I_AltvConfFUPStrgyChnElementTP _FUPChainElement $projection.AltvBsdConfSubstnStrgyUUID = _FUPChainElement.AltvBsdConfSubstnStrgyUUID
[0..*] I_AltvConfAltvConsdtnByCntxtTP _AltvConsiderationByContext $projection.AltvBsdConfSubstnStrgyUUID = _AltvConsiderationByContext.AltvBsdConfSubstnStrgyUUID
[0..*] I_AltvBsdConfSubstnStrgyTextTP _Text $projection.AltvBsdConfSubstnStrgyUUID = _Text.AltvBsdConfSubstnStrgyUUID
[0..*] I_AltvBsdConfRmngQtyAssgmtTP _RemainingQtyAssgmtMode $projection.AltvBsdConfSubstnStrgyUUID = _RemainingQtyAssgmtMode.AltvBsdConfSubstnStrgyUUID
[0..1] P_NrOfFUPStrgiesBySubstnStrgy _NrOfFUPStrgiesBySubstnStrgy $projection.AltvBsdConfSubstnStrgyUUID = _NrOfFUPStrgiesBySubstnStrgy.AltvBsdConfSubstnStrgyUUID

Annotations (16)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.representativeKey AltvBsdConfSubstnStrgyUUID view
ObjectModel.compositionRoot true view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.writeActivePersistence abcsubstnstrgy view
ObjectModel.writeDraftPersistence abcsubstnstrgy_d view
ObjectModel.entityChangeStateId LastChangeDateTime view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Substn Strategy Transactional Processing view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY AltvBsdConfSubstnStrgyUUID AltvBsdConfSubstnStrgyUUID Substitution Strategy UUID
AltvBsdConfSubstnStrgyName AltvBsdConfSubstnStrgyName Strategy Name
AltvBsdConfSubstnStrategyType AltvBsdConfSubstnStrategyType Strategy Type
NumberOfRelatedAltvControls _UsageInAlternativeControl NumberOfRelatedAltvControls
AltvBsdConfRmngQtyAssgmtMsgTgt
ATPSourcingProfileUUID ATPSourcingProfileUUID Sourcing Profile
AltvConfEnrcdSubstnImplmtnName AltvConfEnrcdSubstnImplmtnName Implementation Name
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_Method _Method
_BuildingRule _BuildingRule
_FUPChainElement _FUPChainElement
_AltvConsiderationByContext _AltvConsiderationByContext
_RemainingQtyAssgmtMode _RemainingQtyAssgmtMode
_Text _Text
_SourcingProfile _SourcingProfile
_SubstitutionItemType _SubstitutionItemType
_AltvConsiderationMode _AltvConsiderationMode
_AltvBsdConfAltvCtrl _AltvBsdConfAltvCtrl
_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 I_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 I_AltvBsdConfSubstnStrgyTP AS
SELECT
  AltvBsdConfSubstnStrgyUUID,
  AltvBsdConfSubstnStrgyName,
  AltvBsdConfSubstnStrategyType,
  _UsageInAlternativeControl.NumberOfRelatedAltvControls AS NumberOfRelatedAltvControls,
  cast('' as atp_abc_rmng_qty_msg_target ) AS AltvBsdConfRmngQtyAssgmtMsgTgt,
  ATPSourcingProfileUUID,
  AltvConfEnrcdSubstnImplmtnName,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_AltvBsdConfSubstnStrgy
LEFT OUTER JOIN P_SubstnStrgyUsgeCntInAltvCtrl AS _UsageInAlternativeControl ON AltvBsdConfSubstnStrgyUUID = _UsageInAlternativeControl.AltvBsdConfSubstnStrgyUUID  -- association [0..1]
LEFT OUTER JOIN I_AltvBsdConfAltvCtrlTP AS _AltvBsdConfAltvCtrl ON AltvBsdConfSubstnStrgyUUID = _AltvBsdConfAltvCtrl.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_AltvBsdConfSubstnMethodTP AS _Method ON AltvBsdConfSubstnStrgyUUID = _Method.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_AltvBsdConfBuildingRuleTP AS _BuildingRule ON AltvBsdConfSubstnStrgyUUID = _BuildingRule.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_AltvConfFUPStrgyChnElementTP AS _FUPChainElement ON AltvBsdConfSubstnStrgyUUID = _FUPChainElement.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_AltvConfAltvConsdtnByCntxtTP AS _AltvConsiderationByContext ON AltvBsdConfSubstnStrgyUUID = _AltvConsiderationByContext.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_AltvBsdConfSubstnStrgyTextTP AS _Text ON AltvBsdConfSubstnStrgyUUID = _Text.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN I_AltvBsdConfRmngQtyAssgmtTP AS _RemainingQtyAssgmtMode ON AltvBsdConfSubstnStrgyUUID = _RemainingQtyAssgmtMode.AltvBsdConfSubstnStrgyUUID  -- association [0..*]
LEFT OUTER JOIN P_NrOfFUPStrgiesBySubstnStrgy AS _NrOfFUPStrgiesBySubstnStrgy ON AltvBsdConfSubstnStrgyUUID = _NrOfFUPStrgiesBySubstnStrgy.AltvBsdConfSubstnStrgyUUID  -- association [0..1]
;

Learn More