I_ChangeMstrObjectMgmtRecordTP

DDL: I_CHANGEMSTROBJECTMGMTRECORDTP Type: view_entity TRANSACTIONAL Package: VDM_PLMB_ECN

Change Number Object Management Record (Transactional Proc.)

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

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeMstrObjectMgmtRecord I_ChangeMstrObjectMgmtRecord 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 (Transactional Proc.) view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumber ChangeNumber
KEY SAPObjectTechnicalID ObjMgmtRecdObjectInternalID
SAPObjectReadableID
ObjMgmtRecdObject ObjMgmtRecdObject
ChgNmbrAlternativeDateID _ChangeMasterAltDate ChgNmbrAlternativeDateID
ObjMgmtRecdDescription ObjMgmtRecdDescription
ObjMgmtRecdItemUUID ObjMgmtRecdItemUUID
ObjMgmtRecdLastChangedAt ObjMgmtRecdLastChangedAt
ObjMgmtRecdLastChangedBy ObjMgmtRecdLastChangedBy
ObjMgmtRecdCreationDate ObjMgmtRecdCreationDate
ObjMgmtRecdCreatedBy ObjMgmtRecdCreatedBy
ObjMgmtRecdObjLastChangedAt ObjMgmtRecdObjLastChangedAt
ObjMgmtRecdObjLastChangedBy ObjMgmtRecdObjLastChangedBy
ObjMgmtRecdObjIsLockedForChg ObjMgmtRecdObjIsLockedForChg
ObjMgmtRecdObjIsBaselined ObjMgmtRecdObjIsBaselined
ObjMgmtRecdObjIsPlanned ObjMgmtRecdObjIsPlanned
ObjMgmtRecdObjRevisionLevel ObjMgmtRecdObjRevisionLevel
ChangeNumberObjectType ChangeNumberObjectType
ChgNmbrAlternativeDateCounter I_ChangeMstrObjectMgmtRecord 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 (Transactional Proc.)'
define view entity I_ChangeMstrObjectMgmtRecordTP
  as select from I_ChangeMstrObjectMgmtRecord

  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  cast(
       case ChangeNumberObjectType
          when '02' then 'MaterialBOM'
          when '31' then 'DocumentInfoRecord'
          when '41' then 'Material'
       end as sbo_bo_type )        as SAPObjectType,

  key  ObjMgmtRecdObjectInternalID as SAPObjectTechnicalID,

       cast('' as char90)          as SAPObjectReadableID,

       @Consumption.hidden: true
       ObjMgmtRecdObject,

       _ChangeMasterAltDate.ChgNmbrAlternativeDateID,

       ObjMgmtRecdDescription,

       ObjMgmtRecdItemUUID,

       ObjMgmtRecdLastChangedAt,

       ObjMgmtRecdLastChangedBy,

       ObjMgmtRecdCreationDate,

       ObjMgmtRecdCreatedBy,

       ObjMgmtRecdObjLastChangedAt,

       ObjMgmtRecdObjLastChangedBy,


       ObjMgmtRecdObjIsLockedForChg,

       ObjMgmtRecdObjIsBaselined,

       ObjMgmtRecdObjIsPlanned,

       ObjMgmtRecdObjRevisionLevel,

       @Consumption.hidden: true
       ChangeNumberObjectType,

       @Consumption.hidden: true
       I_ChangeMstrObjectMgmtRecord.ChgNmbrAlternativeDateCounter,

       // for ETag handling

       _ChangeMaster.ChangeNumberLastChgdDateTime,

       _ChangeMaster,
       _ChangeMasterAltDate
}
// restrict for supported object types

where
     ChangeNumberObjectType = '41'
  or ChangeNumberObjectType = '31'
  or ChangeNumberObjectType = '02'

Learn More