SAP ABAP Table FICOS_DC_220020 (Structure - Clearing)

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_DC_220020	Table Relationship Diagram
Short Description	Structure - Clearing

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	Date (Obsolete; Not used for persistency)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	I_DATE	☐	FICO_IDATE	SYSUUID	RAW	16	0	Date
4	.INCLUDE	☐				0	0	Mutual Data of Condition Parts
5	I_COND	☐	FICO_ICOND	SYSUUID	RAW	16	0	Condition GUID	*
6	D_VALIDFROM	☐	FICO_DVALIDFROM	FICO_DDATE	DATS	8	0	Valid-From Date of Condition
7	F_VALIDFROMINC	☐	FICO_FVALIDFROMINC	FICO_FFLAG	CHAR	1	0	Inclusive indicator for valid from date
8	F_VALIDFROMULT	☐	FICO_FVALIDFROMULT	FICO_FFLAG	CHAR	1	0	Month-End Indicator for Valid-From Date
9	D_VALIDTO	☐	FICO_DVALIDTO	FICO_DDATE	DATS	8	0	Valid-Top Date of Condition
10	F_VALIDTOINC	☐	FICO_FVALIDTOINC	FICO_FFLAG	CHAR	1	0	Inclusive indicator for valid to date
11	F_VALIDTOULT	☐	FICO_FVALIDTOULT	FICO_FFLAG	CHAR	1	0	Month-End Indicator for Valid-To Date
12	O_LEVEL	☐	FICO_OLEVEL	FICO_OLEVEL	NUMC	1	0	Tiered or Interval Calculation
13	O_LEVELTOFROM	☐	FICO_OLEVELTOFROM	FICO_OLEVELTOFROM	NUMC	1	0	Condition Item (Upper/Lower Limit)
14	F_ZEROCOND	☐	FICO_FZEROCOND	FICO_FZEROCOND	CHAR	1	0	Condition Form
15	O_TIMELIM	☐	FICO_OTIMELIM	FICO_OTIMELIM	NUMC	2	0	Reason for Assignment of Condition	FICOC_TIMELIM
16	O_LEVELEVAL	☐	FICO_OLEVELEVAL	FICO_OLEVELEVAL	NUMC	1	0	Levels for Condition Determination
17	O_STATUS	☐	FICO_OSTATUS	FICO_OSTATUS	NUMC	2	0	Status of Validity Period of a Condition
18	F_CORRESPONDENCE	☐	FICO_FCORRESPONDENCE	FICO_FFLAG	CHAR	1	0	Generate Correspondence
19	O_LEVELTOFREVAL	☐	FICO_OLEVELTOFREVAL	FICO_OLEVELTOFREVAL	NUMC	1	0	Indicator: Upper/Lower Limit for Condition Determination
20	O_RELCONDTYPE	☐	FICO_ORELCONDTYPE	FICO_OCONDTYP	NUMC	6	0	Reference Condition Type	FICOC_COND
21	F_NOINHERITANCE	☐	FICO_FNO_INHERITANCE	FICO_FNO_INHERITANCE	CHAR	1	0	Condition is not Passed On
22	O_CONDSOURCE	☐	FICO_OCONDSOURCE	FICO_OCONDSOURCE	CHAR	10	0	Origin of the Validity Period
23	I_LIST_SOURCE	☐	FICO_ILISTSOURCE	SYSUUID	RAW	16	0	Original List GUID for the Validity Period
24	O_REFUND	☐	FICO_OREFUND	FICO_OREFUND	NUMC	1	0	Category for Interest Reimbursement
25	I_BASIS_ORDER	☐	FICO_IBASIS_MERGENO	FICO_IMERGENO	NUMC	4	0	Ordinal Number for Basis Conditions in Condition Merger
26	I_COMP_REL	☐	FICO_ICOMP_REL	SYSUUID	RAW	16	0	Dependent Condition Component from Release
27	.INCLUDE	☐				0	0	Scheduling Data
28	O_DATECATG	☐	FICO_ODATECATG	FICO_ODATECATG	CHAR	6	0	Date Category	FICOB_DATE
29	N_REPPERIOD	☐	FICO_NREPPERIOD	FICO_NREPPERIOD	INT4	10	0	Repetition period
30	O_REPUNIT	☐	FICO_OREPUNIT	FICO_OREPUNIT	CHAR	1	0	Repetition Unit
31	O_KEYDATE	☐	FICO_OKEYDATE	FICO_OKEYDATE	NUMC	2	0	Key Date
32	D_STARTDATE	☐	FICO_DSTARTDATE	FICO_DDATE	DATS	8	0	First Calculation Date for Date Update
33	F_STARTDATEINC	☐	FICO_FSTARTDATEINC	FICO_FFLAG	CHAR	1	0	Inclusive Indicator
34	F_STARTDATEULT	☐	FICO_FSTARTDATEULT	FICO_FFLAG	CHAR	1	0	Month-End Indicator for Start Date
35	O_DATERULE	☐	FICO_ODATERULE	FICO_ODATERULE	NUMC	2	0	Update Rule
36	O_PULLDATE	☐	FICO_OPULLDATE	FICO_OPULLDATE	CHAR	2	0	Shift Due Date
37	O_RHYTHMCATG	☐	FICO_ORHYTHMCATG	FICO_ORHYTHMCATG	CHAR	1	0	Frequency Category
38	O_REFSTARTDATE	☐	FICO_OREFSTARTDATE		NUMC	4	0	Reference Date for Start Date
39	N_REFSTARTNUM	☐	FICO_NREFSTARTNUM	FICO_NNUMUNIT	NUMC	3	0	Shift of Reference Date for Start Date: Number of Units
40	U_REFSTARTUNIT	☐	FICO_UREFSTARTUNIT	FICO_UDATEUNIT	NUMC	1	0	Shift of Reference Date for Start Date: Unit
41	F_FIXEDPERIOD	☐	FICO_FFIXEDPERIOD	FICO_FFLAG	CHAR	1	0	Update With Fixed Periods
42	O_RELDATECATG	☐	FICO_ORELDATECATG	FICO_ODATECATG	CHAR	6	0	Reference Date Category	FICOB_DATE
43	O_RELDATESHIFT	☐	FICO_ORELDATESHIFT	FICO_ORELDATESHIFT	CHAR	1	0	Reference Date After Working Day Shift
44	O_REL_MISC	☐	FICO_ORELMISC	FICO_DOM_ORELMISC	CHAR	1	0	Reference Category for Date Category Adjustment
45	O_CAL1	☐	FICO_OCAL1	WFCID	CHAR	2	0	Calendar 1	TFACD
46	O_CAL2	☐	FICO_OCAL2	WFCID	CHAR	2	0	Calendar 2	TFACD
47	O_CAL3	☐	FICO_OCAL3	WFCID	CHAR	2	0	Calendar 3	TFACD
48	O_CAL5	☐	FICO_OCAL5	WFCID	CHAR	2	0	Calendar 4	TFACD
49	O_CAL6	☐	FICO_OCAL6	WFCID	CHAR	2	0	Calendar 5	TFACD
50	O_KEYDATES40	☐	FICO_OKEYDATES40	CHAR40	CHAR	40	0	Multiple Key Dates, CHAR Field With One Character Per Day
51	.INCLUDE	☐				0	0	User data
52	X_CREATEUSER	☐	FICO_XCREATEUSER	FICO_XUSER	CHAR	12	0	Created by
53	D_CREATEDATE	☐	FICO_DCREATEDATE	FICO_DDATE	DATS	8	0	Created on
54	T_CREATETIME	☐	FICO_TCREATETIME	FICO_TTIME	TIMS	6	0	Creation Time
55	X_CHANGEUSER	☐	FICO_XCHANGEUSER	FICO_XUSER	CHAR	12	0	Last changed by
56	D_CHANGEDATE	☐	FICO_DCHANGEDATE	FICO_DDATE	DATS	8	0	Changed on
57	T_CHANGETIME	☐	FICO_TCHANGETIME	FICO_TTIME	TIMS	6	0	Changed at
58	X_RELEASEUSER	☐	FICO_XRELEASEUSER	FICO_XUSER	CHAR	12	0	Released by
59	D_RELEASEDATE	☐	FICO_DRELEASEDATE	FICO_DDATE	DATS	8	0	Released on
60	T_RELEASETIME	☐	FICO_TRELEASETIME	FICO_TTIME	TIMS	6	0	Released at
61	D_VALIDTO_ARCHIV	☐	FICO_DVALIDTO_ARCHIVE	FICO_DDATE	DATS	8	0	Valid-to Date (Calculated) for Archiving
62	.INCLUDE	☐				0	0	Archiving data
63	ARCHIVE_STATUS	☐	AFX_DTE_ARCHIVE_STATUS	AFX_ARCHIVE_STATUS	CHAR	1	0	Archivability Status
64	ARCHIVE_FLUD	☐	AFX_DTE_ARCHIVE_FLUD	DATS	DATS	8	0	Resubmission Date
65	I_GRP	☐	FICO_IGRP	SYSUUID	RAW	16	0	Grouping Components of Validity Period
66	D_VALIDTO_IMPL	☐	FICO_DVALIDTO	FICO_DDATE	DATS	8	0	Valid-Top Date of Condition
67	I_FLDLSTID	☐	FICO_IFLDLSTID	SYSUUID	RAW	16	0	Field List
68	F_VTO_ADAPTED	☐	FICO_FVALIDTO_ADAPTED	FICO_FFLAG	CHAR	1	0	Checkbox for Automatic Deletion of Valid-To Date
69	D_VTO_RESTORE	☐	FICO_DVALIDTO_RESTORE	FICO_DDATE	DATS	8	0	Valid-To Date of Condition to Be Restored

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FICOS_DC_220020	MANDT	T000	MANDT	KEY	1	CN
2	FICOS_DC_220020	O_CAL1	TFACD	IDENT	REF	1	CN
3	FICOS_DC_220020	O_CAL2	TFACD	IDENT	REF	1	CN
4	FICOS_DC_220020	O_CAL3	TFACD	IDENT	REF	1	CN
5	FICOS_DC_220020	O_CAL5	TFACD	IDENT	REF	1	CN
6	FICOS_DC_220020	O_CAL6	TFACD	IDENT	REF	1	CN
7	FICOS_DC_220020	O_DATECATG	FICOB_DATE	O_DATECATG	KEY
8	FICOS_DC_220020	O_RELCONDTYPE	FICOC_COND	O_CONDTYPE
9	FICOS_DC_220020	O_RELDATECATG	FICOB_DATE	O_DATECATG
10	FICOS_DC_220020	O_TIMELIM	FICOC_TIMELIM	O_TIMELIM	REF	1	C

History

Last changed by/on	SAP	20130604
SAP Release Created in