What is A_ChangeRecord in SAP S/4HANA?

A_ChangeRecord is a composite CDS view in SAP S/4HANA. Change Record Header Data It contains 57 fields.

Which tables does A_ChangeRecord read from?

A_ChangeRecord reads data from: I_ChangeRecordTP_2.

What VDM layer is A_ChangeRecord?

A_ChangeRecord is classified as a Composite view that combines data from multiple basic views.

A_ChangeRecord

DDL: A_CHANGERECORD Type: view_entity COMPOSITE

57 Fields 1 Data Sources 36 Associations

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 57 fields with key field ChangeRecordUUID. It has 36 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ChangeRecordTP_2	I_ChangeRecordTP_2	from

Associations (36)

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
[0..*]	A_ChangeRecordRelatedChange	_ChangeRecordRelatedChange
[0..*]	A_ChangeRecordDescription	_ChangeRecordDescription

Annotations (9)

Name	Value	Level
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 (57)

Key	Field	Source Table	Source Field	Description
KEY	ChangeRecordUUID		ChangeRecordUUID	NodeID
	ChangeRecord		ChangeRecord	Char20
	ChangeRecordType		ChangeRecordType	Record Type
	ChangeRecordPriority		ChangeRecordPriority
	SAPNote3540685ChangeRecordPriorityDesc
	SAPNote3540685ChgRecdReasonForChange
	SAPNote3540685ChgRecdHdrRsnForChgCode
	SAPNote3540685ChgRecdHdrRsnForChgDesc
	SAPNote3540685ChgRecdEffectivityType
	SAPNote3570279ChangeRecordStatus
	ChangeRecordStatusDescription
	ChangeNumber		ChangeNumber	Change Number
	CreatedByUser		CreatedByUser	User Name
	CreationDateTime		CreationDateTime	Timestamp
	LastChangedByUser		LastChangedByUser	User Name
	ChangeRecordLifecycleStatus		ChangeRecordLifecycleStatus	Issue Lifecycle
	ChangeRecordLifecycleStatusTxt	_ChangeRecordLifeCycleStatus	ChangeRecordLifecycleStatusTxt
	Partner		Partner	With Partner
	ChgRecdAuthGroup		ChgRecdAuthGroup
	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
	_ChangeRecordRelatedChange		_ChangeRecordRelatedChange
	_ChangeRecordDescription		_ChangeRecordDescription

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_ChangeRecord.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_ChangeRecord AS
SELECT
  ChangeRecordUUID,
  ChangeRecord,
  ChangeRecordType,
  ChangeRecordPriority,
  I_ChangeRecordTP_2._ChangeRecordUserStatus._Text[1: Language = $session.system_language ].ChangeRecordStatusDescription AS ChangeRecordStatusDescription,
  ChangeNumber,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  ChangeRecordLifecycleStatus,
  _ChangeRecordLifeCycleStatus.ChangeRecordLifecycleStatusTxt AS ChangeRecordLifecycleStatusTxt,
  Partner,
  ChgRecdAuthGroup,
  ChgRecordDescriptionText,
  ChangeRecordDetailDescription,
  ChgRecdExpectedCompletionDate
FROM I_ChangeRecordTP_2
LEFT OUTER JOIN E_ChangeRecordBsc AS _HeaderExtension ON ChangeRecordUUID = _HeaderExtension.ChangeRecordUUID  -- association [0..1]
LEFT OUTER JOIN A_ChgRecdBusinessPartner AS _ChangeRecordBusinessPartner ON Partner = _ChangeRecordBusinessPartner.Partner  -- association [0..1]
LEFT OUTER JOIN A_ChangeRecordLifeCycleStatus AS _ChangeRecordLifeCycleStatus ON ChangeRecordLifecycleStatus = _ChangeRecordLifeCycleStatus.ChangeRecordLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN A_ChgRecordUserStatus AS _ChangeRecordUserStatus ON ChangeRecordStatus = _ChangeRecordUserStatus.ChangeRecordStatus  -- association [0..1]
LEFT OUTER JOIN A_ChangeRecordReferenceMat AS _RefMat ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordReferenceBOM AS _RefBOM ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordReferenceDoc AS _RefDoc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordReferenceBit AS _RefBit ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordReferencePSV AS _RefPSV ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordRefInspPlan AS _ChangeRecordRefInspPlan ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordRefRecipe AS _ChangeRecordRefRecipe ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordRefMasterRecipe AS _ChangeRecordRefMasterRecipe ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordRefLabelSet AS _ChangeRecordRefLabelSet ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordRefSpecification AS _ChangeRecordRefSpecification ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordRefProdnRouting AS _ChangeRecordRefProdnRouting ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordRefTmplRouting AS _ChangeRecordRefTmplRouting ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordRefClass AS _ChangeRecordRefClass ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordRefCharc AS _ChangeRecordRefCharc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdRefEquipTskList AS _ChangeRecordRefEquipTskList ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdFuncLocTskList AS _ChangeRecordFuncLocTskList ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdRefOpSetTskList AS _ChangeRecordRefOpSetTskList ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdRateRtgTskList AS _ChangeRecordRateRtgTskList ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdRefRateRtgTskList AS _ChgRecdRefRateRtgTskList ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdRefCutPlngPrflTskList AS _ChgRecdRefCutPlngPrflTskList ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdWBSElmntBOM AS _ChgRecdWBSElmntBOM ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdEquipBOM AS _ChgRecdEquipBOM ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdFuncLocBOM AS _ChgRecdFuncLocBOM ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdObjPgMaintTskList AS _ChgRecdRefMaintTskList ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdRefStdBOM AS _ChangeRecordRefStdBOM ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdRefVarBOM AS _ChangeRecordRefVarBOM ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdRefEngBOM AS _ChgRecdRefEngBOM ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdRefPlngScope AS _ChgRecdRefPlngScp ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdRefMfgBOM AS _ChgRecdRefMfgBOM ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChgRecdPLMEPDCollabn AS _ChgRecdCollaboration ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordRelatedChange AS _ChangeRecordRelatedChange ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_ChangeRecordDescription AS _ChangeRecordDescription ON /* condition not available in parsed metadata */  -- association [0..*]
;

Depth:

A_ChangeRecord view_entity

I_ChangeRecordTP_2 view