I_ChangeRecordTP_2

DDL: I_CHANGERECORDTP_2 SQL: ICHGRECORDTP2 Type: view TRANSACTIONAL
50 Fields 1 Data Sources 29 Associations

Change Record API View

I_ChangeRecordTP_2 is a Transactional CDS View that provides data about "Change Record API View" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordBsc) and exposes 50 fields with key field ChangeRecordUUID. It has 29 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordBsc I_ChangeRecordBsc from

Associations (29)

CardinalityTargetAliasCondition
[0..1] E_ChangeRecordBsc _HeaderExtension $projection.ChangeRecordUUID = _HeaderExtension.ChangeRecordUUID
[0..1] I_ChgRecordLifecycleStatus _ChangeRecordLifeCycleStatus $projection.ChangeRecordLifecycleStatus = _ChangeRecordLifeCycleStatus.ChangeRecordLifecycleStatus
[0..1] I_ChgRecordUserStatus _ChangeRecordUserStatus $projection.ChangeRecordStatus = _ChangeRecordUserStatus.ChangeRecordStatus
[0..*] I_ChangeRecordReferenceBOMTP_2 _ChangeRecordReferenceBOMTP
[0..*] I_ChangeRecordRefBOMItmTP_2 _ChangeRecordRefBOMItmTP
[0..*] I_ChangeRecordReferenceMatTP_2 _ChangeRecordReferenceMatTP
[0..*] I_ChangeRecordReferenceDocTP_2 _ChangeRecordReferenceDocTP
[0..*] I_ChgRecdRefProdStrucVarTP_2 _ChangeRecordReferencePSVTP
[0..*] I_ChangeRecdRefInspPlanTP_2 _ChangeRecordRefInspPlanTP
[0..*] I_ChangeRecdRefRecipeTP_2 _ChangeRecordRefRecipeTP
[0..*] I_ChangeRecdRefMstrRecipeTP_2 _ChangeRecordRefMasterRecipeTP
[0..*] I_ChangeRecdRefSpecTP_2 _ChangeRecdRefSpecificationTP
[0..*] I_ChangeRecdRefLabelSetTP_2 _ChangeRecordRefLabelSetTP
[0..*] I_ChangeRecdRefProdnRtgTP_2 _ChangeRecordRefRoutingTP
[0..*] I_ChangeRecdRefTmplRoutingTP_2 _ChangeRecordRefTmplRoutingTP
[0..*] I_ChangeRecdRefClassTP_2 _ChangeRecordRefClassTP
[0..*] I_ChangeRecdRefCharcTP_2 _ChangeRecordRefCharcTP
[0..*] I_ChgRecdRefEquipTskListTP_2 _ChangeRecordRefEquipTskListTP
[0..*] I_ChgRecdFuncLocTskListTP_2 _ChangeRecordFuncLocTskListTP
[0..*] I_ChgRecdRefOpSetTskListTP_2 _ChangeRecordRefOpSetTskListTP
[0..*] I_ChgRecdRateRtgTskListTP_2 _ChangeRecordRateRtgTskListTP
[0..*] I_ChgRecdRefRateRtgTskListTP_2 _ChgRecdRefRateRtgTskListTP
[0..*] I_ChgRecdRefCutPlngPrflTP_2 _ChgRecdCutPlngPrflTskListTP
[0..*] I_ChgRecdWBSBillOfMatTP_2 _ChgRecdWBSBillOfMatTP
[0..*] I_ChgRecdEquipBillOfMatTP_2 _ChgRecdEquipBillOfMatTP
[0..*] I_ChgRecdFuncLocBillOfMatTP_2 _ChgRecdFuncLocBillOfMatTP
[0..*] I_ChgRecdRefMaintTskListTP_2 _ChgRecdRefMaintTskListTP
[0..*] I_ChgRecdRefStdBillOfMatTP_2 _ChangeRecordRefStdBOMTP
[0..*] I_ChgRecdVarBillOfMatTP_2 _ChangeRecordRefVarTP

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ICHGRECORDTP2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Change Record API View view
Search.searchable true view
ObjectModel.representativeKey ChangeRecordUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name ChangeRecord view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordUUID ChangeRecordUUID NodeID
ChangeRecord ChangeRecord Char20
ChangeRecordType ChangeRecordType Record Type
ParentChangeRecordUUID ParentChangeRecordUUID NodeID
RootChangeRecordUUID RootChangeRecordUUID NodeID
ChangeRecordCategory ChangeRecordCategory Issue Cat.
ChgRecordApplication ChgRecordApplication UI Application
ChangeRecordPriority ChangeRecordPriority Workflow priority
ChangeRecordPriorityDesc ChangeRecordPriorityDesc
SAPNote3540685ChgRecdReasonForChange
SAPNote3540685ChgRecdHdrRsnForChgCode
SAPNote3540685ChgRecdHdrRsnForChgDesc
SAPNote3540685ChangeRecordStatus
ChangeRecordDetailDescription ChangeRecordDetailDescription Detailed Description
ChgRecdExpectedCompletionDate ChgRecdExpectedCompletionDate Exp Completion Date
ChangeNumber ChangeNumber Change Number
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
Partner Partner With Partner
ChangeRecordLifecycleStatus ChangeRecordLifecycleStatus Issue Lifecycle
ChgRecordDescriptionText ChgRecordDescriptionText
_ChangeRecordReferenceMatTP _ChangeRecordReferenceMatTP
_ChangeRecordReferenceBOMTP _ChangeRecordReferenceBOMTP
_ChangeRecordRefBOMItmTP _ChangeRecordRefBOMItmTP
_ChangeRecordReferenceDocTP _ChangeRecordReferenceDocTP
_ChangeRecordReferencePSVTP _ChangeRecordReferencePSVTP
_ChangeRecordRefInspPlanTP _ChangeRecordRefInspPlanTP
_ChangeRecordRefRecipeTP _ChangeRecordRefRecipeTP
_ChangeRecordRefMasterRecipeTP _ChangeRecordRefMasterRecipeTP
_ChangeRecdRefSpecificationTP _ChangeRecdRefSpecificationTP
_ChangeRecordRefLabelSetTP _ChangeRecordRefLabelSetTP
_ChangeRecordRefRoutingTP _ChangeRecordRefRoutingTP
_ChangeRecordRefTmplRoutingTP _ChangeRecordRefTmplRoutingTP
_ChangeRecordRefClassTP _ChangeRecordRefClassTP
_ChangeRecordRefCharcTP _ChangeRecordRefCharcTP
_ChangeRecordRefEquipTskListTP _ChangeRecordRefEquipTskListTP
_ChangeRecordFuncLocTskListTP _ChangeRecordFuncLocTskListTP
_ChangeRecordRefOpSetTskListTP _ChangeRecordRefOpSetTskListTP
_ChangeRecordRateRtgTskListTP _ChangeRecordRateRtgTskListTP
_ChgRecdRefRateRtgTskListTP _ChgRecdRefRateRtgTskListTP
_ChgRecdCutPlngPrflTskListTP _ChgRecdCutPlngPrflTskListTP
_ChgRecdWBSBillOfMatTP _ChgRecdWBSBillOfMatTP
_ChgRecdEquipBillOfMatTP _ChgRecdEquipBillOfMatTP
_ChgRecdFuncLocBillOfMatTP _ChgRecdFuncLocBillOfMatTP
_ChgRecdRefMaintTskListTP _ChgRecdRefMaintTskListTP
_ChangeRecordRefStdBOMTP _ChangeRecordRefStdBOMTP
_ChangeRecordRefVarTP _ChangeRecordRefVarTP
_ChangeRecordLifeCycleStatus _ChangeRecordLifeCycleStatus
_ChangeRecordUserStatus _ChangeRecordUserStatus

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 I_ChangeRecordTP_2.
-- 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.
-- SQL view name: ICHGRECORDTP2

