C_ChangeRecordDetPg
Change Record Details
C_ChangeRecordDetPg is a Consumption CDS View that provides data about "Change Record Details" in SAP S/4HANA. It reads from 1 data source (C_ChangeRecordObjPg) and exposes 108 fields with key field ChangeRecordUUID. Part of development package VDM_PLMB_CR.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| C_ChangeRecordObjPg | C_ChangeRecordObjPg | from |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Change Record Details | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Metadata.allowExtensions | true | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| UI.headerInfo.typeName | Change Record | view | |
| UI.headerInfo.typeNamePlural | Change Records | view | |
| UI.headerInfo.title.value | ChgRecordDescriptionText | view | |
| UI.headerInfo.description.value | ChangeRecord | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.sizeCategory | #XL | view |
Fields (108)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ChangeRecordUUID | ChangeRecordUUID | ||
| ChangeRecord | ChangeRecord | |||
| ParentChangeRecordUUID | ParentChangeRecordUUID | |||
| RootChangeRecordUUID | RootChangeRecordUUID | |||
| ParentChangeRecord | ParentChangeRecord | |||
| ParentChgRecordDescriptionText | ParentChgRecordDescriptionText | |||
| ChangeNumber | ChangeNumber | |||
| ChangeRecordType | ChangeRecordType | |||
| ChangeRecordStatus | ChangeRecordStatus | |||
| Partner | Partner | |||
| CreatedByUser | CreatedByUser | |||
| LastChangedByUser | LastChangedByUser | |||
| CreationDateTime | CreationDateTime | |||
| LastChangeDateTime | LastChangeDateTime | |||
| ChangeRecordLifecycleStatus | ChangeRecordLifecycleStatus | |||
| ChgRecdExpectedCompletionDate | ChgRecdExpectedCompletionDate | |||
| ChangeRecordDetailDescription | ChangeRecordDetailDescription | |||
| ChgRecordDescriptionText | ChgRecordDescriptionText | |||
| CreatedByUserFullName | CreatedByUserFullName | |||
| LastChangedByUserFullName | LastChangedByUserFullName | |||
| ChangeRecordLifecycleStatusTxt | ChangeRecordLifecycleStatusTxt | |||
| ChangeRecordStatusDescription | ChangeRecordStatusDescription | |||
| _ChangeRecordContactPerson | _ChangeRecordContactPerson | |||
| PersonFullName | ||||
| ChangeNumberDescription | ||||
| ChangeRecordTypeDesc | ||||
| _LogAccMObjectTypeActive | _LogAccMObjectTypeActive | |||
| _LogAccMObjectUserAuthzn | _LogAccMObjectUserAuthzn | |||
| _LogAccMObjSecureIDAssgmt | _LogAccMObjSecureIDAssgmt | |||
| AuthorizationGroup | ||||
| IsBusinessPurposeCompleted | ||||
| _LifeCycleStatusText | _LifeCycleStatusText | |||
| _ChgRecdFuncLocTskListTP | _ChgRecdFuncLocTskListTP | |||
| _ChgRecdRefCutPlngPrflTP | _ChgRecdRefCutPlngPrflTP | |||
| _ChgRecdRateRtgTskListTP | _ChgRecdRateRtgTskListTP | |||
| _ChgRecdRefFuncLocBOMTP | _ChgRecdRefFuncLocBOMTP | |||
| _ChgRecdCmntTopTP | _ChgRecdCmntTopTP | |||
| _ChgRecdObjRefCmntTopTP | _ChgRecdObjRefCmntTopTP | |||
| _ChangeRecordReferenceMatTP | _ChangeRecordReferenceMatTP | |||
| _ChangeRecordReferenceBOMTP | _ChangeRecordReferenceBOMTP | |||
| _ChgRecdRefOpSetTskListTP | _ChgRecdRefOpSetTskListTP | |||
| _ChgRecdRefRateRtgTskListTP | _ChgRecdRefRateRtgTskListTP | |||
| _ChangeRecordRefBOMItmTP | _ChangeRecordRefBOMItmTP | |||
| _ChgRecdRefVarBOMTP | _ChgRecdRefVarBOMTP | |||
| _ChgRecdRefEngBOMTP | _ChgRecdRefEngBOMTP | |||
| _ChgRecdRefMfgBOMTP | _ChgRecdRefMfgBOMTP | |||
| _ChgRecdRefPurOrdTP | _ChgRecdRefPurOrdTP | |||
| _ChgRecdRefProdnOrdTP | _ChgRecdRefProdnOrdTP | |||
| _ChgRecdRefPlngScpTP | _ChgRecdRefPlngScpTP | |||
| _ChgRecdRefRoutingTP | _ChgRecdRefRoutingTP | |||
| _ChangeRecordReferenceDocTP | _ChangeRecordReferenceDocTP | |||
| _ChangeRecordReferenceSpecTP | _ChangeRecordReferenceSpecTP | |||
| _ChgRecdRefMasterRecipeTP | _ChgRecdRefMasterRecipeTP | |||
| _ChgRecdRefInspectionPlanTP | _ChgRecdRefInspectionPlanTP | |||
| _ChgRecdRefRecipeTP | _ChgRecdRefRecipeTP | |||
| _ChgRecdRefProdnRoutingTP | _ChgRecdRefProdnRoutingTP | |||
| _ChgRecdRefLabelTP | _ChgRecdRefLabelTP | |||
| _ChgRecdRefPlngRoutingTP | _ChgRecdRefPlngRoutingTP | |||
| _ChgRecdRefTmplRoutingTP | _ChgRecdRefTmplRoutingTP | |||
| _ChgRecdRefMaintTskListTP | _ChgRecdRefMaintTskListTP | |||
| _ChangeMaster | _ChangeMaster | |||
| _IssActyMgmtUserStatus | _IssActyMgmtUserStatus | |||
| _ChangeRecordStatusProgress | _ChangeRecordStatusProgress | |||
| _ChangeRecordItemCount | _ChangeRecordItemCount | |||
| _ChangeRecordImpNavigation | _ChangeRecordImpNavigation | |||
| _ChangeRecordObjPgClfn | _ChangeRecordObjPgClfn | |||
| _ChangeRecordRefOrderBOMTP | _ChangeRecordRefOrderBOMTP | |||
| _ChangeRecordRefCharcTP | _ChangeRecordRefCharcTP | |||
| _ChangeRecordRefClassTP | _ChangeRecordRefClassTP | |||
| _ChangeRecordRefStdBOMTP | _ChangeRecordRefStdBOMTP | |||
| _ChgRecdRefEquipTskListTP | _ChgRecdRefEquipTskListTP | |||
| _ChangeRecordRefWBSElmntBOMTP | _ChangeRecordRefWBSElmntBOMTP | |||
| _ChgRecdRefEquipBOMTP | _ChgRecdRefEquipBOMTP | |||
| _ChgRecdChildTP | _ChgRecdChildTP | |||
| ChgRecdRefObjDocVisible | ChgRecdRefObjDocVisible | |||
| ChgRecdRefObjMatlVisible | ChgRecdRefObjMatlVisible | |||
| ChgRecdRefObjBOMVisible | ChgRecdRefObjBOMVisible | |||
| ChgRecdRefObjBOMItemVisible | ChgRecdRefObjBOMItemVisible | |||
| ChgRecdRefObjEngBOMVisible | ChgRecdRefObjEngBOMVisible | |||
| ChgRecdRefObjMfgBOMVisible | ChgRecdRefObjMfgBOMVisible | |||
| ChgRecdRefObjRoutingVisible | ChgRecdRefObjRoutingVisible | |||
| ChgRecdRefObjProdnRtgVisible | ChgRecdRefObjProdnRtgVisible | |||
| ChgRecdRefObjPlngScpVisible | ChgRecdRefObjPlngScpVisible | |||
| ChgRecdRefObjProdnOrderVisible | ChgRecdRefObjProdnOrderVisible | |||
| ChgRecdRefObjPurOrderVisible | ChgRecdRefObjPurOrderVisible | |||
| ChgRecdRefObjSpecVisible | ChgRecdRefObjSpecVisible | |||
| ChgRecdRefObjMstrRcpVisible | ChgRecdRefObjMstrRcpVisible | |||
| ChgRecdRefObjInspPlanVisible | ChgRecdRefObjInspPlanVisible | |||
| ChgRecdRefObjRecipeVisible | ChgRecdRefObjRecipeVisible | |||
| ChgRecdRefObjLabelVisible | ChgRecdRefObjLabelVisible | |||
| ChgRecdRefObjPlngRtgVisible | ChgRecdRefObjPlngRtgVisible | |||
| ChgRecdRefObjTmplRtgVisible | ChgRecdRefObjTmplRtgVisible | |||
| ChgRecdRefObjOrderBOMVisible | ChgRecdRefObjOrderBOMVisible | |||
| ChgRecdRefObjClassVisible | ChgRecdRefObjClassVisible | |||
| ChgRecdRefObjCharcVisible | ChgRecdRefObjCharcVisible | |||
| ChgRecdObjMaintTskListVisible | ChgRecdObjMaintTskListVisible | |||
| ChgRecdObjEquipTskListVisible | ChgRecdObjEquipTskListVisible | |||
| ChgRecdObjWBSElmntBOMVisible | ChgRecdObjWBSElmntBOMVisible | |||
| ChgRecdObjEquipBOMVisible | ChgRecdObjEquipBOMVisible | |||
| ChgRecdObjFuncLocBOMVisible | ChgRecdObjFuncLocBOMVisible | |||
| ChgRecdRefRateRtgVisible | ChgRecdRefRateRtgVisible | |||
| ChgRecdRateRtgVisible | ChgRecdRateRtgVisible | |||
| ChgRecdRefCutPlngPrflVisible | ChgRecdRefCutPlngPrflVisible | |||
| ChgRecdRefOpSetVisible | ChgRecdRefOpSetVisible | |||
| ChgRecdFuncLocTskListVisible | ChgRecdFuncLocTskListVisible | |||
| ChgRecdObjVarBOMVisible | ChgRecdObjVarBOMVisible | |||
| ChangeRecordIsMerge | ChangeRecordIsMerge | |||
| ChangeRecordIsSplit | ChangeRecordIsSplit |
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Change Record Details'
@VDM.viewType: #CONSUMPTION
@Metadata.allowExtensions: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations: true
@UI.headerInfo:{
typeName: 'Change Record',
typeNamePlural: 'Change Records',
title: { value: 'ChgRecordDescriptionText' },
description: {value: 'ChangeRecord'}
}
@ObjectModel.usageType: {serviceQuality: #C,
dataClass: #MIXED,
sizeCategory: #XL}
define view entity C_ChangeRecordDetPg
as select from C_ChangeRecordObjPg
{
@UI.facet: [
{id:'CUSTOMFIELD', type: #FIELDGROUP_REFERENCE, position:10, purpose:#FILTER, targetQualifier:'ChangeRecord', label: 'Change Record'}
]
@UI.hidden: true
key ChangeRecordUUID,
@ObjectModel.text.element: [ 'ChgRecordDescriptionText']
@Consumption.semanticObject: 'ChangeRecord'
ChangeRecord,
@UI.hidden: true
ParentChangeRecordUUID,
@UI.hidden: true
RootChangeRecordUUID,
@ObjectModel.text.element: ['ParentChgRecordDescriptionText']
ParentChangeRecord,
ParentChgRecordDescriptionText,
@ObjectModel.text.element: [ 'ChangeNumberDescription']
@Consumption.semanticObject: 'ChangeMaster'
ChangeNumber,
@ObjectModel.text.element: [ 'ChangeRecordTypeDesc']
ChangeRecordType,
@ObjectModel.text.element: [ 'ChangeRecordStatusDescription']
ChangeRecordStatus,
@ObjectModel.text.element: [ 'PersonFullName']
Partner,
@ObjectModel.text.element: [ 'CreatedByUserFullName']
CreatedByUser,
@ObjectModel.text.element: [ 'LastChangedByUserFullName']
LastChangedByUser,
CreationDateTime,
LastChangeDateTime,
@ObjectModel.text.element: [ 'ChangeRecordLifecycleStatusTxt']
ChangeRecordLifecycleStatus,
ChgRecdExpectedCompletionDate,
ChangeRecordDetailDescription,
ChgRecordDescriptionText,
CreatedByUserFullName,
LastChangedByUserFullName,
ChangeRecordLifecycleStatusTxt,
ChangeRecordStatusDescription,
_ChangeRecordContactPerson,
C_ChangeRecordObjPg._ChangeRecordContactPerson.PersonFullName as PersonFullName,
C_ChangeRecordObjPg._ChangeMaster.ChangeNumberDescription as ChangeNumberDescription,
C_ChangeRecordObjPg._ChangeRecordTypeVH.ChangeRecordTypeDesc as ChangeRecordTypeDesc,
_LogAccMObjectTypeActive,
_LogAccMObjectUserAuthzn,
_LogAccMObjSecureIDAssgmt,
C_ChangeRecordObjPg._ChangeRecordContactPerson.AuthorizationGroup,
@Semantics.booleanIndicator: true
C_ChangeRecordObjPg._ChangeRecordContactPerson.IsBusinessPurposeCompleted,
_LifeCycleStatusText,
_ChgRecdFuncLocTskListTP,
_ChgRecdRefCutPlngPrflTP,
_ChgRecdRateRtgTskListTP,
_ChgRecdRefFuncLocBOMTP,
_ChgRecdCmntTopTP,
_ChgRecdObjRefCmntTopTP,
_ChangeRecordReferenceMatTP,
_ChangeRecordReferenceBOMTP,
_ChgRecdRefOpSetTskListTP,
_ChgRecdRefRateRtgTskListTP,
_ChangeRecordRefBOMItmTP,
_ChgRecdRefVarBOMTP,
_ChgRecdRefEngBOMTP,
_ChgRecdRefMfgBOMTP,
_ChgRecdRefPurOrdTP,
_ChgRecdRefProdnOrdTP,
_ChgRecdRefPlngScpTP,
_ChgRecdRefRoutingTP,
// _ChgRecdRefOrdSpcfcRoutingTP,
_ChangeRecordReferenceDocTP,
// _ChgRecdRefProdStrucVarTP,
_ChangeRecordReferenceSpecTP,
// _ChgRecdRefEngSnpshtTP,
_ChgRecdRefMasterRecipeTP,
_ChgRecdRefInspectionPlanTP,
_ChgRecdRefRecipeTP,
_ChgRecdRefProdnRoutingTP,
_ChgRecdRefLabelTP,
_ChgRecdRefPlngRoutingTP,
_ChgRecdRefTmplRoutingTP,
_ChgRecdRefMaintTskListTP,
_ChangeMaster,
// _ChgRecdRefObjVibDoc,
//
// _ChgRecdRefObjVibMat,
//
// _ChgRecdRefObjVibBOM,
//
// _ChgRecdRefObjVibBIT,
//
// _ChgRecdRefObjVibEBM,
// _ChgRecdRefObjVibMBM,
// _ChgRecdRefObjVibPLS,
// _ChgRecdRefObjVibROU,
// _ChgRecdRefObjVibOSR,
// _ChgRecdRefObjVibPRO,
// _ChgRecdRefObjVibPUR,
// _ChgRecdRefObjVibPSV,
// _ChgRecdRefObjVibSpec,
// _ChgRecdRefObjVibEngSnpsht,
// _ChgRecdRefObjVibMRC,
// _ChgRecdRefObjVibINP,
// _ChgRecdRefObjVibRCP,
// _ChgRecdRefObjVibLBL,
// _ChgRecdRefObjVibPRG,
// _ChgRecdRefObjVibPlngRouting,
// _ChgRecdRefObjVibTmplRouting,
// _ChgRecdRefObjVibOBM,
// _ChgRecdRefObjVibCLS,
// _ChgRecdRefObjVibCHR,
// _ChgRecdObjVibMaintTskList,
// _ChgRecdRefObjVisibilityStdBOM,
// _ChgRecdRefObjVibEquipTskList,
// _ChgRecdRefObjVisibilityWBSBOM,
// _ChgRecdRefObjVisibilityEquBOM,
_IssActyMgmtUserStatus,
_ChangeRecordStatusProgress,
_ChangeRecordItemCount,
_ChangeRecordImpNavigation,
_ChangeRecordObjPgClfn,
_ChangeRecordRefOrderBOMTP,
_ChangeRecordRefCharcTP,
_ChangeRecordRefClassTP,
_ChangeRecordRefStdBOMTP,
_ChgRecdRefEquipTskListTP,
_ChangeRecordRefWBSElmntBOMTP,
_ChgRecdRefEquipBOMTP,
_ChgRecdChildTP,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjDocVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjMatlVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjBOMVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjBOMItemVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjEngBOMVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjMfgBOMVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjRoutingVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjProdnRtgVisible,
// @UI.hidden: true
// @ObjectModel.readOnly: true
// ChgRecdOrdSpcfcRtgRefIsVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjPlngScpVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjProdnOrderVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
// left( cast( ChgRecdRefObjPurOrderVisible as abap.char(11) ), 8 ) as ChgRecdRefObjPurOrderVisible,
ChgRecdRefObjPurOrderVisible,
// @UI.hidden: true
// @ObjectModel.readOnly: true
// // cast ( left( cast( ChgRecdRefProdStrucVarVisible as abap.char(11) ), 8 ) as /plmb/ppe_counter ) as ChgRecdRefProdStrucVarVisible,
// ChgRecdRefProdStrucVarVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
// cast ( left( cast( ChgRecdRefObjSpecVisible as abap.char(11) ), 3 ) as /iam/int_number ) as ChgRecdRefObjSpecVisible,
ChgRecdRefObjSpecVisible,
// @UI.hidden: true
// @ObjectModel.readOnly: true
// cast ( left( cast( ChgRecdRefObjEngSnpshtVisible as abap.char(11) ), 3 ) as /iam/int_number ) as ChgRecdRefObjEngSnpshtVisible,
// ChgRecdRefObjEngSnpshtVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
// cast ( left( cast( ChgRecdRefObjMstrRcpVisible as abap.char(11) ), 3 ) as /iam/int_number ) as ChgRecdRefObjMstrRcpVisible,
ChgRecdRefObjMstrRcpVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
// cast ( left( cast( ChgRecdRefObjInspPlanVisible as abap.char(11) ), 3 ) as /iam/int_number ) as ChgRecdRefObjInspPlanVisible,
ChgRecdRefObjInspPlanVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
// cast ( left( cast( ChgRecdRefObjRecipeVisible as abap.char(11) ), 3 ) as /iam/int_number ) as ChgRecdRefObjRecipeVisible,
ChgRecdRefObjRecipeVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjLabelVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjPlngRtgVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjTmplRtgVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjOrderBOMVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjClassVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefObjCharcVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdObjMaintTskListVisible,
// @UI.hidden: true
// @ObjectModel.readOnly: true
// ChgRecdObjStdBOMVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdObjEquipTskListVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdObjWBSElmntBOMVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdObjEquipBOMVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdObjFuncLocBOMVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefRateRtgVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRateRtgVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefCutPlngPrflVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdRefOpSetVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdFuncLocTskListVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChgRecdObjVarBOMVisible,
@UI.hidden: true
@ObjectModel.readOnly: true
ChangeRecordIsMerge,
@UI.hidden: true
@ObjectModel.readOnly: true
@Consumption.filter.hidden: true
ChangeRecordIsSplit
// _ChangeRecordRefEquipBOMTP
}
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