I_CHANGEMSTROBMGREDOCINFORECD

CDS View

Change Number ObMaRe of Doc Info Record

I_CHANGEMSTROBMGREDOCINFORECD is a CDS View in S/4HANA. Change Number ObMaRe of Doc Info Record. It contains 1 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChgMstrObMgReDocInfoRecdTP view_entity from TRANSACTIONAL Change Number Object Management Record DIR (Transactional)

Fields (1)

KeyField CDS FieldsUsed in Views
ChgNmbrAlternativeDateCounter ChgNmbrAlternativeDateCounter 1
@AccessControl.authorizationCheck: #CHECK

@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: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API

@EndUserText.label: 'Change Number ObMaRe of Doc Info Record'
define view entity I_ChangeMstrObMgReDocInfoRecd
  as select from I_ChangeMstrObjectMgmtRecord
  association [0..1] to I_DocumentInfoRecord as _DocumentInfoRecord on  $projection.DocumentType       = _DocumentInfoRecord.DocumentInfoRecordDocType
                                                                    and $projection.DocumentInfoRecord = _DocumentInfoRecord.DocumentInfoRecordDocNumber
                                                                    and $projection.DocumentPart       = _DocumentInfoRecord.DocumentInfoRecordDocPart
                                                                    and $projection.DocumentVersion    = _DocumentInfoRecord.DocumentInfoRecordDocVersion
{
  key ChangeNumber,
  key cast(substring(ObjMgmtRecdObject, 1, 3) as dokar)    as DocumentType,
  key cast(substring(ObjMgmtRecdObject, 4, 25) as doknr)   as DocumentInfoRecord,
  key cast(substring(ObjMgmtRecdObject, 29, 3) as doktl_d) as DocumentPart,
  key cast(substring(ObjMgmtRecdObject, 32, 2) as dokvr)   as DocumentVersion,

      ObjMgmtRecdObject,
      ObjMgmtRecdObjectInternalID,

      ChgNmbrAlternativeDateCounter,
      ObjMgmtRecdDescription,
      ObjMgmtRecdItemUUID,

      ObjMgmtRecdLastChangedAt,
      ObjMgmtRecdLastChangedBy,

      ObjMgmtRecdCreationDate,
      ObjMgmtRecdCreatedBy,
      ObjMgmtRecdObjLastChangedAt,
      ObjMgmtRecdObjLastChangedBy,

      ObjMgmtRecdObjIsLockedForChg,
      ObjMgmtRecdObjIsBaselined,
      ObjMgmtRecdChangeType,
      ObjMgmtRecdObjIsPlanned,
      ObjMgmtRecdObjRevisionLevel,

      /* Associations */
      _ChangeMaster,
      _ChangeMasterAltDate
      //      _DocumentInfoRecord

}
where
  ChangeNumberObjectType = '31'