SAP Financial Conditions Tables
Are you looking for the right table related to SAP Financial Conditions Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Financial Conditions (CA-FIM-FCO) module.
Top 10 tables in Financial Conditions
| Table | Description |
|---|---|
| FICOT_LIST | Condition List |
| FICOB_COND | Condition category |
| FICOB_DATE_T | Date Category Texts |
| FICOB_CHECK | FICO Checks |
| FICOB_HEAD_FIE | Condition Header Assignment - Field |
| FICOB_FCTRL_DATE | Date Category Assignment - Field |
| FICOT_POS_REL | Relationships Between Condition Items |
| FICOC_COND_OPRTR | Assignment of Condition Category to Formula Operator |
| FICOT_AMTPOSEXP | Interest Rates and Interest Refs for an Amt Item (Obsolete) |
| FICOT_POS_RULE | Condition Item: Formula ID and Text |
List of tables in Financial Conditions
| Table | Description |
|---|---|
| FICOT_LIST | Condition List |
| FICOB_COND | Condition category |
| FICOB_DATE_T | Date Category Texts |
| FICOB_CHECK | FICO Checks |
| FICOB_HEAD_FIE | Condition Header Assignment - Field |
| FICOB_FCTRL_DATE | Date Category Assignment - Field |
| FICOT_POS_REL | Relationships Between Condition Items |
| FICOC_COND_OPRTR | Assignment of Condition Category to Formula Operator |
| FICOT_AMTPOSEXP | Interest Rates and Interest Refs for an Amt Item (Obsolete) |
| FICOT_POS_RULE | Condition Item: Formula ID and Text |
| FICOC_COND_USER | Condition Type: User Information |
| FICOC_TIMELIM | Reason for Assignment of Condition |
| FICOT_AMTPOS | Amount Item (Obsolete; not used for persistency) |
| FICOB_LIST_T | Texts for Condition Group Category (List Category) |
| FICOB_COND_T | Texts for Condition Category |
| FICOB_OV_CONTROL | Overview Display Field Control |
| FICOT_CONDT_BUFF | Texts for Conditions (Buffered) |
| FICOT_CONDDIFF | Assignment Condition - Differentiation |
| FICOT_DATE | Date (Obsolete; Not used for persistency) |
| FICOC_PCALCREF_T | Text for Interest Penalty Calculation Method |
| FICOC_COND_GUID | Condition Type: Assignment of GUID |
| FICO_FOBUEV001 | FoBuEv: Line (Token) of Formula (Not Buffered) |
| FICOC_FOREIGN | Data from External Applications |
| FICOC_LIST_COND | Assignment Conditon Group Type (List Type) - Condition Type |
| FICOC_COND_FMOD | Field Modifications for Condition Types |
| FICOT_DATEPOS | Date Item (Obsolete; Not used for persistency) |
| FICOC_USEPRD_T | Texts for Period of Use |
| FICOT_COND | Conditions (Obsolete; Not used for persistency) |
| FICOT_CTRL_MAINT | Condition Set of Rules |
| FICOT_CDGRP_VERS | Time-Restricted Condition Groups |
| FICOB_AMT_FCNTR | OBSOLETE DONT USE |
| FICOC_DETPRD_T | Texts for Calculation Period |
| FICOT_POS | Condition Items (Unbuffered) |
| FICOC_COND_DATE | Assignment Condition Type - Deadline Category |
| BCA_CONDGROUP | Condition Group |
| FICOC_COND_DIFF | Assignment Condition Type - Differentiation |
| FICOB_AMT | Amount Category |
| FICOT_POS_REL_BU | Relationships Between Condition Items (Buffered) |
| FICOT_FCTRL_PER | Rules of Condition Set of Rules |
| FICOB_COND_AMT | Assignment Condition Category - Amount Category |
| FICOB_DIFF_T | Texts for Differentiation Categories |
| FICOB_FOREIGN | Data from External Applications |
| FICOC_TIMELIM_T | Texts for Reason for Assignment |
| FICOB_APPL_LIST | Application Assignment - Condition Group Category |
| FICOB_FCTRL_COND | Condition Header Assignment - Field |
| FICOB_DIFF | Differentiation Category |
| FICOB_LIST_COND | Assignment Cond. Group Category (List Cat.) - Condition Cat. |
| FICOB_CHECK_NAME | OBSOLETE: Assgmt of FICO Check ID to the Class Name of Check |
| FICOC_DETPRD | Condition Calculation Period |
| FICOB_DATE_FCNTR | OBSOLETE DONT USE |
| FICOC_CONTROL | Control Parameter for FICO |
| FICOT_FCTRL_PROP | Rules of Condition Set of Rules: Field Properties |
| FICOT_AMT | Amount Table (Obsolete; Not used for persistency) |
| FICOB_COND_FIE | OBSOLETE DONT USE |
| FICOT_VERSIONS | Version Management for Standard Condition Groups |
| FICOC_LIST | Condition Group Type (List Type) |
| FICOC_BASEREF | Texts of Base References |
| FICOC_USEPRD | Condition Use Period |
| FICOT_CONDI_BUFF | Conditions (Buffered) |
| FICOC_BASEREF_T | Texts of Base References |
| FICOB_COND_DIFF | Assignment Condition Category - Differentiation Category |
| FICO_FOBUEV000 | FoPostEv: Header data of Formula (Not Buffered) |
| FICOB_LIST | Condition Group Category (List Category) |
| FICOB_COND_DATE | Assignment Condition Category - Date Category |
| FICOC_COND_BDT | Define Condition Type - BDT |
| FICOC_COND_T | Texts for Condition Type |
| FICOB_FCTRL_AMT | Field for Assignment of Amount Category |
| FICOB_APPL_COND | Application Assignment - Condition Category |
| FICOT_POS_BUFF | Items of the Conditions (Buffered) |
| FICOC_LIST_T | Texts for Condition Group Type (List Type) |
| FICOC_PCALCREF | Interest Penalty Calculation Method |
| FICOT_CONDI | Conditions (Unbuffered) |
| FICOB_CALCCATG_T | Texts for Calculation Category |
| FICOT_COND_T | Texts for Conditions (Unbuffered) |
| FICOT_LIST_COND | Assignment Condition List - Condition |
| FICOB_DATE | Date Category |
| BCA_CONDGROUP_T | Text on Condition Group |
| FICOB_CALCCATG | Calculation Category |
| FICOB_APPL | Application |
| FICOC_COND_FIE | Assignment of Condition Type - Field Properties |
| FICOB_AMT_FIE | Field for Assignment of Amount Category |
| FICOB_APPL_T | Texts on Application |
| FICOC_COND | Condition Type |
| FICOC_COND_AMT | Assignment Condition Type - Amount Category |
| FICOB_DATE_FIE | Date Category Assignment - Field |
| FICOB_AMT_T | Texts on Amount Category |