OIU_PR_WC

Transparent Table Application Table
43 Fields 4 CDS Views

PRA: Well Completion

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_PRAWellCompletion view_entity from BASIC PRA Well Completion
I_WellCompletion view from BASIC Well Completion
UPOV_PR_WC_PRA view from PRA: Well Completion
UPOV_TRIM_WC_PRA view from Trimmed Well and WC of PRA

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY wl_no OIU_WL_NO Well
KEY wc_no OIU_WC_NO Well Completion
api_wc_no OIU_API_WC_NO API WC NO
name OIU_WC_NM_CONV WC name
shtxt OIU_SHTXT Description
uom_grp OIU_ME_UOMGR UoM group
dev_pgm_no OIU_DEV_PGM_NO Program
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
elev_dph_u OIU_ELEV_DPH_U Elev/Depth Unit
plg_bck_dpth OIU_PLG_DPTH PH depth
datum_dpth OIU_DATUM_DPTH Datum depth
kb_elev OIU_KB_ELEV KB elevation
base_bhp_u OIU_BASE_BHP_U Base BHP
base_bhp OIU_BASE_BHP Base BHP
cntry_cd OIU_COUNTRY Country/Reg.
pri_geo_loc OIU_PRI_GEO_LOC Primary geo.loc
sec_geo_loc OIU_SEC_GEO_LOC Secndry geo.loc
resrv OIU_RESRVID Reservoir
reszn OIU_RESZNID Reservoir Zone
field OIU_FIELDID Field
pf_no OIU_PF_NO Platform
pur_cd OIU_WL_PUR_CD Purpose
lse_le_wl_fl OIU_LE_WL_FL Lease line well
beg_prf_dph OIU_BEG_PRF Perforated From
end_prf_dph OIU_END_PRF Perforated To
alt_wc_key OIU_ALT_WC_KEY Alter. WC Key
lcl_wl_no OIU_LCL_WL_NO Local Well
wc_set OIU_WC_SET WC Hier Node
docnr OIUPR_WC_DOCNR Doc.no.
docyr OIU_DOC_YEAR Document year
or1_or_lvl_1_no OIUH_CHAR3_ORGLVL1 Org Level 1
or2_or_lvl_2_no OIUH_CHAR1_ORGLVL2 Org Level 2
or3_or_lvl_3_no OIUH_CHAR3_ORGLVL3 Org Level 3
or4_or_lvl_4_no OIUH_CHAR2_ORGLVL4 Org Level 4
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp
pck_dpth OIU_PACK_DPTH PCK depth
api_sidt OIUREP_API_SIDT APISidt
cbm_indicator /PRA/CBM_INDICATOR Coal Bed Methane

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 Completion
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_WC (
    MANDT,            -- Client [MANDT]
    WL_NO,            -- Well [OIU_WL_NO]
    WC_NO,            -- Well Completion [OIU_WC_NO]
    API_WC_NO,        -- API WC NO [OIU_API_WC_NO]
    NAME,             -- WC name [OIU_WC_NM_CONV]
    SHTXT,            -- Description [OIU_SHTXT]
    UOM_GRP,          -- UoM group [OIU_ME_UOMGR]
    DEV_PGM_NO,       -- Program [OIU_DEV_PGM_NO]
    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]
    ELEV_DPH_U,       -- Elev/Depth Unit [OIU_ELEV_DPH_U]
    PLG_BCK_DPTH,     -- PH depth [OIU_PLG_DPTH]
    DATUM_DPTH,       -- Datum depth [OIU_DATUM_DPTH]
    KB_ELEV,          -- KB elevation [OIU_KB_ELEV]
    BASE_BHP_U,       -- Base BHP [OIU_BASE_BHP_U]
    BASE_BHP,         -- Base BHP [OIU_BASE_BHP]
    CNTRY_CD,         -- Country/Reg. [OIU_COUNTRY]
    PRI_GEO_LOC,      -- Primary geo.loc [OIU_PRI_GEO_LOC]
    SEC_GEO_LOC,      -- Secndry geo.loc [OIU_SEC_GEO_LOC]
    RESRV,            -- Reservoir [OIU_RESRVID]
    RESZN,            -- Reservoir Zone [OIU_RESZNID]
    FIELD,            -- Field [OIU_FIELDID]
    PF_NO,            -- Platform [OIU_PF_NO]
    PUR_CD,           -- Purpose [OIU_WL_PUR_CD]
    LSE_LE_WL_FL,     -- Lease line well [OIU_LE_WL_FL]
    BEG_PRF_DPH,      -- Perforated From [OIU_BEG_PRF]
    END_PRF_DPH,      -- Perforated To [OIU_END_PRF]
    ALT_WC_KEY,       -- Alter. WC Key [OIU_ALT_WC_KEY]
    LCL_WL_NO,        -- Local Well [OIU_LCL_WL_NO]
    WC_SET,           -- WC Hier Node [OIU_WC_SET]
    DOCNR,            -- Doc.no. [OIUPR_WC_DOCNR]
    DOCYR,            -- Document year [OIU_DOC_YEAR]
    OR1_OR_LVL_1_NO,  -- Org Level 1 [OIUH_CHAR3_ORGLVL1]
    OR2_OR_LVL_2_NO,  -- Org Level 2 [OIUH_CHAR1_ORGLVL2]
    OR3_OR_LVL_3_NO,  -- Org Level 3 [OIUH_CHAR3_ORGLVL3]
    OR4_OR_LVL_4_NO,  -- Org Level 4 [OIUH_CHAR2_ORGLVL4]
    OIU_CRUSER,       -- Created By [ERNAM]
    OIU_TIMESTAMP,    -- Time Stamp [TZNTSTMPS]
    PCK_DPTH,         -- PCK depth [OIU_PACK_DPTH]
    API_SIDT,         -- APISidt [OIUREP_API_SIDT]
    CBM_INDICATOR,    -- Coal Bed Methane [/PRA/CBM_INDICATOR]
    PRIMARY KEY (MANDT, WL_NO, WC_NO)
);

Learn More