I_EAMOverallStatusNextPrimary

DDL: I_EAMOVERALLSTATUSNEXTPRIMARY Type: view_entity BASIC Package: EAM_OVRL_STS
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. Part of development package EAM_OVRL_STS.

Data Sources (2)

SourceAliasJoin Type
eam_ostat _ostat inner
P_EAMOverallStatusNextSequence P_EAMOverallStatusNextSequence from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Next Primary Overall Status view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EAMOverallStatusProfile P_EAMOverallStatusNextSequence EAMOverallStatusProfile Ovrl Sts Profile
KEY EAMOverallStatus P_EAMOverallStatusNextSequence EAMOverallStatus Overall Sts
EAMOverallStatusEntity P_EAMOverallStatusNextSequence EAMOverallStatusEntity Entity
EAMOverallStatusSequence P_EAMOverallStatusNextSequence EAMOverallStatusSequence Visit Sequence
EAMNextPrimaryOverallStatus eam_ostat overall_status Overall Sts
EAMNextOverallStatusSequence P_EAMOverallStatusNextSequence 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.

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

Learn More