1. Home
  2. Resources
  3. SAP Tables
  4. OICF6 - Formula Term Item - Working Struct for Maintenance Dialog

SAP Table OICF6

Formula Term Item - Working Struct for Maintenance Dialog

OICF6 (Formula Term Item - Working Struct for Maintenance Dialog) 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 OICF6 to other SAP tables.

OICF6 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FORTRMTYP Formula term type OIC_TRMTYP CHAR 1 0
1 'A' Term
2 'B' Term
PFIND Formula provisional/final indicator OIC_PFIND CHAR 1 0
1 Final
2 Provisional
FORTRMITM Formula term item number OIC_TRMITM NUMC 5 0
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
DAYQTPR Converted daily quotation price OIC_DAYQTPR DEC 31 14
DAYQTPR_SUM Sum of daily quotation prices OIC_DAYQTPR_SUM DEC 31 14
AVQTPR_RAW Unrounded average quotation price OIC_AVQTPR_RAW DEC 31 14
AVQTPR_RND Rounded average quotation price OIC_AVQTPR_RND DEC 31 14
AVQTCUKY Currency of average quotation prices OIC_AVQTCUKY CUKY 5 0
AVQTPRUN Pricing unit of average quotation prices OIC_AVQTPRUN DEC 5 0
AVQTUOM Unit of measure of average quotation prices OIC_AVQTUOM UNIT 3 0
AVQTCNT Number of used daily quotation prices OIC_AVQTCNT INT4 10 0
AVQTPR_LEAD Average quotation price in leading combination OIC_AVQTPR_LEAD DEC 31 14
DAYSUR Daily currency converted surcharge OIC_DAYSUR DEC 31 14
DAYSUR_SUM Sum of daily (currency) converted surcharges OIC_DAYSUR_SUM DEC 31 14
AVSUR_LEAD Unrounded average surcharge in leading Cuky/Prun/UoM OIC_AVSUR_LEAD DEC 31 14
AVSUR_RND Rounded average surcharge in leading Cuky/Prun/UoM OIC_AVSUR_RND DEC 31 14
AVSURCNT Number of used daily currency converted surcharges OIC_AVSURCNT INT4 10 0
LEADCUKY Leading currency within term item OIC_LEADCUKY CUKY 5 0
LEADPRUN Leading pricing unit within term item OIC_LEADPRUN DEC 5 0
LEADUOM Leading unit of measure within term item OIC_LEADUOM UNIT 3 0
ITRATE_LEAD Item rate in leading Cuky/Prun/UoM OIC_ITRATE_LEAD DEC 31 14
ITRATE_FORM Item rate in formula Cuky/Prun/UoM OIC_ITRATE_FORM DEC 31 14
ITRATE_RND Rounded item rate in formula Cuky/Prun/UoM OIC_ITRATE_RND DEC 31 14

OICF6 foreign key relationships

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