OIU_FANDA_TERMSB

Transparent Table Application Table
37 Fields 1 CDS Views

Formula Term

OIU_FANDA_TERMSB is an SAP database table in S/4HANA. Formula Term . It contains 37 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAPricingFormulaTerms2 view from BASIC Pricing Formula Terms

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY formula_term_uuid sysuuid_x16 UUID
formula_uuid sysuuid_x16 UUID
fortrmtyp oiu_oic_trmtyp Term type
kopos kopos Sequent. No. of Cond
mult1 oiu_oic_mult1 Factor 1
mult2 oiu_oic_mult2 Factor 2
quosrc oiu_source Quot.source
quotyp oiu_quotyp Quote type
quotno oiu_quota Quotation no.
trmexit oiu_oic_trmex Item calc. rule
exgrtty oiu_oic_exrtty Exg.rate type
surcharge oiu_surch Surcharge
surcurr oiu_surcur Surcharge curr
surprun oiu_surpru Surcharge/unit
suruom oiu_suruom Surch.UoM
itemcurr oiu_oic_itmcur TermItemCurr
quotval oiu_oic_quotva Quot.ave.val.
surval oiu_oic_surval Surcharge value
oignstraq oiu_oic_gnstrq Quo gr/net str
oignstras oiu_oic_gnstrs Sur gr/net str
rndquot oiu_oic_rndquot Rounding rule
rndsur oiu_oic_rndsur Rounding rule
rnditem oiu_oic_rnditem Rounding rule
calctyp oiu_oic_calctyp Item calc.type
refval1 oiu_oic_refval1 Ref data 1
refuom1 oiu_oic_refuom1 Ref UoM 1
oiu_quotgrp oiu_quogroup Quot. group
oiu_gravid oiu_gravid Gravity ID
refdate oiu_oic_refdat Ref.date exit
timuom oiu_oic_timuom Time UoM
rdoffset oiu_oic_rdoff Ref.date offset
perbef oiu_oic_perbef Per before
peraft oiu_oic_peraft Per. after
datfrm oiu_oic_datfrm Fix date from
datto oiu_oic_datto Fix date to
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 Term
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_FANDA_TERMSB (
    MANDT,                  -- Client [mandt]
    FORMULA_TERM_UUID,      -- UUID [sysuuid_x16]
    FORMULA_UUID,           -- UUID [sysuuid_x16]
    FORTRMTYP,              -- Term type [oiu_oic_trmtyp]
    KOPOS,                  -- Sequent. No. of Cond [kopos]
    MULT1,                  -- Factor 1 [oiu_oic_mult1]
    MULT2,                  -- Factor 2 [oiu_oic_mult2]
    QUOSRC,                 -- Quot.source [oiu_source]
    QUOTYP,                 -- Quote type [oiu_quotyp]
    QUOTNO,                 -- Quotation no. [oiu_quota]
    TRMEXIT,                -- Item calc. rule [oiu_oic_trmex]
    EXGRTTY,                -- Exg.rate type [oiu_oic_exrtty]
    SURCHARGE,              -- Surcharge [oiu_surch]
    SURCURR,                -- Surcharge curr [oiu_surcur]
    SURPRUN,                -- Surcharge/unit [oiu_surpru]
    SURUOM,                 -- Surch.UoM [oiu_suruom]
    ITEMCURR,               -- TermItemCurr [oiu_oic_itmcur]
    QUOTVAL,                -- Quot.ave.val. [oiu_oic_quotva]
    SURVAL,                 -- Surcharge value [oiu_oic_surval]
    OIGNSTRAQ,              -- Quo gr/net str [oiu_oic_gnstrq]
    OIGNSTRAS,              -- Sur gr/net str [oiu_oic_gnstrs]
    RNDQUOT,                -- Rounding rule [oiu_oic_rndquot]
    RNDSUR,                 -- Rounding rule [oiu_oic_rndsur]
    RNDITEM,                -- Rounding rule [oiu_oic_rnditem]
    CALCTYP,                -- Item calc.type [oiu_oic_calctyp]
    REFVAL1,                -- Ref data 1 [oiu_oic_refval1]
    REFUOM1,                -- Ref UoM 1 [oiu_oic_refuom1]
    OIU_QUOTGRP,            -- Quot. group [oiu_quogroup]
    OIU_GRAVID,             -- Gravity ID [oiu_gravid]
    REFDATE,                -- Ref.date exit [oiu_oic_refdat]
    TIMUOM,                 -- Time UoM [oiu_oic_timuom]
    RDOFFSET,               -- Ref.date offset [oiu_oic_rdoff]
    PERBEF,                 -- Per before [oiu_oic_perbef]
    PERAFT,                 -- Per. after [oiu_oic_peraft]
    DATFRM,                 -- Fix date from [oiu_oic_datfrm]
    DATTO,                  -- Fix date to [oiu_oic_datto]
    LOCAL_LAST_CHANGED_AT,  -- Time Stamp [oiu_rap_timestamp]
    PRIMARY KEY (MANDT, FORMULA_TERM_UUID)
);

Learn More