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 15 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 (15)

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
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp
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]
    OIU_CRUSER,       -- Created By [ERNAM]
    OIU_TIMESTAMP,    -- Time Stamp [TZNTSTMPS]
    SETT_FRML_FL,     -- Settlement [OIU_SETT_FL]
    PRIMARY KEY (MANDT, DOC_NO, DOC_YEAR, LINE_NO, SEQ_NO)
);