HRFIO_D_REPVAR

Transparent Table Application Table
19 Fields 1 CDS Views

My Reporting: Variants

HRFIO_D_REPVAR is an SAP database table in S/4HANA. My Reporting: Variants. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_HCMReportingVariant view_entity from BASIC My Reporting Variants per Report

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY pernr PERNR_D Personnel No.
KEY report_id HRFIO_REP_REPORT_ID Report ID
KEY variant_id HRFIO_REP_VARIANT_ID Variant ID
variant_description HRFIO_REP_VARIANT_TITLE Variant Title
period_id HRFIO_REP_PERIOD_ID Period ID
begda BEGDA Start Date
endda ENDDA End Date
date_range_no1 INT4 INT4
date_range_no2 INT4 INT4
view_id HRFIO_REP_VIEW_ID View ID
selected_objects abap.strg
sort_column_id HRFIO_REP_COLUMN_ID Column ID
sort_state abap.char
total_column_ids abap.strg
subtotal_column_id HRFIO_REP_COLUMN_ID Column ID
search_string HRFIO_REP_SEARCH_STRING Search String
is_default ABAP_BOOLEAN Truth Value
is_invalid ABAP_BOOLEAN Truth Value

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- My Reporting: Variants
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_REPVAR (
    CLIENT,               -- abap.clnt
    PERNR,                -- Personnel No. [PERNR_D]
    REPORT_ID,            -- Report ID [HRFIO_REP_REPORT_ID]
    VARIANT_ID,           -- Variant ID [HRFIO_REP_VARIANT_ID]
    VARIANT_DESCRIPTION,  -- Variant Title [HRFIO_REP_VARIANT_TITLE]
    PERIOD_ID,            -- Period ID [HRFIO_REP_PERIOD_ID]
    BEGDA,                -- Start Date [BEGDA]
    ENDDA,                -- End Date [ENDDA]
    DATE_RANGE_NO1,       -- INT4 [INT4]
    DATE_RANGE_NO2,       -- INT4 [INT4]
    VIEW_ID,              -- View ID [HRFIO_REP_VIEW_ID]
    SELECTED_OBJECTS,     -- abap.strg
    SORT_COLUMN_ID,       -- Column ID [HRFIO_REP_COLUMN_ID]
    SORT_STATE,           -- abap.char
    TOTAL_COLUMN_IDS,     -- abap.strg
    SUBTOTAL_COLUMN_ID,   -- Column ID [HRFIO_REP_COLUMN_ID]
    SEARCH_STRING,        -- Search String [HRFIO_REP_SEARCH_STRING]
    IS_DEFAULT,           -- Truth Value [ABAP_BOOLEAN]
    IS_INVALID,           -- Truth Value [ABAP_BOOLEAN]
    PRIMARY KEY (CLIENT, PERNR, REPORT_ID, VARIANT_ID)
);

Learn More