OIURV_DOC_FRMLAU

Transparent Table Application Table

Valuation Formula Alternate Use

OIURV_DOC_FRMLAU is an SAP database table in S/4HANA. Valuation Formula Alternate Use. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAValnDocFmlaAlternateUse view_entity from BASIC Valuation Formula Alternate Use

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY doc_no oiurv_docnr DocNr
KEY doc_year oiu_doc_year Document year
KEY line_no oiu_doc_linenr Doc Line No.
KEY seq_no oiu_own_isq_no Own. ISQ
vsrc_wl_no oiu_wl_no Well
vsrc_wc_no oiu_wc_no Well Completion
vsrc_mp_no oiu_mp_no Measurement Pt
vsrc_ct_no oiu_ct_no Contract
rvwd_matnr matnr Material
rvwd_type_cd oiu_rvwd_type_code Res Word Type
rvwd_vt_type_cd oiu_vt_cd Volume Type
sett_frml_fl oiu_sett_fl Settlement

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.

-- Valuation Formula Alternate Use
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIURV_DOC_FRMLAU (
    MANDT,            -- Client [mandt]
    DOC_NO,           -- DocNr [oiurv_docnr]
    DOC_YEAR,         -- Document year [oiu_doc_year]
    LINE_NO,          -- Doc Line No. [oiu_doc_linenr]
    SEQ_NO,           -- Own. ISQ [oiu_own_isq_no]
    VSRC_WL_NO,       -- Well [oiu_wl_no]
    VSRC_WC_NO,       -- Well Completion [oiu_wc_no]
    VSRC_MP_NO,       -- Measurement Pt [oiu_mp_no]
    VSRC_CT_NO,       -- Contract [oiu_ct_no]
    RVWD_MATNR,       -- Material [matnr]
    RVWD_TYPE_CD,     -- Res Word Type [oiu_rvwd_type_code]
    RVWD_VT_TYPE_CD,  -- Volume Type [oiu_vt_cd]
    SETT_FRML_FL,     -- Settlement [oiu_sett_fl]
    PRIMARY KEY (MANDT, DOC_NO, DOC_YEAR, LINE_NO, SEQ_NO)
);