1. Home
  2. Resources
  3. SAP Tables
  4. OICQ3 - Formula Repository - Formula Term Item

SAP Table OICQ3

Formula Repository - Formula Term Item

OICQ3 (Formula Repository - Formula Term Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OICQ3 to other SAP tables.

OICQ3 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FORID Formula repository ID OIC_FORID CHAR 10 0
FORTRMTYP Formula term type OIC_TRMTYP CHAR 1 0
1 'A' Term
2 'B' Term
FORTRMITM Formula term item number OIC_TRMITM NUMC 5 0
PFIND Formula provisional/final indicator OIC_PFIND CHAR 1 0
1 Final
2 Provisional
MULT1 Calculation factor 1 OIC_MULT1 DEC 7 6
MULT2 Calculation factor 2 OIC_MULT2 DEC 3 2
QUOSRC Quotation source OIC_SOURCE OICQS CHAR 2 0
QUOTYP Quotation type OIC_QUOTYP OICQT CHAR 5 0
QUOTNO Quotation number OIC_QUOTA OICQC CHAR 18 0
TRMEXIT Calculation exit for term item OIC_TRMEX NUMC 3 0
EXGRTTY Exchange rate type OIC_EXRTTY TCURV CHAR 4 0
SURCHARGE Surcharge OIC_SURCH CURR 13 2
SURCURR Surcharge currency OIC_SURCUR TCURC CUKY 5 0
SURPRUN Surcharge per unit OIC_SURPRU DEC 5 0
SURUOM Surcharge unit of measure OIC_SURUOM T006 UNIT 3 0
ITEMVAL Term item value OIC_ITMVAL CURR 15 2
ITEMCURR Term item value currency OIC_ITMCUR TCURC CUKY 5 0
QUOTVAL Quotation average value OIC_QUOTVA CURR 15 2
SURVAL Surcharge value for formula term item OIC_SURVAL CURR 15 2
OIGNSTRAQ Gross/net pricing strategy used for quotation OIC_GNSTRQ CHAR 1 0
X Unit of Measure was replaced
NULL Unit of Measure not replaced
OIGNSTRAS Gross/net pricing strategy used for surcharge OIC_GNSTRS CHAR 1 0
X Unit of Measure was replaced
NULL Unit of Measure not replaced
RNDQUOT Rule for rounding quotation price/value OIC_RNDQUOT NUMC 3 0
RNDSUR Rule for rounding surcharge price/value OIC_RNDSUR NUMC 3 0
RNDITEM Rule for rounding term item value OIC_RNDITEM NUMC 3 0
CALCTYP Calculation type for formula condition item OIC_CALCTYP CHAR 1 0
NULL Calculation only value based (like before release 4.6B)
1 Lead by formula currency / UoM
2 Lead by quotation currency / UoM
3 Lead 1. by quot. currency / UoM, 2. surcharge currency / UoM
4 Reserved (like ' ' in the moment)
5 Reserved (like ' ' in the moment)
6 Reserved (like ' ' in the moment)
REFVAL1 Reference data 1 for formula term item calculation OIC_REFVAL1 DEC 17 7
REFUOM1 UoM for reference data 1 in formula term item calculation OIC_REFUOM1 UNIT 3 0
OIU_QUOTGRP Quotation group OIU_QUOGROUP OIU_QUOGRP CHAR 5 0
OIU_GRAVID ID used to identify gravity scales OIU_GRAVID OIU_RV_GRDEF CHAR 5 0

OICQ3 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OICQ3 EXGRTTY SYST MANDT TCURV Exchange rate types for currency translation MANDT
OICQ3 EXGRTTY OICQ3 EXGRTTY TCURV Exchange rate types for currency translation KURST
OICQ3 ITEMCURR SYST MANDT TCURC Currency Codes MANDT
OICQ3 ITEMCURR OICQ3 ITEMCURR TCURC Currency Codes WAERS
OICQ3 MANDT OICQ3 MANDT T000 Clients MANDT
OICQ3 OIU_GRAVID OICQ3 QUOSRC OIU_RV_GRDEF Gravity table defintion GRAVSRC
OICQ3 OIU_GRAVID OICQ3 OIU_GRAVID OIU_RV_GRDEF Gravity table defintion GRAVID
OICQ3 OIU_GRAVID T000 MANDT OIU_RV_GRDEF Gravity table defintion MANDT
OICQ3 OIU_QUOTGRP T000 MANDT OIU_QUOGRP Quotation group definition MANDT
OICQ3 OIU_QUOTGRP OICQ3 OIU_QUOTGRP OIU_QUOGRP Quotation group definition QUOGRP
OICQ3 QUOSRC SYST MANDT OICQS Quotation Source MANDT
OICQ3 QUOSRC OICQ3 QUOSRC OICQS Quotation Source QUOSRC
OICQ3 QUOTNO SYST MANDT OICQC Quotation Check Table MANDT
OICQ3 QUOTNO OICQ3 QUOSRC OICQC Quotation Check Table QUOSRC
OICQ3 QUOTNO OICQ3 QUOTYP OICQC Quotation Check Table QUOTYP
OICQ3 QUOTNO OICQ3 QUOTNO OICQC Quotation Check Table QUOTNO
OICQ3 QUOTYP SYST MANDT OICQT Quotation Type MANDT
OICQ3 QUOTYP OICQ3 QUOTYP OICQT Quotation Type QUOTYP
OICQ3 SURCURR SYST MANDT TCURC Currency Codes MANDT
OICQ3 SURCURR OICQ3 SURCURR TCURC Currency Codes WAERS
OICQ3 SURUOM SYST MANDT T006 Units of Measurement MANDT
OICQ3 SURUOM OICQ3 SURUOM T006 Units of Measurement MSEHI