R_ChgRecdRefMatTP
Change Record Object Ref Material
R_ChgRecdRefMatTP is a Transactional CDS View that provides data about "Change Record Object Ref Material" in SAP S/4HANA. It reads from 1 data source (R_ChangeRecordItem) and exposes 41 fields with key field ChangeRecordReferenceUUID. It has 7 associations to related views. Part of development package VDM_PLMB_CR_RAP.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_ChangeRecordItem | items | from |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_ChangeRecordProduct_2 | _RefMaterial_2 | items.ChangeRecordReferenceUUID = _RefMaterial_2.ChangeRecordReferenceUUID and items.ChangeRecordUUID = _RefMaterial_2.ChangeRecordUUID |
| [0..1] | I_ProductText | _Text | $projection.Product = _Text.Product and _Text.Language = $session.system_language |
| [0..1] | I_ProductTypeVH | _MaterialType | $projection.MaterialType = _MaterialType.ProductType |
| [0..1] | I_UnitOfMeasure | _UnitOfMeasureValueHelp | $projection.MaterialBaseUnit = _UnitOfMeasureValueHelp.UnitOfMeasure |
| [0..1] | I_MRPMaterialStatusCodeText | _RefMaterialStatusText | $projection.CrossPlantStatus = _RefMaterialStatusText.MRPMaterialStatus and _RefMaterialStatusText.Language = $session.system_language |
| [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 | |
| EndUserText.label | Change Record Object Ref Material | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| Search.searchable | true | view | |
| VDM.viewType | #TRANSACTIONAL | view |
Fields (41)
| 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 | ||
| ChgRecRefInternalKey1 | R_ChangeRecordItem | ChgRecRefInternalKey1 | ||
| 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 | ||
| ChgRecdItmTgtSts | R_ChangeRecordItem | ChgRecdItmTgtSts | ||
| ChgRecdItmDSgntr | R_ChangeRecordItem | ChgRecdItmDSgntr | ||
| ChgRecdReasonForChange | R_ChangeRecordItem | ChgRecdReasonForChange | ||
| ExpdCompltnDte | R_ChangeRecordItem | ExpdCompltnDte | ||
| ChgRecdAuthznGrpText | R_ChangeRecordItem | ChgRecdAuthznGrpText | ||
| ChgRecdNmbrChgSts | R_ChangeRecordItem | ChgRecdNmbrChgSts | ||
| Material | _RefMaterial_2 | Product | ||
| Product | _RefMaterial_2 | Product | ||
| ProductName | _RefMaterial_2 | ProductName | ||
| MaterialType | _RefMaterial_2 | MaterialType | ||
| MaterialBaseUnit | _RefMaterial_2 | BaseUnit | ||
| CrossPlantStatus | _RefMaterial_2 | CrossPlantStatus | ||
| ChangeRecordType | _ChangeRecordTP | ChangeRecordType | ||
| Partner | _ChangeRecordTP | Partner | ||
| _ChangeRecordContactPerson | _ChangeRecordTP | _ChangeRecordContactPerson | ||
| ChangeRecordLifecycleStatus | _ChangeRecordTP | ChangeRecordLifecycleStatus | ||
| _RefMaterial_2 | _RefMaterial_2 | |||
| _ChangeRecordItemRelText | _ChangeRecordItemRelText | |||
| _ChangeRecordItemProcgText | _ChangeRecordItemProcgText | |||
| _RefMaterialStatusText | _RefMaterialStatusText | |||
| _ChangeRecordTP | _ChangeRecordTP | |||
| _Text | _Text | |||
| _MaterialType | _MaterialType | |||
| _UnitOfMeasureValueHelp | _UnitOfMeasureValueHelp |
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Change Record Object Ref Material'
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #L,
dataClass: #MIXED
}
@Search.searchable: true
@VDM.viewType:#TRANSACTIONAL
define view entity R_ChgRecdRefMatTP
as select from R_ChangeRecordItem as items
association [0..1] to I_ChangeRecordProduct_2 as _RefMaterial_2 on items.ChangeRecordReferenceUUID = _RefMaterial_2.ChangeRecordReferenceUUID
and items.ChangeRecordUUID = _RefMaterial_2.ChangeRecordUUID
association [0..1] to I_ProductText as _Text on $projection.Product = _Text.Product
and _Text.Language = $session.system_language
association [0..1] to I_ProductTypeVH as _MaterialType on $projection.MaterialType = _MaterialType.ProductType
association [0..1] to I_UnitOfMeasure as _UnitOfMeasureValueHelp on $projection.MaterialBaseUnit = _UnitOfMeasureValueHelp.UnitOfMeasure
association [0..1] to I_MRPMaterialStatusCodeText as _RefMaterialStatusText on $projection.CrossPlantStatus = _RefMaterialStatusText.MRPMaterialStatus
and _RefMaterialStatusText.Language = $session.system_language
// association [1..1] to I_ChgRecordItemRelevanceText 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,
items.ChgRecRefInternalKey1,
items.ParentChangeRecordRefUUID,
@Semantics.booleanIndicator: true
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,
@Semantics.booleanIndicator: true
items.ChangeRecordVirtualRefInd,
items.ChangeRecordItemRelevance,
items.ChangeRecordItemProcgStatus as ChangeRecordItemProcgStatus,
items.ChgRecdNextItemProcgStatus as ChgRecdNextItemProcgStatus,
items.ChgRecdItmTgtSts,
items.ChgRecdItmDSgntr,
items.ChgRecdReasonForChange,
items.ExpdCompltnDte,
items.ChgRecdAuthznGrpText,
items.ChgRecdNmbrChgSts,
@Search.defaultSearchElement: true
_RefMaterial_2.Product as Material,
_RefMaterial_2.Product as Product,
_RefMaterial_2.ProductName as ProductName,
_RefMaterial_2.MaterialType as MaterialType,
_RefMaterial_2.BaseUnit as MaterialBaseUnit,
_RefMaterial_2.CrossPlantStatus as CrossPlantStatus,
_ChangeRecordTP.ChangeRecordType,
_ChangeRecordTP.Partner,
_ChangeRecordTP._ChangeRecordContactPerson,
_ChangeRecordTP.ChangeRecordLifecycleStatus,
/* Associations */
_RefMaterial_2,
_ChangeRecordItemRelText,
_ChangeRecordItemProcgText,
_RefMaterialStatusText,
_ChangeRecordTP,
_Text,
_MaterialType,
_UnitOfMeasureValueHelp
}
where
items.ChangeRecordReferenceType = 'MAT'
or items.ChangeRecordItemType = 'Product'
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