OIU_OICQ9 - Formula Condition Data-Term Items (enhance CI-Incl.in OICF3)
Formula Condition Data-Term Items (enhance CI-Incl.in OICF3) information is stored in SAP table OIU_OICQ9.
It is part of development package OIU_LO in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "PRA Production and Revenue Accounting (logistic objects)".
It is part of development package OIU_LO in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "PRA Production and Revenue Accounting (logistic objects)".
Fields for table OIU_OICQ9
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| KNUMV | Number of the Document Condition | X | KNUMV | CHAR | 20 | |
| KPOSN | Condition item number | X | KPOSN | NUMC | 12 | |
| STUNR | Step Number | X | STUNR | NUMC | 6 | |
| FORTRMTYP | Formula term type | X | OIU_OIC_TRMTYP | CHAR | 2 | |
| PFIND | Formula provisional/final indicator | X | OIU_OIC_PFIND | CHAR | 2 | |
| FORTRMITM | Formula term item number | X | OIU_OIC_TRMITM | NUMC | 10 | |
| .INCLUDE | OIU_LO_OICF3 | 0 | ||||
| MULT1 | Calculation factor 1 | OIU_OIC_MULT1 | DEC | 4 | ||
| MULT2 | Calculation factor 2 | OIU_OIC_MULT2 | DEC | 2 | ||
| QUOSRC | Quotation source | OIU_SOURCE | CHAR | 4 | ||
| QUOTYP | Quotation type | OIU_QUOTYP | CHAR | 10 | ||
| QUOTNO | Quotation number | OIU_QUOTA | CHAR | 36 | OICQC | |
| TRMEXIT | Calculation exit for term item | OIU_OIC_TRMEX | NUMC | 6 | ||
| EXGRTTY | Exchange rate type | OIU_OIC_EXRTTY | CHAR | 8 | * | |
| SURCHARGE | Surcharge | OIU_SURCH | CURR | 7 | ||
| SURCURR | Surcharge currency | OIU_SURCUR | CUKY | 10 | TCURC | |
| SURPRUN | Surcharge per unit | OIU_SURPRU | DEC | 3 | ||
| SURUOM | Surcharge unit of measure | OIU_SURUOM | UNIT | 6 | T006 | |
| ITEMVAL | Term item value | OIU_OIC_ITMVAL | CURR | 8 | ||
| ITEMCURR | Term item value currency | OIU_OIC_ITMCUR | CUKY | 10 | * | |
| QUOTVAL | Quotation average value | OIU_OIC_QUOTVA | CURR | 8 | ||
| SURVAL | Surcharge value for formula term item | OIU_OIC_SURVAL | CURR | 8 | ||
| OIGNSTRAQ | Gross/net pricing strategy used for quotation | OIU_OIC_GNSTRQ | CHAR | 2 | ||
| OIGNSTRAS | Gross/net pricing strategy used for surcharge | OIU_OIC_GNSTRS | CHAR | 2 | ||
| RNDQUOT | Rule for rounding quotation price/value | OIU_OIC_RNDQUOT | NUMC | 6 | ||
| RNDSUR | Rule for rounding surcharge price/value | OIU_OIC_RNDSUR | NUMC | 6 | ||
| RNDITEM | Rule for rounding term item value | OIU_OIC_RNDITEM | NUMC | 6 | ||
| CALCTYP | Calculation type for formula condition item | OIU_OIC_CALCTYP | CHAR | 2 | ||
| REFVAL1 | Reference data 1 for formula term item calculation | OIU_OIC_REFVAL1 | DEC | 9 | ||
| REFUOM1 | UoM for reference data 1 in formula term item calculation | OIU_OIC_REFUOM1 | UNIT | 6 | * | |
| OIU_QUOTGRP | Quotation group | OIU_QUOGROUP | CHAR | 10 | OIU_QUOGRP | |
| OIU_GRAVID | ID used to identify gravity scales | OIU_GRAVID | CHAR | 10 | OIU_RV_GRDEF | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 |