A_ChangeMaster_1

DDL: A_CHANGEMASTER_1 Type: view_entity CONSUMPTION

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)

SourceAliasJoin Type
I_ChangeMasterTP I_ChangeMasterTP from

Associations (12)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/