SAP ABAP Table OICQ2 (Formula Repository - Formula Term)

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

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

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in