SAP ABAP Table OICQ6 (Formula Condition Data - Formula Term Items)
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
⤷ 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 | OICQ6 | Table Relationship Diagram |
Short Description | Formula Condition Data - Formula Term Items |
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 | KNUMH | KNUMH | KNUMB | CHAR | 10 | 0 | Condition record number | ||
3 | KOPOS | KOPOS | NUM02 | NUMC | 2 | 0 | Sequential number of the condition | ||
4 | FORTRMTYP | OIC_TRMTYP | OIC_TRMTYP | CHAR | 1 | 0 | Formula term type | ||
5 | FORTRMITM | OIC_TRMITM | OIC_TRMITM | NUMC | 5 | 0 | Formula term item number | ||
6 | PFIND | OIC_PFIND | OIC_PFIND | CHAR | 1 | 0 | Formula provisional/final indicator | ||
7 | .INCLUDE | 0 | 0 | Internal Formula Term Item | |||||
8 | MULT1 | OIC_MULT1 | OIC_MULT1 | DEC | 7 | 6 | Calculation factor 1 | ||
9 | MULT2 | OIC_MULT2 | OIC_MULT2 | DEC | 3 | 2 | Calculation factor 2 | ||
10 | QUOSRC | OIC_SOURCE | OICDC | CHAR | 2 | 0 | Quotation source | OICQS | |
11 | QUOTYP | OIC_QUOTYP | OIC_QUOTYP | CHAR | 5 | 0 | Quotation type | OICQT | |
12 | QUOTNO | OIC_QUOTA | CHAR18 | CHAR | 18 | 0 | Quotation number | OICQC | |
13 | TRMEXIT | OIC_TRMEX | OIC_EXIT | NUMC | 3 | 0 | Calculation exit for term item | ||
14 | EXGRTTY | OIC_EXRTTY | KURST | CHAR | 4 | 0 | Exchange rate type | TCURV | |
15 | SURCHARGE | OIC_SURCH | WERTV7 | CURR | 13 | 2 | Surcharge | ||
16 | SURCURR | OIC_SURCUR | WAERS | CUKY | 5 | 0 | Surcharge currency | TCURC | |
17 | SURPRUN | OIC_SURPRU | KPEIN | DEC | 5 | 0 | Surcharge per unit | ||
18 | SURUOM | OIC_SURUOM | MEINS | UNIT | 3 | 0 | Surcharge unit of measure | T006 | |
19 | ITEMVAL | OIC_ITMVAL | WERTV8 | CURR | 15 | 2 | Term item value | ||
20 | ITEMCURR | OIC_ITMCUR | WAERS | CUKY | 5 | 0 | Term item value currency | TCURC | |
21 | QUOTVAL | OIC_QUOTVA | WERTV8 | CURR | 15 | 2 | Quotation average value | ||
22 | SURVAL | OIC_SURVAL | WERTV8 | CURR | 15 | 2 | Surcharge value for formula term item | ||
23 | OIGNSTRAQ | OIC_GNSTRQ | OIC_GNSTRA | CHAR | 1 | 0 | Gross/net pricing strategy used for quotation | ||
24 | OIGNSTRAS | OIC_GNSTRS | OIC_GNSTRA | CHAR | 1 | 0 | Gross/net pricing strategy used for surcharge | ||
25 | RNDQUOT | OIC_RNDQUOT | OIC_EXIT | NUMC | 3 | 0 | Rule for rounding quotation price/value | ||
26 | RNDSUR | OIC_RNDSUR | OIC_EXIT | NUMC | 3 | 0 | Rule for rounding surcharge price/value | ||
27 | RNDITEM | OIC_RNDITEM | OIC_EXIT | NUMC | 3 | 0 | Rule for rounding term item value | ||
28 | CALCTYP | OIC_CALCTYP | OIC_CALCTYP | CHAR | 1 | 0 | Calculation type for formula condition item | ||
29 | REFVAL1 | OIC_REFVAL1 | OIC_REFVAL1 | DEC | 17 | 7 | Reference data 1 for formula term item calculation | ||
30 | REFUOM1 | OIC_REFUOM1 | MEINS | UNIT | 3 | 0 | UoM for reference data 1 in formula term item calculation | * | |
31 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OICQ6 | EXGRTTY | TCURV | KURST | 1 | N | |
2 | OICQ6 | ITEMCURR | TCURC | WAERS | 1 | N | |
3 | OICQ6 | MANDT | T000 | MANDT | |||
4 | OICQ6 | QUOSRC | OICQS | QUOSRC | |||
5 | OICQ6 | QUOTNO | OICQC | QUOTNO | |||
6 | OICQ6 | QUOTYP | OICQT | QUOTYP | |||
7 | OICQ6 | SURCURR | TCURC | WAERS | 1 | N | |
8 | OICQ6 | SURUOM | T006 | MSEHI |
History
Last changed by/on | SAP | 20050224 |
SAP Release Created in |