R_ChgRecdRefBOMTP
Change Record Object Ref BOM
R_ChgRecdRefBOMTP is a Transactional CDS View that provides data about "Change Record Object Ref BOM" in SAP S/4HANA. It reads from 2 data sources (I_ChangeRecordBillOfMaterial_2, R_ChangeRecordItem) and exposes 43 fields with key field ChangeRecordReferenceUUID. It has 5 associations to related views. Part of development package VDM_PLMB_CR_RAP.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_ChangeRecordBillOfMaterial_2 | BOM | inner |
| R_ChangeRecordItem | items | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_PlantStdVH | _Plant | BOM.Plant = _Plant.Plant |
| [0..1] | I_BillOfMaterialUsage | _BillOfMaterialVariantUsage | $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage |
| [0..1] | I_ProductText | _Text | $projection.Material = _Text.Product and _Text.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 | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| EndUserText.label | Change Record Object Ref BOM | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | 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 (43)
| 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 | ||
| 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 | ||
| 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 | I_ChangeRecordBillOfMaterial_2 | Material | ||
| Plant | I_ChangeRecordBillOfMaterial_2 | Plant | ||
| PlantName | _Plant | PlantName | ||
| BillOfMaterialVariantUsage | I_ChangeRecordBillOfMaterial_2 | BillOfMaterialVariantUsage | ||
| BillOfMaterialVariant | I_ChangeRecordBillOfMaterial_2 | BillOfMaterialVariant | ||
| BillOfMaterial | ||||
| BillOfMaterialCategory | I_ChangeRecordBillOfMaterial_2 | BillOfMaterialCategory | ||
| ChangeRecordType | _ChangeRecordTP | ChangeRecordType | ||
| Partner | _ChangeRecordTP | Partner | ||
| _ChangeRecordContactPerson | _ChangeRecordTP | _ChangeRecordContactPerson | ||
| ChangeRecordLifecycleStatus | _ChangeRecordTP | ChangeRecordLifecycleStatus | ||
| _Text | _Text | |||
| _ChangeRecordItemProcgText | _ChangeRecordItemProcgText | |||
| _ChangeRecordItemRelText | _ChangeRecordItemRelText | |||
| _Plant | _Plant | |||
| _BillOfMaterialVariantUsage | _BillOfMaterialVariantUsage | |||
| _ChangeRecordTP | _ChangeRecordTP |
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Change Record Object Ref BOM'
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #L,
dataClass: #MIXED
}
@Search.searchable: true
@VDM.viewType:#TRANSACTIONAL
define view entity R_ChgRecdRefBOMTP
as select from R_ChangeRecordItem as items
inner join I_ChangeRecordBillOfMaterial_2 as BOM on items.ChangeRecordReferenceUUID = BOM.ChangeRecordReferenceUUID
association [0..1] to I_PlantStdVH as _Plant on BOM.Plant = _Plant.Plant
association [0..1] to I_BillOfMaterialUsage as _BillOfMaterialVariantUsage on $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage
association [0..1] to I_ProductText as _Text on $projection.Material = _Text.Product
and _Text.Language = $session.system_language
// 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,
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 as ChangeRecordItemProcgStatus,
items.ChgRecdNextItemProcgStatus as ChgRecdNextItemProcgStatus,
items.ChgRecdItmTgtSts,
items.ChgRecdItmDSgntr,
items.ChgRecdReasonForChange,
items.ExpdCompltnDte,
items.ChgRecdAuthznGrpText,
items.ChgRecdNmbrChgSts,
@Search.defaultSearchElement: true
BOM.Material,
BOM.Plant,
_Plant.PlantName,
BOM.BillOfMaterialVariantUsage,
BOM.BillOfMaterialVariant,
cast(BOM.BillOfMaterial as cs_stlnr preserving type ) as BillOfMaterial,
BOM.BillOfMaterialCategory,
_ChangeRecordTP.ChangeRecordType,
_ChangeRecordTP.Partner,
_ChangeRecordTP._ChangeRecordContactPerson,
_ChangeRecordTP.ChangeRecordLifecycleStatus,
/* Associations */
_Text,
_ChangeRecordItemProcgText,
_ChangeRecordItemRelText,
_Plant,
_BillOfMaterialVariantUsage,
_ChangeRecordTP
}
where
items.ChangeRecordReferenceType = 'BOM'
or items.ChangeRecordItemType = 'BillOfMaterial'
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