SAP ABAP Table OICQ1 (Formula Repository - Formula Header)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ OIC (Package) MAP Marketing, Accounting and Pricing
BBPCRM (Software Component) BBPCRM⤷
CRM (Application Component) Customer Relationship Management⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages⤷
OIC (Package) MAP Marketing, Accounting and Pricing
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | OICQ1 |
Table Relationship Diagram 
|
| Short Description | Formula Repository - Formula Header |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | FORID |
OIC_FORID | OIC_FORID | CHAR | 10 | 0 | Formula repository ID | ||
| 3 | .INCLUDE |
0 | 0 | Internal Formula Header Structure | |||||
| 4 | FORAVB |
OIC_FORAVB | OIC_EXIT | NUMC | 3 | 0 | Formula term selection exit | ||
| 5 | FORDESC |
OIC_FORDES | CHAR40 | CHAR | 40 | 0 | Formula description | ||
| 6 | FORMVAL |
OIC_FORVAL | WERTV8 | CURR | 15 | 2 | Formula condition value | ||
| 7 | FORMCURR |
OIC_FORCUR | WAERS | CUKY | 5 | 0 | Currency for formula condition | TCURC | |
| 8 | FORSTATUS |
OIC_FSTAT | OIC_FSTAT | NUMC | 1 | 0 | Formula evaluation status | ||
| 9 | RATECURR |
OIC_RATCUR | WAERS | CUKY | 5 | 0 | Currency for display of calculated formula rate | TCURC | |
| 10 | FORMUOM |
OIC_FORMUOM | MEINS | UNIT | 3 | 0 | Displayed unit of measure for Formula and Average conditions | T006 | |
| 11 | FORMPER |
OIC_FORMPER | KPEIN | DEC | 5 | 0 | Displayed pricing unit for Formula and Average conditions | ||
| 12 | UOMCNVRL |
OIC_UOMCNVRL | OIC_EXIT | NUMC | 3 | 0 | Rule for conversion of the displayed Formula UoM | ||
| 13 | FORMUMZA |
OIC_FORMUMZA | UMBSZ | DEC | 5 | 0 | Numerator for converting to formula condition UoM | ||
| 14 | FORMUMNE |
OIC_FORMUMNE | UMBSN | DEC | 5 | 0 | Denominator for converting to formula condition UoM | ||
| 15 | RATEBASED |
OIC_RATEBASED | XFELD | CHAR | 1 | 0 | Indicator, if F&A calculation is performed rate based | ||
| 16 | .INCLUDE |
0 | 0 |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | OICQ1 | FORMCURR |  TCURC |
WAERS |
1 | N | |
| 2 | OICQ1 | FORMUOM | T006 |
MSEHI |
|||
| 3 | OICQ1 | MANDT | T000 |
MANDT |
|||
| 4 | OICQ1 | RATECURR | TCURC |
WAERS |
1 | N |
History
| Last changed by/on | SAP | 20050224 |
| SAP Release Created in |
