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

History

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