I_ChangeMasterStatus

DDL: I_CHANGEMASTERSTATUS SQL: IECNSTATUS Type: view BASIC
5 Fields 1 Data Sources 1 Associations

Change Number Status

I_ChangeMasterStatus (Basic)

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

ChangeMasterStatus · R&D Engineering

I_ChangeMasterStatus is a Basic CDS View (Dimension) that provides data about "Change Number Status" in SAP S/4HANA. It reads from 1 data source (t419s) and exposes 5 fields with key field ChangeNumberStatus. It has 1 association to related views.

SAP Help Documentation

CategoryChange Number
StatusStatus
Purpose
This CDS view retrieves change master status data. A change master status is a coded representation of the status of an engineering change master. It is used in engineering change management and controls if changes can be made to a change master and its linked objects. These CDS views provide the prerequisites for answering the following business questions: Which change masters are active in my system? Which change masters can be used to make changes to business objects?

Prerequisites
Users who want to run reports using this CDS view must have display rights for the following authorization object: C_AENR_ERW (CC Eng. Chg. Mgmt. Enhanced Authorization Check)

Structure
Object types These views are built on the following object type: Change master The main filters are: Change number status ( ChangeNumberStatus ) Change number status description ( ChangeNumberStatusText ) Status allows changes ( ChangeIsAllowed ) Language key ( Language ) Important Fields Important fields in this view include the following: Field Name Description Comment ChangeNumberStatus Status The following are values SAP ships: 01 : Active 02 : Inactive 03 : Active with history requirement

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 BusinessR&D Engineering
Application ComponentPLM-WUI-OBJ-ECN
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Data Extraction, Analytical Dimension
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view retrieves change master status data. A change master status is a coded representation of the status of an engineering change master. It is used in engineering change management and controls if changes can be made to a change master and its linked objects. These CDS views provide the prerequisites for answering the following business questions:</p> <ul> <li><p>Which change masters are active in my system?</p></li> <li><p>Which change masters can be used to make changes to business objects?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
t419s t419s from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ChangeMasterStatusText _Text $projection.ChangeNumberStatus = _Text.ChangeNumberStatus

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName IECNSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey ChangeNumberStatus view
Analytics.dataExtraction.enabled true view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Change Number Status view
ObjectModel.sapObjectNodeType.name ChangeMasterStatus view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumberStatus Status of Change Number
ChangeIsAllowed Status allows changes
DateChangeIsAllowed Valid-from date can be changed
DistributionIsLocked Indicator: Distribution lock
_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_ChangeMasterStatus.
-- 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: IECNSTATUS

CREATE VIEW I_ChangeMasterStatus AS
SELECT
  cast ( aenst as /plmb/ecn_status ) AS ChangeNumberStatus,
  cast ( aeflg as /plmb/cc_aeflg ) AS ChangeIsAllowed,
  cast ( dtflg as /plmb/cc_dtflg ) AS DateChangeIsAllowed,
  cast ( dlock as /plmb/cc_dlock ) AS DistributionIsLocked
FROM t419s
LEFT OUTER JOIN I_ChangeMasterStatusText AS _Text ON ChangeNumberStatus = _Text.ChangeNumberStatus  -- association [0..*]
;

Learn More