OIUY3_TX_ROYTXNA SAP (Royalty 2.0 - TX GLO - Royalty Transactions (Allocated)) Table details

Dictionary Type: Table
Description: Royalty 2.0 - TX GLO - Royalty Transactions (Allocated)




ABAP Code to SELECT data from OIUY3_TX_ROYTXNA
Related tables to OIUY3_TX_ROYTXNA
Access table OIUY3_TX_ROYTXNA




Table field list including key, data, relationships and ABAP select examples

OIUY3_TX_ROYTXNA is a standard SAP Table which is used to store Royalty 2.0 - TX GLO - Royalty Transactions (Allocated) data and is available within R/3 SAP systems depending on the version and release level.

The OIUY3_TX_ROYTXNA table consists of various fields, each holding specific information or linking keys about Royalty 2.0 - TX GLO - Royalty Transactions (Allocated) data available in SAP. These include BUKRS (Company Code), SALES_DT (Sales Date / Month), PDCD (Full three char. product code (Major and Detail Products)), WL_NO (Well ID number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIUY3_TX_ROYTXNA table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4OIU_CM_COMPCBUKRSBUKC_T001
SALES_DTSales Date / Month OIU_SALE_DTDATS8DATUM
PDCDFull three char. product code (Major and Detail Products) OIU_FULL_PD_CDCHAR3OIUX3_PDCDOIU_FULL_PD_CD
WL_NOWell ID number OIU_WL_NOCHAR15OIU_PR_WELLALPHAOIU_WL_NOOIU_WELLH_OIU_PR_WELL
WC_NOWell Completion Number OIU_WC_NOCHAR5OIU_PR_WCALPHAOIU_WC_NOOIU_WCH_OIU_PR_WC
MP_NOMeasurement point number OIU_MP_NOCHAR20OIU_PR_MPALPHAOIU_MP_NOOIU_MPH_OIU_PR_MP
VNAMEJoint Venture JV_NAMECHAR6OIU_DO_JVALPHAJV_NAMEJVV
DOI_NODivision of interest (DOI) OIU_DOI_NOCHAR5OIU_DO_DIALPHAOIU_DOI_NOOIU_DOIH_OIU_DO_DI
DN_NODelivery network number OIU_DN_NOCHAR20OIU_PR_DNALPHAOIU_DN_NOOIU_DNH_OIU_PR_DN
CT_NOContract Number OIU_CT_NOCHAR10OIU_RV_CTALPHAOIUCM_CONTRACT_NUMBEROIU_CID
VL_TYPE_CDVolume type code OIU_VT_CDCHAR2OIU_PR_VLTYPOIU_VL_TYPE_CDOIU_VTCD
OWNER_IDENTIFIERRoyalty 2.0 - Owner Identifier OIUYC_OWNER_IDENTIFIERCHAR22
LEASE_IDENTIFIERRoyalty 2.0 - TX GLO/TAMU - Lease Identifier OIUY3_TX_LEASE_IDENTIFIERNUMC6
REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs OIUY3_REV_BOOK_REVADJ_ADJ_INDCHAR1OIUY3_REV_BOOK_REVADJ_ADJ_IND
UNIT_VNAMEJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
ACCT_NOAccount ID OIUH_ACCTIDCHAR10CHAR10
CHV_RPT_CDTemplate cost center RKOSTLCHAR10Assigned to domainALPHAKOSTLRKOS
UOMMeasurement unit OIU_MEAS_UUNIT3T006CUNITMEINS
PS_BASE_QYPressure Base Quantity OIUH_PRESSURE_BASEDEC6(3) OIUH_DEC6_3
GRV_QYGravity OIUH_GRAVITYDEC3(1) OIUH_DEC3_1
PAY_CDPay Code OIUH_PAY_CODECHAR2CHAR2
OWN_INT_DECM_QYRoyalty 2.0 - TX GLO - Owner NRI OIUY3_TX_OWNER_NRIDEC9(8) OIU_PERCENT98
OWN_BAL_DECM_QYOwner Disbursement (Balance) Decimal OIUH_OWNER_DISBUR_DECIMALDEC9(8) OIUH_DEC9_8
PU_NOPurchaser ID OIUH_PURCHASERCHAR6CHAR6
PU_SEQ_NOPurchaser Sequence Number OIUH_PURCHASER_SEQUENCE_NUMBERCHAR2CHAR2
AFFILIATED_SALERoyalty 2.0 - TX GLO - Affiliated Sale Indicator OIUY3_TX_AFFILIATED_SALE_INDCHAR1YESNO
GR_QYGross Volume OIUX3_GROSS_VOLUMEDEC11(2) OIUX3_SIGNED_DEC_11_2
GR_AMGross Value OIUX3_GROSS_VALUECURR11(2) OIUX3_SIGNED_CURR_11_2
TXN_VAL_AMRoyalty 2.0 - TX GLO - Owner Gross Value OIUY3_TX_OWNER_GROSS_VALUECURR11(2) OIUX3_SIGNED_CURR_11_2
TRANS_AMJE Transaction Amount OIUX3_TRANS_AMTDEC11(2) OIUX3_SIGNED_DEC_11_2
TRANS_QYJE Transaction Quantity OIUH_TRANS_QUANTITYDEC11(2) OIUH_DEC11_2
MMBTU_OVL_AMOwner MMBTU OIUH_OWNER_MMBTUDEC11(2) OIUH_DEC11_2
PLT_VL_GRED_AMGross Plant Volume Reduction amount OIUH_GROSS_PLANT_VOLUME_RED_AMDEC11(2) OIUH_DEC11_2
PLT_VL_ORED_AMOwner Plant Volume Reduction amount OIUH_OWNER_PLANT_VOLUME_RED_AMDEC11(2) OIUH_DEC11_2
DED_RMB_AMDeduction/Reimbursement Amount OIUH_DED_REIMB_AMOUNTCURR11(2) OIUH_CURR11_2
NET_TRANSP_AMMarketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
NET_OTH_MK_AMMarketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
TAX_RMB_AMTax Reimbursement Amount OIUH_TAX_REIMBURSEMENT_AMTCURR11(2) OIUH_CURR11_2
BTU_QYBTU Quantity OIUH_BTU_QUANTITYDEC7(3) OIUH_DEC7_3
ORIGINAL_REPORTRoyalty 2.0 - TX GLOTAMU - Original Report OIUY3_TX_ORIGINAL_REPORTCHAR1OIUY3_TX_ORIGINAL_REPORT
GAS_DISP_CODERoyalty 2.0 - TX GLO/TAMU - Royalty Gas Disposition Code OIUY3_TX_GLO_ROY_GAS_DISP_CODENUMC2OIUY3_TX_GLO_ROY_GAS_DISP_CODE
MASTER_LEVELRoyalty 2.0 - TX GLO - Master Level OIUY3_TX_MASTER_LEVELCHAR1
RRC_LEVELRoyalty 2.0 - TX GLO - RRC Master Level OIUY3_TX_RRC_LEVELCHAR1
PURCHASER_IDRoyalty 2.0 - Texas GLO/TAMU - Purchaser ID OIUY3_TX_PURCHASER_IDNUMC11
OPERATOR_IDRoyalty 2.0 - TX GLO - Operator ID OIUY3_TX_OPERATOR_IDCHAR10OIUY3_TX_ID
GLO_LEASERoyalty 2.0 - TX GLO/TAMU Lease OIUY3_TX_GLO_LEASENUMC6OIUY3_TX_LEASEOIUY3_TX_GLO_LEASE
GLO_UNIT_NORoyalty 2.0 - Texas GLO/TAMU - Unit Number OIUY3_TX_GLO_UNIT_NOCHAR4OIUY3_TX_UNIT
ROYALTY_DECIMALRoyalty 2.0 - Texas GLO - Royalty Decimal OIUY3_TX_ROYALTY_DECIMALDEC9(8) OIU_PERCENT98
UNIT_VNAME_FLAGRoy 2.0 - Texas GLO/TAMU - Unit Venture OIUY3_TX_UNIT_VNAMECHAR1YESNO
ALLOC_PERCENTRoyalty 2.0 - TX GLO/TAMU - Allocation Percent OIUY3_TX_ALLOCATION_PERCENTDEC9(8) OIU_PERCENT98
TRACT_PART_FACTRoyalty 2.0 - Texas GLO - Tract Participation Factor OIUY3_TX_TRACT_PART_FACTORDEC9(8) OIU_PERCENT98
RRC_DISTRICT_NORoyalty 2.0 - TX GLO/TAMU - District Number OIUY3_TX_GLO_DISTRICT_NOCHAR2
RRC_OIL_LEASE_NORoyalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number OIUY3_TX_GLO_RRC_OIL_LEASE_NOCHAR5
RRC_GAS_WELL_IDRoyalty 2.0 - TX GLO/TAMU - RRC Gas Well ID OIUY3_TX_GLO_RRC_GAS_WELL_IDCHAR6
RRC_DRILL_PERMITRoyalty 2.0 - TX GLO/TAMU - RRC Drilling Permit OIUY3_TX_GLO_RRC_DRILLING_PERMCHAR6
RRC_FIELD_NAMERoyalty 2.0 - TX GLO/TAMU - RRC Field Name OIUY3_TX_GLO_RRC_FIELD_NAMECHAR32
RRC_LEASE_NAMERoyalty 2.0 - TX GLO/TAMU - RRC Lease Name OIUY3_TX_GLO_RRC_LEASE_NAMECHAR32
PROP_ALIAS_NAMERoyalty 2.0 - TX GLO/TAMU - Property Alias Name OIUY3_TX_GLO_PROP_ALIAS_NAMECHAR32
OPERATOR_NORoyalty 2.0 - TX GLO/TAMU - Operator Number OIUY3_OPERATOR_NUMBERCHAR6OIUH_CM_BAALPHAOIUCM_BUS_ASSOC
OPERATOR_SEQ_NORoyalty 2.0 - TX GLO - Operator Sequence Number OIUY3_OPERATOR_SEQUENCE_NUMBERCHAR2ALPHAOIUCM_SEQ_NO
PAY_REPORT_FLAGRoyalty 2.0 - TX GLO/TAMU - Pay/Report Flag OIUY3_TX_PAY_REPORT_FLAGCHAR1OIUY3_TX_PAY_REPORT_FLAG
DOC_NOVal. document number OIURV_DOCNRCHAR20Assigned to domainALPHAOIU_MP_NOOIU_DOCNR
DOC_YEARDocument year OIU_DOC_YEARNUMC4GJAHRGJAHROIU_DOC_YEAR
INTERFACE_FLRoyalty 2.0 - TX GLO - Interface Flag OIUY3_TX_INTERFACE_FLCHAR1OIUY3_TX_EXT_UPDATE
OPTION1 0
OPTION2 PPN Flag0
OPTION3 0
REFERENCE_RUN_IDRun ID of Tax Report OIUX3_RUN_IDNUMC10NUMC10
REJ_SUSP_INDRejection-Suspension Status OIUX3_REJECT_SUSPEND_INDCHAR1OIUX3_REJECT_SUSPEND_IND
REJ_CDRoyalty 2.0 - Texas GLO - Reject Code OIUY3_TX_REJECT_CODECHAR2Assigned to domainOIUY3_TX_REJECT_CODE
OIU_CRUSERName of Person who Created the Object ERNAMCHAR12USNAM
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP table OIUY3_TX_ROYTXNA using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIUY3_TX_ROYTXNA to SELECT all data from the table
DATA: WA_OIUY3_TX_ROYTXNA TYPE OIUY3_TX_ROYTXNA.

SELECT SINGLE *
FROM OIUY3_TX_ROYTXNA
INTO CORRESPONDING FIELDS OF WA_OIUY3_TX_ROYTXNA
WHERE...

How to access SAP table OIUY3_TX_ROYTXNA

Within an ECC or HANA version of SAP you can also view further information about OIUY3_TX_ROYTXNA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!