OIUY6_WY_MASTER SAP (Royalty 2.0 - WY - Master Data) Table details

Dictionary Type: Table
Description: Royalty 2.0 - WY - Master Data




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




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

OIUY6_WY_MASTER is a standard SAP Table which is used to store Royalty 2.0 - WY - Master Data data and is available within R/3 SAP systems depending on the version and release level.

The OIUY6_WY_MASTER table consists of various fields, each holding specific information or linking keys about Royalty 2.0 - WY - Master Data data available in SAP. These include RPT_ID (Report ID), WL_NO (Well ID number), WC_NO (Well Completion Number), MP_NO (Measurement point 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 OIUY6_WY_MASTER 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
RPT_IDReport ID OIUX3_RPT_IDCHAR10OIUX3_RPTOIUX3_RPT_ID
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
BUKRSCompany Code BUKRSCHAR4OIU_CM_COMPCBUKRSBUKC_T001
VNAMEJoint Venture JV_NAMECHAR6OIU_DO_JVALPHAJV_NAMEJVV
DOI_NODivision of interest (DOI) OIU_DOI_NOCHAR5OIU_DO_DIALPHAOIU_DOI_NOOIU_DOIH_OIU_DO_DI
EFF_FROM_DTEffective from date OIU_EFF_FROM_DTDATS8DATUMOIU_EFD
STATE_LEASE_NORoyalty 2.0 - Wyoming - State Lease Number OIUY6_WY_STATE_LEASE_NOCHAR15
UNIQUE_IDRoyalty 2.0 - Wyoming - PSA OIUY6_WY_UNIQUE_IDENTIFIERCHAR20
EFF_TO_DTEffective To Date OIU_EFF_TO_DTDATS8DATUMOIU_ETD
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
LEASE_TEXTRoyalty 2.0 - WY - Lease Text OIUY6_WY_LEASE_TEXTCHAR15
LEGACY_LEASERoyalty 2.0 - WY - Legacy Lease OIUY6_WY_LEGACY_LEASECHAR15
CHANGE_USERLast Changed By OIUX3_LAST_CHANGED_USERCHAR12USNAM
CHANGE_DATEDate of Last Change OIUX3_LAST_CHANGED_DATEDATS8
CHANGE_TIMETime of Last Change OIUX3_LAST_CHANGED_TIMETIMS6

Key field Non-key field



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

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

SELECT SINGLE *
FROM OIUY6_WY_MASTER
INTO CORRESPONDING FIELDS OF WA_OIUY6_WY_MASTER
WHERE...

How to access SAP table OIUY6_WY_MASTER

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