I_EAMOverallStatusNextPrimary

DDL: I_EAMOVERALLSTATUSNEXTPRIMARY SQL: IEAMOSTATNXPRIM Type: view BASIC
6 Fields 2 Data Sources

Next Primary Overall Status

I_EAMOverallStatusNextPrimary is a Basic CDS View that provides data about "Next Primary Overall Status" in SAP S/4HANA. It reads from 2 data sources (eam_ostat, P_EAMOverallStatusNextSequence) and exposes 6 fields with key fields EAMOverallStatusProfile, EAMOverallStatus.

Data Sources (2)

SourceAliasJoin Type
eam_ostat _ostat inner
P_EAMOverallStatusNextSequence P_EAMOverallStatusNextSequence from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEAMOSTATNXPRIM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Next Primary Overall Status view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EAMOverallStatusProfile EAMOverallStatusProfile Ovrl Sts Profile
KEY EAMOverallStatus EAMOverallStatus Overall Sts
EAMOverallStatusEntity EAMOverallStatusEntity Entity
EAMOverallStatusSequence EAMOverallStatusSequence Visit Sequence
EAMNextPrimaryOverallStatus eam_ostat overall_status Overall Sts
EAMNextOverallStatusSequence EAMNextOverallStatusSequence

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_EAMOverallStatusNextPrimary.
-- 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: IEAMOSTATNXPRIM

CREATE VIEW I_EAMOverallStatusNextPrimary AS
SELECT
  EAMOverallStatusProfile,
  EAMOverallStatus,
  EAMOverallStatusEntity,
  EAMOverallStatusSequence,
  _ostat.overall_status AS EAMNextPrimaryOverallStatus,
  EAMNextOverallStatusSequence
FROM P_EAMOverallStatusNextSequence
INNER JOIN eam_ostat AS _ostat ON /* join condition not captured in parsed metadata */
;

Learn More