I_CHANGEMSTROBMGREDOCINFORECD
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ChgMstrObMgReDocInfoRecdTP | view_entity | from | TRANSACTIONAL | Change Number Object Management Record DIR (Transactional) |
Fields (1)
| Key | Field | CDS Fields | Used 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'