ROIU_PR_WC SAP (Maintenance Structure: OIU_PR_WC) Structure details

Dictionary Type: Structure
Description: Maintenance Structure: OIU_PR_WC




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




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

ROIU_PR_WC is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Maintenance Structure: OIU_PR_WC" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_ROIU_PR_WC TYPE ROIU_PR_WC.

The ROIU_PR_WC table consists of various fields, each holding specific information or linking keys about Maintenance Structure: OIU_PR_WC data available in SAP. These include MANDT (Client), WL_NO (Well ID number), WC_NO (Well Completion Number), API_WC_NO (API well completion 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP ROIU_PR_WC structure 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 MANDTCLNT3Assigned to domainMANDT
WL_NOWell ID number OIU_WL_NOCHAR15OIU_PR_WELLALPHAOIU_WL_NOOIU_WELLH_OIU_PR_WELL
WC_NOWell Completion Number OIU_WC_NOCHAR5Assigned to domainALPHAOIU_WC_NOOIU_WCH_OIU_PR_WC
API_WC_NOAPI well completion number OIU_API_WC_NOCHAR3OIU_API_WC_NO
NAMEWell completion name OIU_WC_NM_CONVCHAR35OIUNMOIU_TEXT35_CONV
SHTXTDescription OIU_SHTXTCHAR35CHAR35
UOM_GRPunit of measure group OIU_ME_UOMGRCHAR3OIU_ME_UOM_GROIU_ME_UOMGROIU_UOMGR
DEV_PGM_NODevelopment program number OIU_DEV_PGM_NOCHAR2OIU_PR_WLPROGOIU_DEV_PGMNO
LAT_NOLatitude number OIU_LAT_NODEC8(6) OIU_LATIT_NO
LAT_DIR_CDLatitude direction code OIU_LAT_DIR_CDCHAR1OIU_LATIT_DIR_CD
LNG_NOLongitude OIU_LNG_NODEC9(6) OIU_LONG_NO
LNG_DIR_CDLongitude Direction Code OIU_LNG_DIR_CDCHAR1OIU_LONG_DIR_CD
ELEV_DPH_UElevation/Depth Unit OIU_ELEV_DPH_UUNIT3Assigned to domainCUNITMEINS
PLG_BCK_DPTHPlug hole depth OIU_PLG_DPTHQUAN17(3) OIU_QUANTITY_17_3
DATUM_DPTHDatum depth OIU_DATUM_DPTHQUAN17(3) OIU_QUANTITY_17_3
KB_ELEVKB elevation OIU_KB_ELEVQUAN17(3) OIU_QUANTITY_17_3
BASE_BHP_UBase bottom hole pressure OIU_BASE_BHP_UUNIT3Assigned to domainCUNITMEINS
BASE_BHPBase bottom hole pressure (BHP) OIU_BASE_BHPQUAN17(3) OIU_QUANTITY_17_3
CNTRY_CDCountry OIU_COUNTRYCHAR3T005LAND1OIU_LAND1
PRI_GEO_LOCPrimary geographical location (PRI geo. loc.) OIU_PRI_GEO_LOCCHAR2OIU_CM_LXPGLOIU_PRI_GEO_LOCOIU_PRI_GEO_LOC
SEC_GEO_LOCSecondary geographic location OIU_SEC_GEO_LOCCHAR3OIU_CM_LXSGLOIU_SEC_GEO_LOC
RESRVReservoir ID OIU_RESRVIDCHAR10OIU_PR_RESRVALPHAOIU_RESRVIDOIU_RESRV
RESZNReservoir zone OIU_RESZNIDCHAR10OIU_PR_RESZNALPHAOIU_RESZNID
FIELDField ID OIU_FIELDIDCHAR10OIU_PR_FIELDALPHAOIU_FIELDIDOIU_FIELD
PF_NOPlatform number OIU_PF_NOCHAR10OIU_PR_PFALPHAOIU_PF_NOOIU_PF
PUR_CDWell purpose code OIU_WL_PUR_CDCHAR1OIU_PR_WLPUROIU_WL_PUR_CD
LSE_LE_WL_FLLease line well flag OIU_LE_WL_FLCHAR1OIU_X_FLAG
BEG_PRF_DPHBegin Perforation Depth OIU_BEG_PRFQUAN17(3) OIU_QUANTITY_17_3
END_PRF_DPHEnd Performation Depth OIU_END_PRFQUAN17(3) OIU_QUANTITY_17_3
ALT_WC_KEYAlternate WC Key OIU_ALT_WC_KEYCHAR20CHAR20
LCL_WL_NOLocal Well Number OIU_LCL_WL_NOCHAR15
WC_SETWell Completion Hierarchy Group OIU_WC_SETCHAR15CHAR15OIU_ENT_NO
DOCNRWell completion document number OIUPR_WC_DOCNRCHAR10ALPHAOIU_DOCNR
DOCYRDocument year OIU_DOC_YEARNUMC4GJAHRGJAHROIU_DOC_YEAR
OR1_OR_LVL_1_NOOrg. Level 1 - Company OIUH_CHAR3_ORGLVL1CHAR3OIUH_CM_OR1OIUH_OR_LVL_1_NO
OR2_OR_LVL_2_NOSecond-highest organization level number ( Company Code) OIUH_CHAR1_ORGLVL2CHAR1OIUH_CM_OR2CHAR1
OR3_OR_LVL_3_NOThird-highest organization level number ( Company Code) OIUH_CHAR3_ORGLVL3CHAR3OIUH_CM_OR3CHAR3
OR4_OR_LVL_4_NOFourth-highest organization level number ( Company Code) OIUH_CHAR2_ORGLVL4CHAR2OIUH_CM_OR4CHAR2
OIU_CRUSERName of Person who Created the Object ERNAMCHAR12USNAM
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS
PCK_DPTHPacker Depth OIU_PACK_DPTHQUAN17(3) OIU_QUANTITY_17_3
WL_DEWell Description OIU_WL_DECHAR35OIU_TEXT35
WL_SHTXTDescription OIU_SHTXTCHAR35CHAR35
XXDBACTIONDatabase Action Flag OIU_DBACTIONCHAR1CHAR1
REF_WL_NOReference well ID number OIU_WL_NO_REFCHAR15OIU_PR_WELLALPHAOIU_WL_NOOIU_R_WELL
REF_WL_DEWell Description OIU_WL_DECHAR35OIU_TEXT35
REF_WL_SHTXTDescription OIU_SHTXTCHAR35CHAR35
REF_WC_NOReference well completion number OIU_WC_NO_REFCHAR5OIU_PR_WCALPHAOIU_WC_NOOIU_R_WC
REF_NAMEWell completion name OIU_WC_NMCHAR35OIU_TEXT35
REF_WC_SHTXTDescription OIU_SHTXTCHAR35CHAR35
FL_NAMEField name OIU_FL_NMCHAR35OIU_TEXT35
PF_NAMEPlatform Name OIU_PF_NAMECHAR35OIU_TEXT35
RES_NAMEReservoir name OIU_RES_NAMECHAR35OIU_TEXT35OIU_RESRV
CNTRY_DECountry Name LANDXCHAR15TEXT15
UOMGR_DESCRDescription of the unit of measure group OIU_ME_UOMGR_TXCHAR40TEXT40
PRI_GEO_DESCPrimary geographical location description OIU_PRI_GEO_DESCCHAR30CHAR30
SEC_GEO_DESCSecondary Geographical Location Description OIU_SEC_GEO_DESCCHAR30CHAR30
ZONE_NAMEZone name OIU_ZONE_NAMECHAR35CHAR35
DEV_PGM_DEWell Completion development program description OIU_DEV_PGM_DECHAR50OIU_TEXT50
WL_PUR_DEWell Purpose Description OIU_WL_PUR_DECHAR50OIU_TEXT50
REF_DOCNRWell completion document number OIUPR_WC_DOCNRCHAR10ALPHAOIU_DOCNR
REF_DOCYRDocument year OIU_DOC_YEARNUMC4GJAHRGJAHROIU_DOC_YEAR
OR1_DEOIUH_CHAR40 OIUH_CHAR40CHAR40CHAR40
OR2_DEOIUH_CHAR14 OIUH_CHAR14CHAR14CHAR14
OR3_DEOIUH_CHAR14 OIUH_CHAR14CHAR14CHAR14
OR4_DEOIUH_CHAR14 OIUH_CHAR14CHAR14CHAR14

Key field Non-key field



How do I retrieve data from SAP structure ROIU_PR_WC using ABAP code?

As ROIU_PR_WC is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ROIU_PR_WC as there is no data to select.

How to access SAP table ROIU_PR_WC

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