C_ProjectStsObjActiveSts

DDL: C_PROJECTSTSOBJACTIVESTS SQL: CPROJSTSOBJACTST Type: view CONSUMPTION
9 Fields 1 Data Sources 1 Associations

View for System and User statuses

C_ProjectStsObjActiveSts is a Consumption CDS View that provides data about "View for System and User statuses" in SAP S/4HANA. It reads from 1 data source (I_StsObjActiveStsInLogonLang) and exposes 9 fields with key fields StatusObject, StatusCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_StsObjActiveStsInLogonLang I_StsObjActiveStsInLogonLang from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Indicator _IsUserStatus $projection.IsUserStatus = _IsUserStatus.IndicatorValue

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CPROJSTSOBJACTST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label View for System and User statuses view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject Status Object
KEY StatusCode StatusCode Statuscode
IsUserStatus IsUserStatus
StatusProfile StatusProfile Status Profile
StatusShortName StatusShortName
StatusName
IndicatorText
StatusProfileName
StatusSequenceNumber

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_ProjectStsObjActiveSts.
-- 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: CPROJSTSOBJACTST

CREATE VIEW C_ProjectStsObjActiveSts AS
SELECT
  StatusObject,
  StatusCode,
  IsUserStatus,
  StatusProfile,
  StatusShortName,
  cast( StatusName as agtxt preserving type) AS StatusName,
  cast(_IsUserStatus._IndicatorText[1:Language = $session.system_language].IndicatorText as poc_process_status_desc preserving type) AS IndicatorText,
  cast( StatusProfileName as ps_s4_stsma_desc ) AS StatusProfileName,
  cast( _StatusCode.StatusSequenceNumber as ps_s4_stonr ) AS StatusSequenceNumber
FROM I_StsObjActiveStsInLogonLang
LEFT OUTER JOIN I_Indicator AS _IsUserStatus ON IsUserStatus = _IsUserStatus.IndicatorValue  -- association [0..1]
;

Learn More