I_StRpActivity

DDL: I_STRPACTIVITY SQL: ISTRPACT Type: view BASIC

Activity Definition

I_StRpActivity is a Basic CDS View that provides data about "Activity Definition" in SAP S/4HANA. It reads from 1 data source (srf_rpg_act) and exposes 10 fields with key field StatryRptActivityUUID.

Data Sources (1)

SourceAliasJoin Type
srf_rpg_act srf_rpg_act from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISTRPACT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Activity Definition view
VDM.viewType #BASIC view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name StatutoryReportingActivity view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY StatryRptActivityUUID srf_rpg_act db_key UUID
StatryRptPhaseUUID srf_rpg_act parent_key UUID
StatryRptTaskUUID srf_rpg_act root_key UUID
StatryRptCategory srf_rpg_act rep_cat_id Report ID
StatryRptActivityId srf_rpg_act activity_id IMG Activity
StatryRptActivityType srf_rpg_act activity_type Inward/Outward Acty
StatryRptActivityPhase srf_rpg_act activity_phase Phase
StatryRptActivityStatus srf_rpg_act activity_status Activity Status
StatryRptTaskDueDate srf_rpg_act due_date Net Due Date
StatryRptActyChgdOnDteTme srf_rpg_act changed_on Variant Changed on

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_StRpActivity.
-- 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: ISTRPACT

CREATE VIEW I_StRpActivity AS
SELECT
  srf_rpg_act.db_key AS StatryRptActivityUUID,
  srf_rpg_act.parent_key AS StatryRptPhaseUUID,
  srf_rpg_act.root_key AS StatryRptTaskUUID,
  srf_rpg_act.rep_cat_id AS StatryRptCategory,
  srf_rpg_act.activity_id AS StatryRptActivityId,
  srf_rpg_act.activity_type AS StatryRptActivityType,
  srf_rpg_act.activity_phase AS StatryRptActivityPhase,
  srf_rpg_act.activity_status AS StatryRptActivityStatus,
  srf_rpg_act.due_date AS StatryRptTaskDueDate,
  srf_rpg_act.changed_on AS StatryRptActyChgdOnDteTme
FROM srf_rpg_act
;