1. SAP Tutorial
  2. Oil & Gas

OIUX5_OK_RPDT SAP table for – Tax 2.0 – Oklahoma Gross Prod Report Detail

Here we would like to draw your attention to OIUX5_OK_RPDT 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). OIUX5_OK_RPDT is a SAP standard transp table used for storing Tax 2.0 – Oklahoma Gross Prod Report Detail related data in SAP. It comes under the package OIU_X5.

SAP OIUX5_OK_RPDT table

Table OIUX5_OK_RPDT technical data

TableOIUX5_OK_RPDT
Data storingTax 2.0 – Oklahoma Gross Prod Report Detail
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-TAX
SAP PackageOIU_X5
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Tax 2.0 – Oklahoma Gross Prod Report Detail Key Fields
    Its a key field.
  • .INCLUDE : Tax 2.0 – Oklahoma Gross Prod Report Summary Key Fields
    Its a key field.
  • RUN_ID : Tax Reporting – Run ID
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • TAXPAYER_NUMBER : Tax 2.0 – Oklahoma Company Reporting Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • PRODUCTION_DATE : Tax 2.0 – Oklahoma Production Date (YYMM)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • OK_PRODUCT_CODE : Tax 2.0 – Oklahoma Product Code
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 1
  • COUNTY : Tax 2.0 – Oklahoma County
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • PROD_PURC_IND : Tax Reporting – Producer/Purchaser Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • PUN : Tax 2.0 – Oklahoma Production Unit Number
    Its a key field. Its data type is CHAR (Character String) with field length 11
  • PROD_PURCH_NO : Tax 2.0 – Oklahoma Prod/Purch Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • GAS_CODE : Tax 2.0 – Oklahoma Gas Code
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 1
  • TIER_CATEGORY : Tax 2.0 – Oklahoma Tier Category
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 1
  • OIL_CLASS : Tax 2.0 – Oklahoma Oil Classification
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 1
  • NGPA_CD : Tax 2.0 OKGP – NGPA Code (Tax Incentive Rate Code)
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • REV_BOOK_ADJ_IND : Tax 2.0 – Reversal/Booking/Reversal Adjustment/Adjustment
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Tax 2.0 – Oklahoma Gross Prod Report Detail Non-Key Fields
  • GROSS_VOL : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • GROSS_VAL : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • BTU : Tax 2.0 – BTU
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • GRAVITY : Gravity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • TAX_REIMB : Tax Reporting – Tax Reimbursement
    Its data type is CURR (Currency Field) with field length 11
  • EXEMPT_CODE_1 : Tax 2.0 – Oklahoma Exempt Code 1
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • EXE_DEC_EQUIV_1 : Tax 2.0 – Oklahaoma Exempt Decimal Equivalent 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXE_ENTTYPE1_VOL : Tax 2.0 – Exempt Entity Type 1 Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • EXE_ENTTYPE1_VAL : Tax 2.0 – Exempt Entity Type 1 Value
    Its data type is CURR (Currency Field) with field length 11
  • EXEMPT_CODE_2 : Tax 2.0 – Oklahoma Exempt Code 2
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • EXE_DEC_EQUIV_2 : Tax 2.0 – Oklahaoma Exempt Decimal Equivalent 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXE_ENTTYPE2_VOL : Tax 2.0 – Exempt Entity Type 2 Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • EXE_ENTTYPE2_VAL : Tax 2.0 – Exempt Entity Type 2 Value
    Its data type is CURR (Currency Field) with field length 11
  • EXEMPT_CODE_3 : Tax 2.0 – Oklahoma Exempt Code 3
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • EXE_DEC_EQUIV_3 : Tax 2.0 – Oklahaoma Exempt Decimal Equivalent 3
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXE_ENTTYPE3_VOL : Tax 2.0 – Exempt Entity Type 3 Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • EXE_ENTTYPE3_VAL : Tax 2.0 – Exempt Entity Type 3 Value
    Its data type is CURR (Currency Field) with field length 11
  • EXEMPT_CODE_4 : Tax 2.0 – Oklahoma Exempt Code 4
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • EXE_DEC_EQUIV_4 : Tax 2.0 – Oklahaoma Exempt Decimal Equivalent 4
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXE_ENTTYPE4_VOL : Tax 2.0 – Exempt Entity Type 4 Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • EXE_ENTTYPE4_VAL : Tax 2.0 – Exempt Entity Type 4 Value
    Its data type is CURR (Currency Field) with field length 11
  • EXEMPT_CODE_5 : Tax 2.0 – Oklahoma Exempt Code 5
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • EXE_DEC_EQUIV_5 : Tax 2.0 – Oklahaoma Exempt Decimal Equivalent 5
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXE_ENTTYPE5_VOL : Tax 2.0 – Exempt Entity Type 5 Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • EXE_ENTTYPE5_VAL : Tax 2.0 – Exempt Entity Type 5 Value
    Its data type is CURR (Currency Field) with field length 11
  • EXEMPT_09_VAL : Tax 2.0 – Exempt Entity Type 09 Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • TAX_VOL : Taxable Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • TAX_VAL : Taxable Value
    Its data type is CURR (Currency Field) with field length 11
  • GP_TAX_AMT : Tax 2.0 – Gross Production Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • PE_TAX_AMT : Tax 2.0 – Petroleum Excise Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • SEC_GEO_DESC : Tax 2.0 – Oklahoma County Name
    Its data type is CHAR (Character String) with field length 30
  • TAXPAYER_NAME : Tax 2.0 – Oklahoma Company Name
    Its data type is CHAR (Character String) with field length 30
  • FEIN_SSN : Tax 2.0 – FEIN/SSN
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • MULTI_COUNTIES : Tax 2.0 – Multiple Counties?
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Creator and date/time created
  • 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

    • OIUX5_OK_RPDT related tables

    • OIUX5_OK_REVSTG : Tax 2.0 – Oklahoma Tax Reversals Staging
    • OIUX5_OK_SOL : Tax 2.0 – Oklahoma Statute of Limitation
    • OIUX5_OK_RPDT : Tax 2.0 – Oklahoma Gross Prod Report Detail
    • OIUX5_OK_REJT : Tax 2.0 – Oklahoma Reject Code Text
    • OIUX5_OK_PRDTC : Tax 2.0 – Oklahoma PRA Detail Tax Transactions Multi Count
    • OIUX5_OK_ASU_HD : Tax 2.0 – Oklahoma Auto Suspend Header
    • OIUX5_OK_EXEXRF : Tax 2.0 – Oklahoma Exempt Code Xref
    • OIUX5_OK_MASTER : Tax 2.0 – Oklahoma Master Data
    • OIUX5_OK_TAXSTG : Tax 2.0 – Oklahoma Tax Transactions Staging
    • OIUX5_OK_TAX_RT : Tax 2.0 – Oklahoma Tax Rates
    • OIUX5_OK_CONFIG : Tax 2.0 – Oklahoma Exempt Decimal Configuration
    • OIUX5_OK_PRDT : Tax 2.0 – Oklahoma PRA Detail Tax Transactions
    • OIUX5_OOSWO : Tax 2.0 – Out Of Statute Write Off
    • OIUX5_OK_OOSTXN : Tax 2.0 – Oklahoma Out Of Statute Transactions
    • OIUX5Y_OK_MSTCNT : Tax 2.0 – Oklahoma Master Data Counties
    • OIUX5_OK_REJ : Tax 2.0 – Oklahoma Reject Codes
    • OIUX5_OK_TAXTXN : Tax 2.0 – Oklahoma Tax Transactions
    • OIUX5_OK_PDCXRF : Tax 2.0 – Oklahoma Product Code Xref
    • OIUX5_OK_SOLEHD : Tax 2.0 – Statute of Limitation Exception Header
    • OIUX5_OK_ZVOL : Tax 2.0 – Oklahoma Zero Volume Reporting Master

    OIUX5_OK_RPDT related transaction codes under SAP package OIU_X5

    • S_YEP_55000005 : IMG activity: V_OIUX5_OK_REJC
    • S_YEP_55000004 : IMG activity: V_OIUX5_OK_REJ
    • O3UX5_OK_PUN_EDIT : Tax 2.0 OK – PUN Edit Report
    • S_YEP_55000002 : IMG activity: OIUX5_OK_EXEXRF
    • O3UX5_OK_ASU : Maintain Auto-Suspension Data
    • O3UX5_OK_MASTER : Oklahoma Master Data Maintenance
    • O3UX5_DISP_OK_TAXHST : Up-to-Date Reported Transactions
    • O3UX5_UPD_OK_OOS_WO : Out-of-Statute Write-Off Maintenance
    • O3UX5_OK_TAX_RT : Tax 2.0 – OKGP Tax Rate Maintenance
    • O3UX5_UPD_OK_TAXTXN : Maintain User Tax Transactions
    • O3UX5_DISP_OK_RPVAR : Oklahoma Tax Variance Report
    • S_YEP_55000001 : IMG activity: OIUX5_OK_PDCXRF
    • O3UX5_UPD_OK_TAXHST : Update Oklahoma Tax History
    • S_YEP_55000007 : IMG activity: OIUX5_SN_NR_OK
    • O3UX5_OK_ZVOL : Maintain Oklahoma Zero Vol Reporting
    • O3UX5_DISP_OOSWO : List of Out-of-Statute Write-Offs
    • O3UX5_OK_SOL : Maintain Statute-of-Limitations Data
    • O3UX5_MIGRATION_002 : Oklahoma Migration Workbench
    • O3UX5_DISP_OK_TAXTXN : Oklahoma Tax Transactions
    • O3UX5_OK_BATXID : Oklahoma BA Tax ID Maintenance

    Related References

    Related Tutorials

    OIUX5_OK_RPSM SAP table for – Tax 2.0 – Oklahoma Gross Prod Report Summary

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

    OIUX5_OK_PRDT SAP table for – Tax 2.0 – Oklahoma PRA Detail Tax Transactions

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

    OIUX5_OK_PRDTC SAP table for – Tax 2.0 – Oklahoma PRA Detail Tax Transactions Multi Count

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

    OIUX5_OK_CONFL SAP table for – Tax 2.0 – Oklahoma Exempt Decimal Conflict

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

    OIUX5_OK_TAXHSTC SAP table for – Tax 2.0 – Oklahoma Tax Transactions History Multi-Counties

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

    OIUX5_OK_TAXHST SAP table for – Tax 2.0 – Oklahoma Tax Transactions History

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

    OIUX5_OK_TAXTXN SAP table for – Tax 2.0 – Oklahoma Tax Transactions

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

    «
    »