SAP ABAP Table OICQ5 (Formula Condition Data - Formula Terms)

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	OICQ5	Table Relationship Diagram
Short Description	Formula Condition Data - Formula Terms

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	PFIND	☑	OIC_PFIND	OIC_PFIND	CHAR	1	0	Formula provisional/final indicator
6	.INCLUDE	☐				0	0	Internal Formula Term Calculation Rules
7	REFDATE	☐	OIC_REFDAT	OIC_EXIT	NUMC	3	0	User exit for reference date determination
8	TIMUOM	☐	OIC_TIMUOM	OIC_EXIT	NUMC	3	0	Time unit of measure exit
9	WERULE	☐	OIC_WERULE	OIC_EXIT	NUMC	3	0	Weekend rule exit
10	NPDAYS	☐	OIC_NPDAYS	OIC_EXIT	NUMC	3	0	Non-posted days rule exit
11	ERRHAN	☐	OIC_ERRHAN	OIC_EXIT	NUMC	3	0	Error handling exit, if no quotation found
12	RDOFFSET	☐	OIC_RDOFF	OIC_EXIT	NUMC	3	0	Offset from reference date
13	PERBEF	☐	OIC_PERBEF	OIC_OFFSET	NUMC	3	0	Period before base date
14	PERAFT	☐	OIC_PERAFT	OIC_OFFSET	NUMC	3	0	Period after base date
15	EXCEX	☐	OIC_EXCEV	XFELD	CHAR	1	0	Exclude Base Date
16	DATFRM	☐	OIC_DATFRM	DATUM	DATS	8	0	'Date from' for average period
17	DATTO	☐	OIC_DATTO	DATUM	DATS	8	0	'Date to' for fixation period
18	CARULE	☐	OIC_CARULE	OIC_EXIT	NUMC	3	0	Average currency rule
19	CDRULE	☐	OIC_CDRULE	OIC_EXIT	NUMC	3	0	Daily currency rule
20	CREFDATE	☐	OIC_CREFDT	OIC_EXIT	NUMC	3	0	Determination exit for currency reference date
21	CTIMUOM	☐	OIC_CTIMUM	OIC_EXIT	NUMC	3	0	Currency time unit of measure exit
22	CWERULE	☐	OIC_CWERUL	OIC_EXIT	NUMC	3	0	Currency weekend rule exit
23	CNPDAYS	☐	OIC_CNPDAY	OIC_EXIT	NUMC	3	0	Currency non-posted days rule exit
24	CERRHAN	☐	OIC_CERRHN	OIC_EXIT	NUMC	3	0	Error-handling exit (if no exch.rate found)
25	CRDOFFSET	☐	OIC_CRDOFF	OIC_OFFSET	NUMC	3	0	Offset from reference date for currency
26	CPERBEF	☐	OIC_CPERBF	OIC_OFFSET	NUMC	3	0	Period before base date for currency
27	CPERAFT	☐	OIC_CPERAF	OIC_OFFSET	NUMC	3	0	Period after base date for currency
28	CEXCEV	☐	OIC_CEXCEV	XFELD	CHAR	1	0	Exclude Base Date for Currency
29	CDATFRM	☐	OIC_CDATFR	DATUM	DATS	8	0	Date from for fixation period for currency
30	CDATTO	☐	OIC_CDATTO	DATUM	DATS	8	0	Date to for fixation period for currency
31	TERMVAL	☐	OIC_TERMVL	WERTV8	CURR	15	2	Formula term value
32	TERMCURR	☐	OIC_TERMCU	WAERS	CUKY	5	0	Currency for formula term	TCURC
33	DDATFRM	☐	OIC_DDATFR	DATUM	DATS	8	0	'Date from' determined for fixation period
34	DDATTO	☐	OIC_DDATTO	DATUM	DATS	8	0	'Date to' determined for fixation period
35	CDDATFRM	☐	OIC_CDDATF	DATUM	DATS	8	0	Date from for fixation period for currency
36	CDDDATTO	☐	OIC_CDDATT	DATUM	DATS	8	0	End date for currency period
37	TSTAT	☐	OIC_TSTAT	OIC_TSTAT	CHAR	1	0	Term status
38	CALID	☐	OIC_CFACTC	WFCID	CHAR	2	0	Factory calendar ID for currency	TFACD
39	RNDTERM	☐	OIC_RNDTERM	OIC_EXIT	NUMC	3	0	Rule for rounding formula term value
40	RNDCURT	☐	OIC_RNDCURT	OIC_EXIT	NUMC	3	0	Rule for rounding currency exchange rate
41	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OICQ5	CALID	TFACD	IDENT
2	OICQ5	MANDT	T000	MANDT
3	OICQ5	TERMCURR	TCURC	WAERS		1	N

History

Last changed by/on	SAP	20050224
SAP Release Created in