OICQ2 - Formula Repository - Formula Term
Formula Repository - Formula Term information is stored in SAP table OICQ2.
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 OICQ2
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 | |
| PFIND | Formula provisional/final indicator | X | OIC_PFIND | CHAR | 1 | |
| .INCLUDE | OICF2 | 0 | ||||
| REFDATE | User exit for reference date determination | OIC_REFDAT | NUMC | 3 | ||
| TIMUOM | Time unit of measure exit | OIC_TIMUOM | NUMC | 3 | ||
| WERULE | Weekend rule exit | OIC_WERULE | NUMC | 3 | ||
| NPDAYS | Non-posted days rule exit | OIC_NPDAYS | NUMC | 3 | ||
| ERRHAN | Error handling exit, if no quotation found | OIC_ERRHAN | NUMC | 3 | ||
| RDOFFSET | Offset from reference date | OIC_RDOFF | NUMC | 3 | ||
| PERBEF | Period before base date | OIC_PERBEF | NUMC | 3 | ||
| PERAFT | Period after base date | OIC_PERAFT | NUMC | 3 | ||
| EXCEX | Exclude Base Date | OIC_EXCEV | CHAR | 1 | ||
| DATFRM | 'Date from' for average period | OIC_DATFRM | DATS | 8 | ||
| DATTO | 'Date to' for fixation period | OIC_DATTO | DATS | 8 | ||
| CARULE | Average currency rule | OIC_CARULE | NUMC | 3 | ||
| CDRULE | Daily currency rule | OIC_CDRULE | NUMC | 3 | ||
| CREFDATE | Determination exit for currency reference date | OIC_CREFDT | NUMC | 3 | ||
| CTIMUOM | Currency time unit of measure exit | OIC_CTIMUM | NUMC | 3 | ||
| CWERULE | Currency weekend rule exit | OIC_CWERUL | NUMC | 3 | ||
| CNPDAYS | Currency non-posted days rule exit | OIC_CNPDAY | NUMC | 3 | ||
| CERRHAN | Error-handling exit (if no exch.rate found) | OIC_CERRHN | NUMC | 3 | ||
| CRDOFFSET | Offset from reference date for currency | OIC_CRDOFF | NUMC | 3 | ||
| CPERBEF | Period before base date for currency | OIC_CPERBF | NUMC | 3 | ||
| CPERAFT | Period after base date for currency | OIC_CPERAF | NUMC | 3 | ||
| CEXCEV | Exclude Base Date for Currency | OIC_CEXCEV | CHAR | 1 | ||
| CDATFRM | Date from for fixation period for currency | OIC_CDATFR | DATS | 8 | ||
| CDATTO | Date to for fixation period for currency | OIC_CDATTO | DATS | 8 | ||
| TERMVAL | Formula term value | OIC_TERMVL | CURR | 8 | ||
| TERMCURR | Currency for formula term | OIC_TERMCU | CUKY | 5 | TCURC | |
| DDATFRM | 'Date from' determined for fixation period | OIC_DDATFR | DATS | 8 | ||
| DDATTO | 'Date to' determined for fixation period | OIC_DDATTO | DATS | 8 | ||
| CDDATFRM | Date from for fixation period for currency | OIC_CDDATF | DATS | 8 | ||
| CDDDATTO | End date for currency period | OIC_CDDATT | DATS | 8 | ||
| TSTAT | Term status | OIC_TSTAT | CHAR | 1 | ||
| CALID | Factory calendar ID for currency | OIC_CFACTC | CHAR | 2 | TFACD | |
| RNDTERM | Rule for rounding formula term value | OIC_RNDTERM | NUMC | 3 | ||
| RNDCURT | Rule for rounding currency exchange rate | OIC_RNDCURT | NUMC | 3 | ||
| .INCLUDE | CI_OICQ_OIAF8 | 0 |