SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

OIUY3_TX_PRDTA Table in SAP | Royalty 2.0 - TX GLO - Royalty PRA Details (Allocated) Table & Fields List

OIUY3_TX_PRDTA is a SAP table coming under IS module and IS-OIL component.View details, Fields & related tables of OIUY3_TX_PRDTA in SAP.

  • Table description : Royalty 2.0 - TX GLO - Royalty PRA Details (Allocated)
  • Module : IS-OIL-PRA-REP-ROY
  • Parent Module : IS
  • Package : OIU_Y3
  • Software Component : IS-OIL
OIUY3_TX_PRDTA table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP OIUY3_TX_PRDTA Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
RUN_IDTax Reporting - Run IDOIUX3_RUN_IDNUMC10
.INCLUDERoyalty 2.0 - TX GLO - Royalty Transactions Key Fields    
.INCLUDERoyalty 2.0 - TX GLO - Royalty Reversal Key Fields    
BUKRSCompany CodeBUKRSBUKRS
SALES_DTSales Date / MonthOIU_SALE_DTDATUM
PDCDFull three char. product code (Major and Detail Products)OIU_FULL_PD_CDOIU_FULL_PD_CD
WL_NOWell ID numberOIU_WL_NOOIU_WL_NO
WC_NOWell Completion NumberOIU_WC_NOOIU_WC_NO
MP_NOMeasurement point numberOIU_MP_NOOIU_MP_NO
VNAMEJoint ventureJV_NAMEJV_NAME
DOI_NODivision of interest (DOI)OIU_DOI_NOOIU_DOI_NO
DN_NODelivery network numberOIU_DN_NOOIU_DN_NO
CT_NOContract NumberOIU_CT_NOOIUCM_CONTRACT_NUMBER
VL_TYPE_CDVolume type codeOIU_VT_CDOIU_VL_TYPE_CD
OWNER_IDENTIFIERRoyalty 2.0 - Owner IdentifierOIUYC_OWNER_IDENTIFIER  
LEASE_IDENTIFIERRoyalty 2.0 - TX GLO/TAMU - Lease IdentifierOIUY3_TX_LEASE_IDENTIFIER  
REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/AdjsOIUY3_REV_BOOK_REVADJ_ADJ_INDOIUY3_REV_BOOK_REVADJ_ADJ_IND
OUT_OF_STATUTETax Reporting - Out Of Statute FlagOIUX3_OUT_OF_STATUTEYESNO
.INCLUDERoyalty 2.0 - TX GLO - Royalty Transactions Non-Key Fields    
UNIT_VNAMEJoint ventureJV_NAMEJV_NAME
ACCT_NOAccount IDOIUH_ACCTIDCHAR10
CHV_RPT_CDTemplate cost centerRKOSTLKOSTL
UOMMeasurement unitOIU_MEAS_UMEINS
PS_BASE_QYPressure Base QuantityOIUH_PRESSURE_BASEOIUH_DEC6_3
GRV_QYGravityOIUH_GRAVITYOIUH_DEC3_1
PAY_CDPay CodeOIUH_PAY_CODECHAR2
OWN_INT_DECM_QYRoyalty 2.0 - TX GLO - Owner NRIOIUY3_TX_OWNER_NRIOIU_PERCENT98
OWN_BAL_DECM_QYOwner Disbursement (Balance) DecimalOIUH_OWNER_DISBUR_DECIMALOIUH_DEC9_8
PU_NOPurchaser IDOIUH_PURCHASERCHAR6
PU_SEQ_NOPurchaser Sequence NumberOIUH_PURCHASER_SEQUENCE_NUMBERCHAR2
AFFILIATED_SALERoyalty 2.0 - TX GLO - Affiliated Sale IndicatorOIUY3_TX_AFFILIATED_SALE_INDYESNO
.INCLUDERoyalty 2.0 - TX GLO - Royalty Transactions Non-Key Vol/Val    
GR_QYGross VolumeOIUX3_GROSS_VOLUMEOIUX3_SIGNED_DEC_11_2
GR_AMGross ValueOIUX3_GROSS_VALUEOIUX3_SIGNED_CURR_11_2
TXN_VAL_AMRoyalty 2.0 - TX GLO - Owner Gross ValueOIUY3_TX_OWNER_GROSS_VALUEOIUX3_SIGNED_CURR_11_2
TRANS_AMJE Transaction AmountOIUX3_TRANS_AMTOIUX3_SIGNED_DEC_11_2
TRANS_QYJE Transaction QuantityOIUH_TRANS_QUANTITYOIUH_DEC11_2
MMBTU_OVL_AMOwner MMBTUOIUH_OWNER_MMBTUOIUH_DEC11_2
PLT_VL_GRED_AMGross Plant Volume Reduction amountOIUH_GROSS_PLANT_VOLUME_RED_AMOIUH_DEC11_2
PLT_VL_ORED_AMOwner Plant Volume Reduction amountOIUH_OWNER_PLANT_VOLUME_RED_AMOIUH_DEC11_2
DED_RMB_AMDeduction/Reimbursement AmountOIUH_DED_REIMB_AMOUNTOIUH_CURR11_2
NET_TRANSP_AMMarketing CostOIUX3_MARKETING_COSTOIUX3_SIGNED_CURR_11_2
NET_OTH_MK_AMMarketing CostOIUX3_MARKETING_COSTOIUX3_SIGNED_CURR_11_2
TAX_RMB_AMTax Reimbursement AmountOIUH_TAX_REIMBURSEMENT_AMTOIUH_CURR11_2
BTU_QYBTU QuantityOIUH_BTU_QUANTITYOIUH_DEC7_3
.INCLUDERoyalty 2.0 - TX GLO - Royalty Transactions Non-Key Validate    
ORIGINAL_REPORTRoyalty 2.0 - TX GLOTAMU - Original ReportOIUY3_TX_ORIGINAL_REPORTOIUY3_TX_ORIGINAL_REPORT
GAS_DISP_CODERoyalty 2.0 - TX GLO/TAMU - Royalty Gas Disposition CodeOIUY3_TX_GLO_ROY_GAS_DISP_CODEOIUY3_TX_GLO_ROY_GAS_DISP_CODE
MASTER_LEVELRoyalty 2.0 - TX GLO - Master LevelOIUY3_TX_MASTER_LEVEL  
RRC_LEVELRoyalty 2.0 - TX GLO - RRC Master LevelOIUY3_TX_RRC_LEVEL  
PURCHASER_IDRoyalty 2.0 - Texas GLO/TAMU - Purchaser IDOIUY3_TX_PURCHASER_ID  
OPERATOR_IDRoyalty 2.0 - TX GLO - Operator IDOIUY3_TX_OPERATOR_IDOIUY3_TX_ID
.INCLUDERoyalty 2,.0 - TX GLO/TAMU - Master Sub Key    
GLO_LEASERoyalty 2.0 - TX GLO/TAMU LeaseOIUY3_TX_GLO_LEASEOIUY3_TX_GLO_LEASE
GLO_UNIT_NORoyalty 2.0 - Texas GLO/TAMU - Unit NumberOIUY3_TX_GLO_UNIT_NO  
ROYALTY_DECIMALRoyalty 2.0 - Texas GLO - Royalty DecimalOIUY3_TX_ROYALTY_DECIMALOIU_PERCENT98
UNIT_VNAME_FLAGRoy 2.0 - Texas GLO/TAMU - Unit VentureOIUY3_TX_UNIT_VNAMEYESNO
.INCLUDERoyalty 2.0 - TX GLO/TAMU - Master Non-Key Fields    
ALLOC_PERCENTRoyalty 2.0 - TX GLO/TAMU - Allocation PercentOIUY3_TX_ALLOCATION_PERCENTOIU_PERCENT98
TRACT_PART_FACTRoyalty 2.0 - Texas GLO - Tract Participation FactorOIUY3_TX_TRACT_PART_FACTOROIU_PERCENT98
.INCLUDERoyalty 2.0 - TX GLO/TAMU - RRC Master Non-Key Fields    
RRC_DISTRICT_NORoyalty 2.0 - TX GLO/TAMU - District NumberOIUY3_TX_GLO_DISTRICT_NO  
RRC_OIL_LEASE_NORoyalty 2.0 - TX GLO/TAMU - RRC Oil Lease NumberOIUY3_TX_GLO_RRC_OIL_LEASE_NO  
RRC_GAS_WELL_IDRoyalty 2.0 - TX GLO/TAMU - RRC Gas Well IDOIUY3_TX_GLO_RRC_GAS_WELL_ID  
RRC_DRILL_PERMITRoyalty 2.0 - TX GLO/TAMU - RRC Drilling PermitOIUY3_TX_GLO_RRC_DRILLING_PERM  
RRC_FIELD_NAMERoyalty 2.0 - TX GLO/TAMU - RRC Field NameOIUY3_TX_GLO_RRC_FIELD_NAME  
RRC_LEASE_NAMERoyalty 2.0 - TX GLO/TAMU - RRC Lease NameOIUY3_TX_GLO_RRC_LEASE_NAME  
PROP_ALIAS_NAMERoyalty 2.0 - TX GLO/TAMU - Property Alias NameOIUY3_TX_GLO_PROP_ALIAS_NAME  
OPERATOR_NORoyalty 2.0 - TX GLO/TAMU - Operator NumberOIUY3_OPERATOR_NUMBEROIUCM_BUS_ASSOC
OPERATOR_SEQ_NORoyalty 2.0 - TX GLO - Operator Sequence NumberOIUY3_OPERATOR_SEQUENCE_NUMBEROIUCM_SEQ_NO
PAY_REPORT_FLAGRoyalty 2.0 - TX GLO/TAMU - Pay/Report FlagOIUY3_TX_PAY_REPORT_FLAGOIUY3_TX_PAY_REPORT_FLAG
DOC_NOVal. document numberOIURV_DOCNROIU_MP_NO
DOC_YEARDocument yearOIU_DOC_YEARGJAHR
INTERFACE_FLRoyalty 2.0 - TX GLO - Interface FlagOIUY3_TX_INTERFACE_FLOIUY3_TX_EXT_UPDATE
OPTION1   
OPTION2   
OPTION3   
REFERENCE_RUN_IDTax Reporting - Run IDOIUX3_RUN_IDNUMC10
.INCLUDECreator and date/time created    
OIU_CRUSERName of Person who Created the ObjectERNAMUSNAM
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSTZNTSTMPS

