SAP Table OIU_PR_WC
PRA: Well Completion
OIU_PR_WC (PRA: Well Completion) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link OIU_PR_WC to other SAP tables.
OIU_PR_WC table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||
|
WL_NO
Well ID number
|
OIU_WL_NO | OIU_PR_WELL |
CHAR
|
15 | 0 | |||||||||
|
WC_NO
Well Completion Number
|
OIU_WC_NO |
CHAR
|
5 | 0 | ||||||||||
|
API_WC_NO
API well completion number
|
OIU_API_WC_NO |
CHAR
|
3 | 0 | ||||||||||
|
NAME
Well completion name
|
OIU_WC_NM_CONV |
CHAR
|
35 | 0 | ||||||||||
|
SHTXT
Description
|
OIU_SHTXT |
CHAR
|
35 | 0 | ||||||||||
|
UOM_GRP
unit of measure group
|
OIU_ME_UOMGR | OIU_ME_UOM_GR |
CHAR
|
3 | 0 | |||||||||
|
DEV_PGM_NO
Development program number
|
OIU_DEV_PGM_NO | OIU_PR_WLPROG |
CHAR
|
2 | 0 | |||||||||
|
LAT_NO
Latitude number
|
OIU_LAT_NO |
DEC
|
8 | 6 | ||||||||||
|
||||||||||||||
|
LAT_DIR_CD
Latitude direction code
|
OIU_LAT_DIR_CD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
LNG_NO
Longitude
|
OIU_LNG_NO |
DEC
|
9 | 6 | ||||||||||
|
||||||||||||||
|
LNG_DIR_CD
Longitude Direction Code
|
OIU_LNG_DIR_CD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
ELEV_DPH_U
Elevation/Depth Unit
|
OIU_ELEV_DPH_U |
UNIT
|
3 | 0 | ||||||||||
|
PLG_BCK_DPTH
Plug hole depth
|
OIU_PLG_DPTH |
QUAN
|
17 | 3 | ||||||||||
|
DATUM_DPTH
Datum depth
|
OIU_DATUM_DPTH |
QUAN
|
17 | 3 | ||||||||||
|
KB_ELEV
KB elevation
|
OIU_KB_ELEV |
QUAN
|
17 | 3 | ||||||||||
|
BASE_BHP_U
Base bottom hole pressure
|
OIU_BASE_BHP_U |
UNIT
|
3 | 0 | ||||||||||
|
BASE_BHP
Base bottom hole pressure (BHP)
|
OIU_BASE_BHP |
QUAN
|
17 | 3 | ||||||||||
|
CNTRY_CD
Country
|
OIU_COUNTRY | T005 |
CHAR
|
3 | 0 | |||||||||
|
PRI_GEO_LOC
Primary geographical location (PRI geo. loc.)
|
OIU_PRI_GEO_LOC | OIU_CM_LXPGL |
CHAR
|
2 | 0 | |||||||||
|
SEC_GEO_LOC
Secondary geographic location
|
OIU_SEC_GEO_LOC | OIU_CM_LXSGL |
CHAR
|
3 | 0 | |||||||||
|
RESRV
Reservoir ID
|
OIU_RESRVID | OIU_PR_RESRV |
CHAR
|
10 | 0 | |||||||||
|
RESZN
Reservoir zone
|
OIU_RESZNID | OIU_PR_RESZN |
CHAR
|
10 | 0 | |||||||||
|
FIELD
Field ID
|
OIU_FIELDID | OIU_PR_FIELD |
CHAR
|
10 | 0 | |||||||||
|
PF_NO
Platform number
|
OIU_PF_NO | OIU_PR_PF |
CHAR
|
10 | 0 | |||||||||
|
PUR_CD
Well purpose code
|
OIU_WL_PUR_CD | OIU_PR_WLPUR |
CHAR
|
1 | 0 | |||||||||
|
LSE_LE_WL_FL
Lease line well flag
|
OIU_LE_WL_FL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
BEG_PRF_DPH
Begin Perforation Depth
|
OIU_BEG_PRF |
QUAN
|
17 | 3 | ||||||||||
|
END_PRF_DPH
End Performation Depth
|
OIU_END_PRF |
QUAN
|
17 | 3 | ||||||||||
|
ALT_WC_KEY
Alternate WC Key
|
OIU_ALT_WC_KEY |
CHAR
|
20 | 0 | ||||||||||
|
LCL_WL_NO
Local Well Number
|
OIU_LCL_WL_NO |
CHAR
|
15 | 0 | ||||||||||
|
WC_SET
Well Completion Hierarchy Group
|
OIU_WC_SET |
CHAR
|
15 | 0 | ||||||||||
|
DOCNR
Well completion document number
|
OIUPR_WC_DOCNR |
CHAR
|
10 | 0 | ||||||||||
|
DOCYR
Document year
|
OIU_DOC_YEAR |
NUMC
|
4 | 0 | ||||||||||
|
OR1_OR_LVL_1_NO
Org. Level 1 - Company
|
OIUH_CHAR3_ORGLVL1 | OIUH_CM_OR1 |
CHAR
|
3 | 0 | |||||||||
|
OR2_OR_LVL_2_NO
Second-highest organization level number ( Company Code)
|
OIUH_CHAR1_ORGLVL2 | OIUH_CM_OR2 |
CHAR
|
1 | 0 | |||||||||
|
OR3_OR_LVL_3_NO
Third-highest organization level number ( Company Code)
|
OIUH_CHAR3_ORGLVL3 | OIUH_CM_OR3 |
CHAR
|
3 | 0 | |||||||||
|
OR4_OR_LVL_4_NO
Fourth-highest organization level number ( Company Code)
|
OIUH_CHAR2_ORGLVL4 | OIUH_CM_OR4 |
CHAR
|
2 | 0 | |||||||||
|
OIU_CRUSER
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||
|
OIU_TIMESTAMP
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
|
TZNTSTMPS |
DEC
|
15 | 0 | ||||||||||
|
PCK_DPTH
Packer Depth
|
OIU_PACK_DPTH |
QUAN
|
17 | 3 | ||||||||||
OIU_PR_WC foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| OIU_PR_WC | CNTRY_CD | OIU_PR_WC | MANDT |
T005
Countries
|
MANDT |
| OIU_PR_WC | CNTRY_CD | OIU_PR_WC | CNTRY_CD |
T005
Countries
|
LAND1 |
| OIU_PR_WC | DEV_PGM_NO | OIU_PR_WC | MANDT |
OIU_PR_WLPROG
WELL COMP PROGRAM ID AND NAME - TBLCM016
|
MANDT |
| OIU_PR_WC | DEV_PGM_NO | OIU_PR_WC | DEV_PGM_NO |
OIU_PR_WLPROG
WELL COMP PROGRAM ID AND NAME - TBLCM016
|
DEV_PGM_NO |
| OIU_PR_WC | FIELD | OIU_PR_WC | MANDT |
OIU_PR_FIELD
Field
|
MANDT |
| OIU_PR_WC | FIELD | OIU_PR_WC | FIELD |
OIU_PR_FIELD
Field
|
FIELD |
| OIU_PR_WC | OR1_OR_LVL_1_NO | OIU_PR_WC | MANDT |
OIUH_CM_OR1
Organization Level 1 Table
|
MANDT |
| OIU_PR_WC | OR1_OR_LVL_1_NO | OIU_PR_WC | OR1_OR_LVL_1_NO |
OIUH_CM_OR1
Organization Level 1 Table
|
OR1_OR_LVL_1_NO |
| OIU_PR_WC | OR2_OR_LVL_2_NO | OIU_PR_WC | MANDT |
OIUH_CM_OR2
Organization Level 2 Table
|
MANDT |
| OIU_PR_WC | OR2_OR_LVL_2_NO | OIU_PR_WC | OR1_OR_LVL_1_NO |
OIUH_CM_OR2
Organization Level 2 Table
|
OR2_OR_LVL_1_NO |
| OIU_PR_WC | OR2_OR_LVL_2_NO | OIU_PR_WC | OR2_OR_LVL_2_NO |
OIUH_CM_OR2
Organization Level 2 Table
|
OR2_OR_LVL_2_NO |
| OIU_PR_WC | OR3_OR_LVL_3_NO | OIU_PR_WC | OR1_OR_LVL_1_NO |
OIUH_CM_OR3
Organizational Level 3 Table
|
OR3_OR_LVL_1_NO |
| OIU_PR_WC | OR3_OR_LVL_3_NO | OIU_PR_WC | OR2_OR_LVL_2_NO |
OIUH_CM_OR3
Organizational Level 3 Table
|
OR3_OR_LVL_2_NO |
| OIU_PR_WC | OR3_OR_LVL_3_NO | OIU_PR_WC | OR3_OR_LVL_3_NO |
OIUH_CM_OR3
Organizational Level 3 Table
|
OR3_OR_LVL_3_NO |
| OIU_PR_WC | OR3_OR_LVL_3_NO | OIU_PR_WC | MANDT |
OIUH_CM_OR3
Organizational Level 3 Table
|
MANDT |
| OIU_PR_WC | OR4_OR_LVL_4_NO | OIU_PR_WC | OR2_OR_LVL_2_NO |
OIUH_CM_OR4
Organizational Level 4 Table
|
OR4_OR_LVL_2_NO |
| OIU_PR_WC | OR4_OR_LVL_4_NO | OIU_PR_WC | OR3_OR_LVL_3_NO |
OIUH_CM_OR4
Organizational Level 4 Table
|
OR4_OR_LVL_3_NO |
| OIU_PR_WC | OR4_OR_LVL_4_NO | OIU_PR_WC | OR4_OR_LVL_4_NO |
OIUH_CM_OR4
Organizational Level 4 Table
|
OR4_OR_LVL_4_NO |
| OIU_PR_WC | OR4_OR_LVL_4_NO | OIU_PR_WC | MANDT |
OIUH_CM_OR4
Organizational Level 4 Table
|
MANDT |
| OIU_PR_WC | OR4_OR_LVL_4_NO | OIU_PR_WC | OR1_OR_LVL_1_NO |
OIUH_CM_OR4
Organizational Level 4 Table
|
OR4_OR_LVL_1_NO |
| OIU_PR_WC | PF_NO | OIU_PR_WC | MANDT |
OIU_PR_PF
PRA: Platform
|
MANDT |
| OIU_PR_WC | PF_NO | OIU_PR_WC | PF_NO |
OIU_PR_PF
PRA: Platform
|
PF_NO |
| OIU_PR_WC | PRI_GEO_LOC | OIU_PR_WC | PRI_GEO_LOC |
OIU_CM_LXPGL
Country and Primary Geo. Location Xref
|
PRI_GEO_LOC |
| OIU_PR_WC | PRI_GEO_LOC | OIU_PR_WC | MANDT |
OIU_CM_LXPGL
Country and Primary Geo. Location Xref
|
MANDT |
| OIU_PR_WC | PRI_GEO_LOC | OIU_PR_WC | CNTRY_CD |
OIU_CM_LXPGL
Country and Primary Geo. Location Xref
|
LAND1 |
| OIU_PR_WC | PUR_CD | OIU_PR_WC | MANDT |
OIU_PR_WLPUR
WELL PURPOSE CODES TABLE - TBLCM019
|
MANDT |
| OIU_PR_WC | PUR_CD | OIU_PR_WC | PUR_CD |
OIU_PR_WLPUR
WELL PURPOSE CODES TABLE - TBLCM019
|
WL_PUR_CD |
| OIU_PR_WC | RESRV | OIU_PR_WC | MANDT |
OIU_PR_RESRV
PRA: Reservoir
|
MANDT |
| OIU_PR_WC | RESRV | OIU_PR_WC | RESRV |
OIU_PR_RESRV
PRA: Reservoir
|
RESRV |
| OIU_PR_WC | RESZN | OIU_PR_WC | MANDT |
OIU_PR_RESZN
PRA: Reservoir Zone Identification
|
MANDT |
| OIU_PR_WC | RESZN | OIU_PR_WC | RESRV |
OIU_PR_RESZN
PRA: Reservoir Zone Identification
|
RESRV |
| OIU_PR_WC | RESZN | OIU_PR_WC | RESZN |
OIU_PR_RESZN
PRA: Reservoir Zone Identification
|
RESZN |
| OIU_PR_WC | SEC_GEO_LOC | OIU_PR_WC | MANDT |
OIU_CM_LXSGL
Cross Reference Between Country and Secondary Geo. Locatio
|
MANDT |
| OIU_PR_WC | SEC_GEO_LOC | OIU_PR_WC | CNTRY_CD |
OIU_CM_LXSGL
Cross Reference Between Country and Secondary Geo. Locatio
|
LAND1 |
| OIU_PR_WC | SEC_GEO_LOC | OIU_PR_WC | PRI_GEO_LOC |
OIU_CM_LXSGL
Cross Reference Between Country and Secondary Geo. Locatio
|
PRI_GEO_LOC |
| OIU_PR_WC | SEC_GEO_LOC | OIU_PR_WC | SEC_GEO_LOC |
OIU_CM_LXSGL
Cross Reference Between Country and Secondary Geo. Locatio
|
SEC_GEO_LOC |
| OIU_PR_WC | UOM_GRP | OIU_PR_WC | UOM_GRP |
OIU_ME_UOM_GR
PRA Measurement: Unit of Measurement Groups
|
UOMGR |
| OIU_PR_WC | UOM_GRP | OIU_PR_WC | MANDT |
OIU_ME_UOM_GR
PRA Measurement: Unit of Measurement Groups
|
MANDT |
| OIU_PR_WC | WL_NO | OIU_PR_WC | MANDT |
OIU_PR_WELL
PRA: Well
|
MANDT |
| OIU_PR_WC | WL_NO | OIU_PR_WC | WL_NO |
OIU_PR_WELL
PRA: Well
|
WL_NO |