SAP table OIUREP_REPORTS (Supported Regulatory reports)
SAP table OIUREP_REPORTS has 2 primary key fields being AGENCY,REP_NAME.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AGENCY | Agency for Reporting | CHAR | 3 | 0 | OIUREP_AGENCIES | OIUREP_AGENCY | |||||||||||||||
| REP_NAME | Regulatory Report Name | CHAR | 40 | 0 | OIU_REP_REPNAME | ||||||||||||||||
| NO_REP_NAME_KEY | Not use the Report name as Master data key - Use Alternative | CHAR | 1 | 0 | OIUREP_NO_REP_NAME_KEY | ||||||||||||||||
| ALT_REP_NAME | Alternative Regulatory Report Name for Master Data | CHAR | 40 | 0 | OIUREP_ALT_REP_NAME | ||||||||||||||||
| MTN_MP_XREF | Maintain Measurement Point Cross Reference | CHAR | 1 | 0 | OIUREP_MTN_MP_XREF | ||||||||||||||||
| MTN_DN_XREF | Maintain Delivery Network Cross Reference | CHAR | 1 | 0 | OIUREP_MTN_DN_XREF | ||||||||||||||||
| OLD_REP_NAME | Old Regulatory Report Name - Premas | CHAR | 40 | 0 | OIUREP_OLD_REPNAME | ||||||||||||||||
| GEN_REPORT | Report Generation Program Name | CHAR | 40 | 0 | OIUREP_GEN_REPNAME | ||||||||||||||||
| MASTER_VIS | Regulatory Reporting - entry visible in Master Data TA | CHAR | 1 | 0 | OIUREP_VIS_MASTER | ||||||||||||||||
| XREF_TRNSP_VIS | Regulatory Reporting - entry visible in Master Data TA | CHAR | 1 | 0 | OIUREP_VIS_MASTER | ||||||||||||||||
| XREF_PRI_VIS | Regulatory Reporting - entry visible in Master Data TA | CHAR | 1 | 0 | OIUREP_VIS_MASTER | ||||||||||||||||
| XREF_SEC_VIS | Regulatory Reporting - entry visible in Master Data TA | CHAR | 1 | 0 | OIUREP_VIS_MASTER | ||||||||||||||||
| XREF_TEXT_VIS | Regulatory Reporting - entry visible in Master Data TA | CHAR | 1 | 0 | OIUREP_VIS_MASTER | ||||||||||||||||
| COMMENTS | Reg.Reporting Comments maintainable on field level | CHAR | 1 | 0 | OIUREP_COMMENTS | ||||||||||||||||
| DEF_FILE_TYPE | Reg.Reporting delivered state compliant file type | CHAR | 1 | 0 | OIUREP_DEF_FILE_TYPE |
|
|||||||||||||||
| FREQUENCY | Reporting Frequency | CHAR | 1 | 0 | OIUREP_FREQUENCY |
|
|||||||||||||||
| SUBMIT_NM | Reg.Reporting - Submit Report Name | CHAR | 40 | 0 | OIUREP_RUN_REPNM | OIUREP_SUBMIT_NM |
OIUREP_REPORTS foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 OIUREP_REPORTS | AGENCY | OIUREP_AGENCIES | Regulatory Reporting Agencies | AGENCY |
| 1 OIUREP_REPORTS | SUBMIT_NM | OIUREP_RUN_REPNM | Reg.Reporting - Report run/submission names | AGENCY |
| 1 OIUREP_REPORTS | SUBMIT_NM | OIUREP_RUN_REPNM | Reg.Reporting - Report run/submission names | SUBMIT_NM |