I_AltvBsdConfSubstnMethodTP

DDL: I_ALTVBSDCONFSUBSTNMETHODTP SQL: ISUBMETHODTP Type: view TRANSACTIONAL
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.

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 (15)

NameValueLevelField
AbapCatalog.sqlViewName ISUBMETHODTP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
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
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.
-- SQL view name: ISUBMETHODTP

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