CREATE VIEW I_ChangeRecordTP_2 AS
SELECT
  ChangeRecordUUID,
  ChangeRecord,
  ChangeRecordType,
  ParentChangeRecordUUID,
  RootChangeRecordUUID,
  ChangeRecordCategory,
  ChgRecordApplication,
  ChangeRecordPriority,
  ChangeRecordPriorityDesc,
  ChangeRecordDetailDescription,
  ChgRecdExpectedCompletionDate,
  ChangeNumber,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  Partner,
  ChangeRecordLifecycleStatus,
  ChgRecordDescriptionText
FROM I_ChangeRecordBsc
LEFT OUTER JOIN E_ChangeRecordBsc AS _HeaderExtension ON ChangeRecordUUID = _HeaderExtension.ChangeRecordUUID  -- association [0..1]
LEFT OUTER JOIN I_ChgRecordLifecycleStatus AS _ChangeRecordLifeCycleStatus ON ChangeRecordLifecycleStatus = _ChangeRecordLifeCycleStatus.ChangeRecordLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_ChgRecordUserStatus AS _ChangeRecordUserStatus ON ChangeRecordStatus = _ChangeRecordUserStatus.ChangeRecordStatus  -- association [0..1]
LEFT OUTER JOIN I_ChangeRecordReferenceBOMTP_2 AS _ChangeRecordReferenceBOMTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordRefBOMItmTP_2 AS _ChangeRecordRefBOMItmTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordReferenceMatTP_2 AS _ChangeRecordReferenceMatTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordReferenceDocTP_2 AS _ChangeRecordReferenceDocTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefProdStrucVarTP_2 AS _ChangeRecordReferencePSVTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecdRefInspPlanTP_2 AS _ChangeRecordRefInspPlanTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecdRefRecipeTP_2 AS _ChangeRecordRefRecipeTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecdRefMstrRecipeTP_2 AS _ChangeRecordRefMasterRecipeTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecdRefSpecTP_2 AS _ChangeRecdRefSpecificationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecdRefLabelSetTP_2 AS _ChangeRecordRefLabelSetTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecdRefProdnRtgTP_2 AS _ChangeRecordRefRoutingTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecdRefTmplRoutingTP_2 AS _ChangeRecordRefTmplRoutingTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecdRefClassTP_2 AS _ChangeRecordRefClassTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecdRefCharcTP_2 AS _ChangeRecordRefCharcTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefEquipTskListTP_2 AS _ChangeRecordRefEquipTskListTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdFuncLocTskListTP_2 AS _ChangeRecordFuncLocTskListTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefOpSetTskListTP_2 AS _ChangeRecordRefOpSetTskListTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRateRtgTskListTP_2 AS _ChangeRecordRateRtgTskListTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefRateRtgTskListTP_2 AS _ChgRecdRefRateRtgTskListTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefCutPlngPrflTP_2 AS _ChgRecdCutPlngPrflTskListTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdWBSBillOfMatTP_2 AS _ChgRecdWBSBillOfMatTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdEquipBillOfMatTP_2 AS _ChgRecdEquipBillOfMatTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdFuncLocBillOfMatTP_2 AS _ChgRecdFuncLocBillOfMatTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefMaintTskListTP_2 AS _ChgRecdRefMaintTskListTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefStdBillOfMatTP_2 AS _ChangeRecordRefStdBOMTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdVarBillOfMatTP_2 AS _ChangeRecordRefVarTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More