OIUREP_REPORTS

Transparent Table System Table (SAP only)

Supported Regulatory reports

OIUREP_REPORTS is an SAP database table in S/4HANA. Supported Regulatory reports. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRARegulatoryReportVH view_entity from BASIC Supported Regulatory report

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY agency OIUREP_AGENCY Rep.Agency
KEY rep_name OIU_REP_REPNAME RegReport
no_rep_name_key OIUREP_NO_REP_NAME_KEY UseAlterRepName
alt_rep_name OIUREP_ALT_REP_NAME MasterDataRepNm
mtn_mp_xref OIUREP_MTN_MP_XREF MP XReference
mtn_dn_xref OIUREP_MTN_DN_XREF DN XReference
old_rep_name OIUREP_OLD_REPNAME OldRegReport
gen_report OIUREP_GEN_REPNAME Generation Rep.
master_vis OIUREP_VIS_MASTER VisMaster
xref_trnsp_vis OIUREP_VIS_MASTER VisMaster
xref_pri_vis OIUREP_VIS_MASTER VisMaster
xref_sec_vis OIUREP_VIS_MASTER VisMaster
xref_text_vis OIUREP_VIS_MASTER VisMaster
comments OIUREP_COMMENTS Comments
def_file_type OIUREP_DEF_FILE_TYPE FileType
frequency OIUREP_FREQUENCY Reporting Frequency
submit_nm OIUREP_SUBMIT_NM SubmitName

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.

-- Supported Regulatory reports
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIUREP_REPORTS (
    AGENCY,           -- Rep.Agency [OIUREP_AGENCY]
    REP_NAME,         -- RegReport [OIU_REP_REPNAME]
    NO_REP_NAME_KEY,  -- UseAlterRepName [OIUREP_NO_REP_NAME_KEY]
    ALT_REP_NAME,     -- MasterDataRepNm [OIUREP_ALT_REP_NAME]
    MTN_MP_XREF,      -- MP XReference [OIUREP_MTN_MP_XREF]
    MTN_DN_XREF,      -- DN XReference [OIUREP_MTN_DN_XREF]
    OLD_REP_NAME,     -- OldRegReport [OIUREP_OLD_REPNAME]
    GEN_REPORT,       -- Generation Rep. [OIUREP_GEN_REPNAME]
    MASTER_VIS,       -- VisMaster [OIUREP_VIS_MASTER]
    XREF_TRNSP_VIS,   -- VisMaster [OIUREP_VIS_MASTER]
    XREF_PRI_VIS,     -- VisMaster [OIUREP_VIS_MASTER]
    XREF_SEC_VIS,     -- VisMaster [OIUREP_VIS_MASTER]
    XREF_TEXT_VIS,    -- VisMaster [OIUREP_VIS_MASTER]
    COMMENTS,         -- Comments [OIUREP_COMMENTS]
    DEF_FILE_TYPE,    -- FileType [OIUREP_DEF_FILE_TYPE]
    FREQUENCY,        -- Reporting Frequency [OIUREP_FREQUENCY]
    SUBMIT_NM,        -- SubmitName [OIUREP_SUBMIT_NM]
    PRIMARY KEY (AGENCY, REP_NAME)
);