SAP ABAP Table FICOS_COND_COMP_DETAIL (Old: Differentiation Categories Component Category)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-FIM-FCO (Application Component) Financial Conditions
     ⤷ FICO (Package) Financial Conditions

Basic Data

Table Category	INTTAB	Structure
Structure	FICOS_COND_COMP_DETAIL	Table Relationship Diagram
Short Description	Old: Differentiation Categories Component Category

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	I_CONDITION	☐	FICO_IINCLUDE	FICO_IINCLUDE	CHAR	10	0	Condition Include: Condition / Condition List
2	X_CONDITION	☐	FICO_XINCLUDE	TEXT25	CHAR	25	0	Description of Include
3	O_CONDTYPE	☐	FICO_OCONDTYPE	FICO_OCONDTYP	NUMC	6	0	Condition Type	*
4	X_ICONIND	☐	FICO_XICONIND	CHAR4	CHAR	4	0	Icon Individual / Standard Condition
5	O_DIFFCATG	☐	FICO_ODIFFCATG	FICO_ODIFFCATG	CHAR	3	0	Differentiation Category	*
6	X_DIFFCATG	☐	FICO_XDIFFCATG	TEXT25	CHAR	25	0	Description of Differentiation Category
7	I_DIFFVALUE	☐	FICO_IDIFFVALUE	FICO_IDIFFVALUE	CHAR	10	0	Differentiation value
8	X_DIFFVALUE	☐	FICO_XDIFFVALUE	TEXT25	CHAR	25	0	Description of Differentiation Value
9	O_DIFFCATG2	☐	FICO_ODIFFCATG	FICO_ODIFFCATG	CHAR	3	0	Differentiation Category	*
10	X_DIFFCATG2	☐	FICO_XDIFFCATG	TEXT25	CHAR	25	0	Description of Differentiation Category
11	I_DIFFVALUE2	☐	FICO_IDIFFVALUE	FICO_IDIFFVALUE	CHAR	10	0	Differentiation value
12	X_DIFFVALUE2	☐	FICO_XDIFFVALUE	TEXT25	CHAR	25	0	Description of Differentiation Value
13	O_DIFFCATG3	☐	FICO_ODIFFCATG	FICO_ODIFFCATG	CHAR	3	0	Differentiation Category	*
14	X_DIFFCATG3	☐	FICO_XDIFFCATG	TEXT25	CHAR	25	0	Description of Differentiation Category
15	I_DIFFVALUE3	☐	FICO_IDIFFVALUE	FICO_IDIFFVALUE	CHAR	10	0	Differentiation value
16	X_DIFFVALUE3	☐	FICO_XDIFFVALUE	TEXT25	CHAR	25	0	Description of Differentiation Value
17	O_RYTHM	☐	FICO_ORYTHM	CHAR10	CHAR	10	0	Old: Frequency (Period + Period Unit)
18	X_INTEREST	☐	FICO_XINTEREST	CHAR10	CHAR	10	0	Text Field for Percentage Rate or Formula
19	X_ADJUSTMENT	☐	FICO_XADJ	CHAR60	CHAR	60	0	Text Field Interest Adjustment
20	.INCLUDE	☐				0	0	Mutual Data of Condition Parts
21	I_COND	☐	FICO_ICOND	SYSUUID	RAW	16	0	Condition GUID	*
22	D_VALIDFROM	☐	FICO_DVALIDFROM	FICO_DDATE	DATS	8	0	Valid-From Date of Condition
23	F_VALIDFROMINC	☐	FICO_FVALIDFROMINC	FICO_FFLAG	CHAR	1	0	Inclusive indicator for valid from date
24	F_VALIDFROMULT	☐	FICO_FVALIDFROMULT	FICO_FFLAG	CHAR	1	0	Month-End Indicator for Valid-From Date
25	D_VALIDTO	☐	FICO_DVALIDTO	FICO_DDATE	DATS	8	0	Valid-Top Date of Condition
26	F_VALIDTOINC	☐	FICO_FVALIDTOINC	FICO_FFLAG	CHAR	1	0	Inclusive indicator for valid to date
27	F_VALIDTOULT	☐	FICO_FVALIDTOULT	FICO_FFLAG	CHAR	1	0	Month-End Indicator for Valid-To Date
28	O_LEVEL	☐	FICO_OLEVEL	FICO_OLEVEL	NUMC	1	0	Tiered or Interval Calculation
29	O_LEVELTOFROM	☐	FICO_OLEVELTOFROM	FICO_OLEVELTOFROM	NUMC	1	0	Condition Item (Upper/Lower Limit)
30	F_ZEROCOND	☐	FICO_FZEROCOND	FICO_FZEROCOND	CHAR	1	0	Condition Form
31	O_TIMELIM	☐	FICO_OTIMELIM	FICO_OTIMELIM	NUMC	2	0	Reason for Assignment of Condition	FICOC_TIMELIM
32	O_LEVELEVAL	☐	FICO_OLEVELEVAL	FICO_OLEVELEVAL	NUMC	1	0	Levels for Condition Determination
33	O_STATUS	☐	FICO_OSTATUS	FICO_OSTATUS	NUMC	2	0	Status of Validity Period of a Condition
34	F_CORRESPONDENCE	☐	FICO_FCORRESPONDENCE	FICO_FFLAG	CHAR	1	0	Generate Correspondence
35	O_LEVELTOFREVAL	☐	FICO_OLEVELTOFREVAL	FICO_OLEVELTOFREVAL	NUMC	1	0	Indicator: Upper/Lower Limit for Condition Determination
36	O_RELCONDTYPE	☐	FICO_ORELCONDTYPE	FICO_OCONDTYP	NUMC	6	0	Reference Condition Type	FICOC_COND
37	F_NOINHERITANCE	☐	FICO_FNO_INHERITANCE	FICO_FNO_INHERITANCE	CHAR	1	0	Condition is not Passed On
38	O_CONDSOURCE	☐	FICO_OCONDSOURCE	FICO_OCONDSOURCE	CHAR	10	0	Origin of the Validity Period
39	I_LIST_SOURCE	☐	FICO_ILISTSOURCE	SYSUUID	RAW	16	0	Original List GUID for the Validity Period
40	O_REFUND	☐	FICO_OREFUND	FICO_OREFUND	NUMC	1	0	Category for Interest Reimbursement
41	I_BASIS_ORDER	☐	FICO_IBASIS_MERGENO	FICO_IMERGENO	NUMC	4	0	Ordinal Number for Basis Conditions in Condition Merger
42	I_COMP_REL	☐	FICO_ICOMP_REL	SYSUUID	RAW	16	0	Dependent Condition Component from Release
43	X_DATECATG	☐	FICO_XDATECATG	TEXT25	CHAR	25	0	Description of Date Category
44	I_DATE	☐	FICO_IDATE	SYSUUID	RAW	16	0	Date
45	I_LOGICDATE	☐	FICO_ILOGICCOMP	FICO_ILOGICCOMP	CHAR	10	0	Time-Independent Component
46	.INCLUDE	☐				0	0	Scheduling Data
47	O_DATECATG	☐	FICO_ODATECATG	FICO_ODATECATG	CHAR	6	0	Date Category	FICOB_DATE
48	N_REPPERIOD	☐	FICO_NREPPERIOD	FICO_NREPPERIOD	INT4	10	0	Repetition period
49	O_REPUNIT	☐	FICO_OREPUNIT	FICO_OREPUNIT	CHAR	1	0	Repetition Unit
50	O_KEYDATE	☐	FICO_OKEYDATE	FICO_OKEYDATE	NUMC	2	0	Key Date
51	D_STARTDATE	☐	FICO_DSTARTDATE	FICO_DDATE	DATS	8	0	First Calculation Date for Date Update
52	F_STARTDATEINC	☐	FICO_FSTARTDATEINC	FICO_FFLAG	CHAR	1	0	Inclusive Indicator
53	F_STARTDATEULT	☐	FICO_FSTARTDATEULT	FICO_FFLAG	CHAR	1	0	Month-End Indicator for Start Date
54	O_DATERULE	☐	FICO_ODATERULE	FICO_ODATERULE	NUMC	2	0	Update Rule
55	O_PULLDATE	☐	FICO_OPULLDATE	FICO_OPULLDATE	CHAR	2	0	Shift Due Date
56	O_RHYTHMCATG	☐	FICO_ORHYTHMCATG	FICO_ORHYTHMCATG	CHAR	1	0	Frequency Category
57	O_REFSTARTDATE	☐	FICO_OREFSTARTDATE		NUMC	4	0	Reference Date for Start Date
58	N_REFSTARTNUM	☐	FICO_NREFSTARTNUM	FICO_NNUMUNIT	NUMC	3	0	Shift of Reference Date for Start Date: Number of Units
59	U_REFSTARTUNIT	☐	FICO_UREFSTARTUNIT	FICO_UDATEUNIT	NUMC	1	0	Shift of Reference Date for Start Date: Unit
60	F_FIXEDPERIOD	☐	FICO_FFIXEDPERIOD	FICO_FFLAG	CHAR	1	0	Update With Fixed Periods
61	O_RELDATECATG	☐	FICO_ORELDATECATG	FICO_ODATECATG	CHAR	6	0	Reference Date Category	FICOB_DATE
62	O_RELDATESHIFT	☐	FICO_ORELDATESHIFT	FICO_ORELDATESHIFT	CHAR	1	0	Reference Date After Working Day Shift
63	O_REL_MISC	☐	FICO_ORELMISC	FICO_DOM_ORELMISC	CHAR	1	0	Reference Category for Date Category Adjustment
64	O_CAL1	☐	FICO_OCAL1	WFCID	CHAR	2	0	Calendar 1	TFACD
65	O_CAL2	☐	FICO_OCAL2	WFCID	CHAR	2	0	Calendar 2	TFACD
66	O_CAL3	☐	FICO_OCAL3	WFCID	CHAR	2	0	Calendar 3	TFACD
67	O_CAL5	☐	FICO_OCAL5	WFCID	CHAR	2	0	Calendar 4	TFACD
68	O_CAL6	☐	FICO_OCAL6	WFCID	CHAR	2	0	Calendar 5	TFACD
69	O_KEYDATES40	☐	FICO_OKEYDATES40	CHAR40	CHAR	40	0	Multiple Key Dates, CHAR Field With One Character Per Day
70	X_DATECATG_2	☐	FICO_XDATECATG	TEXT25	CHAR	25	0	Description of Date Category
71	I_DATE_2	☐	FICO_IDATE	SYSUUID	RAW	16	0	Date
72	I_LOGICDATE_2	☐	FICO_ILOGICCOMP	FICO_ILOGICCOMP	CHAR	10	0	Time-Independent Component
73	.INCLUDE	☐				0	0	Old: Schedule Data
74	O_DATECATG_2	☐	FICO_ODATECATG	FICO_ODATECATG	CHAR	6	0	Date Category	*
75	N_REPPERIOD_2	☐	FICO_NREPPERIOD	FICO_NREPPERIOD	INT4	10	0	Repetition period
76	O_REPUNIT_2	☐	FICO_OREPUNIT	FICO_OREPUNIT	CHAR	1	0	Repetition Unit
77	O_KEYDATE_2	☐	FICO_OKEYDATE	FICO_OKEYDATE	NUMC	2	0	Key Date
78	D_STARTDATE_2	☐	FICO_DSTARTDATE	FICO_DDATE	DATS	8	0	First Calculation Date for Date Update
79	F_STARTDATEINC_2	☐	FICO_FSTARTDATEINC	FICO_FFLAG	CHAR	1	0	Inclusive Indicator
80	F_STARTDATEULT_2	☐	FICO_FSTARTDATEULT	FICO_FFLAG	CHAR	1	0	Month-End Indicator for Start Date
81	O_PULLDATE_2	☐	FICO_OPULLDATE	FICO_OPULLDATE	CHAR	2	0	Shift Due Date
82	O_RHYTHMTYPE_2	☐	FICO_ORHYTHMCATG	FICO_ORHYTHMCATG	CHAR	1	0	Frequency Category
83	F_FIXEDPERIOD_2	☐	FICO_FFIXEDPERIOD	FICO_FFLAG	CHAR	1	0	Update With Fixed Periods
84	O_RELDATECATG_2	☐	FICO_ODATECATG	FICO_ODATECATG	CHAR	6	0	Date Category	*
85	O_RELDATESHIFT_2	☐	FICO_ORELDATESHIFT	FICO_ORELDATESHIFT	CHAR	1	0	Reference Date After Working Day Shift
86	O_CAL1_2	☐	FICO_OCAL1	WFCID	CHAR	2	0	Calendar 1	TFACD
87	O_CAL2_2	☐	FICO_OCAL2	WFCID	CHAR	2	0	Calendar 2	TFACD
88	X_AMTCATG	☐	FICO_XAMTCATG	TEXT25	CHAR	25	0	Amount Category Description
89	I_AMT	☐	FICO_IAMT	SYSUUID	RAW	16	0	Amount
90	I_LOGICAMT	☐	FICO_ILOGICCOMP	FICO_ILOGICCOMP	CHAR	10	0	Time-Independent Component
91	.INCLUDE	☐				0	0	Amount data
92	O_AMTCATG	☐	FICO_OAMTCATG	FICO_OAMTCATG	CHAR	6	0	Amount Category	FICOB_AMT
93	F_ADDDEBIT	☐	FICO_FADDDEBIT	FICO_FFLAG	CHAR	1	0	Obsolete: Ind. Overdraft Int. in Addition to Debit Interest
94	O_INSTMETH	☐	FICO_OINSTMETH	FICO_OINSTMETH	CHAR	4	0	Amout Determination Category for Payment Condition
95	O_INTMETHOD	☐	FICO_OINTMETHOD	SZBMETH_NEW	CHAR	1	0	Interest Calculation Method
96	F_EXPINT	☐	FICO_FEXPINT	FICO_FEXPINT	CHAR	1	0	Exponential/Linear Interest Calculation
97	O_AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
98	A_FREEAMT	☐	FICO_AFREEAMT	FICO_AAMT	CURR	23	2	Exemption
99	N_FREECOUNT	☐	FICO_NFREECOUNT	FICO_NCOUNT	NUMC	7	0	Number of Free Items
100	F_CAPITALINCREM	☐	FICO_FCAPITALINCREM	FICO_FFLAG	CHAR	1	0	Indicator: Capitalization
101	F_DUEDATEREL	☐	FICO_FDUEDATEREL	FICO_FFLAG	CHAR	1	0	Due Date-Related Calculation Indicator
102	F_GRACEINT	☐	FICO_FGRACEINT	FICO_FFLAG	CHAR	1	0	Grace Period Interest Method
103	O_CAL4	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	TFACD
104	F_ROUND	☐	FICO_FROUND	TFM_SROUND	CHAR	1	0	Rounding Category
105	U_ROUNDUNIT	☐	FICO_UROUNDUNIT	TFMSRUNIT	DEC	13	7	Rounding Unit
106	F_COUNT_AMOUNT	☐	FICO_FCOUNT_AMOUNT	FICO_FFLAG	CHAR	1	0	Amount Counter
107	O_SETTLEMENT	☐	FICO_OSETTLEMENT	FICO_OSETTLEMENT	CHAR	1	0	Type of Clearing
108	O_FIMATIMEPROP	☐	FICO_OFIMATIMEPROP	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Calculations in Cash Flow
109	O_ITEMCOUNTER	☐	FICO_OITEMCOUNTER	FICO_OITEMCOUNTER	CHAR	6	0	Counter
110	.INCLUDE	☐				0	0	Amount Component for Interest Penalty Calculation
111	O_PCALCREF	☐	FICO_OPCALC	FICO_OPCALC	CHAR	2	0	Calculation Method for Early Withdrawal Penalty	FICOC_PCALCREF
112	F_REDUCTION	☐	FICO_FREDUCTION	FICO_FFLAG	CHAR	1	0	Obsolete: Do Not Use
113	O_RES_METH_TYPE	☐	FICO_ORES_METH_TYPE		NUMC	4	0	Result Calculation Type
114	.INCLUDE	☐				0	0	Amount and/or Installment-Based Reduction
115	A_AMT_CUTB	☐	FICO_AAMT_CUTB	FICO_AAMT	CURR	23	2	Reduction Amount
116	R_PERC_CUTB	☐	FICO_RPERCENTAGE_CUTB	FICO_RPERCENTAGE	DEC	15	10	Perecentage Reduction
117	O_INTREF_CUTB	☐	FICO_OINTREF_CUTB		CHAR	10	0	Reference Interest Rate Reduction
118	R_INTMIN_CUTB	☐	FICO_RINTMIN_CUTB	FICO_RPERCENTAGE	DEC	15	10	Minimum Interest Reduction
119	R_INTMAX_CUTB	☐	FICO_RINTMAX_CUTB	FICO_RPERCENTAGE	DEC	15	10	Maximum Interest Reduction
120	N_CHRGCOUNT	☐	FICO_NCHRGCOUNT	FICO_NCOUNT	NUMC	7	0	Maximum Number of Items
121	F_RELATION	☐	FICO_FRELATION	FICO_FFLAG	CHAR	1	0	Condition has Relationships
122	.INCLUDE	☐				0	0	Amount Items
123	A_BASE	☐	FICO_ABASE	FICO_AAMT	CURR	23	2	Calculation Basis for Interest Calculation
124	O_BASEREF	☐	FICO_OBASEREF	FICO_OBASEREF	CHAR	4	0	Basis reference	*
125	O_BASEFIXING	☐	FICO_OBASEFIXING	FICO_OBASEFIXING	NUMC	2	0	Calculation Basis-Fixing
126	O_IRUNIT	☐	FICO_OIRUNIT	FICO_OIRUNIT	NUMC	3	0	Time Unit for Interest Rate
127	A_AMT	☐	FICO_AAMT	FICO_AAMT	CURR	23	2	Amount of the Amount Item
128	A_AMTMIN	☐	FICO_AAMTMIN	FICO_AAMT	CURR	23	2	Minimum amount
129	A_AMTMAX	☐	FICO_AAMTMAX	FICO_AAMT	CURR	23	2	Maximum Amount
130	A_AMTTRIV	☐	FICO_AAMTTRIV	FICO_AAMT	CURR	23	2	Trivial Amount
131	A_AMTLIMAMT	☐	FICO_AAMTLIM	FICO_AAMT	CURR	23	2	Amount Limit for Date or Amount Components
132	N_COUNTLIM	☐	FICO_NCOUNTLIM	FICO_NCOUNT	NUMC	7	0	Item Limit
133	N_DIVISOR	☐	FICO_NDIVISOR	FICO_NDIVISOR	DEC	4	0	Divisor
134	I_FORMULA	☐	FICO_IFORMULA	T_FORMBE	CHAR	4	0	Formula Reference	AT30
135	A_ADDAMT	☐	FICO_AADDAMT	FICO_AAMT	CURR	23	2	Additional Amount for Automatic Scaled Calculation
136	A_ADDAMTLIM	☐	FICO_AADDAMTLIM	FICO_AAMT	CURR	23	2	Amount Limit for Automatic Scaled Calculation
137	A_AMT_2	☐	FICO_AAMT_2	FICO_AAMT	CURR	23	2	Line Item Amount
138	N_FX_RATE	☐	FICO_DTE_FX_RATE_DEC	FICO_DOM_DECV4_11	DEC	15	11	Fixed Exchange Rate
139	C_AMT_POST	☐	FICO_CAMT_POST	WAERS	CUKY	5	0	Payment Currency	TCURC
140	P_PAYMENT	☐	FICO_PPAYMENT	TFM_PPAYMENT	DEC	11	7	FICO: Payment Rate
141	.INCLUDE	☐				0	0	Amount Position for Interest Penalty Calculation
142	O_PERCDAY	☐	FICO_PERCDAY	FICO_PERCDAY	DEC	15	10	Percentage or Number of Days
143	.INCLUDE	☐				0	0	Formula ID
144	I_FORMULA_ID	☐	SFBEID	SYSUUID_C	CHAR	32	0	Formula ID
145	O_AMTLIM_REF	☐	FICO_OAMTLIM_REF	FICO_OAMTLIM_REF	CHAR	12	0	Reference Amount Limit
146	.INCLUDE	☐				0	0	Condition Items for Complex Condition Determination
147	O_LEVEL_POS	☐	FICO_OLEVEL_POS	FICO_OLEVEL	NUMC	1	0	Tiered/Interval Calculation (Item)
148	O_LEVELTOFR_POS	☐	FICO_OLEVELTOFROM	FICO_OLEVELTOFROM	NUMC	1	0	Condition Item (Upper/Lower Limit)
149	A_AMTLIMAMT2	☐	FICO_AAMTLIM_CCD	FICO_AAMT	CURR	23	2	Amount Limit Complex Tiers for Condition Determination
150	O_AMTLIM_REF2	☐	FICO_OAMTLIM_REF	FICO_OAMTLIM_REF	CHAR	12	0	Reference Amount Limit
151	O_WAIVETOFROM	☐	FICO_OWAIVETOFROM	FICO_FFLAG	CHAR	1	0	Waive from
152	O_WAIVEPRD	☐	FICO_OWAIVEPRD		NUMC	2	0	Waiver Period
153	N_FREECOUNT_POS	☐	FICO_NFREECOUNT_POS	FICO_NCOUNT	NUMC	7	0	No. of Free Items (Position)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FICOS_COND_COMP_DETAIL	C_AMT_POST	TCURC	WAERS
2	FICOS_COND_COMP_DETAIL	I_FORMULA	AT30	RFORMBEZ	KEY
3	FICOS_COND_COMP_DETAIL	O_AMTCATG	FICOB_AMT	O_AMTCATG	KEY
4	FICOS_COND_COMP_DETAIL	O_CAL1	TFACD	IDENT	REF	1	CN
5	FICOS_COND_COMP_DETAIL	O_CAL1_2	TFACD	IDENT
6	FICOS_COND_COMP_DETAIL	O_CAL2	TFACD	IDENT	REF	1	CN
7	FICOS_COND_COMP_DETAIL	O_CAL2_2	TFACD	IDENT
8	FICOS_COND_COMP_DETAIL	O_CAL3	TFACD	IDENT	REF	1	CN
9	FICOS_COND_COMP_DETAIL	O_CAL4	TFACD	IDENT	REF	1	CN
10	FICOS_COND_COMP_DETAIL	O_CAL5	TFACD	IDENT	REF	1	CN
11	FICOS_COND_COMP_DETAIL	O_CAL6	TFACD	IDENT	REF	1	CN
12	FICOS_COND_COMP_DETAIL	O_DATECATG	FICOB_DATE	O_DATECATG	KEY
13	FICOS_COND_COMP_DETAIL	O_PCALCREF	FICOC_PCALCREF	O_PCALCREF	KEY	1	CN
14	FICOS_COND_COMP_DETAIL	O_RELCONDTYPE	FICOC_COND	O_CONDTYPE
15	FICOS_COND_COMP_DETAIL	O_RELDATECATG	FICOB_DATE	O_DATECATG
16	FICOS_COND_COMP_DETAIL	O_TIMELIM	FICOC_TIMELIM	O_TIMELIM	REF	1	C

History

Last changed by/on	SAP	20130604
SAP Release Created in