I_CHANGEMSTROBJECTMGMTRECORD

CDS View

Change Number Object Management Record

I_CHANGEMSTROBJECTMGMTRECORD is a CDS View in S/4HANA. Change Number Object Management Record. It contains 1 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_Revisionlevellist view from CONSUMPTION List of Revision Levels
I_ChangeMstrObjectMgmtRecordTP view_entity from TRANSACTIONAL Change Number Object Management Record (Transactional Proc.)
I_ChangeMstrObMgReDocInfoRecd view from COMPOSITE Change Number ObMaRe of Doc Info Record
I_ChangeMstrObMgReMaterial view from COMPOSITE Change Number ObMaRe of Material
I_ChangeMstrObMgReMatlBOM view from COMPOSITE Change Number ObMaRe of Material BOM
I_ProductByChangeMasterVH view from COMPOSITE List of Revision Levels

Fields (1)

KeyField CDS FieldsUsed in Views
ChgNmbrAlternativeDateCounter ChgNmbrAlternativeDateCounter 1
@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":""
}
}*/