I_ChangeMstrObjectMgmtRecord

DDL: I_CHANGEMSTROBJECTMGMTRECORD SQL: IECNOMR Type: view BASIC

Change Number Object Management Record

I_ChangeMstrObjectMgmtRecord is a Basic CDS View that provides data about "Change Number Object Management Record" in SAP S/4HANA. It reads from 1 data source (aeoi) and exposes 21 fields with key fields ChangeNumber, ChangeNumberObjectType, ObjMgmtRecdObjectInternalID. It has 3 associations to related views.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
aeoi aeoi from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ChangeMasterObjectType _ChangeMasterObjectType $projection.ChangeNumberObjectType = _ChangeMasterObjectType.ChangeNumberObjectType
[0..1] I_ChangeMaster _ChangeMaster $projection.ChangeNumber = _ChangeMaster.ChangeNumber
[0..1] I_ChangeMasterAltDate _ChangeMasterAltDate $projection.ChangeNumber = _ChangeMasterAltDate.ChangeNumber and $projection.ChgNmbrAlternativeDateCounter = _ChangeMasterAltDate.ChgNmbrAlternativeDateCounter

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IECNOMR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Change Number Object Management Record view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumber aennr
KEY ChangeNumberObjectType aetyp
KEY ObjMgmtRecdObjectInternalID objkt
ObjMgmtRecdObject usobj
ChgNmbrAlternativeDateCounter aedtz
ObjMgmtRecdDescription oitxt
ObjMgmtRecdItemUUID aeoi_guid
ObjMgmtRecdLastChangedAt aedat
ObjMgmtRecdLastChangedBy aenam
ObjMgmtRecdCreationDate andat
ObjMgmtRecdCreatedBy annam
ObjMgmtRecdObjLastChangedAt objdt
ObjMgmtRecdObjLastChangedBy objnm
ObjMgmtRecdObjIsLockedForChg cclck
ObjMgmtRecdObjIsBaselined aeost
ObjMgmtRecdChangeType ccoaa
ObjMgmtRecdObjIsPlanned ccvms
ObjMgmtRecdObjRevisionLevel
_ChangeMasterObjectType _ChangeMasterObjectType
_ChangeMasterAltDate _ChangeMasterAltDate
_ChangeMaster _ChangeMaster 
@AbapCatalog.sqlViewName: 'IECNOMR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET,
                                      #SQL_DATA_SOURCE ]

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

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#PUBLIC_LOCAL_API

@EndUserText.label: 'Change Number Object Management Record'
define view I_ChangeMstrObjectMgmtRecord
  as select from aeoi
  association [0..1] to I_ChangeMasterObjectType as _ChangeMasterObjectType on  $projection.ChangeNumberObjectType = _ChangeMasterObjectType.ChangeNumberObjectType
  association [0..1] to I_ChangeMaster           as _ChangeMaster           on  $projection.ChangeNumber = _ChangeMaster.ChangeNumber
  association [0..1] to I_ChangeMasterAltDate    as _ChangeMasterAltDate    on  $projection.ChangeNumber                  = _ChangeMasterAltDate.ChangeNumber
                                                                            and $projection.ChgNmbrAlternativeDateCounter = _ChangeMasterAltDate.ChgNmbrAlternativeDateCounter

{
      @ObjectModel.text.element: 'ObjMgmtRecdDescription'
  key aennr                                       as ChangeNumber,
  key aetyp                                       as ChangeNumberObjectType,
  key objkt                                       as ObjMgmtRecdObjectInternalID,
      usobj                                       as ObjMgmtRecdObject,
      aedtz                                       as ChgNmbrAlternativeDateCounter,

      oitxt                                       as ObjMgmtRecdDescription,
      aeoi_guid                                   as ObjMgmtRecdItemUUID,

      aedat                                       as ObjMgmtRecdLastChangedAt,
      aenam                                       as ObjMgmtRecdLastChangedBy,
      andat                                       as ObjMgmtRecdCreationDate,
      annam                                       as ObjMgmtRecdCreatedBy,
      objdt                                       as ObjMgmtRecdObjLastChangedAt,
      objnm                                       as ObjMgmtRecdObjLastChangedBy,

      cclck                                       as ObjMgmtRecdObjIsLockedForChg,
      aeost                                       as ObjMgmtRecdObjIsBaselined,
      ccoaa                                       as ObjMgmtRecdChangeType,
      ccvms                                       as ObjMgmtRecdObjIsPlanned,
      //      revlv     as ObjMgmtRecdObjRevisionLevel,

      cast(revlv as cc_revlv_nex preserving type) as ObjMgmtRecdObjRevisionLevel,

      //ltxsp, // Long text original language

      //ccsto, // Partial key for status in engineering change management

      //cont1, // Digital signature status for ECR integration


      _ChangeMasterObjectType,
      _ChangeMasterAltDate,
      _ChangeMaster
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AEOI"
],
"ASSOCIATED":
[
"I_CHANGEMASTER",
"I_CHANGEMASTERALTDATE",
"I_CHANGEMASTEROBJECTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More