I_ChangeMasterFunction

DDL: I_CHANGEMASTERFUNCTION SQL: IECNFUNCTION Type: view BASIC
2 Fields 1 Data Sources 1 Associations

Change Number Function

I_ChangeMasterFunction (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_ChangeMasterFunction is a Basic CDS View that provides data about "Change Number Function" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field ChangeNumberFunction. It has 1 association to related views.

SAP Help Documentation

CategoryChange Number
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business question: Which are the possible functions that can be assigned to change numbers?

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 This view is built on the following object type: Change master Main CDS parameters and filters The main filter is: Change number function ( ChangeNumberFunction )

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>This CDS view provides the prerequisites for answering the following business question:</p> <ul> <li><p>Which are the possible functions that can be assigned to change numbers?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ChangeMasterFunctionText _Text $projection.ChangeNumberFunction = _Text.ChangeNumberFunction

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IECNFUNCTION 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 ChangeNumberFunction 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 Function view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumberFunction Change number function
_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_ChangeMasterFunction.
-- 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: IECNFUNCTION

CREATE VIEW I_ChangeMasterFunction AS
SELECT
  cast ( substring( domvalue_l, 1, 1 ) as cc_aefun ) AS ChangeNumberFunction
FROM dd07l
LEFT OUTER JOIN I_ChangeMasterFunctionText AS _Text ON ChangeNumberFunction = _Text.ChangeNumberFunction  -- association [0..*]
;

Learn More