OIU_PR_PF

Transparent Table Application Table
19 Fields 1 CDS Views

PRA: Platform

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OffshorePlatform view from BASIC Offshore Platform

Fields (19)

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

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]
    PRIMARY KEY (MANDT, PF_NO)
);

Learn More