OIU_RV_FRMLD

Transparent Table Application Table
45 Fields 1 CDS Views

Valuation Formula Detail

OIU_RV_FRMLD is an SAP database table in S/4HANA. Valuation Formula Detail. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAValuationFormulaDetail view_entity from BASIC Valuation Formula Detail

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY frml_no oiu_frml_no Formula Number
KEY seq_no oiu_seq_no Sequence number
KEY eff_from_dt oiu_eff_from_dt Effective From
eff_to_dt oiu_eff_to_dt Effective To
bukrs_1 oiu_bukrs_1 Company Code 1
rvwd_type_cd_1 oiu_rvwd_1_type_cd Res Word Type 1
rvwd_cd_1 oiu_rvwd_1_code Factor
vsrc_cd_1 oiu_vsrc_1_cd VL Source Cd 1
vsrc_no_1 oiu_vsrc_1_no Val Source 1
vsrc_wc_no_1 oiu_wc_1_no Well Compl 1
doi_no_1 oiu_doi_1_no Venture/DOI 1
ctsrc_no_1 oiu_ct_1_no Contract 1
ctsrc_type_cd_1 oiu_ct_type_1_cd Ct Type 1
bukrs_2 oiu_bukrs_2 Company Code 2
rvwd_type_cd_2 oiu_rvwd_2_type_cd Res Word Type 2
rvwd_cd_2 oiu_rvwd_2_code Res Word 2
vsrc_cd_2 oiu_vsrc_2_cd Val Source Cd
vsrc_no_2 oiu_vsrc_2_no Val Source 2
vsrc_wc_no_2 oiu_wc_2_no Well Comp 2
doi_no_2 oiu_doi_2_no Venture/DOI 2
ctsrc_no_2 oiu_ct_2_no Contract 2
ctsrc_type_cd_2 oiu_ct_type_2_cd Contr Type 2
func_cd oiu_func_cd Function
rslt_cd oiu_rvwd_code Val. Res. Word
rslt_taxtype oiu_sevt_tax_ty Severance Tax
appr_fl oiu_appr_fl Approval
rslt_actentst_cd oiu_actentset_cd ActEntSet Codes
affil_fl_1 oiu_affil_1_fl Affiliate 1
peratfi_cd_1 oiu_peratfi_1_cd PRF Code 1
vt_type_cd_1 oiu_vt_1_cd Vol. Type 1
majpd_cd_1 oiu_majpd_1_cd Major Prod 1
matnr_1 oiu_matnr_1 Material 1
pur_no_1 oiu_pu_1_no Purchaser 1
affil_fl_2 oiu_affil_2_fl Affiliate 2
peratfi_cd_2 oiu_peratfi_2_cd PRF Codes 2
vt_type_cd_2 oiu_vt_2_cd Vol. Type Code 2
majpd_cd_2 oiu_majpd_2_cd Major Prod 2
matnr_2 oiu_matnr_2 Material 2
pur_no_2 oiu_pu_2_no Purch 2
rvwd_cd_1_u oiu_std_vol_u Unit
rvwd_cd_2_u oiu_std_vol_u Unit
tr_no_1 oiu_tr_no Tract Number
tr_no_2 oiu_tr_no Tract Number
rslt_tax_cls oiu_tax_cls Tax Class

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 Detail
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_RV_FRMLD (
    MANDT,             -- Client [mandt]
    FRML_NO,           -- Formula Number [oiu_frml_no]
    SEQ_NO,            -- Sequence number [oiu_seq_no]
    EFF_FROM_DT,       -- Effective From [oiu_eff_from_dt]
    EFF_TO_DT,         -- Effective To [oiu_eff_to_dt]
    BUKRS_1,           -- Company Code 1 [oiu_bukrs_1]
    RVWD_TYPE_CD_1,    -- Res Word Type 1 [oiu_rvwd_1_type_cd]
    RVWD_CD_1,         -- Factor [oiu_rvwd_1_code]
    VSRC_CD_1,         -- VL Source Cd 1 [oiu_vsrc_1_cd]
    VSRC_NO_1,         -- Val Source 1 [oiu_vsrc_1_no]
    VSRC_WC_NO_1,      -- Well Compl 1 [oiu_wc_1_no]
    DOI_NO_1,          -- Venture/DOI 1 [oiu_doi_1_no]
    CTSRC_NO_1,        -- Contract 1 [oiu_ct_1_no]
    CTSRC_TYPE_CD_1,   -- Ct Type 1 [oiu_ct_type_1_cd]
    BUKRS_2,           -- Company Code 2 [oiu_bukrs_2]
    RVWD_TYPE_CD_2,    -- Res Word Type 2 [oiu_rvwd_2_type_cd]
    RVWD_CD_2,         -- Res Word 2 [oiu_rvwd_2_code]
    VSRC_CD_2,         -- Val Source Cd [oiu_vsrc_2_cd]
    VSRC_NO_2,         -- Val Source 2 [oiu_vsrc_2_no]
    VSRC_WC_NO_2,      -- Well Comp 2 [oiu_wc_2_no]
    DOI_NO_2,          -- Venture/DOI 2 [oiu_doi_2_no]
    CTSRC_NO_2,        -- Contract 2 [oiu_ct_2_no]
    CTSRC_TYPE_CD_2,   -- Contr Type 2 [oiu_ct_type_2_cd]
    FUNC_CD,           -- Function [oiu_func_cd]
    RSLT_CD,           -- Val. Res. Word [oiu_rvwd_code]
    RSLT_TAXTYPE,      -- Severance Tax [oiu_sevt_tax_ty]
    APPR_FL,           -- Approval [oiu_appr_fl]
    RSLT_ACTENTST_CD,  -- ActEntSet Codes [oiu_actentset_cd]
    AFFIL_FL_1,        -- Affiliate 1 [oiu_affil_1_fl]
    PERATFI_CD_1,      -- PRF Code 1 [oiu_peratfi_1_cd]
    VT_TYPE_CD_1,      -- Vol. Type 1 [oiu_vt_1_cd]
    MAJPD_CD_1,        -- Major Prod 1 [oiu_majpd_1_cd]
    MATNR_1,           -- Material 1 [oiu_matnr_1]
    PUR_NO_1,          -- Purchaser 1 [oiu_pu_1_no]
    AFFIL_FL_2,        -- Affiliate 2 [oiu_affil_2_fl]
    PERATFI_CD_2,      -- PRF Codes 2 [oiu_peratfi_2_cd]
    VT_TYPE_CD_2,      -- Vol. Type Code 2 [oiu_vt_2_cd]
    MAJPD_CD_2,        -- Major Prod 2 [oiu_majpd_2_cd]
    MATNR_2,           -- Material 2 [oiu_matnr_2]
    PUR_NO_2,          -- Purch 2 [oiu_pu_2_no]
    RVWD_CD_1_U,       -- Unit [oiu_std_vol_u]
    RVWD_CD_2_U,       -- Unit [oiu_std_vol_u]
    TR_NO_1,           -- Tract Number [oiu_tr_no]
    TR_NO_2,           -- Tract Number [oiu_tr_no]
    RSLT_TAX_CLS,      -- Tax Class [oiu_tax_cls]
    PRIMARY KEY (MANDT, FRML_NO, SEQ_NO, EFF_FROM_DT)
);

Learn More