SAP ABAP Table OICQ3 (Formula Repository - Formula Term Item)

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	OICQ3	Table Relationship Diagram
Short Description	Formula Repository - Formula Term Item

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	FORTRMTYP	☑	OIC_TRMTYP	OIC_TRMTYP	CHAR	1	0	Formula term type
4	FORTRMITM	☑	OIC_TRMITM	OIC_TRMITM	NUMC	5	0	Formula term item number
5	PFIND	☑	OIC_PFIND	OIC_PFIND	CHAR	1	0	Formula provisional/final indicator
6	.INCLUDE	☐				0	0	Internal Formula Term Item
7	MULT1	☐	OIC_MULT1	OIC_MULT1	DEC	7	6	Calculation factor 1
8	MULT2	☐	OIC_MULT2	OIC_MULT2	DEC	3	2	Calculation factor 2
9	QUOSRC	☐	OIC_SOURCE	OICDC	CHAR	2	0	Quotation source	OICQS
10	QUOTYP	☐	OIC_QUOTYP	OIC_QUOTYP	CHAR	5	0	Quotation type	OICQT
11	QUOTNO	☐	OIC_QUOTA	CHAR18	CHAR	18	0	Quotation number	OICQC
12	TRMEXIT	☐	OIC_TRMEX	OIC_EXIT	NUMC	3	0	Calculation exit for term item
13	EXGRTTY	☐	OIC_EXRTTY	KURST	CHAR	4	0	Exchange rate type	TCURV
14	SURCHARGE	☐	OIC_SURCH	WERTV7	CURR	13	2	Surcharge
15	SURCURR	☐	OIC_SURCUR	WAERS	CUKY	5	0	Surcharge currency	TCURC
16	SURPRUN	☐	OIC_SURPRU	KPEIN	DEC	5	0	Surcharge per unit
17	SURUOM	☐	OIC_SURUOM	MEINS	UNIT	3	0	Surcharge unit of measure	T006
18	ITEMVAL	☐	OIC_ITMVAL	WERTV8	CURR	15	2	Term item value
19	ITEMCURR	☐	OIC_ITMCUR	WAERS	CUKY	5	0	Term item value currency	TCURC
20	QUOTVAL	☐	OIC_QUOTVA	WERTV8	CURR	15	2	Quotation average value
21	SURVAL	☐	OIC_SURVAL	WERTV8	CURR	15	2	Surcharge value for formula term item
22	OIGNSTRAQ	☐	OIC_GNSTRQ	OIC_GNSTRA	CHAR	1	0	Gross/net pricing strategy used for quotation
23	OIGNSTRAS	☐	OIC_GNSTRS	OIC_GNSTRA	CHAR	1	0	Gross/net pricing strategy used for surcharge
24	RNDQUOT	☐	OIC_RNDQUOT	OIC_EXIT	NUMC	3	0	Rule for rounding quotation price/value
25	RNDSUR	☐	OIC_RNDSUR	OIC_EXIT	NUMC	3	0	Rule for rounding surcharge price/value
26	RNDITEM	☐	OIC_RNDITEM	OIC_EXIT	NUMC	3	0	Rule for rounding term item value
27	CALCTYP	☐	OIC_CALCTYP	OIC_CALCTYP	CHAR	1	0	Calculation type for formula condition item
28	REFVAL1	☐	OIC_REFVAL1	OIC_REFVAL1	DEC	17	7	Reference data 1 for formula term item calculation
29	REFUOM1	☐	OIC_REFUOM1	MEINS	UNIT	3	0	UoM for reference data 1 in formula term item calculation	*
30	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OICQ3	EXGRTTY	TCURV	KURST		1	N
2	OICQ3	ITEMCURR	TCURC	WAERS		1	N
3	OICQ3	MANDT	T000	MANDT
4	OICQ3	QUOSRC	OICQS	QUOSRC
5	OICQ3	QUOTNO	OICQC	QUOTNO
6	OICQ3	QUOTYP	OICQT	QUOTYP
7	OICQ3	SURCURR	TCURC	WAERS		1	N
8	OICQ3	SURUOM	T006	MSEHI

History

Last changed by/on	SAP	20050224
SAP Release Created in