I_ChgImpactAnlysObjActions

DDL: I_CHGIMPACTANLYSOBJACTIONS SQL: ICHGIMPANLOBJACT Type: view BASIC Package: MPE_PLAN_CIMA

Analysis Object Actions

I_ChgImpactAnlysObjActions is a Basic CDS View that provides data about "Analysis Object Actions" in SAP S/4HANA. It reads from 1 data source (mpe_cima_oact) and exposes 9 fields with key fields AnalysisObj, AnlysObjAct, AnlysObjActImplementType. It has 2 associations to related views. Part of development package MPE_PLAN_CIMA.

Data Sources (1)

SourceAliasJoin Type
mpe_cima_oact AnlysObjAct from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ChgImpactAnlysObjActnTxt _AnlysObjActTxt AnlysObjAct.analysis_obj = _AnlysObjActTxt.AnalysisObj and AnlysObjAct.obj_action = _AnlysObjActTxt.AnlysObjAct and AnlysObjAct.obj_action_impl_type = _AnlysObjActTxt.AnlysObjActImplementType
[1..1] I_ChgImpactAnlysObj _AnalysisObj AnlysObjAct.analysis_obj = _AnalysisObj.AnalysisObj

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICHGIMPANLOBJACT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Analysis Object Actions view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY AnalysisObj mpe_cima_oact analysis_obj Analysis Object Type
KEY AnlysObjAct mpe_cima_oact obj_action Analysis Object Act
KEY AnlysObjActImplementType mpe_cima_oact obj_action_impl_type Analysis Obj Act Typ
AnlysObjActClass mpe_cima_oact action_class Action Class
ActiveFlag mpe_cima_oact active_flag Active Flag
SemanticObject mpe_cima_oact semantic_object Semantic Object
SemanticObjectAction mpe_cima_oact semantic_obj_act Sem Obj Act
_AnlysObjActTxt _AnlysObjActTxt
_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 I_ChgImpactAnlysObjActions.
-- 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: ICHGIMPANLOBJACT

CREATE VIEW I_ChgImpactAnlysObjActions AS
SELECT
  AnlysObjAct.analysis_obj AS AnalysisObj,
  AnlysObjAct.obj_action AS AnlysObjAct,
  AnlysObjAct.obj_action_impl_type AS AnlysObjActImplementType,
  AnlysObjAct.action_class AS AnlysObjActClass,
  AnlysObjAct.active_flag AS ActiveFlag,
  AnlysObjAct.semantic_object AS SemanticObject,
  AnlysObjAct.semantic_obj_act AS SemanticObjectAction
FROM mpe_cima_oact AS AnlysObjAct
LEFT OUTER JOIN I_ChgImpactAnlysObjActnTxt AS _AnlysObjActTxt ON AnlysObjAct.analysis_obj = _AnlysObjActTxt.AnalysisObj AND AnlysObjAct.obj_action = _AnlysObjActTxt.AnlysObjAct AND AnlysObjAct.obj_action_impl_type = _AnlysObjActTxt.AnlysObjActImplementType  -- association [0..*]
LEFT OUTER JOIN I_ChgImpactAnlysObj AS _AnalysisObj ON AnlysObjAct.analysis_obj = _AnalysisObj.AnalysisObj  -- association [1..1]
;