OIUY3_TX_ROYTXNA SAP table for – Royalty 2.0 – TX GLO – Royalty Transactions (Allocated)

Here we would like to draw your attention to OIUY3_TX_ROYTXNA 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). OIUY3_TX_ROYTXNA is a SAP standard transp table used for storing Royalty 2.0 – TX GLO – Royalty Transactions (Allocated) related data in SAP. It comes under the package OIU_Y3.

SAP OIUY3_TX_ROYTXNA table

Table OIUY3_TX_ROYTXNA technical data

TableOIUY3_TX_ROYTXNA
Data storingRoyalty 2.0 – TX GLO – Royalty Transactions (Allocated)
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-ROY
SAP PackageOIU_Y3
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Royalty 2.0 – TX GLO – Royalty Transactions Key Fields
    Its a key field.
  • .INCLUDE : Royalty 2.0 – TX GLO – Royalty Reversal Key Fields
    Its a key field.
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SALES_DT : Sales Date / Month
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PDCD : Full three char. product code (Major and Detail Products)
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • WL_NO : Well ID number
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • WC_NO : Well Completion Number
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • MP_NO : Measurement point number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • VNAME : Joint venture
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • DOI_NO : Division of interest (DOI)
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • DN_NO : Delivery network number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • CT_NO : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • VL_TYPE_CD : Volume type code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • OWNER_IDENTIFIER : Royalty 2.0 – Owner Identifier
    Its a key field. Its data type is CHAR (Character String) with field length 22
  • LEASE_IDENTIFIER : Royalty 2.0 – TX GLO/TAMU – Lease Identifier
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • REV_BOOK_ADJ_IND : Royalty 2.0 – TX – Reversal/Booking/Reversal Adjustment/Adjs
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Royalty 2.0 – TX GLO – Royalty Transactions Non-Key Fields
  • UNIT_VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • ACCT_NO : Account ID
    Its data type is CHAR (Character String) with field length 10
  • CHV_RPT_CD : Template cost center
    Its data type is CHAR (Character String) with field length 10
  • UOM : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • PS_BASE_QY : Pressure Base Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • GRV_QY : Gravity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • PAY_CD : Pay Code
    Its data type is CHAR (Character String) with field length 2
  • OWN_INT_DECM_QY : Royalty 2.0 – TX GLO – Owner NRI
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OWN_BAL_DECM_QY : Owner Disbursement (Balance) Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • PU_NO : Purchaser ID
    Its data type is CHAR (Character String) with field length 6
  • PU_SEQ_NO : Purchaser Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • AFFILIATED_SALE : Royalty 2.0 – TX GLO – Affiliated Sale Indicator
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Royalty 2.0 – TX GLO – Royalty Transactions Non-Key Vol/Val
  • GR_QY : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • GR_AM : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • TXN_VAL_AM : Royalty 2.0 – TX GLO – Owner Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • TRANS_AM : JE Transaction Amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • TRANS_QY : JE Transaction Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • MMBTU_OVL_AM : Owner MMBTU
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PLT_VL_GRED_AM : Gross Plant Volume Reduction amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PLT_VL_ORED_AM : Owner Plant Volume Reduction amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • DED_RMB_AM : Deduction/Reimbursement Amount
    Its data type is CURR (Currency Field) with field length 11
  • NET_TRANSP_AM : Marketing Cost
    Its data type is CURR (Currency Field) with field length 11
  • NET_OTH_MK_AM : Marketing Cost
    Its data type is CURR (Currency Field) with field length 11
  • TAX_RMB_AM : Tax Reimbursement Amount
    Its data type is CURR (Currency Field) with field length 11
  • BTU_QY : BTU Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • .INCLUDE : Royalty 2.0 – TX GLO – Royalty Transactions Non-Key Validate
  • ORIGINAL_REPORT : Royalty 2.0 – TX GLOTAMU – Original Report
    Its data type is CHAR (Character String) with field length 1
  • GAS_DISP_CODE : Royalty 2.0 – TX GLO/TAMU – Royalty Gas Disposition Code
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • MASTER_LEVEL : Royalty 2.0 – TX GLO – Master Level
    Its data type is CHAR (Character String) with field length 1
  • RRC_LEVEL : Royalty 2.0 – TX GLO – RRC Master Level
    Its data type is CHAR (Character String) with field length 1
  • PURCHASER_ID : Royalty 2.0 – Texas GLO/TAMU – Purchaser ID
    Its data type is NUMC (Character String with Digits Only) with field length 11
  • OPERATOR_ID : Royalty 2.0 – TX GLO – Operator ID
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Royalty 2,.0 – TX GLO/TAMU – Master Sub Key
  • GLO_LEASE : Royalty 2.0 – TX GLO/TAMU Lease
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • GLO_UNIT_NO : Royalty 2.0 – Texas GLO/TAMU – Unit Number
    Its data type is CHAR (Character String) with field length 4
  • ROYALTY_DECIMAL : Royalty 2.0 – Texas GLO – Royalty Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • UNIT_VNAME_FLAG : Roy 2.0 – Texas GLO/TAMU – Unit Venture
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Royalty 2.0 – TX GLO/TAMU – Master Non-Key Fields
  • ALLOC_PERCENT : Royalty 2.0 – TX GLO/TAMU – Allocation Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • TRACT_PART_FACT : Royalty 2.0 – Texas GLO – Tract Participation Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • .INCLUDE : Royalty 2.0 – TX GLO/TAMU – RRC Master Non-Key Fields
  • RRC_DISTRICT_NO : Royalty 2.0 – TX GLO/TAMU – District Number
    Its data type is CHAR (Character String) with field length 2
  • RRC_OIL_LEASE_NO : Royalty 2.0 – TX GLO/TAMU – RRC Oil Lease Number
    Its data type is CHAR (Character String) with field length 5
  • RRC_GAS_WELL_ID : Royalty 2.0 – TX GLO/TAMU – RRC Gas Well ID
    Its data type is CHAR (Character String) with field length 6
  • RRC_DRILL_PERMIT : Royalty 2.0 – TX GLO/TAMU – RRC Drilling Permit
    Its data type is CHAR (Character String) with field length 6
  • RRC_FIELD_NAME : Royalty 2.0 – TX GLO/TAMU – RRC Field Name
    Its data type is CHAR (Character String) with field length 32
  • RRC_LEASE_NAME : Royalty 2.0 – TX GLO/TAMU – RRC Lease Name
    Its data type is CHAR (Character String) with field length 32
  • PROP_ALIAS_NAME : Royalty 2.0 – TX GLO/TAMU – Property Alias Name
    Its data type is CHAR (Character String) with field length 32
  • OPERATOR_NO : Royalty 2.0 – TX GLO/TAMU – Operator Number
    Its data type is CHAR (Character String) with field length 6
  • OPERATOR_SEQ_NO : Royalty 2.0 – TX GLO – Operator Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • PAY_REPORT_FLAG : Royalty 2.0 – TX GLO/TAMU – Pay/Report Flag
    Its data type is CHAR (Character String) with field length 1
  • DOC_NO : Val. document number
    Its data type is CHAR (Character String) with field length 20
  • DOC_YEAR : Document year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • INTERFACE_FL : Royalty 2.0 – TX GLO – Interface Flag
    Its data type is CHAR (Character String) with field length 1
  • OPTION1 : CSI Char-field of length 200
    Its data type is CHAR (Character String) with field length 1
  • OPTION2 : CSI Char-field of length 200
    Its data type is CHAR (Character String) with field length 1
  • OPTION3 : CSI Char-field of length 200
    Its data type is CHAR (Character String) with field length 1
  • REFERENCE_RUN_ID : Tax Reporting – Run ID
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • REJ_SUSP_IND : Tax Reporting – Reject/Suspend Indicator
    Its data type is CHAR (Character String) with field length 1
  • REJ_CD : Royalty 2.0 – Texas GLO – Reject Code
    Its data type is CHAR (Character String) with field length 2
  • .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