OIUY6_WY_PRDTA SAP (Royalty 2.0 - WY - Royalty PRA Details (Allocated)) Table details

Dictionary Type: Table
Description: Royalty 2.0 - WY - Royalty PRA Details (Allocated)




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




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

OIUY6_WY_PRDTA is a standard SAP Table which is used to store Royalty 2.0 - WY - Royalty PRA Details (Allocated) data and is available within R/3 SAP systems depending on the version and release level.

The OIUY6_WY_PRDTA table consists of various fields, each holding specific information or linking keys about Royalty 2.0 - WY - Royalty PRA Details (Allocated) data available in SAP. These include RUN_ID (Run ID of Tax Report), BUKRS (Company Code), SALES_DT (Sales Date / Month), PDCD (Full three char. product code (Major and Detail Products)).. 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 OIUY6_WY_PRDTA 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
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 - WY - Lease Identifier OIUY6_WY_LEASE_IDENTIFIERCHAR35
REV_BOOK_ADJ_INDRoyalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjs OIUY6_REV_BOOK_REVADJ_ADJ_INDCHAR1OIUY6_REV_BOOK_REVADJ_ADJ_IND
OUT_OF_STATUTEOut of Statute OIUX3_OUT_OF_STATUTECHAR1YESNO
UNIT_VNAMEJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
ACCT_NOAccount ID OIUH_ACCTIDCHAR10CHAR10
UOMMeasurement unit OIU_MEAS_UUNIT3T006CUNITMEINS
GR_QYGross Volume OIUX3_GROSS_VOLUMEDEC11(2) OIUX3_SIGNED_DEC_11_2
GR_AMGross Value OIUX3_GROSS_VALUECURR11(2) OIUX3_SIGNED_CURR_11_2
DED_RMB_AMDeduction/Reimbursement Amount OIUH_DED_REIMB_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_RMB_AMTax Reimbursement Amount OIUH_TAX_REIMBURSEMENT_AMTCURR11(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
MKT_COST_01Marketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
MKT_COST_02Marketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
MKT_COST_03Marketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
MKT_COST_04Marketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
MKT_COST_05Marketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
MKT_COST_06Marketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
MKT_COST_07Marketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
MKT_COST_08Marketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
MKT_COST_09Marketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
MKT_COST_10Marketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
TXN_VAL_AMRoyalty 2.0 - WY - Owner Gross Value OIUY6_WY_OWNER_GROSS_VALUECURR11(2) OIUX3_SIGNED_CURR_11_2
OWN_INT_DECM_QYRoyalty 2.0 - Wyoming - Owner NRI OIUY6_WY_OWNER_NRIDEC9(8) OIU_PERCENT98
TRANS_AMJE Transaction Amount OIUX3_TRANS_AMTDEC11(2) OIUX3_SIGNED_DEC_11_2
TRANS_QYJE Transaction Quantity OIUH_TRANS_QUANTITYDEC11(2) OIUH_DEC11_2
BTU_QYBTU Quantity OIUH_BTU_QUANTITYDEC7(3) OIUH_DEC7_3
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_BAL_DECM_QYOwner Disbursement (Balance) Decimal OIUH_OWNER_DISBUR_DECIMALDEC9(8) OIUH_DEC9_8
MMBTU_OVL_AMOwner MMBTU OIUH_OWNER_MMBTUDEC11(2) OIUH_DEC11_2
OPERATED_FLRoyalty 2.0 - WY - Operated Flag OIUY6_OPERATED_FLAGCHAR1YESNO
OPERATOR_NAMERoyalty 2.0 - WY - Operator Name OIUY6_WY_OPERATOR_NAMECHAR38CHAR38
STATE_LEASE_NORoyalty 2.0 - Wyoming - State Lease Number OIUY6_WY_STATE_LEASE_NOCHAR15
UNIQUE_IDRoyalty 2.0 - Wyoming - PSA OIUY6_WY_UNIQUE_IDENTIFIERCHAR20
REPORT_ONLYRoyalty 2.0 - WY - Report Only Flag OIUY6_WY_REPORT_ONLY_FLCHAR1YESNO
OVERRIDE_FLRoyalty 2.0 - WY - Override Operated Flag OIUY6_WY_OVERRIDE_OPERATED_FLCHAR1OIUY6_WY_OVERRIDE_OPERATED_FL
TRACT_ALLOC_LSERoyalty 2.0 - Wyoming - Tract Allocation to Lease OIUY6_WY_TRACT_ALLOC_TO_LEASEDEC9(8) OIU_PERCENT98
ROYALTY_RATERoyalty 2.0 - Wyoming - Royalty Rate OIUY6_WY_ROYALTY_RATEDEC9(8) OIU_PERCENT98
ALLOC_PERCENTRoyalty 2.0 - Wyoming - Allocation Percent OIUY6_WY_ALLOCATION_PERCENTDEC9(8) OIU_PERCENT98
REFERENCE_FIELDRoyalty 2.0 - WY - Reference Field OIUY6_WY_REFERENCE_FIELDCHAR20
ALTERNATE_PSARoyalty 2.0 - Wyoming - Alternate PSA OIUY6_WY_ALTERNATE_PSACHAR20
CTRACT_ALLOC_LSERoyalty 2.0 - Wyoming - Calculated Tract Allocation to Lease OIUY6_WY_CALC_TRACT_ALLOC_LSEDEC9(8) OIU_PERCENT98
MASTER_LEVELRoyalty 2.0 - WY - Master Level OIUY6_WY_MASTER_LEVELCHAR1
WY_PDCDRoyalty 2.0 - Wyoming - Product Code OIUY6_WY_PRODUCT_CODENUMC3OIUY6_WY_PRODUCT_CODE
PAYER_CODERoyalty 2.0 - Wyoming - Payer Code OIUY6_WY_PAYER_CODENUMC4OIUY6_WY_COMPANY_ID
ORIGINAL_REPORTRoyalty 2.0 - WY - Original Report OIUY6_WY_ORIGINAL_REPORTCHAR1YESNO
DOC_NOVal. document number OIURV_DOCNRCHAR20Assigned to domainALPHAOIU_MP_NOOIU_DOCNR
DOC_YEARDocument year OIU_DOC_YEARNUMC4GJAHRGJAHROIU_DOC_YEAR
INTERFACE_FLRoyalty 2.0 - WY - Interface Flag OIUY6_WY_INTERFACE_FLCHAR1OIUY6_WY_EXT_UPDATE
OPTION1 0
OPTION2 PPN Flag0
OPTION3 0
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 OIUY6_WY_PRDTA using ABAP code

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

SELECT SINGLE *
FROM OIUY6_WY_PRDTA
INTO CORRESPONDING FIELDS OF WA_OIUY6_WY_PRDTA
WHERE...

How to access SAP table OIUY6_WY_PRDTA

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