A_ChangeMaster_1
Change Number
A_ChangeMaster_1 is a Consumption CDS View that provides data about "Change Number" in SAP S/4HANA. It reads from 1 data source (I_ChangeMasterTP) and exposes 28 fields with key field ChangeNumber. It has 12 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ChangeMasterTP | I_ChangeMasterTP | from |
Associations (12)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | A_ChangeMasterClass | _Classification | $projection.ChangeNumber = _Classification.ChangeNumber |
| [0..*] | A_ChangeMasterCharc | _Characteristics | $projection.ChangeNumber = _Characteristics.ChangeNumber |
| [0..1] | A_ChangeMasterStatus | _ChangeNumberStatus | $projection.ChangeNumberStatus = _ChangeNumberStatus.ChangeNumberStatus |
| [0..1] | A_LogAccMObjectTypeActive | _LogAccMObjectTypeActive | _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_ECN' |
| [0..*] | A_LogAccMObjSecureIDAssgmt | _LogAccMObjSecureIDAssgmt | $projection.ChangeNumber = _LogAccMObjSecureIDAssgmt.LogAccMObjectID and _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_ECN' |
| [0..*] | A_LogAccMObjectUserAuthzn | _LogAccMObjectUserAuthzn | $projection.ChangeNumber = _LogAccMObjectUserAuthzn.LogAccMObjectID and _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_ECN' and _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_ECN' and ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03' or _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*' ) and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' and ( _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user or _LogAccMObjectUserAuthzn.UserID = $session.user ) |
| [1..*] | A_ChangeMasterAltDate_1 | _AlternativeDate | |
| [1..*] | A_ChangeMasterObjTypeAssgmt_1 | _ObjTypeAssignment | |
| [1..*] | A_ChangeMstrObjectMgmtRecord | _ChangeMstrObjectMgmtRecord | |
| [1..*] | A_ChangeMstrObMgReMaterial | _ChangeMstrObMgReMaterial | |
| [1..*] | A_ChangeMstrObMgReMatlBOM | _ChangeMstrObMgReMatlBOM | |
| [1..*] | A_ChangeMstrObMgReDocInfoRecd | _ChangeMstrObMgReDocInfoRecd | |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| OData.entitySet.name | A_ChangeMaster | view | |
| VDM.viewType | #CONSUMPTION | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| EndUserText.label | Change Number | view |
Fields (28)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ChangeNumber | ChangeNumber | ||
| ChangeNumberStatus | ChangeNumberStatus | |||
| AuthorizationGroup | AuthorizationGroup | |||
| ChangeNumberFunction | ChangeNumberFunction | |||
| IsTechnicallyReleased | IsTechnicallyReleased | |||
| ChangeNumberReleaseKey | ChangeNumberReleaseKey | |||
| ReasonForChangeText | ReasonForChangeText | |||
| ChangeNumberDescription | ChangeNumberDescription | |||
| ChangeNumberValidFromDate | ChangeNumberValidFromDate | |||
| ChangeNumberCreationDate | ChangeNumberCreationDate | |||
| ChangeNumberCreatedByUser | ChangeNumberCreatedByUser | |||
| ChangeNumberLastChangedDate | ChangeNumberLastChangedDate | |||
| ChangeNumberLastChangedByUser | ChangeNumberLastChangedByUser | |||
| IsUsedForDataDefinition | IsUsedForDataDefinition | |||
| ChangeNumberIsMrkdForDeletion | ChangeNumberIsMrkdForDeletion | |||
| ChangeNumberLastChgdDateTime | ChangeNumberLastChgdDateTime | |||
| _ChangeNumberStatus | _ChangeNumberStatus | |||
| _AlternativeDate | _AlternativeDate | |||
| _ObjTypeAssignment | _ObjTypeAssignment | |||
| _ChangeMstrObjectMgmtRecord | _ChangeMstrObjectMgmtRecord | |||
| _ChangeMstrObMgReMaterial | _ChangeMstrObMgReMaterial | |||
| _ChangeMstrObMgReMatlBOM | _ChangeMstrObMgReMatlBOM | |||
| _ChangeMstrObMgReDocInfoRecd | _ChangeMstrObMgReDocInfoRecd | |||
| _Classification | _Classification | |||
| _Characteristics | _Characteristics | |||
| _LogAccMObjectTypeActive | _LogAccMObjectTypeActive | |||
| _LogAccMObjectUserAuthzn | _LogAccMObjectUserAuthzn | |||
| _LogAccMObjSecureIDAssgmt | _LogAccMObjSecureIDAssgmt |
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER
// set entity set name in OData for service backward compatibility
@OData.entitySet.name : 'A_ChangeMaster'
@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Change Number'
define root view entity A_ChangeMaster_1
as select from I_ChangeMasterTP
composition [1..*] of A_ChangeMasterAltDate_1 as _AlternativeDate
composition [1..*] of A_ChangeMasterObjTypeAssgmt_1 as _ObjTypeAssignment
composition [1..*] of A_ChangeMstrObjectMgmtRecord as _ChangeMstrObjectMgmtRecord
composition [1..*] of A_ChangeMstrObMgReMaterial as _ChangeMstrObMgReMaterial
composition [1..*] of A_ChangeMstrObMgReMatlBOM as _ChangeMstrObMgReMatlBOM
composition [1..*] of A_ChangeMstrObMgReDocInfoRecd as _ChangeMstrObMgReDocInfoRecd
association [0..*] to A_ChangeMasterClass as _Classification on $projection.ChangeNumber = _Classification.ChangeNumber
association [0..*] to A_ChangeMasterCharc as _Characteristics on $projection.ChangeNumber = _Characteristics.ChangeNumber
association [0..1] to A_ChangeMasterStatus as _ChangeNumberStatus on $projection.ChangeNumberStatus = _ChangeNumberStatus.ChangeNumberStatus
// Access Control Management integration
association [0..1] to A_LogAccMObjectTypeActive as _LogAccMObjectTypeActive on _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_ECN'
association [0..*] to A_LogAccMObjSecureIDAssgmt as _LogAccMObjSecureIDAssgmt on $projection.ChangeNumber = _LogAccMObjSecureIDAssgmt.LogAccMObjectID
and _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_ECN'
association [0..*] to A_LogAccMObjectUserAuthzn as _LogAccMObjectUserAuthzn on $projection.ChangeNumber = _LogAccMObjectUserAuthzn.LogAccMObjectID
and _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_ECN'
and _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_ECN'
and (
_LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03'
or _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*'
)
and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT'
and (
_LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user
or _LogAccMObjectUserAuthzn.UserID = $session.user
)
{
key ChangeNumber,
ChangeNumberStatus,
AuthorizationGroup,
ChangeNumberFunction,
IsTechnicallyReleased,
ChangeNumberReleaseKey,
ReasonForChangeText,
ChangeNumberDescription,
ChangeNumberValidFromDate,
ChangeNumberCreationDate,
ChangeNumberCreatedByUser,
ChangeNumberLastChangedDate,
ChangeNumberLastChangedByUser,
IsUsedForDataDefinition,
ChangeNumberIsMrkdForDeletion,
ChangeNumberLastChgdDateTime,
_ChangeNumberStatus,
_AlternativeDate,
_ObjTypeAssignment,
_ChangeMstrObjectMgmtRecord,
_ChangeMstrObMgReMaterial,
_ChangeMstrObMgReMatlBOM,
_ChangeMstrObMgReDocInfoRecd,
_Classification,
_Characteristics,
// Access Control Management
_LogAccMObjectTypeActive,
_LogAccMObjectUserAuthzn,
_LogAccMObjSecureIDAssgmt
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEMASTERTP"
],
"ASSOCIATED":
[
"A_CHANGEMASTERALTDATE_1",
"A_CHANGEMASTERCHARC",
"A_CHANGEMASTERCLASS",
"A_CHANGEMASTEROBJTYPEASSGMT_1",
"A_CHANGEMASTERSTATUS",
"A_CHANGEMSTROBJECTMGMTRECORD",
"A_CHANGEMSTROBMGREDOCINFORECD",
"A_CHANGEMSTROBMGREMATERIAL",
"A_CHANGEMSTROBMGREMATLBOM",
"A_LOGACCMOBJECTTYPEACTIVE",
"A_LOGACCMOBJECTUSERAUTHZN",
"A_LOGACCMOBJSECUREIDASSGMT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA