SAP Table OIU_PR_PF
PRA: Platform
OIU_PR_PF (PRA: Platform) 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_PF to other SAP tables.
OIU_PR_PF table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||
| PF_NO | Platform number | OIU_PF_NO | CHAR | 10 | 0 | |||||||||
| FIRST_PRD_DT | First production date | OIU_FIRST_PRD_DT | DATS | 8 | 0 | |||||||||
| INSTL_DT | Installation Date | OIU_INST_DT | DATS | 8 | 0 | |||||||||
| PF_NAME | Platform Name | OIU_PF_NAME | CHAR | 35 | 0 | |||||||||
| SHTXT | Description | OIU_SHTXT | CHAR | 35 | 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
|
||||||||
| RTE_U | Rotary Table Elevation Unit | OIU_RTE_U | T006 | UNIT | 3 | 0 | ||||||||
| RTE | Rotary Table elevation | OIU_RTE | QUAN | 13 | 3 | |||||||||
| TYPE_CD | Platform Type | OIU_PF_TYP_CD | OIU_PR_PFTYP | CHAR | 2 | 0 | ||||||||
| WATR_DPH_U | Water depth unit | OIU_WATR_DPH_U | T006 | UNIT | 3 | 0 | ||||||||
| WATR_DPH | Water depth | OIU_WATR_DPH | QUAN | 13 | 3 | |||||||||
| LOCATION_CD | Offshore code | OIU_OFFSHO_CD | OIU_PR_PFLOC | CHAR | 1 | 0 | ||||||||
| PF_GRP | Platform group | OIU_PF_GRP | OIU_PR_PF_GRP | CHAR | 4 | 0 | ||||||||
| DOCNR | Platform document number | OIUPR_PF_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_PF foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OIU_PR_PF | LOCATION_CD | OIU_PR_PF | MANDT | OIU_PR_PFLOC | Platform location | MANDT |
| OIU_PR_PF | LOCATION_CD | OIU_PR_PF | LOCATION_CD | OIU_PR_PFLOC | Platform location | OFFSHO_CD |
| OIU_PR_PF | PF_GRP | OIU_PR_PF | MANDT | OIU_PR_PF_GRP | PRA: Platform Group Codes | MANDT |
| OIU_PR_PF | PF_GRP | OIU_PR_PF | PF_GRP | OIU_PR_PF_GRP | PRA: Platform Group Codes | PF_GRP |
| OIU_PR_PF | RTE_U | OIU_PR_PF | MANDT | T006 | Units of Measurement | MANDT |
| OIU_PR_PF | RTE_U | OIU_PR_PF | RTE_U | T006 | Units of Measurement | MSEHI |
| OIU_PR_PF | TYPE_CD | OIU_PR_PF | MANDT | OIU_PR_PFTYP | PLATFORM TYPE - TBLPR009 | MANDT |
| OIU_PR_PF | TYPE_CD | OIU_PR_PF | TYPE_CD | OIU_PR_PFTYP | PLATFORM TYPE - TBLPR009 | PF_TYP_CD |
| OIU_PR_PF | WATR_DPH_U | OIU_PR_PF | MANDT | T006 | Units of Measurement | MANDT |
| OIU_PR_PF | WATR_DPH_U | OIU_PR_PF | WATR_DPH_U | T006 | Units of Measurement | MSEHI |
