I_ChangeMstrObMgReMaterialTP

DDL: I_CHANGEMSTROBMGREMATERIALTP Type: view_entity TRANSACTIONAL Package: VDM_PLMB_ECN

Change Number Object Management Record Material (Trans.)

I_ChangeMstrObMgReMaterialTP is a Transactional CDS View that provides data about "Change Number Object Management Record Material (Trans.)" in SAP S/4HANA. It reads from 1 data source (I_ChangeMstrObMgReMaterial) and exposes 19 fields with key fields ChangeNumber, Material. It has 1 association to related views. Part of development package VDM_PLMB_ECN.

Data Sources (1)

SourceAliasJoin Type
I_ChangeMstrObMgReMaterial I_ChangeMstrObMgReMaterial from

Associations (1)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Change Number Object Management Record Material (Trans.) view

Fields (19)

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

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

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@EndUserText.label: 'Change Number Object Management Record Material (Trans.)'
define view entity I_ChangeMstrObMgReMaterialTP
  as select from I_ChangeMstrObMgReMaterial
  association        to parent I_ChangeMasterTP as _ChangeMaster        on  $projection.ChangeNumber = _ChangeMaster.ChangeNumber

  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to I_ChangeMasterAltDateTP as _ChangeMasterAltDate on  $projection.ChangeNumber                  = _ChangeMasterAltDate.ChangeNumber
                                                                        and $projection.ChgNmbrAlternativeDateCounter = _ChangeMasterAltDate.ChgNmbrAlternativeDateCounter

{
  key ChangeNumber,
  key Material,

      _ChangeMasterAltDate.ChgNmbrAlternativeDateID,

      ObjMgmtRecdObjectInternalID as SAPObjectTechnicalID,

      ObjMgmtRecdDescription,

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

      ObjMgmtRecdObjIsLockedForChg,
      ObjMgmtRecdObjIsPlanned,
      ObjMgmtRecdObjRevisionLevel,

      @Consumption.hidden: true
      I_ChangeMstrObMgReMaterial.ChgNmbrAlternativeDateCounter,

      // for ETag handling

      _ChangeMaster.ChangeNumberLastChgdDateTime,

      /* Associations */
      _ChangeMaster,
      _ChangeMasterAltDate
}