R_ChgRecdRefDocTP
Change Record Object Ref Doc - TP
R_ChgRecdRefDocTP is a Transactional CDS View that provides data about "Change Record Object Ref Doc - TP" in SAP S/4HANA. It reads from 2 data sources (I_ChangeRecordDocument_2, R_ChangeRecordItem) and exposes 37 fields with key field ChangeRecordReferenceUUID. It has 4 associations to related views. Part of development package VDM_PLMB_CR_RAP.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_ChangeRecordDocument_2 | _Document | inner |
| R_ChangeRecordItem | items | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_DocumentInfoRecordDesc | _DocDesc | ( _DocDesc.DocumentInfoRecordDocType = items.ChgRecRefInternalKey1 and _DocDesc.DocumentInfoRecordDocNumber = items.ChgRecRefInternalKey2 and _DocDesc.DocumentInfoRecordDocVersion = items.ChgRecRefInternalKey3 and _DocDesc.DocumentInfoRecordDocPart = items.ChgRecRefInternalKey4 and _DocDesc.Language = $session.system_language ) or ( _DocDesc.DocumentInfoRecordDocType = _Document.DocumentInfoRecordDocType and _DocDesc.DocumentInfoRecordDocNumber = _Document.DocumentInfoRecordDocNumber and _DocDesc.DocumentInfoRecordDocVersion = _Document.DocumentInfoRecordDocVersion and _DocDesc.DocumentInfoRecordDocPart = _Document.DocumentInfoRecordDocPart and _DocDesc.Language = $session.system_language ) |
| [0..1] | I_ChangeRecordDocStatus | _DocumentStatus | items.ChgRecRefInternalKey1 = _DocumentStatus.DocumentType and items.ChgRecRefInternalKey2 = _DocumentStatus.DocumentInfoRecord and items.ChgRecRefInternalKey3 = _DocumentStatus.DocumentVersion and items.ChgRecRefInternalKey4 = _DocumentStatus.DocumentPart |
| [0..1] | I_ChangeRecordItemRelevance_3 | _ChangeRecordItemRelText | $projection.changerecordtype = _ChangeRecordItemRelText.ChangeRecordType and $projection.ChangeRecordItemType = _ChangeRecordItemRelText.ChangeRecordItemType and $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelText.ChangeRecordItemRelevance |
| [1..1] | I_ChgRecdItemProcgStatusText | _ChangeRecordItemProcgText | $projection.ChgRecdNextItemProcgStatus = _ChangeRecordItemProcgText.ChangeRecordItemProcgStatus and _ChangeRecordItemProcgText.Language = $session.system_language |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| EndUserText.label | Change Record Object Ref Doc - TP | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| Search.searchable | true | view | |
| VDM.viewType | #TRANSACTIONAL | view |
Fields (37)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ChangeRecordReferenceUUID | R_ChangeRecordItem | ChangeRecordReferenceUUID | |
| ChangeRecordUUID | R_ChangeRecordItem | ChangeRecordUUID | ||
| ChangeRecordReferenceType | R_ChangeRecordItem | ChangeRecordReferenceType | ||
| ChangeRecordItemType | R_ChangeRecordItem | ChangeRecordItemType | ||
| ChangeRecordReferenceSubtype | R_ChangeRecordItem | ChangeRecordReferenceSubtype | ||
| DocumentType | I_ChangeRecordDocument_2 | DocumentInfoRecordDocType | ||
| DocumentInfoRecord | I_ChangeRecordDocument_2 | DocumentInfoRecordDocNumber | ||
| DocumentVersion | I_ChangeRecordDocument_2 | DocumentInfoRecordDocVersion | ||
| DocumentPart | I_ChangeRecordDocument_2 | DocumentInfoRecordDocPart | ||
| InternalDocumentStatus | _DocumentStatus | InternalDocumentStatus | ||
| ExternalDocumentStatus | ||||
| DocumentStatusName | ||||
| ChgRecRefInternalKey1 | R_ChangeRecordItem | ChgRecRefInternalKey1 | ||
| ChgRecRefInternalKey2 | R_ChangeRecordItem | ChgRecRefInternalKey2 | ||
| ChgRecRefInternalKey3 | R_ChangeRecordItem | ChgRecRefInternalKey3 | ||
| ChgRecRefInternalKey4 | R_ChangeRecordItem | ChgRecRefInternalKey4 | ||
| ParentChangeRecordRefUUID | R_ChangeRecordItem | ParentChangeRecordRefUUID | ||
| IsMainReference | R_ChangeRecordItem | IsMainReference | ||
| ChangeRecordReference | R_ChangeRecordItem | ChangeRecordReference | ||
| CreatedByUser | R_ChangeRecordItem | CreatedByUser | ||
| CreationDateTime | R_ChangeRecordItem | CreationDateTime | ||
| LastChangedByUser | R_ChangeRecordItem | LastChangedByUser | ||
| LastChangeDateTime | R_ChangeRecordItem | LastChangeDateTime | ||
| ChangeRecordVirtualRefInd | R_ChangeRecordItem | ChangeRecordVirtualRefInd | ||
| ChangeRecordItemRelevance | R_ChangeRecordItem | ChangeRecordItemRelevance | ||
| ChangeRecordItemProcgStatus | R_ChangeRecordItem | ChangeRecordItemProcgStatus | ||
| ChgRecdNextItemProcgStatus | R_ChangeRecordItem | ChgRecdNextItemProcgStatus | ||
| ChgRecdNmbrChgSts | R_ChangeRecordItem | ChgRecdNmbrChgSts | ||
| ChangeRecordType | _ChangeRecordTP | ChangeRecordType | ||
| Partner | _ChangeRecordTP | Partner | ||
| _ChangeRecordContactPerson | _ChangeRecordTP | _ChangeRecordContactPerson | ||
| ChangeRecordLifecycleStatus | _ChangeRecordTP | ChangeRecordLifecycleStatus | ||
| _DocDesc | _DocDesc | |||
| _DocumentStatus | _DocumentStatus | |||
| _ChangeRecordItemProcgText | _ChangeRecordItemProcgText | |||
| _ChangeRecordItemRelText | _ChangeRecordItemRelText | |||
| _ChangeRecordTP | _ChangeRecordTP |
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Change Record Object Ref Doc - TP'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType: {
serviceQuality: #C,
sizeCategory: #M,
dataClass: #MIXED
}
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
define view entity R_ChgRecdRefDocTP
as select from R_ChangeRecordItem as items
inner join I_ChangeRecordDocument_2 as _Document on items.ChangeRecordReferenceUUID = _Document.ChangeRecordReferenceUUID
and items.ChangeRecordUUID = _Document.ChangeRecordUUID
association [0..1] to I_DocumentInfoRecordDesc as _DocDesc on (
_DocDesc.DocumentInfoRecordDocType = items.ChgRecRefInternalKey1
and _DocDesc.DocumentInfoRecordDocNumber = items.ChgRecRefInternalKey2
and _DocDesc.DocumentInfoRecordDocVersion = items.ChgRecRefInternalKey3
and _DocDesc.DocumentInfoRecordDocPart = items.ChgRecRefInternalKey4
and _DocDesc.Language = $session.system_language
)
// items.ChgRecRefInternalKey1 = _DocDesc.DocumentInfoRecordDocType
// and items.ChgRecRefInternalKey2 = _DocDesc.DocumentInfoRecordDocNumber
// and items.ChgRecRefInternalKey3 = _DocDesc.DocumentInfoRecordDocVersion
// and items.ChgRecRefInternalKey4 = _DocDesc.DocumentInfoRecordDocPart
//)
or (
_DocDesc.DocumentInfoRecordDocType = _Document.DocumentInfoRecordDocType
and _DocDesc.DocumentInfoRecordDocNumber = _Document.DocumentInfoRecordDocNumber
and _DocDesc.DocumentInfoRecordDocVersion = _Document.DocumentInfoRecordDocVersion
and _DocDesc.DocumentInfoRecordDocPart = _Document.DocumentInfoRecordDocPart //or (
and _DocDesc.Language = $session.system_language
) // _Document.DocumentInfoRecordDocType = _DocDesc.DocumentInfoRecordDocType
// and _Document.DocumentInfoRecordDocNumber = _DocDesc.DocumentInfoRecordDocNumber
// and _Document.DocumentInfoRecordDocVersion = _DocDesc.DocumentInfoRecordDocVersion
// and _Document.DocumentInfoRecordDocPart = _DocDesc.DocumentInfoRecordDocPart
// )
//
association [0..1] to I_ChangeRecordDocStatus as _DocumentStatus on items.ChgRecRefInternalKey1 = _DocumentStatus.DocumentType
and items.ChgRecRefInternalKey2 = _DocumentStatus.DocumentInfoRecord
and items.ChgRecRefInternalKey3 = _DocumentStatus.DocumentVersion
and items.ChgRecRefInternalKey4 = _DocumentStatus.DocumentPart
// association [1..1] to I_ChgRecordItemRelevanceText_2 as _ChangeRecordItemRelText on $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelText.ChangeRecordItemRelevance
// and _ChangeRecordItemRelText.Language = $session.system_language
association [0..1] to I_ChangeRecordItemRelevance_3 as _ChangeRecordItemRelText on $projection.changerecordtype = _ChangeRecordItemRelText.ChangeRecordType
and $projection.ChangeRecordItemType = _ChangeRecordItemRelText.ChangeRecordItemType
and $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelText.ChangeRecordItemRelevance
association [1..1] to I_ChgRecdItemProcgStatusText as _ChangeRecordItemProcgText on $projection.ChgRecdNextItemProcgStatus = _ChangeRecordItemProcgText.ChangeRecordItemProcgStatus
and _ChangeRecordItemProcgText.Language = $session.system_language
association to parent R_ChangeRecordTP as _ChangeRecordTP on $projection.ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID
{
key items.ChangeRecordReferenceUUID,
items.ChangeRecordUUID,
items.ChangeRecordReferenceType,
items.ChangeRecordItemType,
items.ChangeRecordReferenceSubtype,
@Search.defaultSearchElement: true
_Document.DocumentInfoRecordDocType as DocumentType,
_Document.DocumentInfoRecordDocNumber as DocumentInfoRecord,
_Document.DocumentInfoRecordDocVersion as DocumentVersion,
_Document.DocumentInfoRecordDocPart as DocumentPart,
_DocumentStatus.InternalDocumentStatus,
_DocumentStatus._DocStatus._Text[1:Language = $session.system_language].ExternalDocumentStatus,
_DocumentStatus._DocStatus._Text[1:Language = $session.system_language].DocumentStatusName,
items.ChgRecRefInternalKey1,
items.ChgRecRefInternalKey2,
items.ChgRecRefInternalKey3,
items.ChgRecRefInternalKey4,
items.ParentChangeRecordRefUUID,
items.IsMainReference,
items.ChangeRecordReference,
@Semantics.user.createdBy: true
items.CreatedByUser,
@Semantics.systemDateTime.createdAt: true
items.CreationDateTime,
@Semantics.user.localInstanceLastChangedBy: true
items.LastChangedByUser,
@Semantics.systemDateTime.localInstanceLastChangedAt: true
items.LastChangeDateTime,
items.ChangeRecordVirtualRefInd,
items.ChangeRecordItemRelevance,
items.ChangeRecordItemProcgStatus,
items.ChgRecdNextItemProcgStatus,
items.ChgRecdNmbrChgSts,
_ChangeRecordTP.ChangeRecordType,
_ChangeRecordTP.Partner,
_ChangeRecordTP._ChangeRecordContactPerson,
_ChangeRecordTP.ChangeRecordLifecycleStatus,
/* Associations */
_DocDesc,
_DocumentStatus,
_ChangeRecordItemProcgText,
_ChangeRecordItemRelText,
_ChangeRecordTP
}
where
items.ChangeRecordReferenceType = 'DOC'
or items.ChangeRecordItemType = 'DocumentInfoRecord'
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA