OIU_PR_WELL

Transparent Table Application Table
31 Fields 4 CDS Views

PRA: Well

OIU_PR_WELL is an SAP database table in S/4HANA. PRA: Well. It contains 31 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 (31)

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
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: 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]
    OIU_CRUSER,     -- Created By [ERNAM]
    OIU_TIMESTAMP,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, WL_NO)
);

Learn More