OIU_FANDA_HEADER

Transparent Table Application Table
20 Fields 1 CDS Views

Formula Pricing Header

OIU_FANDA_HEADER is an SAP database table in S/4HANA. Formula Pricing Header. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAPricingFormulaHeader view from BASIC Pricing Formula Header

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY formula_uuid sysuuid_x16 UUID
formula_id oiu_formula_id Formula ID
fordesc oiu_oic_fordes Formula descr.
eff_from_date oiu_eff_from_dt Effective From
eff_to_date oiu_eff_to_dt Effective To
foravb oiu_oic_foravb A vs. B rule
oiu_dmgrv oiu_dmgrv Deemed gravity
oiu_dnty oiu_denstyp Density type
oiu_clgrv oiu_clgrv Ceiling Gravity
oiu_flgrv oiu_flgrv Floor Gravity
oiu_floor oiu_floor Floor Rate
oiu_perf kpein Pricing Unit
oiu_curf oiu_curr Currency
oiu_uomf oiu_uomf UoM for floor
oiu_ceil oiu_ceil Ceiling rate
oiu_perc kpein Pricing Unit
oiu_curc oiu_curr Currency
oiu_uomc oiu_uomc UoM for ceiling
local_last_changed_at oiu_rap_timestamp Time Stamp

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.

-- Formula Pricing Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_FANDA_HEADER (
    MANDT,                  -- Client [mandt]
    FORMULA_UUID,           -- UUID [sysuuid_x16]
    FORMULA_ID,             -- Formula ID [oiu_formula_id]
    FORDESC,                -- Formula descr. [oiu_oic_fordes]
    EFF_FROM_DATE,          -- Effective From [oiu_eff_from_dt]
    EFF_TO_DATE,            -- Effective To [oiu_eff_to_dt]
    FORAVB,                 -- A vs. B rule [oiu_oic_foravb]
    OIU_DMGRV,              -- Deemed gravity [oiu_dmgrv]
    OIU_DNTY,               -- Density type [oiu_denstyp]
    OIU_CLGRV,              -- Ceiling Gravity [oiu_clgrv]
    OIU_FLGRV,              -- Floor Gravity [oiu_flgrv]
    OIU_FLOOR,              -- Floor Rate [oiu_floor]
    OIU_PERF,               -- Pricing Unit [kpein]
    OIU_CURF,               -- Currency [oiu_curr]
    OIU_UOMF,               -- UoM for floor [oiu_uomf]
    OIU_CEIL,               -- Ceiling rate [oiu_ceil]
    OIU_PERC,               -- Pricing Unit [kpein]
    OIU_CURC,               -- Currency [oiu_curr]
    OIU_UOMC,               -- UoM for ceiling [oiu_uomc]
    LOCAL_LAST_CHANGED_AT,  -- Time Stamp [oiu_rap_timestamp]
    PRIMARY KEY (MANDT, FORMULA_UUID)
);

Learn More