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 | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||
|
||||||||||||||
|
LAT_DIR_CD
Latitude direction code
|
OIU_LAT_DIR_CD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
LNG_NO
Longitude
|
OIU_LNG_NO |
DEC
|
9 | 6 | ||||||||||
|
||||||||||||||
|
LNG_DIR_CD
Longitude Direction Code
|
OIU_LNG_DIR_CD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
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 |