C_MaintExecutionObjSubPhaseVH

DDL: C_MAINTEXECUTIONOBJSUBPHASEVH Type: view_entity CONSUMPTION
4 Fields 1 Data Sources

Maintenance Execution Subphases

C_MaintExecutionObjSubPhaseVH is a Consumption CDS View that provides data about "Maintenance Execution Subphases" in SAP S/4HANA. It reads from 1 data source (I_EAMProcSubPhasePhaseMapping) and exposes 4 fields with key field EAMProcessSubPhaseCode.

Data Sources (1)

SourceAliasJoin Type
I_EAMProcSubPhasePhaseMapping SubphaseAndPhase from

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey EAMProcessSubPhaseCode view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
EndUserText.label Maintenance Execution Subphases view
Metadata.ignorePropagatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY EAMProcessSubPhaseCode I_EAMProcSubPhasePhaseMapping EAMProcessSubPhaseCode Process Subphase
EAMProcessSubPhaseCodeDesc Subphase
EAMProcessPhaseCode I_EAMProcSubPhasePhaseMapping EAMProcessPhaseCode Process Phase
EAMProcessPhaseCodeDesc Phase

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_MaintExecutionObjSubPhaseVH.
-- 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 C_MaintExecutionObjSubPhaseVH AS
SELECT
  SubphaseAndPhase.EAMProcessSubPhaseCode AS EAMProcessSubPhaseCode,
  cast (SubphaseAndPhase._SubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc as eam_maint_ord_proc_subphase) AS EAMProcessSubPhaseCodeDesc,
  SubphaseAndPhase.EAMProcessPhaseCode AS EAMProcessPhaseCode,
  cast (SubphaseAndPhase._Phase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc as eam_maint_ord_proc_phase) AS EAMProcessPhaseCodeDesc
FROM I_EAMProcSubPhasePhaseMapping AS SubphaseAndPhase
;

Learn More