OIUY3_TX_PRDTA related tables

TableNote
OIUY3_TX_PRDTARoyalty 2.0 - TX GLO - Royalty PRA Details (Allocated)
OIUY6_WY_PRDTARoyalty 2.0 - WY - Royalty PRA Details (Allocated)
OIUY3_TX_ROYHSTARoyalty 2.0 - TX GLO - Royalty Trans History (Allocated)
OIUY3_TX_ROYTXNARoyalty 2.0 - TX GLO - Royalty Transactions (Allocated)
OIUY3_TX_PRDTRoyalty 2.0 - TX GLO - Royalty PRA Details
OIUY6_WY_ROYHSTARoyalty 2.0 - WY - Royalty Transaction History (Allocated)
OIUY6_WY_ROYTXNARoyalty 2.0 - WY - Royalty Transactions (Allocated)
OIUY6_WY_PRDTRoyalty 2.0 - WY - Royalty PRA Details
OIUY3_TX_INTSTGRoyalty 2.0 - TX GLO - Royalty Trans Interface Staging
OIUY3_TX_INTTXNRoyalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface
OIUY3_TX_OOSTXNRoyalty 2.0 - TX GLO - Out of Statute Royalty Transactions
OIUY3_TX_RDCXRFRoyalty 2.0 - TX GLO/TAMU - Royalty Disposition XRef
OIUY3_TX_REVSTGRoyalty 2.0 - TX GLO - Royalty Reversals (Staging)
OIUY3_TX_REVTXNRoyalty 2.0 - TX GLO - Royalty Reversals
OIUY3_TX_ROYHSTRoyalty 2.0 - TX GLO - Royalty Transaction History
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com