SRFD_I_REP_CAT

DDL: SRFD_I_REP_CAT Type: view_entity Package: GLO_GEN_SRF_AUTHORING
13 Fields 1 Data Sources 2 Associations

Report Category Data

SRFD_I_REP_CAT is a CDS View that provides data about "Report Category Data" in SAP S/4HANA. It reads from 1 data source (srf_rep_cat) and exposes 13 fields with key fields ReportCategoryId, ReportCategoryVersion. It has 2 associations to related views. Part of development package GLO_GEN_SRF_AUTHORING.

Data Sources (1)

SourceAliasJoin Type
srf_rep_cat Category from

Associations (2)

CardinalityTargetAliasCondition
[0..*] SRFD_I_REP_CAT_ACT _Activities
[0..*] SRFD_I_REP_CAT_T _Texts

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Report Category Data view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ReportCategoryId srf_rep_cat rep_cat_id Report ID
KEY ReportCategoryVersion srf_rep_cat rep_cat_version Category Version
Country srf_rep_cat land1 Trip Ctry/Reg
ExtendedReportCategoryId srf_rep_cat extended_rep_cat_id Extd Rpt Cat ID
SwitchId srf_rep_cat switch_id Switch
ChangedOn srf_rep_cat changed_on Variant Changed on
ChangedBy srf_rep_cat changed_by User Name
ToggleId srf_rep_cat toggle_id Feature Toggle
ClassificationId srf_rep_cat classification_id Classification
AbapLanguageVersion srf_rep_cat abap_language_version Language Version
TemplateType srf_rep_cat template_type Template Type
_Activities _Activities
_Texts _Texts

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 SRFD_I_REP_CAT.
-- 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 SRFD_I_REP_CAT AS
SELECT
  Category.rep_cat_id AS ReportCategoryId,
  Category.rep_cat_version AS ReportCategoryVersion,
  Category.land1 AS Country,
  Category.extended_rep_cat_id AS ExtendedReportCategoryId,
  Category.switch_id AS SwitchId,
  Category.changed_on AS ChangedOn,
  Category.changed_by AS ChangedBy,
  Category.toggle_id AS ToggleId,
  Category.classification_id AS ClassificationId,
  Category.abap_language_version AS AbapLanguageVersion,
  Category.template_type AS TemplateType
FROM srf_rep_cat AS Category
LEFT OUTER JOIN SRFD_I_REP_CAT_ACT AS _Activities ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN SRFD_I_REP_CAT_T AS _Texts ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More