I_ChgRecordUserStatus

DDL: I_CHGRECORDUSERSTATUS Type: view_entity BASIC
2 Fields 1 Data Sources 1 Associations

Change Record User Status

I_ChgRecordUserStatus (Basic)

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

ChangeRecordUserStatus · Product Lifecycle Management

I_ChgRecordUserStatus is a Basic CDS View that provides data about "Change Record User Status" in SAP S/4HANA. It reads from 1 data source (/iam/c_stat) and exposes 2 fields with key field ChangeRecordStatus. It has 1 association to related views.

SAP Help Documentation

CategoryChange Record
StatusUser Status
Purpose
This CDS view enables the collection of change record user status data. A change record user status is a coded representation of the user status of a change record. It is used in change record processing. User statuses and the corresponding user actions can be assigned to a change record type as a status profile. The status can be any one of the following: Status Description Change Request in Work Change request is in work Change Completed Change is completed New New change request Change Request in Review Change request is in review Request Ready for Approval Change request is ready for approval Change Request Rejected Change request is rejected Change Request Approved Change request is approved Change in Process Change is in process Change Incomplete Change is incomplete Change Completed Change is completed Change Closed Change is closed Change Released Change is released

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description Comment ChangeRecordStatus User Status The following are values SAP ships: 10 : Initial 20 : Change Request in Work 80 : Change Completed E0 : New E1 : Change Request in Review E2 : Request Ready for Approval E3 : Change Request Rejected E4 : Change Request Approved E5 : Change in Process E6 : Change Incomplete E7 : Change Completed E8 : Change Closed E9 : Change Released S0 : New S1 : Change Request in Review S2 : Request Ready for Approval S3 : Change Request Rejected S4 : Change Request Approved S5 : Change in Process S6 : Change Incomplete S7 : Change Completed S8 : Change Closed S9 : Change Released

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessProduct Lifecycle Management
Application ComponentPLM-CR
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageProduct Lifecycle Management for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view enables the collection of change record user status data. A change record user status is a coded representation of the user status of a change record. It is used in change record processing. User statuses and the corresponding user actions can be assigned to a change record type as a status profile. The status can be any one of the following: </p> Status Description <p>Change Request in Work</p> <p>Change request is in work</p> <p>Change Completed</p> <p>Change is completed</p> <p>New</p> <p>New change request</p> <p>Change Request in Review</p> <p>Change request is in review</p> <p>Request Ready for Approval</p> <p>Change request is ready for approval</p> <p>Change Request Rejected</p> <p>Change request is rejected</p> <p>Change Request Approved</p> <p>Change request is approved</p> <p>Change in Process</p> <p>Change is in process</p> <p>Change Incomplete</p> <p>Change is incomplete</p> <p>Change Completed</p> <p>Change is completed</p> <p>Change Closed</p> <p>Change is closed</p> <p>Change Released</p> <p>Change is released</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
/iam/c_stat /iam/c_stat from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ChgRecordUserStatusText _Text

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Change Record User Status view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name ChangeRecordUserStatus view
ObjectModel.representativeKey ChangeRecordStatus view
Search.searchable true view
VDM.viewType #BASIC view
ObjectModel.modelingPattern #NONE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordStatus status User Status Code
_Text _Text

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_ChgRecordUserStatus.
-- 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_ChgRecordUserStatus AS
SELECT
  status AS ChangeRecordStatus
FROM /iam/c_stat
LEFT OUTER JOIN I_ChgRecordUserStatusText AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More