OIUREP_TEXT_XREF SAP table for – Regulatory Reporting Texts for Diff Reporting Levels

Here we would like to draw your attention to OIUREP_TEXT_XREF table in SAP. As we know it is being mainly used with the SAP IS-OIL-PRA (Production and Revenue Accounting in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIUREP_TEXT_XREF is a SAP standard transp table used for storing Regulatory Reporting Texts for Diff Reporting Levels related data in SAP. It comes under the package OIU_REP.

SAP OIUREP_TEXT_XREF table

Table OIUREP_TEXT_XREF technical data

TableOIUREP_TEXT_XREF
Data storingRegulatory Reporting Texts for Diff Reporting Levels
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-ROY
SAP PackageOIU_REP
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUREP_TEXT_XREF Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIUREP_TEXT_XREF table.

  • .INCLUDE : Key for regulatory reporting tables
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • AGENCY : Agency for Reporting
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • REP_NAME : Regulatory Report Name
    Its a key field. Its data type is CHAR (Character String) with field length 40
  • FIELDNAME : Field Name
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • FIELDVALUE : Value of Regulatory reporting parameters
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • SEQ_NO : Sequence number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • TEXT_ID : Text ID
    Its data type is CHAR (Character String) with field length 4
  • TEXT : Field text
    Its data type is CHAR (Character String) with field length 60
  • EFFECTIVE_FROM : Effective from date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EFFECTIVE_TO : Effective To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8