A_ChgRecdNextUserStatusAction

DDL: A_CHGRECDNEXTUSERSTATUSACTION Type: view_entity CONSUMPTION Package: VDM_PLMB_CR_API
6 Fields 1 Data Sources 1 OData Services

Next User Status Action

A_ChgRecdNextUserStatusAction is a Consumption CDS View that provides data about "Next User Status Action" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordNextStatus) and exposes 6 fields with key fields ChangeRecordType, ChangeRecordActionConditionCtr, ChangeRecordStatus, ChangeRecordStatusNext, ChangeRecordStatusAction. It is exposed through 1 OData service (API_CHGRECDNEXTUSERSTATUSACTN). Part of development package VDM_PLMB_CR_API.

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordNextStatus User_Status from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Next User Status Action view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name ChangeRecordNextStatus_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

OData Services (1)

ServiceBindingVersionContractRelease
API_CHGRECDNEXTUSERSTATUSACTN API_CHGRECDNEXTUSERSTATUSACTN V4 C2 C1

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordType I_ChangeRecordNextStatus ChangeRecordType Record Type
KEY ChangeRecordActionConditionCtr I_ChangeRecordNextStatus ChangeRecordActionConditionCtr Version
KEY ChangeRecordStatus I_ChangeRecordNextStatus ChangeRecordStatus Workflow Status
KEY ChangeRecordStatusNext I_ChangeRecordNextStatus ChangeRecordStatusNext Status
KEY ChangeRecordStatusAction I_ChangeRecordNextStatus ChangeRecordStatusAction User action
ChangeRecordStatusActionText I_ChangeRecordNextStatus ChangeRecordStatusActionText Well Code Des.

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 A_ChgRecdNextUserStatusAction.
-- 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 A_ChgRecdNextUserStatusAction AS
SELECT
  User_Status.ChangeRecordType AS ChangeRecordType,
  User_Status.ChangeRecordActionConditionCtr AS ChangeRecordActionConditionCtr,
  User_Status.ChangeRecordStatus AS ChangeRecordStatus,
  User_Status.ChangeRecordStatusNext AS ChangeRecordStatusNext,
  User_Status.ChangeRecordStatusAction AS ChangeRecordStatusAction,
  User_Status.ChangeRecordStatusActionText AS ChangeRecordStatusActionText
FROM I_ChangeRecordNextStatus AS User_Status
;

Learn More