R_ChgRecdRateRtgTskListTP

DDL: R_CHGRECDRATERTGTSKLISTTP Type: view_entity TRANSACTIONAL Package: VDM_PLMB_CR_O
26 Fields 1 Data Sources 4 Associations

Chg Reсd Ref Obj Rate Rtg Task List - TP

R_ChgRecdRateRtgTskListTP is a Transactional CDS View that provides data about "Chg Reсd Ref Obj Rate Rtg Task List - TP" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRateRtgTskListBsc) and exposes 26 fields with key field ChangeRecordReferenceUUID. It has 4 associations to related views. Part of development package VDM_PLMB_CR_O.

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRateRtgTskListBsc RateRtgTaskListReference from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_ChgRecdRateRtgTskListBsc _RateRtgTaskListExtension $projection.ChangeRecordReferenceUUID = _RateRtgTaskListExtension.ChangeRecordReferenceUUID
[0..1] C_ChangeRecdDigSignStatusVH _DigSignStatusText $projection.ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus and _DigSignStatusText.Language = $session.system_language
[0..1] I_ChangeRecordRefObjIcons _ChangeRecordRefObjIcons $projection.ChangeRecordUUID = _ChangeRecordRefObjIcons.ChangeRecordUUID and $projection.ChangeRecordReferenceType = _ChangeRecordRefObjIcons.ChangeRecordReferenceType
[1..1] R_ChangeRecordHeader _ChangeRecord $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID

Annotations (8)

NameValueLevelField
EndUserText.label Chg Reсd Ref Obj Rate Rtg Task List - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRateRtgTskListBsc ChangeRecordReferenceUUID UUID
ChangeRecordUUID I_ChgRecdRateRtgTskListBsc ChangeRecordUUID NodeID
ChangeRecordReferenceType I_ChgRecdRateRtgTskListBsc ChangeRecordReferenceType Object Type
ChangeRecordReferenceSubtype I_ChgRecdRateRtgTskListBsc ChangeRecordReferenceSubtype Subtype
ChangeRecordRefObjectUUID I_ChgRecdRateRtgTskListBsc ChangeRecordRefObjectUUID GUID-Key
ChangeRecordReference I_ChgRecdRateRtgTskListBsc ChangeRecordReference Ref. Object ID
ParentChangeRecordRefUUID I_ChgRecdRateRtgTskListBsc ParentChangeRecordRefUUID Node ID
IsMainReference I_ChgRecdRateRtgTskListBsc IsMainReference Main Reference
ChgRecdReasonForChange I_ChgRecdRateRtgTskListBsc ChgRecdReasonForChange Reason for Chge
ExpdCompltnDte I_ChgRecdRateRtgTskListBsc ExpdCompltnDte Exp Completion Date
ChgRecdAuthznGrpText I_ChgRecdRateRtgTskListBsc ChgRecdAuthznGrpText Authoriz. Group
ChgRecdNmbrChgSts I_ChgRecdRateRtgTskListBsc ChgRecdNmbrChgSts Status
CreatedByUser I_ChgRecdRateRtgTskListBsc CreatedByUser User Name
CreationDateTime I_ChgRecdRateRtgTskListBsc CreationDateTime Timestamp
LastChangedByUser I_ChgRecdRateRtgTskListBsc LastChangedByUser User Name
LastChangeDateTime I_ChgRecdRateRtgTskListBsc LastChangeDateTime Timestamp
ChangeRecordItemRelevance I_ChgRecdRateRtgTskListBsc ChangeRecordItemRelevance Relevance
ChangeRecordVirtualRefInd I_ChgRecdRateRtgTskListBsc ChangeRecordVirtualRefInd Virtual Reference
ChangeRecordItemProcgStatus I_ChgRecdRateRtgTskListBsc ChangeRecordItemProcgStatus Processing Status
ChgRecdCurrentItemProcgStatus I_ChgRecdRateRtgTskListBsc ChgRecdCurrentItemProcgStatus Processing Status
ChangeNumber I_ChgRecdRateRtgTskListBsc ChangeNumber Change Number
ChgRecdItmTgtSts I_ChgRecdRateRtgTskListBsc ChgRecdItmTgtSts Tgt Proc. Sts
ChgRecdItmDSgntr I_ChgRecdRateRtgTskListBsc ChgRecdItmDSgntr Itm. Dgt. Sign.
ChangeRecordRefObjIcon
_ChangeRecord _ChangeRecord
_ChangeRecordRefObjIcons _ChangeRecordRefObjIcons

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 R_ChgRecdRateRtgTskListTP.
-- 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 R_ChgRecdRateRtgTskListTP AS
SELECT
  RateRtgTaskListReference.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  RateRtgTaskListReference.ChangeRecordUUID AS ChangeRecordUUID,
  RateRtgTaskListReference.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  RateRtgTaskListReference.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  RateRtgTaskListReference.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  RateRtgTaskListReference.ChangeRecordReference AS ChangeRecordReference,
  RateRtgTaskListReference.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  RateRtgTaskListReference.IsMainReference AS IsMainReference,
  RateRtgTaskListReference.ChgRecdReasonForChange AS ChgRecdReasonForChange,
  RateRtgTaskListReference.ExpdCompltnDte AS ExpdCompltnDte,
  RateRtgTaskListReference.ChgRecdAuthznGrpText AS ChgRecdAuthznGrpText,
  RateRtgTaskListReference.ChgRecdNmbrChgSts AS ChgRecdNmbrChgSts,
  RateRtgTaskListReference.CreatedByUser AS CreatedByUser,
  RateRtgTaskListReference.CreationDateTime AS CreationDateTime,
  RateRtgTaskListReference.LastChangedByUser AS LastChangedByUser,
  RateRtgTaskListReference.LastChangeDateTime AS LastChangeDateTime,
  RateRtgTaskListReference.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  RateRtgTaskListReference.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  RateRtgTaskListReference.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  RateRtgTaskListReference.ChgRecdCurrentItemProcgStatus AS ChgRecdCurrentItemProcgStatus,
  RateRtgTaskListReference.ChangeNumber AS ChangeNumber,
  RateRtgTaskListReference.ChgRecdItmTgtSts AS ChgRecdItmTgtSts,
  RateRtgTaskListReference.ChgRecdItmDSgntr AS ChgRecdItmDSgntr,
  _ChangeRecordRefObjIcons[ChangeRecordType = ChangeRecordType].ChangeRecordRefObjIcon AS ChangeRecordRefObjIcon
FROM I_ChgRecdRateRtgTskListBsc AS RateRtgTaskListReference
LEFT OUTER JOIN E_ChgRecdRateRtgTskListBsc AS _RateRtgTaskListExtension ON ChangeRecordReferenceUUID = _RateRtgTaskListExtension.ChangeRecordReferenceUUID  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecdDigSignStatusVH AS _DigSignStatusText ON ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus AND _DigSignStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ChangeRecordRefObjIcons AS _ChangeRecordRefObjIcons ON ChangeRecordUUID = _ChangeRecordRefObjIcons.ChangeRecordUUID AND ChangeRecordReferenceType = _ChangeRecordRefObjIcons.ChangeRecordReferenceType  -- association [0..1]
LEFT OUTER JOIN R_ChangeRecordHeader AS _ChangeRecord ON ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID  -- association [1..1]
;

Learn More