I_HCMReportingVariant

DDL: I_HCMREPORTINGVARIANT Type: view_entity BASIC
19 Fields 1 Data Sources

My Reporting Variants per Report

I_HCMReportingVariant is a Basic CDS View that provides data about "My Reporting Variants per Report" in SAP S/4HANA. It reads from 1 data source (hrfio_d_repvar) and exposes 19 fields with key fields PersonWorkAgreement, HCMReportingReportID, HCMReportingVariantID.

Data Sources (1)

SourceAliasJoin Type
hrfio_d_repvar hrfio_d_repvar from

Annotations (7)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label My Reporting Variants per Report view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement pernr Personnel no.
KEY HCMReportingReportID report_id Report ID
KEY HCMReportingVariantID variant_id Variant Id
HCMReportVariantTitle variant_description Variant Title
HCMReportingPeriodID period_id Period ID
StartDate begda Valid From
EndDate endda Valid To
HCMDateRange1Value date_range_no1 Date Range 1
HCMDateRange2Value date_range_no2 Date Range 2
HCMReportingViewID view_id View ID
HCMSelectedObjectCollText selected_objects
HCMReportingSortColumnID sort_column_id Sort Column ID
HCMSortOrder sort_state
HCMRptgTotalColumnIDCollText total_column_ids
HCMReportingSubtotalColumnID subtotal_column_id Subtotal Column ID
HCMSearchString search_string Term
HCMVariantIsDefault is_default Default Variant
HCMVariantIsInvalid is_invalid Variant is invalid
HCMRptgHiddenColumnIDCollText hidden_column_ids

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_HCMReportingVariant.
-- 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 I_HCMReportingVariant AS
SELECT
  pernr AS PersonWorkAgreement,
  report_id AS HCMReportingReportID,
  variant_id AS HCMReportingVariantID,
  variant_description AS HCMReportVariantTitle,
  period_id AS HCMReportingPeriodID,
  begda AS StartDate,
  endda AS EndDate,
  date_range_no1 AS HCMDateRange1Value,
  date_range_no2 AS HCMDateRange2Value,
  view_id AS HCMReportingViewID,
  selected_objects AS HCMSelectedObjectCollText,
  sort_column_id AS HCMReportingSortColumnID,
  sort_state AS HCMSortOrder,
  total_column_ids AS HCMRptgTotalColumnIDCollText,
  subtotal_column_id AS HCMReportingSubtotalColumnID,
  search_string AS HCMSearchString,
  is_default AS HCMVariantIsDefault,
  is_invalid AS HCMVariantIsInvalid,
  hidden_column_ids AS HCMRptgHiddenColumnIDCollText
FROM hrfio_d_repvar
;

Learn More