SAP table OIU_PR_WC (PRA: Well Completion)
SAP table OIU_PR_WC has 3 primary key fields being MANDT,WL_NO,WC_NO.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | MANDT | ||
| WL_NO | Well ID number | CHAR | 15 | 0 | OIU_PR_WELL | OIU_WL_NO | |
| WC_NO | Well Completion Number | CHAR | 5 | 0 | OIU_WC_NO | ||
| API_WC_NO | API well completion number | CHAR | 3 | 0 | OIU_API_WC_NO | ||
| NAME | Well completion name | CHAR | 35 | 0 | OIU_WC_NM_CONV | ||
| SHTXT | Description | CHAR | 35 | 0 | OIU_SHTXT | ||
| UOM_GRP | unit of measure group | CHAR | 3 | 0 | OIU_ME_UOM_GR | OIU_ME_UOMGR | |
| DEV_PGM_NO | Development program number | CHAR | 2 | 0 | OIU_PR_WLPROG | OIU_DEV_PGM_NO | |
| LAT_NO | Latitude number | DEC | 8 | 6 | OIU_LAT_NO | ||
| LAT_DIR_CD | Latitude direction code | CHAR | 1 | 0 | OIU_LAT_DIR_CD | ||
| LNG_NO | Longitude | DEC | 9 | 6 | OIU_LNG_NO | ||
| LNG_DIR_CD | Longitude Direction Code | CHAR | 1 | 0 | OIU_LNG_DIR_CD | ||
| ELEV_DPH_U | Elevation/Depth Unit | UNIT | 3 | 0 | OIU_ELEV_DPH_U | ||
| PLG_BCK_DPTH | Plug hole depth | QUAN | 17 | 3 | OIU_PLG_DPTH | ||
| DATUM_DPTH | Datum depth | QUAN | 17 | 3 | OIU_DATUM_DPTH | ||
| KB_ELEV | KB elevation | QUAN | 17 | 3 | OIU_KB_ELEV | ||
| BASE_BHP_U | Base bottom hole pressure | UNIT | 3 | 0 | OIU_BASE_BHP_U | ||
| BASE_BHP | Base bottom hole pressure (BHP) | QUAN | 17 | 3 | OIU_BASE_BHP | ||
| CNTRY_CD | Country/Region | CHAR | 3 | 0 | T005 | OIU_COUNTRY | |
| PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | CHAR | 2 | 0 | OIU_CM_LXPGL | OIU_PRI_GEO_LOC | |
| SEC_GEO_LOC | Secondary geographic location | CHAR | 3 | 0 | OIU_CM_LXSGL | OIU_SEC_GEO_LOC | |
| RESRV | Reservoir ID | CHAR | 10 | 0 | OIU_PR_RESRV | OIU_RESRVID | |
| RESZN | Reservoir zone | CHAR | 10 | 0 | OIU_PR_RESZN | OIU_RESZNID | |
| FIELD | Field ID | CHAR | 10 | 0 | OIU_PR_FIELD | OIU_FIELDID | |
| PF_NO | Platform number | CHAR | 10 | 0 | OIU_PR_PF | OIU_PF_NO | |
| PUR_CD | Well purpose code | CHAR | 1 | 0 | OIU_PR_WLPUR | OIU_WL_PUR_CD | |
| LSE_LE_WL_FL | Lease line well flag | CHAR | 1 | 0 | OIU_LE_WL_FL | ||
| BEG_PRF_DPH | Begin Perforation Depth | QUAN | 17 | 3 | OIU_BEG_PRF | ||
| END_PRF_DPH | End Performation Depth | QUAN | 17 | 3 | OIU_END_PRF | ||
| ALT_WC_KEY | Alternate WC Key | CHAR | 40 | 0 | OIU_ALT_WC_KEY | ||
| LCL_WL_NO | Local Well Number | CHAR | 15 | 0 | OIU_LCL_WL_NO | ||
| WC_SET | Well Completion Hierarchy Group | CHAR | 15 | 0 | OIU_WC_SET | ||
| DOCNR | Well completion document number | CHAR | 10 | 0 | OIUPR_WC_DOCNR | ||
| DOCYR | Document year | NUMC | 4 | 0 | OIU_DOC_YEAR | ||
| OR1_OR_LVL_1_NO | Org. Level 1 - Company | CHAR | 3 | 0 | OIUH_CM_OR1 | OIUH_CHAR3_ORGLVL1 | |
| OR2_OR_LVL_2_NO | Second-highest organization level number ( Company Code) | CHAR | 1 | 0 | OIUH_CM_OR2 | OIUH_CHAR1_ORGLVL2 | |
| OR3_OR_LVL_3_NO | Third-highest organization level number ( Company Code) | CHAR | 3 | 0 | OIUH_CM_OR3 | OIUH_CHAR3_ORGLVL3 | |
| OR4_OR_LVL_4_NO | Fourth-highest organization level number ( Company Code) | CHAR | 2 | 0 | OIUH_CM_OR4 | OIUH_CHAR2_ORGLVL4 | |
| OIU_CRUSER | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TZNTSTMPS | ||
| PCK_DPTH | Packer Depth | QUAN | 17 | 3 | OIU_PACK_DPTH | ||
| API_SIDT | Reg.Reporting - API Side Track | CHAR | 2 | 0 | OIUREP_API_SIDT | ||
| CBM_INDICATOR | Coal Bed Methane Indicator | CHAR | 1 | 0 | /PRA/CBM_INDICATOR |
OIU_PR_WC foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 OIU_PR_WC | CNTRY_CD | T005 | Countries | MANDT |
| 0 OIU_PR_WC | CNTRY_CD | T005 | Countries | LAND1 |
| 1 OIU_PR_WC | DEV_PGM_NO | OIU_PR_WLPROG | WELL COMP PROGRAM ID AND NAME - TBLCM016 | MANDT |
| 1 OIU_PR_WC | DEV_PGM_NO | OIU_PR_WLPROG | WELL COMP PROGRAM ID AND NAME - TBLCM016 | DEV_PGM_NO |
| 0 OIU_PR_WC | FIELD | OIU_PR_FIELD | Field | MANDT |
| 1 OIU_PR_WC | OR1_OR_LVL_1_NO | OIUH_CM_OR1 | Organization Level 1 Table | MANDT |
| 0 OIU_PR_WC | OR2_OR_LVL_2_NO | OIUH_CM_OR2 | Organization Level 2 Table | MANDT |
| 0 OIU_PR_WC | OR2_OR_LVL_2_NO | OIUH_CM_OR2 | Organization Level 2 Table | OR2_OR_LVL_2_NO |
| 1 OIU_PR_WC | OR3_OR_LVL_3_NO | OIUH_CM_OR3 | Organizational Level 3 Table | MANDT |
| 1 OIU_PR_WC | OR3_OR_LVL_3_NO | OIUH_CM_OR3 | Organizational Level 3 Table | OR3_OR_LVL_2_NO |
| 0 OIU_PR_WC | OR4_OR_LVL_4_NO | OIUH_CM_OR4 | Organizational Level 4 Table | MANDT |
| 0 OIU_PR_WC | OR4_OR_LVL_4_NO | OIUH_CM_OR4 | Organizational Level 4 Table | OR4_OR_LVL_2_NO |
| 0 OIU_PR_WC | OR4_OR_LVL_4_NO | OIUH_CM_OR4 | Organizational Level 4 Table | OR4_OR_LVL_4_NO |
| 1 OIU_PR_WC | PF_NO | OIU_PR_PF | PRA: Platform | MANDT |
| 1 OIU_PR_WC | PF_NO | OIU_PR_PF | PRA: Platform | PF_NO |
| 0 OIU_PR_WC | PRI_GEO_LOC | OIU_CM_LXPGL | Country and Primary Geo. Location Xref | MANDT |
| 0 OIU_PR_WC | PRI_GEO_LOC | OIU_CM_LXPGL | Country and Primary Geo. Location Xref | LAND1 |
| 0 OIU_PR_WC | PRI_GEO_LOC | OIU_CM_LXPGL | Country and Primary Geo. Location Xref | PRI_GEO_LOC |
| 1 OIU_PR_WC | PUR_CD | OIU_PR_WLPUR | WELL PURPOSE CODES TABLE - TBLCM019 | MANDT |
| 1 OIU_PR_WC | PUR_CD | OIU_PR_WLPUR | WELL PURPOSE CODES TABLE - TBLCM019 | WL_PUR_CD |
| 0 OIU_PR_WC | RESRV | OIU_PR_RESRV | PRA: Reservoir | MANDT |
| 0 OIU_PR_WC | RESRV | OIU_PR_RESRV | PRA: Reservoir | RESRV |
| 1 OIU_PR_WC | RESZN | OIU_PR_RESZN | PRA: Reservoir Zone Identification | MANDT |
| 1 OIU_PR_WC | RESZN | OIU_PR_RESZN | PRA: Reservoir Zone Identification | RESRV |
| 0 OIU_PR_WC | SEC_GEO_LOC | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | MANDT |
| 0 OIU_PR_WC | SEC_GEO_LOC | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | LAND1 |
| 0 OIU_PR_WC | SEC_GEO_LOC | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | PRI_GEO_LOC |
| 1 OIU_PR_WC | UOM_GRP | OIU_ME_UOM_GR | PRA Measurement: Unit of Measurement Groups | MANDT |
| 0 OIU_PR_WC | WL_NO | OIU_PR_WELL | PRA: Well | MANDT |
| 0 OIU_PR_WC | WL_NO | OIU_PR_WELL | PRA: Well | WL_NO |