R_MDOFEDPROCESSTRACKING

DDL: R_MDOFEDPROCESSTRACKING Type: view_entity

MDO: Federation Process Tracking

R_MDOFEDPROCESSTRACKING is a CDS View that provides data about "MDO: Federation Process Tracking" in SAP S/4HANA. It reads from 1 data source (mdo_fed_prc) and exposes 9 fields with key fields BusinessObjectType, ObjectId, TokenId. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
mdo_fed_prc FederationProcessTracking from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_MDOFEDPROCESSSTEPTRACKING _FederationProcessStepTracking $projection.BusinessObjectType = _FederationProcessStepTracking.BusinessObjectType and $projection.ObjectId = _FederationProcessStepTracking.ObjectId and $projection.TokenId = _FederationProcessStepTracking.TokenId

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MDO: Federation Process Tracking view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BusinessObjectType businessobjecttype Object Type
KEY ObjectId objectid Object Value
KEY TokenId tokenid Token ID
Operation operation Transaction
Status status Workflow Status
OdmObjectType odmobjecttype ODM Type
CreatedAt createdat Time Stamp
LastChangedAt lastchangedat Time Stamp
_FederationProcessStepTracking _FederationProcessStepTracking

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_MDOFEDPROCESSTRACKING.
-- 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_MDOFEDPROCESSTRACKING AS
SELECT
  BusinessObjectType,
  ObjectId,
  TokenId,
  Operation,
  Status,
  OdmObjectType,
  CreatedAt,
  LastChangedAt
FROM mdo_fed_prc AS FederationProcessTracking
LEFT OUTER JOIN R_MDOFEDPROCESSSTEPTRACKING AS _FederationProcessStepTracking ON BusinessObjectType = _FederationProcessStepTracking.BusinessObjectType AND ObjectId = _FederationProcessStepTracking.ObjectId AND TokenId = _FederationProcessStepTracking.TokenId  -- association [0..*]
;