I_ProcessRouteAreaActivityText

DDL: I_PROCESSROUTEAREAACTIVITYTEXT SQL: IPRAREAACTYTEXT Type: view BASIC
5 Fields 3 Data Sources

Process Route Area Activity Text

I_ProcessRouteAreaActivityText is a Basic CDS View that provides data about "Process Route Area Activity Text" in SAP S/4HANA. It reads from 3 data sources (srmactivty, srmactivtt, /plmb/pr_obj_act) and exposes 5 fields with key fields ProcessRouteActivityArea, ProcessRouteActivity, Language.

Data Sources (3)

SourceAliasJoin Type
srmactivty Activities inner
srmactivtt ActivityText from
/plmb/pr_obj_act ObjectActivities inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPRAREAACTYTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Process Route Area Activity Text view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProcessRouteActivityArea srmactivtt actarea Activity Area
KEY ProcessRouteActivity srmactivtt activity VAT Activity
KEY Language srmactivtt spras Off. Language
ProcessRouteActivityDesc srmactivtt actdc Activity Description
ProcessRouteActivityType srmactivty act_type Task Type

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_ProcessRouteAreaActivityText.
-- 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: IPRAREAACTYTEXT

CREATE VIEW I_ProcessRouteAreaActivityText AS
SELECT
  ActivityText.actarea AS ProcessRouteActivityArea,
  ActivityText.activity AS ProcessRouteActivity,
  ActivityText.spras AS Language,
  ActivityText.actdc AS ProcessRouteActivityDesc,
  Activities.act_type AS ProcessRouteActivityType
FROM srmactivtt AS ActivityText
INNER JOIN srmactivty AS Activities ON /* join condition not captured in parsed metadata */
INNER JOIN /plmb/pr_obj_act AS ObjectActivities ON /* join condition not captured in parsed metadata */
;

Learn More