SAP ABAP Table OICQ9_WRK (F&A - Work Struct. for 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	INTTAB	Structure
Structure	OICQ9_WRK	Table Relationship Diagram
Short Description	F&A - Work Struct. for Formula Term Item

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in	472