OIU_PR_WELL

Transparent Table Application Table
29 Fields 4 CDS Views

PRA: Well

OIU_PR_WELL is an SAP database table in S/4HANA. PRA: Well. It contains 29 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_PRAWell view_entity from BASIC
I_Well view from BASIC Well
UPOV_PR_WELL_PRA view from PRA: Well
UPOV_TRIM_WELL_PRA view from Trimmed Well Value of PRA

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY wl_no oiu_wl_no Well
api_no oiu_wlapi API well number
wl_de oiu_wl_de_conv Well Description
shtxt oiu_shtxt Description
dev_cd oiu_dev_cd Well drilled
gle_u oiu_gle_u GLE unit
gle oiu_gle GL elevation
slot_no oiu_slot_no Base Meridian
sur_lat_no oiu_sur_lat_no Latitude
sur_lat_d_cd oiu_sur_lat_d_cd Latitude Dir.
sur_lng_no oiu_sur_lng_no Longitude
sur_lng_d_cd oiu_sur_lng_d_cd Longitude Dir.
leg_de oiu_leg_de Legal Desc.
do_dpth_u oiu_do_dpth_u DO depth unit
do_dpth oiu_do_dpth Drill-out depth
qtr_1_no oiu_qtr_1_no Qtr 1
qtr_2_no oiu_qtr_2_no Qtr 2
section_no oiu_section_no Section
twp_no oiu_twp_no Township
twp_dir_cd oiu_twp_dir_cd Township dir.
rng_no oiu_rng_no Range
rng_dir_cd oiu_rng_dir_cd Range Direction
targ_dpth_u oiu_targ_dpth_u TD unit
targ_dpth oiu_targ_dpth Target depth
mms_owner_cd oiu_mms_owner_fl MMS Ownership
wl_grp oiu_wl_grp WL Number Group
docnr oiupr_wl_docnr Well 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: Well
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_WELL (
    MANDT,         -- Client [mandt]
    WL_NO,         -- Well [oiu_wl_no]
    API_NO,        -- API well number [oiu_wlapi]
    WL_DE,         -- Well Description [oiu_wl_de_conv]
    SHTXT,         -- Description [oiu_shtxt]
    DEV_CD,        -- Well drilled [oiu_dev_cd]
    GLE_U,         -- GLE unit [oiu_gle_u]
    GLE,           -- GL elevation [oiu_gle]
    SLOT_NO,       -- Base Meridian [oiu_slot_no]
    SUR_LAT_NO,    -- Latitude [oiu_sur_lat_no]
    SUR_LAT_D_CD,  -- Latitude Dir. [oiu_sur_lat_d_cd]
    SUR_LNG_NO,    -- Longitude [oiu_sur_lng_no]
    SUR_LNG_D_CD,  -- Longitude Dir. [oiu_sur_lng_d_cd]
    LEG_DE,        -- Legal Desc. [oiu_leg_de]
    DO_DPTH_U,     -- DO depth unit [oiu_do_dpth_u]
    DO_DPTH,       -- Drill-out depth [oiu_do_dpth]
    QTR_1_NO,      -- Qtr 1 [oiu_qtr_1_no]
    QTR_2_NO,      -- Qtr 2 [oiu_qtr_2_no]
    SECTION_NO,    -- Section [oiu_section_no]
    TWP_NO,        -- Township [oiu_twp_no]
    TWP_DIR_CD,    -- Township dir. [oiu_twp_dir_cd]
    RNG_NO,        -- Range [oiu_rng_no]
    RNG_DIR_CD,    -- Range Direction [oiu_rng_dir_cd]
    TARG_DPTH_U,   -- TD unit [oiu_targ_dpth_u]
    TARG_DPTH,     -- Target depth [oiu_targ_dpth]
    MMS_OWNER_CD,  -- MMS Ownership [oiu_mms_owner_fl]
    WL_GRP,        -- WL Number Group [oiu_wl_grp]
    DOCNR,         -- Well doc.no. [oiupr_wl_docnr]
    DOCYR,         -- Document year [oiu_doc_year]
    PRIMARY KEY (MANDT, WL_NO)
);

Learn More