1. SAP Tutorial
  2. Oil & Gas

OIUY3_TX_PRDT SAP table for – Royalty 2.0 – TX GLO – Royalty PRA Details

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

SAP OIUY3_TX_PRDT table

Table OIUY3_TX_PRDT technical data

TableOIUY3_TX_PRDT
Data storingRoyalty 2.0 – TX GLO – Royalty PRA Details
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_PRDT 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_PRDT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RUN_ID : Tax Reporting – Run ID
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • .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
  • 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
  • OUT_OF_STATUTE : Tax Reporting – Out Of Statute Flag
    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
  • .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

    • OIUY3_TX_PRDT related tables

    • OIUY3_TX_PRDTA : Royalty 2.0 – TX GLO – Royalty PRA Details (Allocated)
    • OIUY3_TX_UNIT : Royalty 2.0 – TX GLO – Unit Master
    • OIUY3_TX_OPSL : Roy 2.0 TX – OPSL Summary Data for a Run
    • OIUY3_TX_MASTER : Royalty 2.0 – TX GLO/TAMU – Master Data
    • OIUY3_TX_GLO1_TH : Royalty 2.0 – TX GLO/TAMU – GLO1 Threshold
    • OIUY3Y_TX_RRC : Royalty 2.0 – TX GLO/TAMU – RRC Master PPN
    • OIUY3_TX_PDCXRF : Royalty 2.0 – TX GLO/TAMU – Production Disposition XRef
    • OIUY3_TX_SOLEDT : Royalty 2.0 – TX GLO/TAMU SOL Exception Detail
    • OIUY3_TX_ROYHSTA : Royalty 2.0 – TX GLO – Royalty Trans History (Allocated)
    • OIUY3_TX_ROYSTG : Royalty 2.0 – TX GLO – Royalty Transactions (Staging)
    • OIUY3_TX_OOSHST : Royalty 2.0 – TX – Out of Statute Royalty Transaction Hist
    • OIUY3_TX_ROYTXNA : Royalty 2.0 – TX GLO – Royalty Transactions (Allocated)
    • OIUY3_TX_RDCXRF : Royalty 2.0 – TX GLO/TAMU – Royalty Disposition XRef
    • OIUY3_TX_OOSTXN : Royalty 2.0 – TX GLO – Out of Statute Royalty Transactions
    • OIUY3_TX_ROYHST : Royalty 2.0 – TX GLO – Royalty Transaction History
    • OIUY3_TX_ASU_DT : Royalty 2.0 – TX GLO/TAMU – Auto Suspend Detail
    • OIUY3Y_TX_MASTER : Royalty 2.0 – TX GLO/TAMU – Master Data PPN
    • OIUY3_TX_RPODT : Royalty 2.0 – TX GLO/TAMU – Oil Report
    • OIUY3_TX_GLO2_TH : Royalty 2.0 – TX GLO/TAMU – GLO2 Threshold
    • OIUY3_TX_PRDT : Royalty 2.0 – TX GLO – Royalty PRA Details

    OIUY3_TX_PRDT related transaction codes under SAP package OIU_Y3

    • S_YEP_42000005 : IMG activity: V_OIUY3_RPT_CFG
    • O3UY3_TX_OWNOVR : Maintain TX GLO/TAMU Own Lvl Rpt Ovr
    • O3UY3_TX_MASTER : Maintain Texas GLO/TAMU Master Data
    • O3UY3_DISP_BAL_RPT : Texas GLO/TAMU Balancing Report
    • O3UY3_UPD_TX_ROYTXN : Maintain Texas GLO User Roy Trans
    • O3UY3_DISP_TX_ROYTXN : Display TX GLO/TAMU Royalty Trans
    • O3UY3_UPD_TX_ROYHST : Update TX GLO/TAMU Royalty History
    • O3UY3_UPD_TX_OOS_WO : TX GLO/TAMU Out-of-Statute Write-Off
    • S_YEP_42000001 : IMG activity: OIUY3_SN_NR_TX
    • O3UY3_MIGRATION_GAS : TX GLO/TAMU Roy Gas Migration
    • O3UY3_TX_BAXRF : Maintain Texas GLO/TAMU BA XRef
    • O3UY3_DISP_TX_ROYHST : Up-to-Date Reported Texas GLO Trans
    • O3UY3_TX_UNIT : Maintain Texas GLO/TAMU Unit Master
    • O3UY3_TX_SOL : Maintain Texas GLO/TAMU SOL Master
    • S_YEP_42000002 : IMG activity: V_OIUY3_GRPPX
    • O3UY3_MIGRATION_OIL : TX GLO/TAMU Roy Oil Migration
    • O3UY3_DISP_PAY_RECON : Texas GLO/TAMU Payables Recon
    • O3UY3_DISP_TX_RPTVAR : TX GLO/TAMU Royalty Variance Report
    • O3UY3_TX_ASU : Maintain Texas GLO/TAMU ASU Master
    • O3UY3_TX_RDCXRF : Maintain Royalty Disposition XRef

    Related References

    Related Tutorials

    OIUY3_TX_PRDTA SAP table for – Royalty 2.0 – TX GLO – Royalty PRA Details (Allocated)

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

    OIUY3_TX_RPODT SAP table for – Royalty 2.0 – TX GLO/TAMU – Oil Report

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

    OIUY3_TX_INTSTG SAP table for – Royalty 2.0 – TX GLO – Royalty Trans Interface Staging

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

    OIUY3_TX_OOSTXN SAP table for – Royalty 2.0 – TX GLO – Out of Statute Royalty Transactions

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

    OIUY3_TX_ROYHSTA SAP table for – Royalty 2.0 – TX GLO – Royalty Trans History (Allocated)

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

    OIUY3_TX_ROYHST SAP table for – Royalty 2.0 – TX GLO – Royalty Transaction History

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

    OIUY3_TX_ROYTXN SAP table for – Royalty 2.0 – TX GLO – Royalty Transactions

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

    «
    »