SAP ABAP Table FICOS_CONDITION_HIST (Condition History)

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_CONDITION_HIST	Table Relationship Diagram
Short Description	Condition History

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_EXTKEY	☐	FICO_IEXTKEY	INT4	INT4	10	0	External Condition Component
2	.INCLUDE	☐				0	0	Condition List
3	O_LISTTYPE	☐	FICO_OLISTTYP	FICO_OLISTTYP	NUMC	6	0	Condition Group Type	FICOC_LIST
4	O_APPL	☐	FICO_OAPPL	FICO_OAPPL	CHAR	6	0	Application	FICOB_APPL
5	.INCLUDE	☐				0	0	Conditions
6	O_CONDTYPE	☐	FICO_OCONDTYPE	FICO_OCONDTYP	NUMC	6	0	Condition Type	*
7	F_INCREM	☐	FICO_FINCREM	FICO_FINCREM	CHAR	1	0	Replacement Category
8	I_MERGE_ORDER	☐	FICO_IMERGENO	FICO_IMERGENO	NUMC	4	0	Ordinal Number for Markup Conditions in Condition Merger
9	C_AMT	☐	FICO_CAMT	WAERS	CUKY	5	0	Currency	TCURC
10	F_INDCOND	☐	FICO_FINDCOND	FICO_FFLAG	CHAR	1	0	Individual Condition
11	.INCLUDE	☐				0	0	Mutual Data of Condition Parts
12	I_COND	☐	FICO_ICOND	SYSUUID	RAW	16	0	Condition GUID
13	D_VALIDFROM	☐	FICO_DVALIDFROM	FICO_DDATE	DATS	8	0	Valid-From Date of Condition
14	F_VALIDFROMINC	☐	FICO_FVALIDFROMINC	FICO_FFLAG	CHAR	1	0	Inclusive indicator for valid from date
15	F_VALIDFROMULT	☐	FICO_FVALIDFROMULT	FICO_FFLAG	CHAR	1	0	Month-End Indicator for Valid-From Date
16	D_VALIDTO	☐	FICO_DVALIDTO	FICO_DDATE	DATS	8	0	Valid-Top Date of Condition
17	F_VALIDTOINC	☐	FICO_FVALIDTOINC	FICO_FFLAG	CHAR	1	0	Inclusive indicator for valid to date
18	F_VALIDTOULT	☐	FICO_FVALIDTOULT	FICO_FFLAG	CHAR	1	0	Month-End Indicator for Valid-To Date
19	O_LEVEL	☐	FICO_OLEVEL	FICO_OLEVEL	NUMC	1	0	Tiered or Interval Calculation
20	O_LEVELTOFROM	☐	FICO_OLEVELTOFROM	FICO_OLEVELTOFROM	NUMC	1	0	Condition Item (Upper/Lower Limit)
21	F_ZEROCOND	☐	FICO_FZEROCOND	FICO_FZEROCOND	CHAR	1	0	Condition Form
22	O_TIMELIM	☐	FICO_OTIMELIM	FICO_OTIMELIM	NUMC	2	0	Reason for Assignment of Condition	FICOC_TIMELIM
23	O_LEVELEVAL	☐	FICO_OLEVELEVAL	FICO_OLEVELEVAL	NUMC	1	0	Levels for Condition Determination
24	O_STATUS	☐	FICO_OSTATUS	FICO_OSTATUS	NUMC	2	0	Status of Validity Period of a Condition
25	F_CORRESPONDENCE	☐	FICO_FCORRESPONDENCE	FICO_FFLAG	CHAR	1	0	Generate Correspondence
26	O_LEVELTOFREVAL	☐	FICO_OLEVELTOFREVAL	FICO_OLEVELTOFREVAL	NUMC	1	0	Indicator: Upper/Lower Limit for Condition Determination
27	O_RELCONDTYPE	☐	FICO_ORELCONDTYPE	FICO_OCONDTYP	NUMC	6	0	Reference Condition Type	FICOC_COND
28	F_NOINHERITANCE	☐	FICO_FNO_INHERITANCE	FICO_FNO_INHERITANCE	CHAR	1	0	Condition is not Passed On
29	O_CONDSOURCE	☐	FICO_OCONDSOURCE	FICO_OCONDSOURCE	CHAR	10	0	Origin of the Validity Period
30	I_LIST_SOURCE	☐	FICO_ILISTSOURCE	SYSUUID	RAW	16	0	Original List GUID for the Validity Period
31	O_REFUND	☐	FICO_OREFUND	FICO_OREFUND	NUMC	1	0	Category for Interest Reimbursement
32	I_BASIS_ORDER	☐	FICO_IBASIS_MERGENO	FICO_IMERGENO	NUMC	4	0	Ordinal Number for Basis Conditions in Condition Merger
33	I_COMP_REL	☐	FICO_ICOMP_REL	SYSUUID	RAW	16	0	Dependent Condition Component from Release
34	.INCLUDE	☐				0	0	Amount data
35	O_AMTCATG	☐	FICO_OAMTCATG	FICO_OAMTCATG	CHAR	6	0	Amount Category	FICOB_AMT
36	F_ADDDEBIT	☐	FICO_FADDDEBIT	FICO_FFLAG	CHAR	1	0	Obsolete: Ind. Overdraft Int. in Addition to Debit Interest
37	O_INSTMETH	☐	FICO_OINSTMETH	FICO_OINSTMETH	CHAR	4	0	Amout Determination Category for Payment Condition
38	O_INTMETHOD	☐	FICO_OINTMETHOD	SZBMETH_NEW	CHAR	1	0	Interest Calculation Method
39	F_EXPINT	☐	FICO_FEXPINT	FICO_FEXPINT	CHAR	1	0	Exponential/Linear Interest Calculation
40	O_AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
41	A_FREEAMT	☐	FICO_AFREEAMT	FICO_AAMT	CURR	23	2	Exemption
42	N_FREECOUNT	☐	FICO_NFREECOUNT	FICO_NCOUNT	NUMC	7	0	Number of Free Items
43	F_CAPITALINCREM	☐	FICO_FCAPITALINCREM	FICO_FFLAG	CHAR	1	0	Indicator: Capitalization
44	F_DUEDATEREL	☐	FICO_FDUEDATEREL	FICO_FFLAG	CHAR	1	0	Due Date-Related Calculation Indicator
45	F_GRACEINT	☐	FICO_FGRACEINT	FICO_FFLAG	CHAR	1	0	Grace Period Interest Method
46	O_CAL4	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	TFACD
47	F_ROUND	☐	FICO_FROUND	TFM_SROUND	CHAR	1	0	Rounding Category
48	U_ROUNDUNIT	☐	FICO_UROUNDUNIT	TFMSRUNIT	DEC	13	7	Rounding Unit
49	F_COUNT_AMOUNT	☐	FICO_FCOUNT_AMOUNT	FICO_FFLAG	CHAR	1	0	Amount Counter
50	O_SETTLEMENT	☐	FICO_OSETTLEMENT	FICO_OSETTLEMENT	CHAR	1	0	Type of Clearing
51	O_FIMATIMEPROP	☐	FICO_OFIMATIMEPROP	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Calculations in Cash Flow
52	O_ITEMCOUNTER	☐	FICO_OITEMCOUNTER	FICO_OITEMCOUNTER	CHAR	6	0	Counter
53	.INCLUDE	☐				0	0	Amount Component for Interest Penalty Calculation
54	O_PCALCREF	☐	FICO_OPCALC	FICO_OPCALC	CHAR	2	0	Calculation Method for Early Withdrawal Penalty	FICOC_PCALCREF
55	F_REDUCTION	☐	FICO_FREDUCTION	FICO_FFLAG	CHAR	1	0	Obsolete: Do Not Use
56	O_RES_METH_TYPE	☐	FICO_ORES_METH_TYPE		NUMC	4	0	Result Calculation Type
57	.INCLUDE	☐				0	0	Amount and/or Installment-Based Reduction
58	A_AMT_CUTB	☐	FICO_AAMT_CUTB	FICO_AAMT	CURR	23	2	Reduction Amount
59	R_PERC_CUTB	☐	FICO_RPERCENTAGE_CUTB	FICO_RPERCENTAGE	DEC	15	10	Perecentage Reduction
60	O_INTREF_CUTB	☐	FICO_OINTREF_CUTB		CHAR	10	0	Reference Interest Rate Reduction
61	R_INTMIN_CUTB	☐	FICO_RINTMIN_CUTB	FICO_RPERCENTAGE	DEC	15	10	Minimum Interest Reduction
62	R_INTMAX_CUTB	☐	FICO_RINTMAX_CUTB	FICO_RPERCENTAGE	DEC	15	10	Maximum Interest Reduction
63	N_CHRGCOUNT	☐	FICO_NCHRGCOUNT	FICO_NCOUNT	NUMC	7	0	Maximum Number of Items
64	F_RELATION	☐	FICO_FRELATION	FICO_FFLAG	CHAR	1	0	Condition has Relationships
65	.INCLUDE	☐				0	0	Condition Determination
66	O_REFDATE	☐	FICO_OREFDATE	FICO_OREFDATE	NUMC	1	0	Reference Date
67	U_REFDATUNIT	☐	FICO_UREFDATUNIT	FICO_UDATEUNIT	NUMC	1	0	Shift of Reference Date: Unit
68	N_REFDATNUM	☐	FICO_NREFDATNUM	FICO_NNUMUNIT	NUMC	3	0	Shift of reference date: Number of units
69	O_REFDATSETDATE	☐	FICO_OREFDATSETDATE	FICO_OSETDATE	NUMC	2	0	Shift of reference date: Key date
70	U_UNITDETSHIFT	☐	FICO_UUNITDETSHIFT	FICO_UDATEUNIT	NUMC	1	0	Shift of Determination Period: Unit
71	N_NUMDETSHIFT	☐	FICO_NNUMDETSHIFT	FICO_NNUMUNIT	NUMC	3	0	Shift of Calculation Period: Number of Units
72	O_USEPRD	☐	FICO_OUSEPRD	FICO_OUSEPRD	NUMC	2	0	Use Period	FICOC_USEPRD
73	O_DETPRD	☐	FICO_ODETPRD	FICO_ODETPRD	NUMC	2	0	Determination Period	FICOC_DETPRD
74	O_TIMEPROPCALC	☐	FICO_OTIMEPROPCALC	FICO_OTIMEPROPCALC	NUMC	2	0	Charge Calculation Method
75	O_TRNOVRCLASS	☐	FICO_OTRNOVRCLASS	FICO_OTRNOVRCLASS	CHAR	4	0	Turnover Class
76	O_TRNOVRCLBASE	☐	FICO_OTRNOVRCLBASE	FICO_OTRNOVRCLBASE	NUMC	2	0	Balancing Method
77	O_BALANCECATG	☐	FICO_OBALANCECATG	FICO_OBALANCECATG	NUMC	2	0	Balance Category
78	O_BALANCEBASE	☐	FICO_OBALANCEBASE	FICO_OBALANCEBASE	NUMC	2	0	Basis of Balances
79	O_PERIODCATG	☐	FICO_OPERIODCATG	FICO_OPERIODCATG	NUMC	2	0	Period Category
80	O_BASEREFEVAL	☐	FICO_OBASEREFEVAL		CHAR	10	0	Calculation Basis
81	.INCLUDE	☐				0	0	Scheduling Data
82	O_DATECATG	☐	FICO_ODATECATG	FICO_ODATECATG	CHAR	6	0	Date Category	FICOB_DATE
83	N_REPPERIOD	☐	FICO_NREPPERIOD	FICO_NREPPERIOD	INT4	10	0	Repetition period
84	O_REPUNIT	☐	FICO_OREPUNIT	FICO_OREPUNIT	CHAR	1	0	Repetition Unit
85	O_KEYDATE	☐	FICO_OKEYDATE	FICO_OKEYDATE	NUMC	2	0	Key Date
86	D_STARTDATE	☐	FICO_DSTARTDATE	FICO_DDATE	DATS	8	0	First Calculation Date for Date Update
87	F_STARTDATEINC	☐	FICO_FSTARTDATEINC	FICO_FFLAG	CHAR	1	0	Inclusive Indicator
88	F_STARTDATEULT	☐	FICO_FSTARTDATEULT	FICO_FFLAG	CHAR	1	0	Month-End Indicator for Start Date
89	O_DATERULE	☐	FICO_ODATERULE	FICO_ODATERULE	NUMC	2	0	Update Rule
90	O_PULLDATE	☐	FICO_OPULLDATE	FICO_OPULLDATE	CHAR	2	0	Shift Due Date
91	O_RHYTHMCATG	☐	FICO_ORHYTHMCATG	FICO_ORHYTHMCATG	CHAR	1	0	Frequency Category
92	O_REFSTARTDATE	☐	FICO_OREFSTARTDATE		NUMC	4	0	Reference Date for Start Date
93	N_REFSTARTNUM	☐	FICO_NREFSTARTNUM	FICO_NNUMUNIT	NUMC	3	0	Shift of Reference Date for Start Date: Number of Units
94	U_REFSTARTUNIT	☐	FICO_UREFSTARTUNIT	FICO_UDATEUNIT	NUMC	1	0	Shift of Reference Date for Start Date: Unit
95	F_FIXEDPERIOD	☐	FICO_FFIXEDPERIOD	FICO_FFLAG	CHAR	1	0	Update With Fixed Periods
96	O_RELDATECATG	☐	FICO_ORELDATECATG	FICO_ODATECATG	CHAR	6	0	Reference Date Category	FICOB_DATE
97	O_RELDATESHIFT	☐	FICO_ORELDATESHIFT	FICO_ORELDATESHIFT	CHAR	1	0	Reference Date After Working Day Shift
98	O_REL_MISC	☐	FICO_ORELMISC	FICO_DOM_ORELMISC	CHAR	1	0	Reference Category for Date Category Adjustment
99	O_CAL1	☐	FICO_OCAL1	WFCID	CHAR	2	0	Calendar 1	TFACD
100	O_CAL2	☐	FICO_OCAL2	WFCID	CHAR	2	0	Calendar 2	TFACD
101	O_CAL3	☐	FICO_OCAL3	WFCID	CHAR	2	0	Calendar 3	TFACD
102	O_CAL5	☐	FICO_OCAL5	WFCID	CHAR	2	0	Calendar 4	TFACD
103	O_CAL6	☐	FICO_OCAL6	WFCID	CHAR	2	0	Calendar 5	TFACD
104	O_KEYDATES40	☐	FICO_OKEYDATES40	CHAR40	CHAR	40	0	Multiple Key Dates, CHAR Field With One Character Per Day
105	.INCLUDE	☐				0	0	Structure for Changing Differentiations
106	O_DIFFCATG	☐	FICO_ODIFFCATG_0	FICO_ODIFFCATG	CHAR	3	0	Differentiation Category	*
107	I_DIFFVALUE	☐	FICO_IDIFFVALUE	FICO_IDIFFVALUE	CHAR	10	0	Differentiation value
108	O_DIFFCATG_1	☐	FICO_ODIFFCATG_1	FICO_ODIFFCATG	CHAR	3	0	Differentiation Category	*
109	I_DIFFVALUE_1	☐	FICO_IDIFFVALUE	FICO_IDIFFVALUE	CHAR	10	0	Differentiation value
110	O_DIFFCATG_2	☐	FICO_ODIFFCATG_2	FICO_ODIFFCATG	CHAR	3	0	Differentiation Category	*
111	I_DIFFVALUE_2	☐	FICO_IDIFFVALUE	FICO_IDIFFVALUE	CHAR	10	0	Differentiation value
112	O_DIFFCATG_3	☐	FICO_ODIFFCATG_3	FICO_ODIFFCATG	CHAR	3	0	Differentiation Category	*
113	I_DIFFVALUE_3	☐	FICO_IDIFFVALUE	FICO_IDIFFVALUE	CHAR	10	0	Differentiation value
114	O_DIFFCATG_4	☐	FICO_ODIFFCATG_4	FICO_ODIFFCATG	CHAR	3	0	Differentiation Category	*
115	I_DIFFVALUE_4	☐	FICO_IDIFFVALUE	FICO_IDIFFVALUE	CHAR	10	0	Differentiation value
116	.INCLUDE	☐				0	0	Conditions - Change Details
117	VALID_FROM_TST	☐	FICO_VALIDFROM_TST	FICO_TIMESTAMP	DEC	15	0	Time Stamp Valid-From
118	X_CHANGED_BY_USER	☐	FICO_XCHANGEUSER	FICO_XUSER	CHAR	12	0	Last changed by
119	.INCLUDE	☐				0	0	Conditions - Validity Period
120	VALID_TO_TST	☐	FICO_VALIDTO_TST	FICO_TIMESTAMP	DEC	15	0	Time Stamp Valid-To
121	F_INCONSISTENT	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FICOS_CONDITION_HIST	C_AMT	TCURC	WAERS	REF	C	CN
2	FICOS_CONDITION_HIST	O_AMTCATG	FICOB_AMT	O_AMTCATG	KEY
3	FICOS_CONDITION_HIST	O_APPL	FICOB_APPL	O_APPL
4	FICOS_CONDITION_HIST	O_CAL1	TFACD	IDENT	REF	1	CN
5	FICOS_CONDITION_HIST	O_CAL2	TFACD	IDENT	REF	1	CN
6	FICOS_CONDITION_HIST	O_CAL3	TFACD	IDENT	REF	1	CN
7	FICOS_CONDITION_HIST	O_CAL4	TFACD	IDENT	REF	1	CN
8	FICOS_CONDITION_HIST	O_CAL5	TFACD	IDENT	REF	1	CN
9	FICOS_CONDITION_HIST	O_CAL6	TFACD	IDENT	REF	1	CN
10	FICOS_CONDITION_HIST	O_DATECATG	FICOB_DATE	O_DATECATG	KEY
11	FICOS_CONDITION_HIST	O_DETPRD	FICOC_DETPRD	O_DETPRD	REF	1	C
12	FICOS_CONDITION_HIST	O_LISTTYPE	FICOC_LIST	O_LISTTYPE
13	FICOS_CONDITION_HIST	O_PCALCREF	FICOC_PCALCREF	O_PCALCREF	KEY	1	CN
14	FICOS_CONDITION_HIST	O_RELCONDTYPE	FICOC_COND	O_CONDTYPE	REF	1	CN
15	FICOS_CONDITION_HIST	O_RELDATECATG	FICOB_DATE	O_DATECATG
16	FICOS_CONDITION_HIST	O_TIMELIM	FICOC_TIMELIM	O_TIMELIM	REF	1	C
17	FICOS_CONDITION_HIST	O_USEPRD	FICOC_USEPRD	O_USEPRD	REF	1	C

History

Last changed by/on	SAP	20130604
SAP Release Created in	710