A_ChangeMstrObMgReMaterial

DDL: A_CHANGEMSTROBMGREMATERIAL Type: view_entity CONSUMPTION

Change Number Object Management Records - Material

A_ChangeMstrObMgReMaterial is a Consumption CDS View that provides data about "Change Number Object Management Records - Material" in SAP S/4HANA. It reads from 1 data source (I_ChangeMstrObMgReMaterialTP) and exposes 19 fields with key fields ChangeNumber, Material. It has 1 association to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeMstrObMgReMaterialTP I_ChangeMstrObMgReMaterialTP from

Associations (1)

CardinalityTargetAliasCondition
[0..1] A_ChangeMasterAltDate_1 _ChangeMasterAltDate $projection.ChangeNumber = _ChangeMasterAltDate.ChangeNumber and $projection.ChgNmbrAlternativeDateCounter = _ChangeMasterAltDate.ChgNmbrAlternativeDateCounter

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Change Number Object Management Records - Material view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumber ChangeNumber
KEY Material Material
ChgNmbrAlternativeDateID ChgNmbrAlternativeDateID
SAPObjectTechnicalID SAPObjectTechnicalID
ObjMgmtRecdDescription ObjMgmtRecdDescription
ObjMgmtRecdItemUUID ObjMgmtRecdItemUUID
ObjMgmtRecdLastChangedAt ObjMgmtRecdLastChangedAt
ObjMgmtRecdLastChangedBy ObjMgmtRecdLastChangedBy
ObjMgmtRecdCreationDate ObjMgmtRecdCreationDate
ObjMgmtRecdCreatedBy ObjMgmtRecdCreatedBy
ObjMgmtRecdObjLastChangedAt ObjMgmtRecdObjLastChangedAt
ObjMgmtRecdObjLastChangedBy ObjMgmtRecdObjLastChangedBy
ObjMgmtRecdObjIsLockedForChg ObjMgmtRecdObjIsLockedForChg
ObjMgmtRecdObjIsPlanned ObjMgmtRecdObjIsPlanned
ObjMgmtRecdObjRevisionLevel ObjMgmtRecdObjRevisionLevel
ChgNmbrAlternativeDateCounter ChgNmbrAlternativeDateCounter
ChangeNumberLastChgdDateTime ChangeNumberLastChgdDateTime
_ChangeMaster _ChangeMaster
_ChangeMasterAltDate _ChangeMasterAltDate 
@AccessControl.authorizationCheck: #CHECK

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MASTER

@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Change Number Object Management Records - Material'
define view entity A_ChangeMstrObMgReMaterial
  as select from I_ChangeMstrObMgReMaterialTP
  association        to parent A_ChangeMaster_1 as _ChangeMaster        on  $projection.ChangeNumber = _ChangeMaster.ChangeNumber
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to A_ChangeMasterAltDate_1 as _ChangeMasterAltDate on  $projection.ChangeNumber                  = _ChangeMasterAltDate.ChangeNumber
                                                                        and $projection.ChgNmbrAlternativeDateCounter = _ChangeMasterAltDate.ChgNmbrAlternativeDateCounter
{
  key ChangeNumber,
  key Material,

      ChgNmbrAlternativeDateID,
      SAPObjectTechnicalID,

      ObjMgmtRecdDescription,

      ObjMgmtRecdItemUUID,
      ObjMgmtRecdLastChangedAt,
      ObjMgmtRecdLastChangedBy,
      ObjMgmtRecdCreationDate,
      ObjMgmtRecdCreatedBy,
      ObjMgmtRecdObjLastChangedAt,
      ObjMgmtRecdObjLastChangedBy,

      ObjMgmtRecdObjIsLockedForChg,

      ObjMgmtRecdObjIsPlanned,
      ObjMgmtRecdObjRevisionLevel,

      @Consumption.hidden: true
      ChgNmbrAlternativeDateCounter,

      // for ETag handling

      ChangeNumberLastChgdDateTime,

      /* Associations */
      _ChangeMaster,
      _ChangeMasterAltDate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEMSTROBMGREMATERIALTP"
],
"ASSOCIATED":
[
"A_CHANGEMASTERALTDATE_1",
"A_CHANGEMASTER_1"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More