1. SAP Tutorial
  2. Oil & Gas

OIUREP_ROY_AGY SAP table for – Reporting Agencies for Tax and Royalty

Here we would like to draw your attention to OIUREP_ROY_AGY 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_ROY_AGY is a SAP standard transp table used for storing Reporting Agencies for Tax and Royalty related data in SAP. It comes under the package OIU_REP.

SAP OIUREP_ROY_AGY table

Table OIUREP_ROY_AGY technical data

TableOIUREP_ROY_AGY
Data storingReporting Agencies for Tax and Royalty
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-ROY
SAP PackageOIU_REP
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUREP_ROY_AGY 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_ROY_AGY table.

  • AGENCY : Agency for Reporting
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • COUNTRY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • STATE : Primary geographical location (PRI geo. loc.)
    Its data type is CHAR (Character String) with field length 2
  • VOL_EXTRACT : Falg to indicate if volume extract is required
    Its data type is CHAR (Character String) with field length 1
  • AMND_CONCEPT : Flag to indicate if the new amended concept is applicable
    Its data type is CHAR (Character String) with field length 1
  • GRAVITY_FLAG : Gravity applicable flag
    Its data type is CHAR (Character String) with field length 1
  • ZERO_VOL_RPT : Reporting for Zero Volume
    Its data type is CHAR (Character String) with field length 1
  • TAX_ROY_IND : Report Type (Tax or Royalty)
    Its data type is CHAR (Character String) with field length 1
  • STRUCT_LNK : Structure with parameters at PUID and RE link level
    Its data type is CHAR (Character String) with field length 30
  • STRUCT_RE : Structure with parameters at RE level
    Its data type is CHAR (Character String) with field length 30
  • STRUCT_PUID : Structure with parameters at PUID level
    Its data type is CHAR (Character String) with field length 30
  • STRUCT_RSG : Structure with parameters at RSG level
    Its data type is CHAR (Character String) with field length 30
  • STRUCT_RPT : Structure with parameters at RPT level
    Its data type is CHAR (Character String) with field length 30
  • TABLE_LNK : Table with parameters at LNK level
    Its data type is CHAR (Character String) with field length 30
  • TABLE_RE : Table with parameters at RE level
    Its data type is CHAR (Character String) with field length 30
  • TABLE_PUID : Table with parameters at PUID level
    Its data type is CHAR (Character String) with field length 30
  • TABLE_RSG : Table with parameters at RSG level
    Its data type is CHAR (Character String) with field length 30
  • TABLE_RPT : Table with parameters at RPT level
    Its data type is CHAR (Character String) with field length 30
  • REF_AGENCY : Reference Agency for Volume Data
    Its data type is CHAR (Character String) with field length 3
  • FREQUENCY : Reporting Frequency
    Its data type is CHAR (Character String) with field length 1
  • GENERIC : Generic Flag
    Its data type is CHAR (Character String) with field length 1
  • PROC_IND : Processing indicator to indicate the tax types allowed
    Its data type is CHAR (Character String) with field length 1
  • VARKEY_RULE : Rule for the variable key in tax reporting
    Its data type is CHAR (Character String) with field length 1
  • UPLOAD_LEVEL : Upload level flag
    Its data type is CHAR (Character String) with field length 1
  • BLPS_AS_GROSS : Use wet-less-residue volume as gross volume for NGL
    Its data type is CHAR (Character String) with field length 1
  • WLR_AS_GROSS : Use wet-less-residue volume as gross volume for NGL
    Its data type is CHAR (Character String) with field length 1
  • SPECIAL_LOGIC : General Flag
    Its data type is CHAR (Character String) with field length 1

    • OIUREP_ROY_AGY related tables

    • OIUREP_RRST_NEW : NEW Regulatory Reporting Status Table (with Version Number)
    • OIUREP_ROY_PRFLD : Field Values in the Royalty Reporting Profiles
    • OIUREP_2014_REP : MMS-2014 – Supplemental Reports From Report Executions
    • OIUREP_PDCD_XREF : Cross Reference Between State Agency and PRA Material
    • OIUREP_RT_HIST : MMS-2014 – Royalty Transaction (Pending) History
    • OIUREP_FIELDS : Regulatory Report Master Data set up
    • OIUREP_AGY_VLTP : Agency defined Volume Types
    • OIUREP_INDIAN_TR : MMS-2014 – Indian Tribes
    • OIUREP_PRDCDXREF : MMS: Possible Material No/MMS Prod Cd Combinations
    • OIUREP_SALESTYPE : MMS-2014 – Sales Type
    • OIUREP_VOLHIST : Reported Volume Data by Reporting Entities
    • OIUREP_CODE_FLDS : Fields available for customizing
    • OIUREP_RECOUP : MMS-2014 – Recoupable Balance
    • OIUREP_REG_OPER : Regulatory Reporting Operator and Contact Xref EFF Dated
    • OIUREP_CODE_RULE : Reg Reporting Rules for Column Data
    • OIUREP_WCPAYXREF : MMS-2014 – Well Completion / Payor XRef
    • OIUREP_REG_OUT : Regulatory Reporting Output Control
    • OIUREP_RPT_PRFL : Report Profile
    • OIUREPP_PRPAYXRF : MMS-2014 – Property / Payor XRef PPA
    • OIUREP_MMS_ACTN : MMS Well Status Reason Code/Action Code Combos (OGOR-A)

    OIUREP_ROY_AGY related transaction codes under SAP package OIU_REP

    • S_SO7_65001143 : Generated Text
    • O3UREP_OPERATOR : Regulatory Reporting Setup
    • S_SO7_65001116 : Generated Text
    • S_SOG_81000029 : IMG activity: SIMG_OIUREP_013
    • O3UREP_MMS_MRTPEND : MMS Level Pending Royalty Trans Rep
    • S_SOG_81000017 : Generated Text
    • S_SOG_81000049 : IMG activity: OIUREP_MAINTAIN_NRIV
    • O5UREP_MMS_TRANS_VAR : MMS-2014: Transport Suppl Rpt Vars
    • O3UREP_MMS_RECOUP : MMS Indian Recoupable Report
    • O5UREP_COMMON : Regulatory Reporting Setup
    • O3UREP_MMS_2014_FORM : MMS 2014 Printable Form
    • O3UREP_MMS_RTHIST : Historic Extract Report
    • S_SO7_65001152 : Generated Text
    • O3UREP_ROY_BASEDATA : Royalty base data maintenance
    • O3UREP_MASTER : Regulatory Reporting Master Data
    • S_SOG_81000094 : IMG activity: OIUREP_2014_UOM
    • S_SO7_65001103 : Generated Text
    • O3UREP_MMS_REJECTS : MMS Extraction Rejects Report
    • S_SOG_81000027 : IMG activity: OIUREP_ADJCD_XRF
    • S_SOG_81000053 : IMG activity: OIUREP_SALES_TYPE

    Related References

    Related Tutorials

    OIUREP_AGENCYTX SAP table for – Regulatory Reporting Agencies

    OIUREP_AGENCYTX table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUREP_ACTIVATE SAP table for – Reg./Tax and Royalty Reporting – report activation

    OIUREP_ACTIVATE table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUREP_ROY_AGYTX SAP table for – Regulatory Reporting Agencies

    OIUREP_ROY_AGYTX table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUREP_AGENCIES SAP table for – Regulatory Reporting Agencies

    OIUREP_AGENCIES table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUREP_LGL_RPTS SAP table for – Legal Reports for Tax and Royalty Reporting

    OIUREP_LGL_RPTS table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUREP_LGL_RPTTX SAP table for – Text Table for Legal Reports (Tax and Royalty)

    OIUREP_LGL_RPTTX table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUREP_RPT_OWNER SAP table for – Owners for royalty reporting

    OIUREP_RPT_OWNER table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »