I_ChangeMasterReleaseKey

DDL: I_CHANGEMASTERRELEASEKEY SQL: IECNRELKEY Type: view BASIC

Change Number Release Key

I_ChangeMasterReleaseKey (Basic)

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

R&D Engineering

I_ChangeMasterReleaseKey is a Basic CDS View that provides data about "Change Number Release Key" in SAP S/4HANA. It reads from 1 data source (tcc10) and exposes 9 fields with key field ChangeNumberReleaseKey. It has 1 association to related views.

SAP Help Documentation

CategoryChange Number
StatusReleased
Purpose
These CDS views provide the prerequisites for answering the following business question: Is a change released globally within my company, or only for a specific operative area (for example costing, planning, or production)?

Prerequisites
Users who want to run reports using this CDS view must have display rights to the authorization object C_AENR_ERW .

Structure
Object types These views are built on the following object type: Change master Main CDS parameters and filters The main filters are: Release key for change master record ( ChangeNumberReleaseKey ) Release key description ( ChangeNumberReleaseKeyText ) Global release indicator ( IsGloballyReleased ) Language key ( Language )

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentPLM-WUI-OBJ-ECN
CapabilitiesAssociation Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition
Description <p>These CDS views provide the prerequisites for answering the following business question:</p> <ul> <li><p>Is a change released globally within my company, or only for a specific operative area (for example costing, planning, or production)?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tcc10 tcc10 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ChangeMasterReleaseKeyText _Text $projection.ChangeNumberReleaseKey = _Text.ChangeNumberReleaseKey

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IECNRELKEY 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 ChangeNumberReleaseKey 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 Release Key view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumberReleaseKey rlkey Release Key for Change Master Record
IsGloballyReleased rlglb ECM: global release indicator
IsReleasedForCosting aefrk Release for costing
IsReleasedForPlanning aefrp Release for planning
IsReleasedForProduction aefrf Release for production
IsReleasedForSimulation aefrs Release for simulation
IsDateShiftCreatedOCMPresel ocmdv Date shift creates preselection for OCM
IsReleaseKeyCreatedOCMPresel ocmfs Release key creates preselection for OCM
_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_ChangeMasterReleaseKey.
-- 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: IECNRELKEY

CREATE VIEW I_ChangeMasterReleaseKey AS
SELECT
  rlkey AS ChangeNumberReleaseKey,
  rlglb AS IsGloballyReleased,
  aefrk AS IsReleasedForCosting,
  aefrp AS IsReleasedForPlanning,
  aefrf AS IsReleasedForProduction,
  aefrs AS IsReleasedForSimulation,
  ocmdv AS IsDateShiftCreatedOCMPresel,
  ocmfs AS IsReleaseKeyCreatedOCMPresel
FROM tcc10
LEFT OUTER JOIN I_ChangeMasterReleaseKeyText AS _Text ON ChangeNumberReleaseKey = _Text.ChangeNumberReleaseKey  -- association [0..*]
;