A_ChangeRecord
Change Record Header Data
A_ChangeRecord is a Composite CDS View that provides data about "Change Record Header Data" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordTP_2) and exposes 48 fields with key field ChangeRecordUUID. It has 34 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ChangeRecordTP_2 | I_ChangeRecordTP_2 | from |
Associations (34)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_ChangeRecordBsc | _HeaderExtension | $projection.ChangeRecordUUID = _HeaderExtension.ChangeRecordUUID |
| [0..1] | A_ChgRecdBusinessPartner | _ChangeRecordBusinessPartner | $projection.Partner = _ChangeRecordBusinessPartner.Partner |
| [0..1] | A_ChangeRecordLifeCycleStatus | _ChangeRecordLifeCycleStatus | $projection.ChangeRecordLifecycleStatus = _ChangeRecordLifeCycleStatus.ChangeRecordLifecycleStatus |
| [0..1] | A_ChgRecordUserStatus | _ChangeRecordUserStatus | $projection.ChangeRecordStatus = _ChangeRecordUserStatus.ChangeRecordStatus |
| [0..*] | A_ChangeRecordReferenceMat | _RefMat | |
| [0..*] | A_ChangeRecordReferenceBOM | _RefBOM | |
| [0..*] | A_ChangeRecordReferenceDoc | _RefDoc | |
| [0..*] | A_ChangeRecordReferenceBit | _RefBit | |
| [0..*] | A_ChangeRecordReferencePSV | _RefPSV | |
| [0..*] | A_ChangeRecordRefInspPlan | _ChangeRecordRefInspPlan | |
| [0..*] | A_ChangeRecordRefRecipe | _ChangeRecordRefRecipe | |
| [0..*] | A_ChangeRecordRefMasterRecipe | _ChangeRecordRefMasterRecipe | |
| [0..*] | A_ChangeRecordRefLabelSet | _ChangeRecordRefLabelSet | |
| [0..*] | A_ChangeRecordRefSpecification | _ChangeRecordRefSpecification | |
| [0..*] | A_ChangeRecordRefProdnRouting | _ChangeRecordRefProdnRouting | |
| [0..*] | A_ChangeRecordRefTmplRouting | _ChangeRecordRefTmplRouting | |
| [0..*] | A_ChangeRecordRefClass | _ChangeRecordRefClass | |
| [0..*] | A_ChangeRecordRefCharc | _ChangeRecordRefCharc | |
| [0..*] | A_ChgRecdRefEquipTskList | _ChangeRecordRefEquipTskList | |
| [0..*] | A_ChgRecdFuncLocTskList | _ChangeRecordFuncLocTskList | |
| [0..*] | A_ChgRecdRefOpSetTskList | _ChangeRecordRefOpSetTskList | |
| [0..*] | A_ChgRecdRateRtgTskList | _ChangeRecordRateRtgTskList | |
| [0..*] | A_ChgRecdRefRateRtgTskList | _ChgRecdRefRateRtgTskList | |
| [0..*] | A_ChgRecdRefCutPlngPrflTskList | _ChgRecdRefCutPlngPrflTskList | |
| [0..*] | A_ChgRecdWBSElmntBOM | _ChgRecdWBSElmntBOM | |
| [0..*] | A_ChgRecdEquipBOM | _ChgRecdEquipBOM | |
| [0..*] | A_ChgRecdFuncLocBOM | _ChgRecdFuncLocBOM | |
| [0..*] | A_ChgRecdObjPgMaintTskList | _ChgRecdRefMaintTskList | |
| [0..*] | A_ChgRecdRefStdBOM | _ChangeRecordRefStdBOM | |
| [0..*] | A_ChgRecdRefVarBOM | _ChangeRecordRefVarBOM | |
| [0..*] | A_ChgRecdRefEngBOM | _ChgRecdRefEngBOM | |
| [0..*] | A_ChgRecdRefPlngScope | _ChgRecdRefPlngScp | |
| [0..*] | A_ChgRecdRefMfgBOM | _ChgRecdRefMfgBOM | |
| [0..*] | A_ChgRecdPLMEPDCollabn | _ChgRecdCollaboration | |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| OData.entitySet.name | A_ChangeRecord | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| EndUserText.label | Change Record Header Data | view |
Fields (48)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ChangeRecordUUID | ChangeRecordUUID | ||
| ChangeRecord | ChangeRecord | |||
| ChangeRecordType | ChangeRecordType | |||
| ChangeRecordStatus | ChangeRecordStatus | |||
| ChangeRecordStatusDescription | ||||
| ChangeNumber | ChangeNumber | |||
| CreatedByUser | CreatedByUser | |||
| CreationDateTime | CreationDateTime | |||
| LastChangedByUser | LastChangedByUser | |||
| ChangeRecordLifecycleStatus | ChangeRecordLifecycleStatus | |||
| ChangeRecordLifecycleStatusTxt | _ChangeRecordLifeCycleStatus | ChangeRecordLifecycleStatusTxt | ||
| Partner | Partner | |||
| ChgRecordDescriptionText | ChgRecordDescriptionText | |||
| ChangeRecordDetailDescription | ChangeRecordDetailDescription | |||
| ChgRecdExpectedCompletionDate | ChgRecdExpectedCompletionDate | |||
| _RefMat | _RefMat | |||
| _RefBOM | _RefBOM | |||
| _RefDoc | _RefDoc | |||
| _RefBit | _RefBit | |||
| _RefPSV | _RefPSV | |||
| _ChangeRecordRefInspPlan | _ChangeRecordRefInspPlan | |||
| _ChangeRecordRefRecipe | _ChangeRecordRefRecipe | |||
| _ChangeRecordRefMasterRecipe | _ChangeRecordRefMasterRecipe | |||
| _ChangeRecordRefLabelSet | _ChangeRecordRefLabelSet | |||
| _ChangeRecordRefSpecification | _ChangeRecordRefSpecification | |||
| _ChangeRecordRefProdnRouting | _ChangeRecordRefProdnRouting | |||
| _ChangeRecordRefTmplRouting | _ChangeRecordRefTmplRouting | |||
| _ChangeRecordRefClass | _ChangeRecordRefClass | |||
| _ChangeRecordRefCharc | _ChangeRecordRefCharc | |||
| _ChangeRecordRefEquipTskList | _ChangeRecordRefEquipTskList | |||
| _ChangeRecordFuncLocTskList | _ChangeRecordFuncLocTskList | |||
| _ChangeRecordRefOpSetTskList | _ChangeRecordRefOpSetTskList | |||
| _ChangeRecordRateRtgTskList | _ChangeRecordRateRtgTskList | |||
| _ChgRecdRefRateRtgTskList | _ChgRecdRefRateRtgTskList | |||
| _ChgRecdRefCutPlngPrflTskList | _ChgRecdRefCutPlngPrflTskList | |||
| _ChgRecdWBSElmntBOM | _ChgRecdWBSElmntBOM | |||
| _ChgRecdEquipBOM | _ChgRecdEquipBOM | |||
| _ChgRecdFuncLocBOM | _ChgRecdFuncLocBOM | |||
| _ChgRecdRefMaintTskList | _ChgRecdRefMaintTskList | |||
| _ChangeRecordRefStdBOM | _ChangeRecordRefStdBOM | |||
| _ChangeRecordRefVarBOM | _ChangeRecordRefVarBOM | |||
| _ChangeRecordBusinessPartner | _ChangeRecordBusinessPartner | |||
| _ChgRecdRefEngBOM | _ChgRecdRefEngBOM | |||
| _ChgRecdRefPlngScp | _ChgRecdRefPlngScp | |||
| _ChgRecdRefMfgBOM | _ChgRecdRefMfgBOM | |||
| _ChgRecdCollaboration | _ChgRecdCollaboration | |||
| _ChangeRecordLifeCycleStatus | _ChangeRecordLifeCycleStatus | |||
| _ChangeRecordUserStatus | _ChangeRecordUserStatus |
@AccessControl.authorizationCheck: #CHECK
@OData.entitySet.name : 'A_ChangeRecord'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations: true
//@ObjectModel.transactionalProcessingDelegated: true
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
//@ObjectModel: {
// compositionRoot: true,
// // representativeKey: 'ChangeRecord',
//// createEnabled: true, // opened for test
// usageType: {
// dataClass: #TRANSACTIONAL,
// serviceQuality: #D,
// sizeCategory: #L
// }
//}
//@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
//@ObjectModel.updateEnabled: true
//@ObjectModel.deleteEnabled: true
//@ObjectModel.writeActiveImplementedBy: 'ABAP:ZCL_RAP_PLMI_CR'
@EndUserText.label: 'Change Record Header Data'
define root view entity A_ChangeRecord
as select from I_ChangeRecordTP_2
association [0..1] to E_ChangeRecordBsc as _HeaderExtension on $projection.ChangeRecordUUID = _HeaderExtension.ChangeRecordUUID
association [0..1] to A_ChgRecdBusinessPartner as _ChangeRecordBusinessPartner on $projection.Partner = _ChangeRecordBusinessPartner.Partner
association [0..1] to A_ChangeRecordLifeCycleStatus as _ChangeRecordLifeCycleStatus on $projection.ChangeRecordLifecycleStatus = _ChangeRecordLifeCycleStatus.ChangeRecordLifecycleStatus
association [0..1] to A_ChgRecordUserStatus as _ChangeRecordUserStatus on $projection.ChangeRecordStatus = _ChangeRecordUserStatus.ChangeRecordStatus
composition [0..*] of A_ChangeRecordReferenceMat as _RefMat
composition [0..*] of A_ChangeRecordReferenceBOM as _RefBOM
composition [0..*] of A_ChangeRecordReferenceDoc as _RefDoc
composition [0..*] of A_ChangeRecordReferenceBit as _RefBit
composition [0..*] of A_ChangeRecordReferencePSV as _RefPSV
composition [0..*] of A_ChangeRecordRefInspPlan as _ChangeRecordRefInspPlan
composition [0..*] of A_ChangeRecordRefRecipe as _ChangeRecordRefRecipe
composition [0..*] of A_ChangeRecordRefMasterRecipe as _ChangeRecordRefMasterRecipe
composition [0..*] of A_ChangeRecordRefLabelSet as _ChangeRecordRefLabelSet
composition [0..*] of A_ChangeRecordRefSpecification as _ChangeRecordRefSpecification
composition [0..*] of A_ChangeRecordRefProdnRouting as _ChangeRecordRefProdnRouting
composition [0..*] of A_ChangeRecordRefTmplRouting as _ChangeRecordRefTmplRouting
composition [0..*] of A_ChangeRecordRefClass as _ChangeRecordRefClass
composition [0..*] of A_ChangeRecordRefCharc as _ChangeRecordRefCharc
composition [0..*] of A_ChgRecdRefEquipTskList as _ChangeRecordRefEquipTskList
composition [0..*] of A_ChgRecdFuncLocTskList as _ChangeRecordFuncLocTskList
composition [0..*] of A_ChgRecdRefOpSetTskList as _ChangeRecordRefOpSetTskList
composition [0..*] of A_ChgRecdRateRtgTskList as _ChangeRecordRateRtgTskList
composition [0..*] of A_ChgRecdRefRateRtgTskList as _ChgRecdRefRateRtgTskList
composition [0..*] of A_ChgRecdRefCutPlngPrflTskList as _ChgRecdRefCutPlngPrflTskList
composition [0..*] of A_ChgRecdWBSElmntBOM as _ChgRecdWBSElmntBOM
composition [0..*] of A_ChgRecdEquipBOM as _ChgRecdEquipBOM
composition [0..*] of A_ChgRecdFuncLocBOM as _ChgRecdFuncLocBOM
composition [0..*] of A_ChgRecdObjPgMaintTskList as _ChgRecdRefMaintTskList
composition [0..*] of A_ChgRecdRefStdBOM as _ChangeRecordRefStdBOM
composition [0..*] of A_ChgRecdRefVarBOM as _ChangeRecordRefVarBOM
composition [0..*] of A_ChgRecdRefEngBOM as _ChgRecdRefEngBOM
composition [0..*] of A_ChgRecdRefPlngScope as _ChgRecdRefPlngScp
composition [0..*] of A_ChgRecdRefMfgBOM as _ChgRecdRefMfgBOM
composition [0..*] of A_ChgRecdPLMEPDCollabn as _ChgRecdCollaboration
{
key ChangeRecordUUID,
ChangeRecord,
ChangeRecordType,
ChangeRecordStatus,
I_ChangeRecordTP_2._ChangeRecordUserStatus._Text[1: Language = $session.system_language ].ChangeRecordStatusDescription as ChangeRecordStatusDescription,
ChangeNumber,
CreatedByUser,
CreationDateTime,
LastChangedByUser,
case
when LastChangeDateTime = fltp_to_dec( 0.00 as timestampl )
then fltp_to_dec( 19720401000000.00 as timestampl )
else LastChangeDateTime
end as LastChangeDateTime,
ChangeRecordLifecycleStatus,
_ChangeRecordLifeCycleStatus.ChangeRecordLifecycleStatusTxt as ChangeRecordLifecycleStatusTxt,
Partner,
ChgRecordDescriptionText,
ChangeRecordDetailDescription,
ChgRecdExpectedCompletionDate,
_RefMat,
_RefBOM,
_RefDoc,
_RefBit,
_RefPSV,
_ChangeRecordRefInspPlan,
_ChangeRecordRefRecipe,
_ChangeRecordRefMasterRecipe,
_ChangeRecordRefLabelSet,
_ChangeRecordRefSpecification,
_ChangeRecordRefProdnRouting,
_ChangeRecordRefTmplRouting,
_ChangeRecordRefClass,
_ChangeRecordRefCharc,
_ChangeRecordRefEquipTskList,
_ChangeRecordFuncLocTskList,
_ChangeRecordRefOpSetTskList,
_ChangeRecordRateRtgTskList,
_ChgRecdRefRateRtgTskList,
_ChgRecdRefCutPlngPrflTskList,
_ChgRecdWBSElmntBOM,
_ChgRecdEquipBOM,
_ChgRecdFuncLocBOM,
_ChgRecdRefMaintTskList,
_ChangeRecordRefStdBOM,
_ChangeRecordRefVarBOM,
_ChangeRecordBusinessPartner,
_ChgRecdRefEngBOM,
_ChgRecdRefPlngScp,
_ChgRecdRefMfgBOM,
_ChgRecdCollaboration,
_ChangeRecordLifeCycleStatus,
_ChangeRecordUserStatus
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_CHANGERECORDLIFECYCLESTATUS",
"I_CHANGERECORDTP_2",
"I_CHGRECORDUSERSTATUS",
"I_CHGRECORDUSERSTATUSTEXT"
],
"ASSOCIATED":
[
"A_CHANGERECORDLIFECYCLESTATUS",
"A_CHANGERECORDREFCHARC",
"A_CHANGERECORDREFCLASS",
"A_CHANGERECORDREFERENCEBIT",
"A_CHANGERECORDREFERENCEBOM",
"A_CHANGERECORDREFERENCEDOC",
"A_CHANGERECORDREFERENCEMAT",
"A_CHANGERECORDREFERENCEPSV",
"A_CHANGERECORDREFINSPPLAN",
"A_CHANGERECORDREFLABELSET",
"A_CHANGERECORDREFMASTERRECIPE",
"A_CHANGERECORDREFPRODNROUTING",
"A_CHANGERECORDREFRECIPE",
"A_CHANGERECORDREFSPECIFICATION",
"A_CHANGERECORDREFTMPLROUTING",
"A_CHGRECDBUSINESSPARTNER",
"A_CHGRECDEQUIPBOM",
"A_CHGRECDFUNCLOCBOM",
"A_CHGRECDFUNCLOCTSKLIST",
"A_CHGRECDOBJPGMAINTTSKLIST",
"A_CHGRECDPLMEPDCOLLABN",
"A_CHGRECDRATERTGTSKLIST",
"A_CHGRECDREFCUTPLNGPRFLTSKLIST",
"A_CHGRECDREFENGBOM",
"A_CHGRECDREFEQUIPTSKLIST",
"A_CHGRECDREFMFGBOM",
"A_CHGRECDREFOPSETTSKLIST",
"A_CHGRECDREFPLNGSCOPE",
"A_CHGRECDREFRATERTGTSKLIST",
"A_CHGRECDREFSTDBOM",
"A_CHGRECDREFVARBOM",
"A_CHGRECDWBSELMNTBOM",
"A_CHGRECORDUSERSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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