1. Home
  2. Resources
  3. SAP Tables
  4. OIUREP_REPORTS - Supported Regulatory reports

SAP Table OIUREP_REPORTS

Supported Regulatory reports

OIUREP_REPORTS (Supported Regulatory reports) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIUREP_REPORTS to other SAP tables.

Source: OIUREP_REPORTS (Supported Regulatory reports)

OIUREP_REPORTS table fields

Field Data element Checktable Datatype Length Decimals
AGENCY Agency for Reporting OIUREP_AGENCY OIUREP_AGENCIES CHAR 3 0
REP_NAME Regulatory Report Name OIU_REP_REPNAME CHAR 40 0
NO_REP_NAME_KEY Not use the Report name as Master data key - Use Alternative OIUREP_NO_REP_NAME_KEY CHAR 1 0
X Use alternative Report Name for Master Data and reporting
M Use alternative Report Name for Master Data only
NULL No alternative Report Name used
ALT_REP_NAME Alternative Regulatory Report Name for Master Data OIUREP_ALT_REP_NAME CHAR 40 0
MTN_MP_XREF Maintain Measurement Point Cross Reference OIUREP_MTN_MP_XREF CHAR 1 0
X Yes
NULL No
MTN_DN_XREF Maintain Delivery Network Cross Reference OIUREP_MTN_DN_XREF CHAR 1 0
X Yes
NULL No
OLD_REP_NAME Old Regulatory Report Name - Premas OIUREP_OLD_REPNAME CHAR 40 0
GEN_REPORT Report Generation Program Name OIUREP_GEN_REPNAME CHAR 40 0
MASTER_VIS Regulatory Reporting - entry visible in Master Data TA OIUREP_VIS_MASTER CHAR 1 0
X Yes
NULL No
XREF_TRNSP_VIS Regulatory Reporting - entry visible in Master Data TA OIUREP_VIS_MASTER CHAR 1 0
X Yes
NULL No
XREF_PRI_VIS Regulatory Reporting - entry visible in Master Data TA OIUREP_VIS_MASTER CHAR 1 0
X Yes
NULL No
XREF_SEC_VIS Regulatory Reporting - entry visible in Master Data TA OIUREP_VIS_MASTER CHAR 1 0
X Yes
NULL No
XREF_TEXT_VIS Regulatory Reporting - entry visible in Master Data TA OIUREP_VIS_MASTER CHAR 1 0
X Yes
NULL No
COMMENTS Reg.Reporting Comments maintainable on field level OIUREP_COMMENTS CHAR 1 0
X Yes
NULL No
DEF_FILE_TYPE Reg.Reporting delivered state compliant file type OIUREP_DEF_FILE_TYPE CHAR 1 0
NULL ASCII file format (no separators)
C CSV file format (comma separated)
FREQUENCY Reporting Frequency OIUREP_FREQUENCY CHAR 1 0
W Weekly
F Fortnighly
M Monthly
B Bi-monthly
Q Quarterly
S Semi-annually
A Annually
SUBMIT_NM Reg.Reporting - Submit Report Name OIUREP_SUBMIT_NM OIUREP_RUN_REPNM CHAR 40 0

OIUREP_REPORTS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIUREP_REPORTS AGENCY OIUREP_REPORTS AGENCY OIUREP_AGENCIES Regulatory Reporting Agencies AGENCY
OIUREP_REPORTS SUBMIT_NM OIUREP_REPORTS AGENCY OIUREP_RUN_REPNM Reg.Reporting - Report run/submission names AGENCY
OIUREP_REPORTS SUBMIT_NM OIUREP_REPORTS SUBMIT_NM OIUREP_RUN_REPNM Reg.Reporting - Report run/submission names SUBMIT_NM