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