OIU_PR_WC - PRA: Well Completion
PRA: Well Completion information is stored in SAP table OIU_PR_WC.
It is part of development package OIU in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "PRA Production and Revenue Accounting (Upstream Business)".
It is part of development package OIU in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "PRA Production and Revenue Accounting (Upstream Business)".
Fields for table OIU_PR_WC
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
WL_NO | Well ID number | X | OIU_WL_NO | CHAR | 30 | OIU_PR_WELL |
WC_NO | Well Completion Number | X | OIU_WC_NO | CHAR | 10 | |
API_WC_NO | API well completion number | OIU_API_WC_NO | CHAR | 6 | ||
NAME | Well completion name | OIU_WC_NM_CONV | CHAR | 70 | ||
SHTXT | Description | OIU_SHTXT | CHAR | 70 | ||
UOM_GRP | unit of measure group | OIU_ME_UOMGR | CHAR | 6 | OIU_ME_UOM_GR | |
DEV_PGM_NO | Development program number | OIU_DEV_PGM_NO | CHAR | 4 | OIU_PR_WLPROG | |
LAT_NO | Latitude number | OIU_LAT_NO | DEC | 5 | ||
LAT_DIR_CD | Latitude direction code | OIU_LAT_DIR_CD | CHAR | 2 | ||
LNG_NO | Longitude | OIU_LNG_NO | DEC | 5 | ||
LNG_DIR_CD | Longitude Direction Code | OIU_LNG_DIR_CD | CHAR | 2 | ||
ELEV_DPH_U | Elevation/Depth Unit | OIU_ELEV_DPH_U | UNIT | 6 | ||
PLG_BCK_DPTH | Plug hole depth | OIU_PLG_DPTH | QUAN | 9 | ||
DATUM_DPTH | Datum depth | OIU_DATUM_DPTH | QUAN | 9 | ||
KB_ELEV | KB elevation | OIU_KB_ELEV | QUAN | 9 | ||
BASE_BHP_U | Base bottom hole pressure | OIU_BASE_BHP_U | UNIT | 6 | ||
BASE_BHP | Base bottom hole pressure (BHP) | OIU_BASE_BHP | QUAN | 9 | ||
CNTRY_CD | Country/Region | OIU_COUNTRY | CHAR | 6 | T005 | |
PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | OIU_PRI_GEO_LOC | CHAR | 4 | OIU_CM_LXPGL | |
SEC_GEO_LOC | Secondary geographic location | OIU_SEC_GEO_LOC | CHAR | 6 | OIU_CM_LXSGL | |
RESRV | Reservoir ID | OIU_RESRVID | CHAR | 20 | OIU_PR_RESRV | |
RESZN | Reservoir zone | OIU_RESZNID | CHAR | 20 | OIU_PR_RESZN | |
FIELD | Field ID | OIU_FIELDID | CHAR | 20 | OIU_PR_FIELD | |
PF_NO | Platform number | OIU_PF_NO | CHAR | 20 | OIU_PR_PF | |
PUR_CD | Well purpose code | OIU_WL_PUR_CD | CHAR | 2 | OIU_PR_WLPUR | |
LSE_LE_WL_FL | Lease line well flag | OIU_LE_WL_FL | CHAR | 2 | ||
BEG_PRF_DPH | Begin Perforation Depth | OIU_BEG_PRF | QUAN | 9 | ||
END_PRF_DPH | End Performation Depth | OIU_END_PRF | QUAN | 9 | ||
ALT_WC_KEY | Alternate WC Key | OIU_ALT_WC_KEY | CHAR | 80 | ||
LCL_WL_NO | Local Well Number | OIU_LCL_WL_NO | CHAR | 30 | ||
WC_SET | Well Completion Hierarchy Group | OIU_WC_SET | CHAR | 30 | ||
DOCNR | Well completion document number | OIUPR_WC_DOCNR | CHAR | 20 | ||
DOCYR | Document year | OIU_DOC_YEAR | NUMC | 8 | ||
OR1_OR_LVL_1_NO | Org. Level 1 - Company | OIUH_CHAR3_ORGLVL1 | CHAR | 6 | OIUH_CM_OR1 | |
OR2_OR_LVL_2_NO | Second-highest organization level number ( Company Code) | OIUH_CHAR1_ORGLVL2 | CHAR | 2 | OIUH_CM_OR2 | |
OR3_OR_LVL_3_NO | Third-highest organization level number ( Company Code) | OIUH_CHAR3_ORGLVL3 | CHAR | 6 | OIUH_CM_OR3 | |
OR4_OR_LVL_4_NO | Fourth-highest organization level number ( Company Code) | OIUH_CHAR2_ORGLVL4 | CHAR | 4 | OIUH_CM_OR4 | |
.INCLUDE | OIU_CREATION | 0 | ||||
OIU_CRUSER | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 8 | ||
PCK_DPTH | Packer Depth | OIU_PACK_DPTH | QUAN | 9 | ||
.INCLU--AP | /PRA/S_PR_WC | 0 | ||||
API_SIDT | Reg.Reporting - API Side Track | OIUREP_API_SIDT | CHAR | 4 | ||
CBM_INDICATOR | Coal Bed Methane Indicator | /PRA/CBM_INDICATOR | CHAR | 2 |