OIU_FANDA_TERMSA

Transparent Table Application Table
37 Fields 1 CDS Views

Formula Term

OIU_FANDA_TERMSA 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_PRAPricingFormulaTerms1 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_TERMSA (
    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