OIU_PR_PF

Transparent Table Application Table
21 Fields 3 CDS Views

PRA: Platform

OIU_PR_PF is an SAP database table in S/4HANA. PRA: Platform. It contains 21 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_OffshorePlatform view from BASIC Offshore Platform
UPOV_PR_PF_PRA view from PRA: Platform
UPOV_TRIM_PLATFORM_PRA view from Trimmed Platform Value of PRA

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pf_no OIU_PF_NO Platform
first_prd_dt OIU_FIRST_PRD_DT First prod.date
instl_dt OIU_INST_DT Installation Date
pf_name OIU_PF_NAME Platform Name
shtxt OIU_SHTXT Description
lat_no OIU_LAT_NO Latitude
lat_dir_cd OIU_LAT_DIR_CD Latitude DC
lng_no OIU_LNG_NO Longitude
lng_dir_cd OIU_LNG_DIR_CD Longitude DC
rte_u OIU_RTE_U Rotary Elev. Unit
rte OIU_RTE Rotary Tbl Elev
type_cd OIU_PF_TYP_CD Platform Type
watr_dph_u OIU_WATR_DPH_U Water Depth Unit
watr_dph OIU_WATR_DPH Water depth
location_cd OIU_OFFSHO_CD Offshore code
pf_grp OIU_PF_GRP PF number group
docnr OIUPR_PF_DOCNR Doc.no.
docyr OIU_DOC_YEAR Document year
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- PRA: Platform
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_PF (
    MANDT,          -- Client [MANDT]
    PF_NO,          -- Platform [OIU_PF_NO]
    FIRST_PRD_DT,   -- First prod.date [OIU_FIRST_PRD_DT]
    INSTL_DT,       -- Installation Date [OIU_INST_DT]
    PF_NAME,        -- Platform Name [OIU_PF_NAME]
    SHTXT,          -- Description [OIU_SHTXT]
    LAT_NO,         -- Latitude [OIU_LAT_NO]
    LAT_DIR_CD,     -- Latitude DC [OIU_LAT_DIR_CD]
    LNG_NO,         -- Longitude [OIU_LNG_NO]
    LNG_DIR_CD,     -- Longitude DC [OIU_LNG_DIR_CD]
    RTE_U,          -- Rotary Elev. Unit [OIU_RTE_U]
    RTE,            -- Rotary Tbl Elev [OIU_RTE]
    TYPE_CD,        -- Platform Type [OIU_PF_TYP_CD]
    WATR_DPH_U,     -- Water Depth Unit [OIU_WATR_DPH_U]
    WATR_DPH,       -- Water depth [OIU_WATR_DPH]
    LOCATION_CD,    -- Offshore code [OIU_OFFSHO_CD]
    PF_GRP,         -- PF number group [OIU_PF_GRP]
    DOCNR,          -- Doc.no. [OIUPR_PF_DOCNR]
    DOCYR,          -- Document year [OIU_DOC_YEAR]
    OIU_CRUSER,     -- Created By [ERNAM]
    OIU_TIMESTAMP,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, PF_NO)
);

Learn More