SAP table OICQ2 (Formula Repository - Formula Term)

SAP table OICQ2 has 4 primary key fields being MANDT,FORID,FORTRMTYP,PFIND.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
FORID Formula repository ID CHAR 10 0 OIC_FORID
FORTRMTYP Formula term type CHAR 1 0 OIC_TRMTYP
1 'A' Term
2 'B' Term
PFIND Formula provisional/final indicator CHAR 1 0 OIC_PFIND
1 Final
2 Provisional
REFDATE User exit for reference date determination NUMC 3 0 OIC_REFDAT
TIMUOM Time unit of measure exit NUMC 3 0 OIC_TIMUOM
WERULE Weekend rule exit NUMC 3 0 OIC_WERULE
NPDAYS Non-posted days rule exit NUMC 3 0 OIC_NPDAYS
ERRHAN Error handling exit, if no quotation found NUMC 3 0 OIC_ERRHAN
RDOFFSET Offset from reference date NUMC 3 0 OIC_RDOFF
PERBEF Period before base date NUMC 3 0 OIC_PERBEF
PERAFT Period after base date NUMC 3 0 OIC_PERAFT
EXCEX Exclude Base Date CHAR 1 0 OIC_EXCEV
DATFRM 'Date from' for average period DATS 8 0 OIC_DATFRM
DATTO 'Date to' for fixation period DATS 8 0 OIC_DATTO
CARULE Average currency rule NUMC 3 0 OIC_CARULE
CDRULE Daily currency rule NUMC 3 0 OIC_CDRULE
CREFDATE Determination exit for currency reference date NUMC 3 0 OIC_CREFDT
CTIMUOM Currency time unit of measure exit NUMC 3 0 OIC_CTIMUM
CWERULE Currency weekend rule exit NUMC 3 0 OIC_CWERUL
CNPDAYS Currency non-posted days rule exit NUMC 3 0 OIC_CNPDAY
CERRHAN Error-handling exit (if no exch.rate found) NUMC 3 0 OIC_CERRHN
CRDOFFSET Offset from reference date for currency NUMC 3 0 OIC_CRDOFF
CPERBEF Period before base date for currency NUMC 3 0 OIC_CPERBF
CPERAFT Period after base date for currency NUMC 3 0 OIC_CPERAF
CEXCEV Exclude Base Date for Currency CHAR 1 0 OIC_CEXCEV
CDATFRM Date from for fixation period for currency DATS 8 0 OIC_CDATFR
CDATTO Date to for fixation period for currency DATS 8 0 OIC_CDATTO
TERMVAL Formula term value CURR 15 2 OIC_TERMVL
TERMCURR Currency for formula term CUKY 5 0 TCURC OIC_TERMCU
DDATFRM 'Date from' determined for fixation period DATS 8 0 OIC_DDATFR
DDATTO 'Date to' determined for fixation period DATS 8 0 OIC_DDATTO
CDDATFRM Date from for fixation period for currency DATS 8 0 OIC_CDDATF
CDDDATTO End date for currency period DATS 8 0 OIC_CDDATT
TSTAT Term status CHAR 1 0 OIC_TSTAT
Not evaluated
1 Evaluated successfully using final rules
2 Evaluated successfully using provisional rules
3 Evaluated provisionally (some of quot fix per. in future)
4 Quotation fixation period in future, eval at current date
5 Quotation fixation period could not be determined
6 Quotation fixation period is in the future
7 Quotation lookup error
8 Evaluated provisionally (some of curr fix per. in future)
9 Currency fixation period in the future, eval at current date
A Currency fixation period could not be determined
B Currency fixation period is in the future
C Currency lookup error
D Currency lookup error: no rate on date in average period
E No lookup of posting in contract (E & P)
G Error: gravity scale not found or not valid
S No posting on exact date
T Error: gravity type not matching
V Error: gravity scale not active
CALID Factory calendar ID for currency CHAR 2 0 TFACD OIC_CFACTC
RNDTERM Rule for rounding formula term value NUMC 3 0 OIC_RNDTERM
RNDCURT Rule for rounding currency exchange rate NUMC 3 0 OIC_RNDCURT

OICQ2 foreign key relationships

Table Field Check Table Check Field
0 OICQ2 MANDT T000 Clients MANDT
1 OICQ2 TERMCURR TCURC Currency Codes MANDT
1 OICQ2 TERMCURR TCURC Currency Codes WAERS