I_EAMProcessSubPhaseText

DDL: I_EAMPROCESSSUBPHASETEXT SQL: IEAMPROCSPT Type: view BASIC
5 Fields 1 Data Sources 2 Associations

Process Subphase - Text

I_EAMProcessSubPhaseText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Asset Management

I_EAMProcessSubPhaseText is a Basic CDS View that provides data about "Process Subphase - Text" in SAP S/4HANA. It reads from 1 data source (eam_ostat_sph_t) and exposes 5 fields with key fields EAMProcessSubPhaseCode, Language. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-WOC
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageAsset Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
eam_ostat_sph_t eam_ostat_sph_t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_EAMProcessSubPhase _EAMProcessSubPhase $projection.EAMProcessSubPhaseCode = _EAMProcessSubPhase.EAMProcessSubPhaseCode

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IEAMPROCSPT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Process Subphase - Text view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey EAMProcessSubPhaseCode view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY EAMProcessSubPhaseCode eamovrlprocsubphase Process Subphase
KEY Language language Report Text Language
EAMProcessSubPhaseCodeDesc eamovrlprocsubphasedesc Description of Overall Process Subphase
_Language _Language
_EAMProcessSubPhase _EAMProcessSubPhase

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_EAMProcessSubPhaseText.
-- 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: IEAMPROCSPT

CREATE VIEW I_EAMProcessSubPhaseText AS
SELECT
  eamovrlprocsubphase AS EAMProcessSubPhaseCode,
  Language,
  eamovrlprocsubphasedesc AS EAMProcessSubPhaseCodeDesc
FROM eam_ostat_sph_t
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessSubPhase AS _EAMProcessSubPhase ON EAMProcessSubPhaseCode = _EAMProcessSubPhase.EAMProcessSubPhaseCode  -- association [0..1]
;

Learn More