I_ChgRecdRefOpSetTskListTP_2

DDL: I_CHGRECDREFOPSETTSKLISTTP_2 SQL: ICHGRECREFROSTP2 Type: view TRANSACTIONAL
19 Fields 1 Data Sources 2 Associations

Chg Record Ref Op Set Task List

I_ChgRecdRefOpSetTskListTP_2 is a Transactional CDS View that provides data about "Chg Record Ref Op Set Task List" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefOpSetTskListBsc) and exposes 19 fields with key field ChangeRecordReferenceUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefOpSetTskListBsc reference_ros from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ChangeRecordDraftTP _ChangeRecordTP $projection.ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID
[0..1] E_ChgRecdRefOpSetTskListBsc _RefOpSetTskListExtension $projection.ChangeRecordReferenceUUID = _RefOpSetTskListExtension.ChangeRecordReferenceUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICHGRECREFROSTP2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Chg Record Ref Op Set Task List view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRefOpSetTskListBsc ChangeRecordReferenceUUID UUID
BOOInternalVersionCounter
ChangeRecordUUID I_ChgRecdRefOpSetTskListBsc ChangeRecordUUID NodeID
ChangeRecord I_ChgRecdRefOpSetTskListBsc ChangeRecord Char20
ChangeRecordReferenceType I_ChgRecdRefOpSetTskListBsc ChangeRecordReferenceType Object Type
ChangeRecordReferenceSubtype I_ChgRecdRefOpSetTskListBsc ChangeRecordReferenceSubtype Subtype
ChangeRecordRefObjectUUID I_ChgRecdRefOpSetTskListBsc ChangeRecordRefObjectUUID GUID-Key
ChangeRecordReference I_ChgRecdRefOpSetTskListBsc ChangeRecordReference Ref. Object ID
ParentChangeRecordRefUUID I_ChgRecdRefOpSetTskListBsc ParentChangeRecordRefUUID Node ID
IsMainReference I_ChgRecdRefOpSetTskListBsc IsMainReference Main Reference
CreatedByUser I_ChgRecdRefOpSetTskListBsc CreatedByUser User Name
CreationDateTime I_ChgRecdRefOpSetTskListBsc CreationDateTime Timestamp
LastChangedByUser I_ChgRecdRefOpSetTskListBsc LastChangedByUser User Name
LastChangeDateTime I_ChgRecdRefOpSetTskListBsc LastChangeDateTime Timestamp
ChangeRecordItemRelevance I_ChgRecdRefOpSetTskListBsc ChangeRecordItemRelevance Relevance
ChangeRecordVirtualRefInd I_ChgRecdRefOpSetTskListBsc ChangeRecordVirtualRefInd Virtual Reference
ChangeRecordItemProcgStatus I_ChgRecdRefOpSetTskListBsc ChangeRecordItemProcgStatus Processing Status
_ChangeRecordTP _ChangeRecordTP
_ChangeRecordAPITP _ChangeRecordAPITP

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_ChgRecdRefOpSetTskListTP_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: ICHGRECREFROSTP2

CREATE VIEW I_ChgRecdRefOpSetTskListTP_2 AS
SELECT
  reference_ros.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  cast ('00000000' as cim_count ) AS BOOInternalVersionCounter,
  reference_ros.ChangeRecordUUID AS ChangeRecordUUID,
  reference_ros.ChangeRecord AS ChangeRecord,
  reference_ros.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  reference_ros.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  reference_ros.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  reference_ros.ChangeRecordReference AS ChangeRecordReference,
  reference_ros.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  reference_ros.IsMainReference AS IsMainReference,
  reference_ros.CreatedByUser AS CreatedByUser,
  reference_ros.CreationDateTime AS CreationDateTime,
  reference_ros.LastChangedByUser AS LastChangedByUser,
  reference_ros.LastChangeDateTime AS LastChangeDateTime,
  reference_ros.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  reference_ros.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  reference_ros.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus
FROM I_ChgRecdRefOpSetTskListBsc AS reference_ros
LEFT OUTER JOIN I_ChangeRecordDraftTP AS _ChangeRecordTP ON ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN E_ChgRecdRefOpSetTskListBsc AS _RefOpSetTskListExtension ON ChangeRecordReferenceUUID = _RefOpSetTskListExtension.ChangeRecordReferenceUUID  -- association [0..1]
;

Learn More