OIUY1_EXEC_STATD SAP table for – Execution Statistics for Royalty Reporting

Here we would like to draw your attention to OIUY1_EXEC_STATD 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). OIUY1_EXEC_STATD is a SAP standard transp table used for storing Execution Statistics for Royalty Reporting related data in SAP. It comes under the package OIU.

SAP OIUY1_EXEC_STATD table

Table OIUY1_EXEC_STATD technical data

TableOIUY1_EXEC_STATD
Data storingExecution Statistics for Royalty Reporting
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUY1_EXEC_STATD 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 OIUY1_EXEC_STATD table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RPT_YYYYMM : Reporting Year and Month
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • ORG_LEVEL1_NO : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • AGENCY : Agency for Reporting
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • OGIND : Oil and Gas Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • LEGAL_REPORT_ID : Legal report Identifier for tax and royalty reports
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • AMENEDED : flag
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • SF_DOWNLOAD : flag
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • DISPLAY_JOB : Background job name
    Its data type is CHAR (Character String) with field length 32
  • DISPLAY_CNT : Job ID
    Its data type is CHAR (Character String) with field length 8
  • DISPLAY_ST : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • OIU_CRUSER : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • OIU_TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15