OICQ3 - Formula Repository - Formula Term Item
Formula Repository - Formula Term Item information is stored in SAP table OICQ3.
It is part of development package OIC in software component IS-OIL-DS-MAP. This development package consists of objects that can be grouped under "MAP Marketing, Accounting and Pricing".
It is part of development package OIC in software component IS-OIL-DS-MAP. This development package consists of objects that can be grouped under "MAP Marketing, Accounting and Pricing".
Fields for table OICQ3
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | T000 |
| FORID | Formula repository ID | X | OIC_FORID | CHAR | 10 | |
| FORTRMTYP | Formula term type | X | OIC_TRMTYP | CHAR | 1 | |
| FORTRMITM | Formula term item number | X | OIC_TRMITM | NUMC | 5 | |
| PFIND | Formula provisional/final indicator | X | OIC_PFIND | CHAR | 1 | |
| .INCLUDE | OICF3 | 0 | ||||
| MULT1 | Calculation factor 1 | OIC_MULT1 | DEC | 4 | ||
| MULT2 | Calculation factor 2 | OIC_MULT2 | DEC | 2 | ||
| QUOSRC | Quotation source | OIC_SOURCE | CHAR | 2 | OICQS | |
| QUOTYP | Quotation type | OIC_QUOTYP | CHAR | 5 | OICQT | |
| QUOTNO | Quotation number | OIC_QUOTA | CHAR | 18 | OICQC | |
| TRMEXIT | Calculation exit for term item | OIC_TRMEX | NUMC | 3 | ||
| EXGRTTY | Exchange rate type | OIC_EXRTTY | CHAR | 4 | TCURV | |
| SURCHARGE | Surcharge | OIC_SURCH | CURR | 7 | ||
| SURCURR | Surcharge currency | OIC_SURCUR | CUKY | 5 | TCURC | |
| SURPRUN | Surcharge per unit | OIC_SURPRU | DEC | 3 | ||
| SURUOM | Surcharge unit of measure | OIC_SURUOM | UNIT | 3 | T006 | |
| ITEMVAL | Term item value | OIC_ITMVAL | CURR | 8 | ||
| ITEMCURR | Term item value currency | OIC_ITMCUR | CUKY | 5 | TCURC | |
| QUOTVAL | Quotation average value | OIC_QUOTVA | CURR | 8 | ||
| SURVAL | Surcharge value for formula term item | OIC_SURVAL | CURR | 8 | ||
| OIGNSTRAQ | Gross/net pricing strategy used for quotation | OIC_GNSTRQ | CHAR | 1 | ||
| OIGNSTRAS | Gross/net pricing strategy used for surcharge | OIC_GNSTRS | CHAR | 1 | ||
| RNDQUOT | Rule for rounding quotation price/value | OIC_RNDQUOT | NUMC | 3 | ||
| RNDSUR | Rule for rounding surcharge price/value | OIC_RNDSUR | NUMC | 3 | ||
| RNDITEM | Rule for rounding term item value | OIC_RNDITEM | NUMC | 3 | ||
| CALCTYP | Calculation type for formula condition item | OIC_CALCTYP | CHAR | 1 | ||
| REFVAL1 | Reference data 1 for formula term item calculation | OIC_REFVAL1 | DEC | 9 | ||
| REFUOM1 | UoM for reference data 1 in formula term item calculation | OIC_REFUOM1 | UNIT | 3 | * | |
| .INCLUDE | CI_OICQ_OIAF9 | 0 |