OIUREP_COF7_FDTL

Transparent Table Application Table
53 Fields 1 CDS Views

Colorado Form 7 Persisted FInal Run Structured Detail

OIUREP_COF7_FDTL is an SAP database table in S/4HANA. Colorado Form 7 Persisted FInal Run Structured Detail. It contains 53 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
OIUREP_COF7_OWNER_RPT view inner Sample View for Colorado Owner Form 7

Fields (53)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY reg_number OIUREP_COF7_FINAL_RUN CO Form 7 Run
KEY dtl_seq_no OIUREP_DTL_SEQ_NO Sequence
head_seqnr OIUREP_HEAD_SEQNR HeadSequNo
rec_type OIUREP_OGR_REC_TYPE Record Type
form_name abap.char
prod_month OIU_REPMONTH ReportingMonth
prod_year OIU_REPYEAR Reporting Year
oper_nbr OIUREP_CO_OPER_NBR Operator No.
oper_nbrb OIUREP_CO_OPER_NBRB OperNoSuffix
operator_name OIUREP_CO_OPERATOR Operator
address OIUREP_CO_ADDRESS Address
city OIUREP_CO_CITY City
state OIUREP_CO_STATE State
zip OIUREP_CO_ZIP ZIP
phoneac OIUREP_PHONEAC Phone Area Code
phonenbr OIUREP_PHONENBR Phone Number
faxac OIUREP_FAXAC Fax Area Code
faxnbr OIUREP_FAXNBR Fax Number
revised OIUREP_CO_REVISED Revised
api_cty OIUREP_API_CTY County
api_seq OIUREP_API_SEQ API Seq
api_sidt OIUREP_API_SIDT APISidt
wl_name_nbr OIUREP_CO_WL_NAME_NBR CO Well No.
form_cd OIUREP_CO_FORM_CD_NEW FormationCd
well_stat OIUREP_WELL_STAT MMS Well Status
days_prod OIUREP_OGA_DAYS_PROD Days Produced
qq OIUREP_CO_QQ Quarter
sec OIUREP_CO_SEC Section
twp OIUREP_CO_TWP Township
rng OIUREP_CO_RNG Rng
beg_inv OIUREP_CO_BEG_INV_VOL Beg. Inventory
oil_prod OIUREP_OGA_PROD_VOL_OILCOND Oil/Cond Prod Vol
oil_sold OIUREP_CO_OIL_SOLD Oil sold
oil_adj OIUREP_CO_OIL_ADJ Oil adjusted
end_inv OIUREP_OGC_END_INV_VOL Ending Inventory
gas_prod OIUREP_OGA_PROD_VOL_GAS Gas Prod Vol
gas_flared OIUREP_CO_GAS_FLARED Gas flared
gas_used OIUREP_CO_GAS_USED Gas used
gas_shrink OIUREP_CO_GAS_SHRINK Gas shrink
gas_sold OIUREP_CO_GAS_SOLD Gas sold
oil_grav OIUREP_CO_OIL_GRAV API Gravity
gas_btu OIUREP_CO_GAS_BTU BTU
water_prod OIUREP_OGA_PROD_VOL_WATER Water Prod Vol
water_disp_cd OIUREP_CO_WATER_DISP_CD WaterDispCd
water_tbg_pres OIUREP_CO_WATER_TBG_PRES WTubingPres
water_csg_pres OIUREP_CO_WATER_CSG_PRES WaterCsgPres
gas_tbg_pres OIUREP_CO_GAS_TBG_PRES GTubingPres
gas_csg_pres OIUREP_CO_GAS_CSG_PRES GasCsgPres
print_name OIUREP_PRINT_NAME Print name
signed OIUREP_SIGNED Signed
title OIUREP_TITLE Title
signed_date OIUREP_DATE_MMDDYYYY Date

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.

