I_AltvBsdConfSubstnMethodTP

DDL: I_ALTVBSDCONFSUBSTNMETHODTP Type: view_entity TRANSACTIONAL Package: ATP_ABC_SUBSTITUTION_STRATEGY
7 Fields 1 Data Sources 2 Associations

Substitution Method

I_AltvBsdConfSubstnMethodTP is a Transactional CDS View that provides data about "Substitution Method" in SAP S/4HANA. It reads from 1 data source (I_AltvBsdConfSubstnMethod) and exposes 7 fields with key field AltvBsdConfSubstnMethodUUID. It has 2 associations to related views. Part of development package ATP_ABC_SUBSTITUTION_STRATEGY.

Data Sources (1)

SourceAliasJoin Type
I_AltvBsdConfSubstnMethod I_AltvBsdConfSubstnMethod from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_AltvBsdConfSubstnStrgyTP _Strategy $projection.AltvBsdConfSubstnStrgyUUID = _Strategy.AltvBsdConfSubstnStrgyUUID
[0..*] I_AltvBsdConfSubstnMethSrceTP _MethodSource $projection.AltvBsdConfSubstnMethodUUID = _MethodSource.AltvBsdConfSubstnMethodUUID

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.representativeKey AltvBsdConfSubstnMethodUUID view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeActivePersistence ABCSUBMETHOD view
ObjectModel.writeDraftPersistence ABCSUBMETHOD_D view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Analytics.technicalName ISUBMETHODTP view
EndUserText.label Substitution Method view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AltvBsdConfSubstnMethodUUID AltvBsdConfSubstnMethodUUID Substitution method UUID
AltvBsdConfSubstnStrgyUUID AltvBsdConfSubstnStrgyUUID Substitution Strategy UUID
OrdinalNumberValue OrdinalNumberValue Ordinal Number
AltvBsdConfSubstnMethodClass AltvBsdConfSubstnMethodClass Substitution Method
_Strategy _Strategy
_MethodSource _MethodSource
_MethodClassText _MethodClassText

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_AltvBsdConfSubstnMethodTP.
-- 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_AltvBsdConfSubstnMethodTP AS
SELECT
  AltvBsdConfSubstnMethodUUID,
  AltvBsdConfSubstnStrgyUUID,
  OrdinalNumberValue,
  AltvBsdConfSubstnMethodClass
FROM I_AltvBsdConfSubstnMethod
LEFT OUTER JOIN I_AltvBsdConfSubstnStrgyTP AS _Strategy ON AltvBsdConfSubstnStrgyUUID = _Strategy.AltvBsdConfSubstnStrgyUUID  -- association [1..1]
LEFT OUTER JOIN I_AltvBsdConfSubstnMethSrceTP AS _MethodSource ON AltvBsdConfSubstnMethodUUID = _MethodSource.AltvBsdConfSubstnMethodUUID  -- association [0..*]
;

Learn More