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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||
| LAT_DIR_CD | Latitude direction code | OIU_LAT_DIR_CD | CHAR | 1 | 0 |
Possible values
|
||||||||
| LNG_NO | Longitude | OIU_LNG_NO | DEC | 9 | 6 |
Possible values
|
||||||||
| LNG_DIR_CD | Longitude Direction Code | OIU_LNG_DIR_CD | CHAR | 1 | 0 |
Possible values
|
||||||||
| 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 |
Possible values
|
||||||||
| 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 | DEV_PGM_NO | OIU_PR_WLPROG | WELL COMP PROGRAM ID AND NAME - TBLCM016 | DEV_PGM_NO |
| OIU_PR_WC | DEV_PGM_NO | OIU_PR_WC | MANDT | OIU_PR_WLPROG | WELL COMP PROGRAM ID AND NAME - TBLCM016 | MANDT |
| OIU_PR_WC | FIELD | OIU_PR_WC | FIELD | OIU_PR_FIELD | Field | FIELD |
| OIU_PR_WC | FIELD | OIU_PR_WC | MANDT | OIU_PR_FIELD | Field | MANDT |
| 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 | 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 | OR2_OR_LVL_2_NO | OIU_PR_WC | MANDT | OIUH_CM_OR2 | Organization Level 2 Table | MANDT |
| 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 | 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 | 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 | 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 | 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 | 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 | PRI_GEO_LOC | OIU_PR_WC | PRI_GEO_LOC | OIU_CM_LXPGL | Country and Primary Geo. Location Xref | PRI_GEO_LOC |
| 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 | 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 | RESZN | OIU_PR_WC | MANDT | OIU_PR_RESZN | PRA: Reservoir Zone Identification | MANDT |
| 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 | 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 | UOM_GRP | OIU_PR_WC | MANDT | OIU_ME_UOM_GR | PRA Measurement: Unit of Measurement Groups | MANDT |
| OIU_PR_WC | UOM_GRP | OIU_PR_WC | UOM_GRP | OIU_ME_UOM_GR | PRA Measurement: Unit of Measurement Groups | UOMGR |
| 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 |
