C_ChgImpactAnlysReltdObj

DDL: C_CHGIMPACTANLYSRELTDOBJ SQL: CCHGIMPANLYSREL Type: view CONSUMPTION Package: MPE_PLAN_CIMA
5 Fields 1 Data Sources 2 Associations

Analysis Obj and Its Related Obj

C_ChgImpactAnlysReltdObj is a Consumption CDS View that provides data about "Analysis Obj and Its Related Obj" in SAP S/4HANA. It reads from 1 data source (I_ChgImpactAnlysToReltdObj) and exposes 5 fields with key fields AnalysisObj, RelatedObj, RelationKey. It has 2 associations to related views. Part of development package MPE_PLAN_CIMA.

Data Sources (1)

SourceAliasJoin Type
I_ChgImpactAnlysToReltdObj AnlysObjReltdObj from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ChgImpactAnlysRelshpTxt _AnlysObjRelshpTxt AnlysObjReltdObj.AnalysisObj = _AnlysObjRelshpTxt.AnalysisObj and AnlysObjReltdObj.RelatedObj = _AnlysObjRelshpTxt.RelatedObj and AnlysObjReltdObj.RelationKey = _AnlysObjRelshpTxt.RelationKey and _AnlysObjRelshpTxt.Language = $session.system_language
[0..1] C_ChgImpactAnlysObj _AnalysisObj AnlysObjReltdObj.AnalysisObj = _AnalysisObj.AnalysisObj

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CCHGIMPANLYSREL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Analysis Obj and Its Related Obj view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY AnalysisObj I_ChgImpactAnlysToReltdObj AnalysisObj Analysis Object Type
KEY RelatedObj I_ChgImpactAnlysToReltdObj RelatedObj Related Object Type
KEY RelationKey I_ChgImpactAnlysToReltdObj RelationKey Rel key
_AnlysObjRelshpTxt _AnlysObjRelshpTxt
_AnalysisObj _AnalysisObj

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_ChgImpactAnlysReltdObj.
-- 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: CCHGIMPANLYSREL

CREATE VIEW C_ChgImpactAnlysReltdObj AS
SELECT
  AnlysObjReltdObj.AnalysisObj AS AnalysisObj,
  AnlysObjReltdObj.RelatedObj AS RelatedObj,
  AnlysObjReltdObj.RelationKey AS RelationKey
FROM I_ChgImpactAnlysToReltdObj AS AnlysObjReltdObj
LEFT OUTER JOIN I_ChgImpactAnlysRelshpTxt AS _AnlysObjRelshpTxt ON AnlysObjReltdObj.AnalysisObj = _AnlysObjRelshpTxt.AnalysisObj AND AnlysObjReltdObj.RelatedObj = _AnlysObjRelshpTxt.RelatedObj AND AnlysObjReltdObj.RelationKey = _AnlysObjRelshpTxt.RelationKey AND _AnlysObjRelshpTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_ChgImpactAnlysObj AS _AnalysisObj ON AnlysObjReltdObj.AnalysisObj = _AnalysisObj.AnalysisObj  -- association [0..1]
;

Learn More