OIUY3_TX_ROYTXNA SAP table for - Royalty 2.0 - TX GLO

Table of Contents

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

Table	OIUY3_TX_ROYTXNA
Data storing	Royalty 2.0 – TX GLO – Royalty Transactions (Allocated)
Module	IS-OIL
Sub Module	IS-OIL-PRA-REP-ROY
SAP Package	OIU_Y3
Delivery Class	A – Application table (master and transaction data)
Component	IS-OIL
Table Category	TRANSP

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

OIUY3_TX_ROYTXNA related tables

OIUY3_TX_PRDT : Royalty 2.0 – TX GLO – Royalty PRA Details
OIUY3_TX_ASU_HD : Royalty 2.0 – TX GLO/TAMU – Auto Suspend Header
OIUY3_TX_REVTXN : Royalty 2.0 – TX GLO – Royalty Reversals
OIUY3_TX_SOLEHD : Royalty 2.0 – TX GLO/TAMU SOL Exception Header
OIUY3_TX_GLO2_TH : Royalty 2.0 – TX GLO/TAMU – GLO2 Threshold
OIUY3_TX_OOSTXN : Royalty 2.0 – TX GLO – Out of Statute Royalty Transactions
OIUY3_TX_BAXRF : Royalty 2.0 – TX GLO/TAU – BA Xref
OIUY3_TX_ROYTXN : Royalty 2.0 – TX GLO – Royalty Transactions
OIUY3_TX_REJT : Royalty 2.0 – Texas GLO – Reject Code Text
OIUY3_MIG_DN : Royalty 2.0 – TX GLO/A&M – Migration – DNs
OIUY3Y_TX_RRC : Royalty 2.0 – TX GLO/TAMU – RRC Master PPN
OIUY3_TX_OOSWO : Royalty 2.0 – Texas GLO Out Of Statute Write Off
OIUY3_TX_ROYHSTA : Royalty 2.0 – TX GLO – Royalty Trans History (Allocated)
OIUY3_TX_UNIT : Royalty 2.0 – TX GLO – Unit Master
OIUY3_TX_ROYHST : Royalty 2.0 – TX GLO – Royalty Transaction History
OIUY3_TX_LEASE : Royalty 2.0 – TX GLO – Lease Master
OIUY3_TX_REVSTG : Royalty 2.0 – TX GLO – Royalty Reversals (Staging)
OIUY3_TX_ASU_DT : Royalty 2.0 – TX GLO/TAMU – Auto Suspend Detail
OIUY3_TX_SOLEDT : Royalty 2.0 – TX GLO/TAMU SOL Exception Detail
OIUY3_TX_ROYSTG : Royalty 2.0 – TX GLO – Royalty Transactions (Staging)

OIUY3_TX_ROYTXNA related transaction codes under SAP package OIU_Y3

O3UY3_TX_PDCXRF : Maintain Production Disposition XRef
O3UY3_TX_UNIT : Maintain Texas GLO/TAMU Unit Master
S_YEP_42000001 : IMG activity: OIUY3_SN_NR_TX
O3UY3_TX_MASTER : Maintain Texas GLO/TAMU Master Data
S_YEP_42000005 : IMG activity: V_OIUY3_RPT_CFG
O3UY3_TX_SOL : Maintain Texas GLO/TAMU SOL Master
O3UY3_UPD_TX_ROYHST : Update TX GLO/TAMU Royalty History
S_YEP_42000003 : IMG activity: V_OIUY3_TX_REJ
O3UY3_DISP_TX_ROYHST : Up-to-Date Reported Texas GLO Trans
O3UY3_UPD_TX_OOS_WO : TX GLO/TAMU Out-of-Statute Write-Off
S_YEP_42000002 : IMG activity: V_OIUY3_GRPPX
O3UY3_TX_BAXRF : Maintain Texas GLO/TAMU BA XRef
O3UY3_DISP_TX_ROYTXN : Display TX GLO/TAMU Royalty Trans
O3UY3_MIGRATION_OIL : TX GLO/TAMU Roy Oil Migration
O3UY3_TX_SOLE : Maintain TX GLO/TAMU SOL Exception
O3UY3_UPD_TX_ROYTXN : Maintain Texas GLO User Roy Trans
S_YEP_42000004 : IMG activity: V_OIUY3_TX_REJC
O3UY3_DISP_BAL_RPT : Texas GLO/TAMU Balancing Report
O3UY3_TX_RRC : Maintain Texas GLO/TAMU RRC Master
O3UY3_DISP_TX_OOSWO : List of Texas GLO OOS Write-Offs

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

Table OIUY3_TX_ROYTXNA technical data

SAP OIUY3_TX_ROYTXNA Table Fields

OIUY3_TX_ROYTXNA related tables

OIUY3_TX_ROYTXNA related transaction codes under SAP package OIU_Y3

Related References

About SAP

Most Popular

SAP Analytics & Administration

Useful References

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

Table OIUY3_TX_ROYTXNA technical data

SAP OIUY3_TX_ROYTXNA Table Fields

OIUY3_TX_ROYTXNA related tables

OIUY3_TX_ROYTXNA related transaction codes under SAP package OIU_Y3

Related References

Related Tutorials

About SAP

Most Popular

SAP Analytics & Administration

Useful References