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

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