-- Colorado Form 7 Persisted FInal Run Structured Detail
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIUREP_COF7_FDTL (
    MANDT,           -- Client [MANDT]
    REG_NUMBER,      -- CO Form 7 Run [OIUREP_COF7_FINAL_RUN]
    DTL_SEQ_NO,      -- Sequence [OIUREP_DTL_SEQ_NO]
    HEAD_SEQNR,      -- HeadSequNo [OIUREP_HEAD_SEQNR]
    REC_TYPE,        -- Record Type [OIUREP_OGR_REC_TYPE]
    FORM_NAME,       -- abap.char
    PROD_MONTH,      -- ReportingMonth [OIU_REPMONTH]
    PROD_YEAR,       -- Reporting Year [OIU_REPYEAR]
    OPER_NBR,        -- Operator No. [OIUREP_CO_OPER_NBR]
    OPER_NBRB,       -- OperNoSuffix [OIUREP_CO_OPER_NBRB]
    OPERATOR_NAME,   -- Operator [OIUREP_CO_OPERATOR]
    ADDRESS,         -- Address [OIUREP_CO_ADDRESS]
    CITY,            -- City [OIUREP_CO_CITY]
    STATE,           -- State [OIUREP_CO_STATE]
    ZIP,             -- ZIP [OIUREP_CO_ZIP]
    PHONEAC,         -- Phone Area Code [OIUREP_PHONEAC]
    PHONENBR,        -- Phone Number [OIUREP_PHONENBR]
    FAXAC,           -- Fax Area Code [OIUREP_FAXAC]
    FAXNBR,          -- Fax Number [OIUREP_FAXNBR]
    REVISED,         -- Revised [OIUREP_CO_REVISED]
    API_CTY,         -- County [OIUREP_API_CTY]
    API_SEQ,         -- API Seq [OIUREP_API_SEQ]
    API_SIDT,        -- APISidt [OIUREP_API_SIDT]
    WL_NAME_NBR,     -- CO Well No. [OIUREP_CO_WL_NAME_NBR]
    FORM_CD,         -- FormationCd [OIUREP_CO_FORM_CD_NEW]
    WELL_STAT,       -- MMS Well Status [OIUREP_WELL_STAT]
    DAYS_PROD,       -- Days Produced [OIUREP_OGA_DAYS_PROD]
    QQ,              -- Quarter [OIUREP_CO_QQ]
    SEC,             -- Section [OIUREP_CO_SEC]
    TWP,             -- Township [OIUREP_CO_TWP]
    RNG,             -- Rng [OIUREP_CO_RNG]
    BEG_INV,         -- Beg. Inventory [OIUREP_CO_BEG_INV_VOL]
    OIL_PROD,        -- Oil/Cond Prod Vol [OIUREP_OGA_PROD_VOL_OILCOND]
    OIL_SOLD,        -- Oil sold [OIUREP_CO_OIL_SOLD]
    OIL_ADJ,         -- Oil adjusted [OIUREP_CO_OIL_ADJ]
    END_INV,         -- Ending Inventory [OIUREP_OGC_END_INV_VOL]
    GAS_PROD,        -- Gas Prod Vol [OIUREP_OGA_PROD_VOL_GAS]
    GAS_FLARED,      -- Gas flared [OIUREP_CO_GAS_FLARED]
    GAS_USED,        -- Gas used [OIUREP_CO_GAS_USED]
    GAS_SHRINK,      -- Gas shrink [OIUREP_CO_GAS_SHRINK]
    GAS_SOLD,        -- Gas sold [OIUREP_CO_GAS_SOLD]
    OIL_GRAV,        -- API Gravity [OIUREP_CO_OIL_GRAV]
    GAS_BTU,         -- BTU [OIUREP_CO_GAS_BTU]
    WATER_PROD,      -- Water Prod Vol [OIUREP_OGA_PROD_VOL_WATER]
    WATER_DISP_CD,   -- WaterDispCd [OIUREP_CO_WATER_DISP_CD]
    WATER_TBG_PRES,  -- WTubingPres [OIUREP_CO_WATER_TBG_PRES]
    WATER_CSG_PRES,  -- WaterCsgPres [OIUREP_CO_WATER_CSG_PRES]
    GAS_TBG_PRES,    -- GTubingPres [OIUREP_CO_GAS_TBG_PRES]
    GAS_CSG_PRES,    -- GasCsgPres [OIUREP_CO_GAS_CSG_PRES]
    PRINT_NAME,      -- Print name [OIUREP_PRINT_NAME]
    SIGNED,          -- Signed [OIUREP_SIGNED]
    TITLE,           -- Title [OIUREP_TITLE]
    SIGNED_DATE,     -- Date [OIUREP_DATE_MMDDYYYY]
    PRIMARY KEY (MANDT, REG_NUMBER, DTL_SEQ_NO)
);

Learn More