I_MaintOpExecStageCodeText

DDL: I_MAINTOPEXECSTAGECODETEXT SQL: IMAINOPEXESTAGET Type: view BASIC
4 Fields 2 Data Sources

Maint. Operation Exec. Stage Code Text

I_MaintOpExecStageCodeText is a Basic CDS View that provides data about "Maint. Operation Exec. Stage Code Text" in SAP S/4HANA. It reads from 2 data sources (eam_mopexcphasea, eam_mopexcphaset) and exposes 4 fields with key fields MaintOperationExecStageCode, LanguageCode.

Data Sources (2)

SourceAliasJoin Type
eam_mopexcphasea eam_mopexcphasea left_outer
eam_mopexcphaset eam_mopexcphaset from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IMAINOPEXESTAGET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maint. Operation Exec. Stage Code Text view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MaintOperationExecStageCode
KEY LanguageCode eam_mopexcphaset spras Off. Language
MaintOpExecutionStageName
MaintOpExecStageShortText Execution Stage Description

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_MaintOpExecStageCodeText.
-- 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: IMAINOPEXESTAGET

CREATE VIEW I_MaintOpExecStageCodeText AS
SELECT
  cast( eam_mopexcphaset.maintopexecutionphasecode as eam_premainpost_cds preserving type ) AS MaintOperationExecStageCode,
  eam_mopexcphaset.spras AS LanguageCode,
  cast(coalesce(eam_mopexcphasea.maintopexecutionstagename, eam_mopexcphaset.maintopexecutionstagename) as eam_premainpost_name preserving type ) AS MaintOpExecutionStageName,
  cast(coalesce(eam_mopexcphasea.maintopexecstageshorttext, eam_mopexcphaset.maintopexecstageshorttext) as eam_premainpost_desc preserving type ) AS MaintOpExecStageShortText
FROM eam_mopexcphaset
LEFT OUTER JOIN eam_mopexcphasea ON /* join condition not captured in parsed metadata */
;

Learn More