SAP ABAP Table OICQ9 (Formula Condition Data-Term Items (enhance CI-Incl.in OICF3))

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	OICQ9	Table Relationship Diagram
Short Description	Formula Condition Data-Term Items (enhance CI-Incl.in OICF3)

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

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in