OIUREP_REPORTS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PRARegulatoryReportVH | view_entity | from | BASIC | Supported Regulatory report |
Fields (17)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA