OIU_PR_WELL

PRA: Well | #masterdata | Component: Production and Revenue Accounting
Column Name Description
MANDT Client
WL_NO Well ID number
Column Name Description
Column Name Description
📏 Drill-out depth unit (DO_DPTH_U):
DO_DPTH Drill-out depth
📏 Target depth unit of measure (TARG_DPTH_U):
TARG_DPTH Target depth
Column Name Description
Column Name Description
SUR_LAT_NO Surface Latitude Show values
SUR_LAT_D_CD Surface latitude Direction Show values
SUR_LNG_NO Surface longitude Show values
SUR_LNG_D_CD Surface longitude direction code Show values
TWP_DIR_CD Township direction code Show values
RNG_DIR_CD Range Direction Code Show values
MMS_OWNER_CD MMS Ownership Code Show values
Column Name Description Domain name
API_NO API well number OIU_WLAPI
WL_DE Well Description OIU_TEXT35_CONV
SHTXT Description CHAR35
GLE Ground level elevation OIU_VOLUME_SIGN
SLOT_NO Slot Number (Base Meridian) OIU_SLOT_NO
LEG_DE Legal Description CHAR60
QTR_1_NO Quarter 1 Number CHAR2
QTR_2_NO Quarter 2 Number CHAR2
SECTION_NO Section Number CHAR3
TWP_NO Township number CHAR3
RNG_NO Range number CHAR3
DOCNR Well document number OIU_DOCNR
DOCYR Document year GJAHR
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Well drilled
Unit
  • OIU_PR_WELL.MANDT == T006.MANDT
  • OIU_PR_WELL.DO_DPTH_U == T006.MSEHI
GLE Unit
  • OIU_PR_WELL.MANDT == T006.MANDT
  • OIU_PR_WELL.GLE_U == T006.MSEHI
Unit
  • OIU_PR_WELL.MANDT == T006.MANDT
  • OIU_PR_WELL.TARG_DPTH_U == T006.MSEHI
Well Group
  • Well Number Range Group
  • Client