OIUY3_TX_RPODT SAP (Royalty 2.0 - TX GLO/TAMU - Oil Report) Table details

Dictionary Type: Table
Description: Royalty 2.0 - TX GLO/TAMU - Oil Report




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




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

OIUY3_TX_RPODT is a standard SAP Table which is used to store Royalty 2.0 - TX GLO/TAMU - Oil Report data and is available within R/3 SAP systems depending on the version and release level.

The OIUY3_TX_RPODT table consists of various fields, each holding specific information or linking keys about Royalty 2.0 - TX GLO/TAMU - Oil Report data available in SAP. These include RUN_ID (Run ID of Tax Report), PROD_YEAR_MO (Royalty 2.0 - Texas GLO/TAMU - Production Year/Month YYYYMM), GLO_LEASE (Royalty 2.0 - TX GLO/TAMU Lease), RRC_DISTRICT_NO (Royalty 2.0 - TX GLO/TAMU - District 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_RPODT 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
RUN_IDRun ID of Tax Report OIUX3_RUN_IDNUMC10NUMC10
PROD_YEAR_MORoyalty 2.0 - Texas GLO/TAMU - Production Year/Month YYYYMM OIUY3_TX_PROD_YEAR_MOACCP6PERIOIU_PROD_MONTH
GLO_LEASERoyalty 2.0 - TX GLO/TAMU Lease OIUY3_TX_GLO_LEASENUMC6OIUY3_TX_LEASEOIUY3_TX_GLO_LEASE
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
PURCHASER_IDRoyalty 2.0 - Texas GLO/TAMU - Purchaser ID OIUY3_TX_PURCHASER_IDNUMC11
REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs OIUY3_REV_BOOK_REVADJ_ADJ_INDCHAR1OIUY3_REV_BOOK_REVADJ_ADJ_IND
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
REPORT_TYPERoyalty 2.0 - Texas GLO/TAMU - Report Type OIUY3_TX_REPORT_TYPECHAR1OIUY3_TX_REPORT_TYPE
GLO_UNIT_NORoyalty 2.0 - Texas GLO/TAMU - Unit Number OIUY3_TX_GLO_UNIT_NOCHAR4
TRACT_PART_FACTRoyalty 2.0 - Texas GLO - Tract Participation Factor OIUY3_TX_TRACT_PART_FACTORDEC9(8) OIU_PERCENT98
OVERRIDE_CODERoyalty 2.0 - TX GLO/TAMU - Override Code OIUY3_TX_OVERRIDE_CODECHAR5
OPERATOR_IDRoyalty 2.0 - TX GLO - Operator ID OIUY3_TX_OPERATOR_IDCHAR10OIUY3_TX_ID
PROD_DISP_RPTRoyalty 2.0 - TX GLO/TAMU - Production Disp Report Indicator OIUY3_TX_PROD_DISP_RPT_INDCHAR1YESNO
AFFILIATED_SALERoyalty 2.0 - TX GLO - Affiliated Sale Indicator OIUY3_TX_AFFILIATED_SALE_INDCHAR1YESNO
GLO_TIKRoyalty 2.0 - Texas GLO/TAMU - GLO TIK OIUY3_TX_GLO_TIKCHAR1YESNO
BEGINNING_STOCKRoyalty 2.0 - TX GLO/TAMU - Beginning Stock OIUY3_TX_BEGINNING_STOCKDEC15(6) OIUY3_SIGNED_DEC_15_6
GROSS_PRODUCTIONRoyalty 2.0 - TX GLO/TAMU - Gross Production OIUY3_TX_GROSS_PRODUCTIONDEC15(6) OIUY3_SIGNED_DEC_15_6
PIPELINERoyalty 2.0 - TX GLO/TAMU - Pipeline OIUY3_TX_PIPELINEDEC15(6) OIUY3_SIGNED_DEC_15_6
TRUCKRoyalty 2.0 - TX GLO/TAMU - Truck OIUY3_TX_TRUCKDEC15(6) OIUY3_SIGNED_DEC_15_6
TANK_CAR_BARGERoyalty 2.0 - TX GLO/TAMU - Tank Car Barge OIUY3_TX_TANK_CAR_BARGEDEC15(6) OIUY3_SIGNED_DEC_15_6
TANK_CLEANINGRoyalty 2.0 - TX GLO/TAMU - Tank Cleaning OIUY3_TX_TANK_CLEANINGDEC15(6) OIUY3_SIGNED_DEC_15_6
CIRC_OIL_CONDRoyalty 2.0 - TX GLO/TAMU - Circulating Oil/Condensate OIUY3_TX_CIRCULATING_OIL_CONDDEC15(6) OIUY3_SIGNED_DEC_15_6
LOST_STOLENRoyalty 2.0 - TX GLO/TAMU - Lost/Stolen OIUY3_TX_LOST_STOLENDEC15(6) OIUY3_SIGNED_DEC_15_6
BSWRoyalty 2.0 - TX GLO/TAMU - Basic Sediment / Water OIUY3_TX_BASIC_SEDIMENT_WATERDEC15(6) OIUY3_SIGNED_DEC_15_6
OTHER_ROY_DUERoyalty 2.0 - TX GLO/TAMU - Other Royalty Due OIUY3_TX_OTHER_ROYALTY_DUEDEC15(6) OIUY3_SIGNED_DEC_15_6
OTHER_NO_ROY_DUERoyalty 2.0 - TX GLO/TAMU - Other No Royalty Due OIUY3_TX_OTHER_NO_ROYALTY_DUEDEC15(6) OIUY3_SIGNED_DEC_15_6
SKIM_LIQ_HYDRORoyalty 2.0 - TX GLO/TAMU - Skim Liquid Hydrocarbon OIUY3_TX_SKIM_LIQUID_HYDRODEC15(6) OIUY3_SIGNED_DEC_15_6
SCRUBBER_OILRoyalty 2.0 - TX GLO/TAMU - Scrubber Oil OIUY3_TX_SCRUBBER_OILDEC15(6) OIUY3_SIGNED_DEC_15_6
ENDING_STOCKRoyalty 2.0 - TX GLO/TAMU - Ending Stock OIUY3_TX_ENDING_STOCKDEC15(6) OIUY3_SIGNED_DEC_15_6
DRIP_OILRoyalty 2.0 - TX GLO/TAMU - Drip Oil OIUY3_TX_DRIP_OILDEC15(6) OIUY3_SIGNED_DEC_15_6
ENTIRE_ROY_OBRoyalty 2.0 - TX GLO/TAMU - Entire Royalty Obligation OIUY3_TX_ENTIRE_ROYALTY_OBCHAR1OIUY3_TX_ENTIRE_ROYALTY_OB
ROY_DUE_NET_BBLSRoyalty 2.0 - TX GLO/TAMU - Royalty Due Net Barrels OIUY3_TX_ROY_DUE_NET_BARRELSDEC15(6) OIUY3_SIGNED_DEC_15_6
API_GRAVITYRoyalty 2.0 - Texas GLO/TAMU - API Gravity OIUY3_TX_API_GRAVITYDEC9(6)
UNIT_VALUERoyalty 2.0 - Texas GLO/TAMU - Unit Value OIUY3_TX_UNIT_VALUEDEC9(6)
GROSS_VALUEGross Value OIUX3_GROSS_VALUECURR11(2) OIUX3_SIGNED_CURR_11_2
ROYALTY_DECIMALRoyalty 2.0 - Texas GLO - Royalty Decimal OIUY3_TX_ROYALTY_DECIMALDEC9(8) OIU_PERCENT98
ROYALTY_DUERoyalty 2.0 - Texas GLO/TAMU - Royalty Due OIUY3_TX_ROYALTY_DUECURR11(2) OIUX3_SIGNED_CURR_11_2
COMMENT_FLRoyalty 2.0 - Texas GLO/TAMU - Comment Flag OIUY3_TX_COMMENT_FLCHAR1YESNO
ORIGINAL_REPORTRoyalty 2.0 - TX GLOTAMU - Original Report OIUY3_TX_ORIGINAL_REPORTCHAR1OIUY3_TX_ORIGINAL_REPORT
ZERO_VOLRoyalty 2.0 - Texas GLO/TAMU - Zero Volume Flag OIUY3_TX_ZERO_VOLCHAR1YESNO
PAY_REPORT_FLAGRoyalty 2.0 - TX GLO/TAMU - Pay/Report Flag OIUY3_TX_PAY_REPORT_FLAGCHAR1OIUY3_TX_PAY_REPORT_FLAG
EXPECTED_RPT_EXCRoyalty 2.0 - Texas GLO/TAMU No of Expected Reports Exceeded OIUY3_TX_EXPECTED_RPT_EXCEEDEDCHAR1FLAG
MULTI_PURCHASERRoyalty 2.0 - Texas GLO/TAMU - Multiple Purchasers Flag OIUY3_TX_MULTIPLE_PURCHASERSCHAR1YESNO
REPORT_NUMRoy 2.0 TX - Report Number OIUY3_TX_REPORT_NUMNUMC4
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_RPODT using ABAP code

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

SELECT SINGLE *
FROM OIUY3_TX_RPODT
INTO CORRESPONDING FIELDS OF WA_OIUY3_TX_RPODT
WHERE...

How to access SAP table OIUY3_TX_RPODT

Within an ECC or HANA version of SAP you can also view further information about OIUY3_TX_RPODT 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!