SAP Table OIU_PR_WELL
PRA: Well
OIU_PR_WELL (PRA: Well) 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_WELL to other SAP tables.
OIU_PR_WELL 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 |
CHAR
|
15 | 0 | ||||||||||
|
API_NO
API well number
|
OIU_WLAPI |
CHAR
|
12 | 0 | ||||||||||
|
WL_DE
Well Description
|
OIU_WL_DE_CONV |
CHAR
|
35 | 0 | ||||||||||
|
SHTXT
Description
|
OIU_SHTXT |
CHAR
|
35 | 0 | ||||||||||
|
DEV_CD
Well drilled
|
OIU_DEV_CD | OIU_PR_WLDEV |
CHAR
|
1 | 0 | |||||||||
|
GLE_U
Ground level elevation unit
|
OIU_GLE_U | T006 |
UNIT
|
3 | 0 | |||||||||
|
GLE
Ground level elevation
|
OIU_GLE |
DEC
|
13 | 3 | ||||||||||
|
SLOT_NO
Slot Number (Base Meridian)
|
OIU_SLOT_NO |
CHAR
|
5 | 0 | ||||||||||
|
SUR_LAT_NO
Surface Latitude
|
OIU_SUR_LAT_NO |
DEC
|
8 | 6 | ||||||||||
|
||||||||||||||
|
SUR_LAT_D_CD
Surface latitude Direction
|
OIU_SUR_LAT_D_CD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SUR_LNG_NO
Surface longitude
|
OIU_SUR_LNG_NO |
DEC
|
9 | 6 | ||||||||||
|
||||||||||||||
|
SUR_LNG_D_CD
Surface longitude direction code
|
OIU_SUR_LNG_D_CD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
LEG_DE
Legal Description
|
OIU_LEG_DE |
CHAR
|
60 | 0 | ||||||||||
|
DO_DPTH_U
Drill-out depth unit
|
OIU_DO_DPTH_U | T006 |
UNIT
|
3 | 0 | |||||||||
|
DO_DPTH
Drill-out depth
|
OIU_DO_DPTH |
QUAN
|
13 | 3 | ||||||||||
|
QTR_1_NO
Quarter 1 Number
|
OIU_QTR_1_NO |
CHAR
|
2 | 0 | ||||||||||
|
QTR_2_NO
Quarter 2 Number
|
OIU_QTR_2_NO |
CHAR
|
2 | 0 | ||||||||||
|
SECTION_NO
Section Number
|
OIU_SECTION_NO |
CHAR
|
3 | 0 | ||||||||||
|
TWP_NO
Township number
|
OIU_TWP_NO |
CHAR
|
3 | 0 | ||||||||||
|
TWP_DIR_CD
Township direction code
|
OIU_TWP_DIR_CD |
CHAR
|
1 | 0 | ||||||||||
|
RNG_NO
Range number
|
OIU_RNG_NO |
CHAR
|
3 | 0 | ||||||||||
|
RNG_DIR_CD
Range Direction Code
|
OIU_RNG_DIR_CD |
CHAR
|
1 | 0 | ||||||||||
|
TARG_DPTH_U
Target depth unit of measure
|
OIU_TARG_DPTH_U | T006 |
UNIT
|
3 | 0 | |||||||||
|
TARG_DPTH
Target depth
|
OIU_TARG_DPTH |
QUAN
|
13 | 3 | ||||||||||
|
MMS_OWNER_CD
MMS Ownership Code
|
OIU_MMS_OWNER_FL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
WL_GRP
Well Number Range Group
|
OIU_WL_GRP | OIU_PR_WL_GRP |
CHAR
|
4 | 0 | |||||||||
|
DOCNR
Well document number
|
OIUPR_WL_DOCNR |
CHAR
|
10 | 0 | ||||||||||
|
DOCYR
Document year
|
OIU_DOC_YEAR |
NUMC
|
4 | 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 | ||||||||||
OIU_PR_WELL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| OIU_PR_WELL | DEV_CD | OIU_PR_WELL | MANDT |
OIU_PR_WLDEV
Well Deviation
|
MANDT |
| OIU_PR_WELL | DEV_CD | OIU_PR_WELL | DEV_CD |
OIU_PR_WLDEV
Well Deviation
|
DEV_CD |
| OIU_PR_WELL | DO_DPTH_U | OIU_PR_WELL | MANDT |
T006
Units of Measurement
|
MANDT |
| OIU_PR_WELL | DO_DPTH_U | OIU_PR_WELL | DO_DPTH_U |
T006
Units of Measurement
|
MSEHI |
| OIU_PR_WELL | GLE_U | OIU_PR_WELL | MANDT |
T006
Units of Measurement
|
MANDT |
| OIU_PR_WELL | GLE_U | OIU_PR_WELL | GLE_U |
T006
Units of Measurement
|
MSEHI |
| OIU_PR_WELL | TARG_DPTH_U | OIU_PR_WELL | MANDT |
T006
Units of Measurement
|
MANDT |
| OIU_PR_WELL | TARG_DPTH_U | OIU_PR_WELL | TARG_DPTH_U |
T006
Units of Measurement
|
MSEHI |
| OIU_PR_WELL | WL_GRP | OIU_PR_WELL | MANDT |
OIU_PR_WL_GRP
PRA: Well Group Codes
|
MANDT |
| OIU_PR_WELL | WL_GRP | OIU_PR_WELL | WL_GRP |
OIU_PR_WL_GRP
PRA: Well Group Codes
|
WL_GRP |