1. SAP Tutorial
  2. Oil & Gas

OIUREP_RTPEND SAP table for – MMS-2014 – Royalty Transaction Pending

Here we would like to draw your attention to OIUREP_RTPEND 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_RTPEND is a SAP standard transp table used for storing MMS-2014 – Royalty Transaction Pending related data in SAP. It comes under the package OIU_REP.

SAP OIUREP_RTPEND table

Table OIUREP_RTPEND technical data

TableOIUREP_RTPEND
Data storingMMS-2014 – Royalty Transaction Pending
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-ROY
SAP PackageOIU_REP
Delivery ClassL – Table for storing temporary data
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUREP_RTPEND 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_RTPEND table.

  • .INCLUDE : Production: MMS-2014 – Royalty Transactions Key Fields
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SALES_YEAR : MMS-2014 – Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • SALES_MONTH : MMS-2014 – Month
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • RTP_LINE_NUM : MMS-2014 – Line Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • .INCLUDE : Production: MMS-2014 – Royalty Transactions Non-Key Fields
  • PAYOR_NO : Production: MMS-2014 – Payor
    Its data type is CHAR (Character String) with field length 5
  • FED_INDIAN_CD : Production: MMS-2014 – Federal or Indian Code
    Its data type is CHAR (Character String) with field length 1
  • INDIAN_TRIBE_NO : Production: MMS-2014 – Indian Tribe Number
    Its data type is CHAR (Character String) with field length 2
  • API_WELL_NO : API well number
    Its data type is CHAR (Character String) with field length 12
  • API_WELL_CM_NO : API well completion number
    Its data type is CHAR (Character String) with field length 3
  • LEASE_NO : MMS-2014 – Lease Number
    Its data type is CHAR (Character String) with field length 11
  • AGREEMENT_NO : Production: MMS-2014 – Agreement Number
    Its data type is CHAR (Character String) with field length 11
  • MMS_PROD_CD : Production: MMS Product Code
    Its data type is CHAR (Character String) with field length 2
  • SALES_TYPE_CD : Production: MMS-2014 – Sales Type Code
    Its data type is CHAR (Character String) with field length 4
  • SALES_DATE : Sales Date / Month
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TRANS_CD : Production: MMS-2014 – Transaction Code
    Its data type is CHAR (Character String) with field length 2
  • PAY_METHOD_CD : Production: MMS-2014 – Payment Method Code
    Its data type is CHAR (Character String) with field length 1
  • WL_NO : Well ID number
    Its data type is CHAR (Character String) with field length 15
  • WC_NO : Well Completion Number
    Its data type is CHAR (Character String) with field length 5
  • VNAME : MMS-2014 – Venture
    Its data type is CHAR (Character String) with field length 6
  • DOI_NO : Division of interest (DOI)
    Its data type is CHAR (Character String) with field length 5
  • PU_NO : Purchaser
    Its data type is CHAR (Character String) with field length 10
  • PU_SEQ_NO : Purchasing Representative Interest Sequence No
    Its data type is CHAR (Character String) with field length 2
  • PU_AFFIL_FL : Production: MMS-2014 – Purchaser Affiliation Flag
    Its data type is CHAR (Character String) with field length 1
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • OWN_NO : PRA owner
    Its data type is CHAR (Character String) with field length 10
  • OWN_ISQ_NO : Owner Interest Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • CT_NO : Contract Number
    Its data type is CHAR (Character String) with field length 10
  • GL_ACCTID_NO : Account ID
    Its data type is CHAR (Character String) with field length 10
  • NWK_NO : Network Number
    Its data type is CHAR (Character String) with field length 4
  • SUB_NWK_NO : Sub Network Number
    Its data type is CHAR (Character String) with field length 4
  • INT_TYPE_CD : Interest Type Code
    Its data type is CHAR (Character String) with field length 2
  • INT_SEQ_NO : Interest Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • SALES_QY : Sales Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • SALES_QY_U : Production: MMS-2014 – Sales Qty Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SALES_GV_QY : Production: MMS-2014 – Sales Gravity Qty
    Its data type is QUAN (Quantity field) with field length 4
  • SALES_GV_QY_U : Production: MMS-2014 – Sales Gravity Qty Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SALES_BTU_QY : Production: MMS-2014 – Sales BTU Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • SALES_BTU_QY_U : Production: MMS-2014 – Sales BTU Qty Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SALES_PS_BASE_QY : Pressure Base
    Its data type is QUAN (Quantity field) with field length 13
  • SALES_PS_BASE_U : Pressure Base Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SALES_AMT : Production: MMS-2014 – Sales Amount
    Its data type is CURR (Currency Field) with field length 15
  • SALES_CUR : Production: MMS-2014 – Sales Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ROY_PR_ALW_AMT : Production: MMS-2014 – Royalty Value Prior to Allows. Amt
    Its data type is CURR (Currency Field) with field length 15
  • ROY_PR_ALW_CUR : Production: MMS-2014 – Royalty Value Prior to Allows. Curr
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TRNSP_ALW_DE_AMT : Production: MMS-2014 – Transportation Allowance Amount
    Its data type is CURR (Currency Field) with field length 15
  • TRNSP_ALW_DE_CUR : MMS-2014 – Transportation Allowance Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PROC_ALW_DE_AMT : Production: MMS-2014 – Manufacturing UOM Amount
    Its data type is CURR (Currency Field) with field length 15
  • PROC_ALW_DE_CUR : Production: MMS-2014 – Manufacturing UOM Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ROY_LS_ALLOW_AMT : Production: MMS-2014 – Royalty Value Less Allows. Amt
    Its data type is CURR (Currency Field) with field length 15
  • ROY_LS_ALLOW_CUR : Production: MMS-2014 – Royalty Value Less Allows Curr
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ROY_QY : Production: MMS-2014 – Royalty Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • ROY_QY_U : Production: MMS-2014 – Royalty Quantity Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DED_REMB_AMT : Production: MMS-2014 – Deduction Reimbursement Amount
    Its data type is CURR (Currency Field) with field length 15
  • DED_REMB_CUR : Production: MMS-2014 – Deduction Reimbursement Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TAX_AMT : Production: MMS-2014 – Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • TAX_CUR : Production: MMS-2014 – Tax Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TAX_REMB_AMT : Production: MMS-2014 – Tax Reimbursement Amount
    Its data type is CURR (Currency Field) with field length 15
  • TAX_REMB_CUR : Production: MMS-2014 – Tax Reimbursement Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • MMS_ROY_QY : Production: MMS-2014 – MMS Royalty Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • MMS_ROY_QY_U : Production: MMS-2014 – MMS Royalty Quantity Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MMS_PS_BASE_QY : Pressure Base
    Its data type is QUAN (Quantity field) with field length 13
  • MMS_PS_BASE_QY_U : Pressure Base Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MMS_ROY_AMT : MMS-2014 – JE Offset Amount
    Its data type is CURR (Currency Field) with field length 15
  • MMS_ROY_CUR : MMS-2014 – JE Offset Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • MMS_SA_QY : Production: MMS-2014 – MMS Sales Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • MMS_SA_QY_U : Production: MMS-2014 – MMS Sales Quantity Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MMS_SA_AMT : Production: MMS-2014 – MMS Sales Amount
    Its data type is CURR (Currency Field) with field length 15
  • MMS_SA_CUR : Production: MMS-2014 – MMS Sales Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • SUSPEND_RSN_CD : Suspense Reason Code
    Its data type is CHAR (Character String) with field length 3
  • ADJ_CD : Production: MMS-2014 – Adjustment Reason Code
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • ADJ_SA_QY : Production: MMS-2014 – Adjusted Sales Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • ADJ_SA_QY_U : Production: MMS-2014 – Adjusted Sales Quantity Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ADJ_ROY_QY : Production: MMS-2014 – Adjusted Royalty Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • ADJ_ROY_QY_U : Production: MMS-2014 – Adjusted Royalty Quantity Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ADJ_BTU_QY : Production: MMS-2014 – Adjusted BTU Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • ADJ_BTU_QY_U : Production: MMS-2014 – Adjusted BTU Quantity Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • GAS_MMBTU_QY : Production: MMS-2014 – Gas MMBTU Qty
    Its data type is QUAN (Quantity field) with field length 13
  • GAS_MMBTU_QY_U : Production: MMS-2014 – Gas MMBTU Qty Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • HISTORY_FL : Production: MMS-2014 – History Flag
    Its data type is CHAR (Character String) with field length 1
  • REPORT_PART_FAC : Production: MMS-2014 – Report Participation Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • TRIBAL_ALLOT_CD : Production: MMS-2014 – Tribal/Allottee Code
    Its data type is CHAR (Character String) with field length 1
  • COMP_ROY_FL : Production: MMS-2014 – Compensatory Royalty Flag
    Its data type is CHAR (Character String) with field length 1
  • ROY_IN_KIND_FL : Production: MMS-2014 – Royalty In Kind Flag
    Its data type is CHAR (Character String) with field length 1
  • PAY_CD : Production: MMS-2014 – Payment Code
    Its data type is CHAR (Character String) with field length 2
  • EXTRACTED_FL : MMS-2014: Extracted
    Its data type is CHAR (Character String) with field length 1
  • EXTRACT_RUN_TYPE : Defines whether the run is direct pay or not
    Its data type is CHAR (Character String) with field length 1
  • MANUAL_CREATE_FL
    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
  • .INCLUDE : Change Username & Timestamp
  • CHANGE_USER : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • CHANGE_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

    • OIUREP_RTPEND related tables

    • OIUREP_COMN_KEYS : Reg.Reporting – Field description for COMN table keys
    • OIUREP_HISTCNTRL : Regulatory Reporting History Control table
    • OIUREP_REG_HIST : Reporting history (System table INDX)
    • OIUREP_KEY_XREFD : Regulatory Reporting SAP Key Cross Reference Detail
    • OIUREP_CODE_VALS : Code Values available for customizing Reg Reporting
    • OIUREP_VOLHIST : Reported Volume Data by Reporting Entities
    • OIUREP_ROY_AGY : Reporting Agencies for Tax and Royalty
    • OIUREP_WCPAYXREF : MMS-2014 – Well Completion / Payor XRef
    • OIUREP_AGY_VLTP : Agency defined Volume Types
    • OIUREP_VALTABCTX : Reporting general value table – Customizing
    • OIUREP_LGL_RPTTX : Text Table for Legal Reports (Tax and Royalty)
    • OIUREP_ROYHIST : Reported Royalty and Volume Data by Reporting Entities
    • OIUREP_MRT_HIST : MMS-2014 MMS Royalty Transaction Processed History
    • OIUREP_VOL_DATA : Reported Volume Data by Reporting Entities
    • OIUREP_CODE_COMN : Common table for converting SAP codes to Agency codes
    • OIUREP_CODE_CMLB : Regulatory Reporting Common Table List Box Setup
    • OIUREPP_SALETYPE : MMS-2014 – Sales Type PPA
    • OIUREP_GEN_DATA : Reg. Reporting – Generic Transactional data
    • OIUREP_CODE_FLDT : Descriptions for Code Fields
    • OIUREP_MMS_REAS : MMS Well Status / Reason Code Combinations (OGOR-A)

    OIUREP_RTPEND related transaction codes under SAP package OIU_REP

    • S_SO7_65001107 : Generated Text
    • S_SOG_81000124 : IMG activity: OIUREP_MMS_2014_BADI
    • O3UREP_MASTER : Regulatory Reporting Master Data
    • O3UREP_ROY_BASEDATA : Royalty base data maintenance
    • S_SO7_65001103 : Generated Text
    • S_SOG_81000029 : IMG activity: SIMG_OIUREP_013
    • O3UREP_MMS_REJECTS : MMS Extraction Rejects Report
    • S_SO7_65001152 : Generated Text
    • S_SO7_65001264 : Generated Text
    • S_SO7_65001144 : Generated Text
    • S_SOG_81000123 : IMG activity: SIMG_OIUREP_SUBMIT
    • S_SO7_65001143 : Generated Text
    • O3UREP_OPERATOR : Regulatory Reporting Setup
    • S_SO7_65001105 : Generated Text
    • S_SO7_65001114 : Generated Text
    • S_SO7_65001132 : Generated Text
    • S_SO7_65001116 : Generated Text
    • S_SO7_65001135 : Generated Text
    • S_SOG_81000026 : IMG activity: OIUREP_2014_CONFIG
    • S_SOG_81000017 : Generated Text

    Related References

    Related Tutorials

    OIUREP_MRT_PEND SAP table for – MMS-2014 MMS Royalty Transaction Processed – Pending

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

    OIUREP_RT_HIST SAP table for – MMS-2014 – Royalty Transaction (Pending) History

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

    OIUREP_MRT_HIST SAP table for – MMS-2014 MMS Royalty Transaction Processed History

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

    O3UREP_MMS_MRTPEND SAP tcode for – MMS Level Pending Royalty Trans Rep

    O3UREP_MMS_MRTPEND tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for MMS Level...

    OIUREP_MMS_REJS SAP table for – MMS-2014 – Extraction Rejects

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

    OIUREP_TRAN_FLDS SAP table for – MMS-2014 – Transaction Code Field Requirement XREF

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

    OIUREPP_SALETYPE SAP table for – MMS-2014 – Sales Type PPA

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

    «
    »