SAP SAP Cash Management Tables
Are you looking for the right table related to SAP SAP Cash Management 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 SAP Cash Management (FIN-FSCM-CLM) module.
Top 10 tables in SAP Cash Management
| Table | Description |
|---|---|
| FCLM_BAM_REVW | Bank Account Review Phase Definition |
| FCLM_BAM2PHHR | SDOK: Use of target anchors in physical objects |
| FCLM_BAMCHKF | Bank Account Attachment: Outgoing hyperlinks from physical o |
| FCLMPHRE | SDOK: Status Table for Indexing Documents |
| BANKACCWD | I_BANKACCOUNTTP I_BANKACCOUNTTP |
| FCLMLOPR | SDOK: Logical information object descriptions |
| BANKACCTEXTWD | I_BANKACCOUNTTP I_BANKACCTEXTTP |
| FCLM_BAM3PHPR | SDOK: Attributes of Physical Information Objects |
| FCLMPHHRPR | SDOK: Attributes of Target Anchor Relationships |
| FCLMCHKO | SDOK: Files of Physical Information Objects |
List of tables in SAP Cash Management
| Table | Description |
|---|---|
| FCLM_BAM_REVW | Bank Account Review Phase Definition |
| FCLM_BAM2PHHR | SDOK: Use of target anchors in physical objects |
| FCLM_BAMCHKF | Bank Account Attachment: Outgoing hyperlinks from physical o |
| FCLMPHRE | SDOK: Status Table for Indexing Documents |
| BANKACCWD | I_BANKACCOUNTTP I_BANKACCOUNTTP |
| FCLMLOPR | SDOK: Logical information object descriptions |
| BANKACCTEXTWD | I_BANKACCOUNTTP I_BANKACCTEXTTP |
| FCLM_BAM3PHPR | SDOK: Attributes of Physical Information Objects |
| FCLMPHHRPR | SDOK: Attributes of Target Anchor Relationships |
| FCLMCHKO | SDOK: Files of Physical Information Objects |
| FCLM_ACCT_NOTE | SDOK: Table for document contents (import/export) |
| FCLMLOIOT | SDOK: Incoming Relationships of Logical Information Objects |
| FCLM_BAMIDXSTA | Bank Account Attachment: Attributes of Outgoing Relationship |
| FCLM_BAM_AC_LINK | Linkages Between House Bank Accounts and Bank Accounts |
| FCLM_BALC_PROF | Balance Calculation Profile |
| FCLM_BAM_CNTL | Control table |
| FCLM_BAM4CHKO | SDOK: Checkout data for physical information object |
| FCLM_BAM3LOREPR | SDOK: Attributes of Outgoing Relationships for LOIOs |
| FCLM_BAM2PHNM | SDOK: Outgoing Links of Physical Information Objects |
| FCLM_BAM3PHHRPR | SDOK: Attributes of Hyperlink Relationships |
| FCLM_BAM3PHRIPR | SDOK: Attributes of Incoming Relationships for PHIOs |
| FCLM_BAM4CHKF | SDOK: File name of last checkout |
| FCLM_BAM2LOIOT | SDOK: Incoming Relationships of Logical Information Objects |
| FCLM_BAM3PHNM | SDOK: Use of target anchors in physical objects |
| FCLM_BAM2PHRE | SDOK: Status Table for Indexing Documents |
| FCLM_BAM_ACSLINK | Linkage between Signatory Card and Bank Account |
| FCLM_BAMPHIO | Bank Account Attachment: Physical information object instanc |
| FCLM_BALC_PLEV | Assign Planning Level to Balance Calculation Profile |
| FCLM_BAMPHNM | Bank Account Attachment: Outgoing Links of Physical Informat |
| FCLMCONDSRV | I_BANKCONDITIONTP I_BANKCONDITIONSRVTP |
| FCLM_BAMPHF | Bank Account Attachment: Physical information object incomin |
| FCLM_BAM4PHF | SDOK: Files of Physical Information Objects |
| FCLM_BAM4PHRE | SDOK: Outgoing Links of Physical Information Objects |
| FCLM_BAM_BNKA_BP | [Obsoleted] Relationship between Bank and Business Partner |
| FCLM_BAM4LOREPR | SDOK: Attributes of Outgoing Relationships for LOIOs |
| FCLM_BAM_BSIMP_T | Bank Statement Import Type Description |
| FCLM_BAM_AMD_LIM | Bank Account Master Data: Overdraft Limit |
| FCLMLORE | SDOK: Attributes of Outgoing Relationships for LOIOs |
| FCLM_BAM2PHHRPR | SDOK: Attributes of Target Anchor Relationships |
| FCLM_BAM2PHIO | SDOK: Physical information object instances |
| FCLM_BAMPHNMPR | Bank Account Attachment: Attributes of Physical Information |
| FCLM_BAMLORIPR | Bank Account Management: Logical information object attribut |
| FCLM_BAM2LOPR | SDOK: Logical information object descriptions |
| FCLM_BAM_ATTACH | SDOK: Table for document contents (import/export) |
| FCLM_BAM_AC_TYPT | Bank Account Type Text |
| FCLMLOREPR | SDOK: Attributes of Incoming Relationships for LOIOs |
| FCLM_BAM4LORIPR | SDOK: Attributes of Incoming Relationships for LOIOs |
| FCLM_BAM4PHRIPR | SDOK: Attributes of Incoming Relationships for PHIOs |
| FCLM_BAMCHKO | Bank Account Attachment: Files of Physical Information Objec |
| FCLMPHREPR | SDOK: Attributes of Incoming Relationships for PHIOs |
| FCLM_BAM_AMD | Bank Account Master Data |
| FCLM_BAM2LORE | SDOK: Attributes of Outgoing Relationships for LOIOs |
| FCLM_BAMPHPR | Bank Account Attachment: Checkout data for physical informat |
| FCLM_BAM3PHF | SDOK: Files of Physical Information Objects |
| FCLMCONDITEM | I_BANKCONDITIONTP I_BANKCONDITIONITEMTP |
| FCLM_BAM4IDXSTA | SDOK: Status Table for Indexing Documents |
| FCLM_BAM3LOPR | SDOK: Logical information object attribute values |
| FCLM_BAM4LORI | SDOK: Incoming Relationships of Logical Information Objects |
| FCLM_BAM_AMD_CUR | Obsolete: Supported Currencies of Account |
| FCLM_BAM2PHNMPR | SDOK: Attributes of Physical Information Objects |
| FCLM_BAM3LORIPR | SDOK: Attributes of Incoming Relationships for LOIOs |
| FCLM_BALC_PRFT | Balance Calculation Profile Description |
| FCLM_BAM2PHRIPR | SDOK: Attributes of Hyperlink Relationships |
| FCLM_BAM4PHNM | SDOK: Use of target anchors in physical objects |
| BANKACCSIGWD | I_BANKACCOUNTTP I_BANKACCSIGNATURETP |
| FCLM_BAM3LORI | SDOK: Incoming Relationships of Logical Information Objects |
| FCLM_BAM_CONFIG1 | configuration table: relation between target system and RFC |
| FCLM_BAMLOIOT | Bank Account Management: Incoming Relationships of Logical I |
| FCLM_BAM_AMD_T | Bank Account Master Data: Text table of Account Description |
| FCLM_BAM3LORE | SDOK: Outgoing Relationships of Logical Information Objects |
| FCLMPHHR | SDOK: Use of target anchors in physical objects |
| FCLM_BAM4PHHRPR | SDOK: Attributes of Hyperlink Relationships |
| FCLM_BAM3LOIOT | SDOK: Logical information object descriptions |
| FCLM_BAM4PHREPR | SDOK: Attributes of Outgoing Relationships for PHIOs |
| FCLM_BAM2CHKF | SDOK: Outgoing hyperlinks from physical objects |
| FCLM_BAM_AMD_SIG | Obsolete: Bank Account Master Data: Signatory |
| FCLM_BAM3PHHR | SDOK: Outgoing hyperlinks from physical objects |
| FCLM_BAM4LOPR | SDOK: Logical information object attribute values |
| FCLM_BAM_BAREVWP | [Obseleted] Bank Account Review Phase Definition |
| FCLM_BAM4LORE | SDOK: Outgoing Relationships of Logical Information Objects |
| FCLM_BAM2LORIPR | SDOK: Logical information object attribute values |
| FCLM_BAM2PHF | SDOK: Physical information object incoming relationships |
| FCLM_BAM2LOIO | SDOK: Logical information object instances |
| FCLM_BAM3PHNMPR | SDOK: Attributes of Target Anchor Relationships |
| FCLM_BAM2PHRI | SDOK: File name of last checkout |
| FCLMPHNMPR | SDOK: Attributes of Physical Information Objects |
| FCLM_BAM2IDXSTA | SDOK: Attributes of Outgoing Relationships for PHIOs |
| FCLM_BAM_AC_APRJ | Account Automatic Approval or Rejection |
| FCLM_BAMPHHRPR | Bank Account Attachment: Attributes of Target Anchor Relatio |
| FCLM_BAM4PHRI | SDOK: Physical information object incoming relationships |
| FCLM_BAMLORI | Bank Account Management: Outgoing Relationships of Logical I |
| FCLM_BAM3PHREPR | SDOK: Attributes of Outgoing Relationships for PHIOs |
| FCLM_BAM3PHRE | SDOK: Outgoing Links of Physical Information Objects |
| FCLM_BAM_AC_TYPE | Bank Account Type |
| FCLM_BAM3CHKF | SDOK: File name of last checkout |
| FCLM_BAM_CONFIG | Configuration for Bank Account Management |
| FCLM_BAM3PHIO | SDOK: Physical information object instances |
| FCLM_BAMPHREPR | Bank Account Attachment: Attributes of Incoming Relationship |
| FCLMCHKF | SDOK: Outgoing hyperlinks from physical objects |
| BANKACCLIMWD | I_BANKACCOUNTTP I_BANKACCLIMITTP |
| FCLMPHRI | SDOK: File name of last checkout |
| FCLM_BAM_BKBPHIS | History for Bank and BP Linkage |
| FCLM_BAMPHRE | Bank Account Attachment: Status Table for Indexing Documents |
| FCLM_BAM2CHKO | SDOK: Files of Physical Information Objects |
| FCLM_BAM_BNKABP2 | Relationship between Bank and Business Partner |
| FCLMLOIO | SDOK: Logical information object instances |
| FCLM_BAM2LORI | SDOK: Outgoing Relationships of Logical Information Objects |
| FCLM_BAM3LOIO | SDOK: Logical information object instances |
| FCLMLORIPR | SDOK: Logical information object attribute values |
| FCLM_BAM2PHPR | SDOK: Checkout data for physical information object |
| FCLMPHIO | SDOK: Physical information object instances |
| FCLM_BAM4PHHR | SDOK: Outgoing hyperlinks from physical objects |
| FCLM_BAM3CHKO | SDOK: Checkout data for physical information object |
| FCLM_ACTIVE_PU | Planning Units in Activated Hierarchy |
| FCLM_BAM4LOIO | SDOK: Logical information object instances |
| FCLM_BAM4PHIO | SDOK: Physical information object instances |
| FCLMCOND | I_BANKCONDITIONTP I_BANKCONDITIONTP |
| FCLM_BAM3IDXSTA | SDOK: Status Table for Indexing Documents |
| FCLMPHPR | SDOK: Checkout data for physical information object |
| FCLMLORI | SDOK: Outgoing Relationships of Logical Information Objects |
| FCLM_BAM2LOREPR | SDOK: Attributes of Incoming Relationships for LOIOs |
| BANKACCAC2WD | I_BANKACCOUNTTP I_BANKACCHOUSEBANKACCTP |
| FCLM_BAM_ACLINK2 | Linkages Between Bank Account and House Bank Accounts |
| FCLM_BAM_BSIMP | Bank Statement Import Type Definition |
| FCLMIDXSTA | SDOK: Attributes of Outgoing Relationships for PHIOs |
| FCLM_BAMPHRIPR | Bank Account Attachment: Attributes of Hyperlink Relationshi |
| FCLM_BAMLOIO | Bank Account Management: Logical information object instance |
| FCLM_BAMLOPR | Bank Account Management: Logical information object descript |
| FCLMPHNM | SDOK: Outgoing Links of Physical Information Objects |
| FCLM_BAM4LOIOT | SDOK: Logical information object descriptions |
| FCLMPHF | SDOK: Physical information object incoming relationships |
| FCLMPHRIPR | SDOK: Attributes of Hyperlink Relationships |
| FCLM_BAMPHHR | Bank Account Attachment: Use of target anchors in physical o |
| FCLM_BAM_ADTFUND | Obsolet: BAM items that exist additionally in target system |
| FCLM_BAMLOREPR | Bank Account Management: Attributes of Incoming Relationship |
| FCLM_BAM4PHNMPR | SDOK: Attributes of Target Anchor Relationships |
| FCLM_BAM3PHRI | SDOK: Physical information object incoming relationships |
| FCLM_BAMPHRI | Bank Account Attachment: File name of last checkout |
| FCLM_BAM4PHPR | SDOK: Attributes of Physical Information Objects |
| FCLM_BM_TIMELINE | Obsolete: Timeline data |
| FCLM_BAM_HBA_IDX | Standard index table |
| FCLM_BAMLORE | Bank Account Management: Attributes of Outgoing Relationship |
| FCLM_BAM2PHREPR | SDOK: Attributes of Incoming Relationships for PHIOs |
| FCLM_BAM_IDX | Standard index table |
| FCLM_CR_FDLEV | Assign Planning Levels to Cash Requests |
| FCLM_HC_CHKP_TXT | Health Check Point Description |
| FCLM_LQH_HIER | Liquidity Item Hierarchy Relationship |
| FCLM_CRL | Line item table for cash reconciliation |
| FCLM_HC_PFCP_MAP | Mapping: Profile -> Check Point |
| FCLM_FB_PACKAGE | Packages for Flow Builder |
| FCLM_CPL_FLOW | Run flows for cash pooling |
| FCLM_LQF_DERPARA | Liquidity Item Derivation Parameters |
| FCLM_CPL | Cash Pool |
| FCLM_CPL_FLOW_IT | Line item for cash pooling |
| FCLM_LP_ORG_UNIT | Planning Unit Settings |
| FCLM_FB_CHN_STP | Flow Builder Chain Step |
| FCLM_LQH_TEXT | Liquidity Item Hierarchy Text |
| FCLM_VP_CDS_MAP | Field Mapping |
| FCLM_FB_LOG | Log Table of Flow Builder |
| FCLM_PARA_TAB | Table Parameters for HANA |
| FCLM_NOTE | SDOK: Table for document contents (import/export) |
| FCLM_CONFIG2 | General Settings for Cash Management |
| FCLM_LP_SUGG_TXT | Text for suggestion source |
| FCLM_LP_CON_IN | Configuration of the input for liquidity item |
| FCLM_BAM_HIERBGN | Bank - bank group name mapping |
| FCLM_LQH_ATTR | Liquidity Item Hierarchy Attributes (Header) |
| FCLM_BAM_SIGCART | Signatory Card Text |
| FCLM_CPL_TXT | Cash Pool Description |
| FCLM_TGT | Name of Tolerances Groups for cash reconciliation |
| FCLM_BAM_FPROP | UI Fields Property |
| FCLM_BAM_SIG | Payment Approver |
| T012K_HKTID_TDC | Preset UI for House Bank Account |
| FCLM_BAM_HIERT | Text table of Bank Account Hierarchy |
| FCLM_BAM_MIGCONF | House Bank Account Migration |
| FCLM_LP_PT_TXT | Plan Type Text |
| FCLM_BAM_C_REQFD | Sensitive fields definition which will trigger workflow |
| FCLM_BAM_REQLOG | Change request log for bank account master data |
| FCLM_BAM_FGRP_T | Text table for field status group |
| FCLM_BAM_CONFIG4 | configuration table: define filters for sync objects |
| FCLM_BAM_FGRP | Field Status Group Definition |
| IMEMORECORDT | I_MEMORECORDTP I_MEMORECORDTP |
| FCLM_BAM_REVWLOG | Bank Account: Review Log |
| FCLM_BAM_CPOOL | Cash Pool Definition |
| FCLM_BAM_REQ | Change request for bank account master Data |
| FCLM_CRH | Head table for cash reconciliation |
| FCLM_HC_CHKP | Health Check Point |
| FCLM_SYNC_RECORD | Obsolete: store bam's synchronization system and status |
| FCLM_FCV_LQITEM | Mapping G/L Accounts to Lqdy Items for Frgn Crcy Valn |
| FCLM_CMR | memo record |
| FCLM_FB_FOREST | Flow Builder Forest: Runtime Info |
| FCLM_BAM_SIGGRPT | Text table for signatory group |
| FCLM_BRM_BSB | Total of Bank Service Billing Statement |
| FCLM_BAM_SIGCARD | Signatory Cards |
| FCLM_BAM_REVIWER | [Obsoleted]Bank Account: Reviwer for review request |
| FCLM_LQF_IND_ASG | Indicator Assignment for Flow Level |
| FCLM_BAM_FGRPD_W | Field Group Assignment - WF |
| FCLM_BRM_CONDT | Texts for Bank Conditon |
| FCLM_FB_CLR_FRST | Flow Builder Forest: Runtime Info |
| FCLM_BRM_RULE_T | Description for Rules of Periodic Appointments |
| FCLM_BRM_GENAPPT | Generated appointments |
| FCLM_BAM_HIERDT | Hierarchy Node in Design Time |
| FCLM_R001_SUB | Reporting configuration |
| FCLM_BRM_SRV_MAP | Bank Fee Service Mapping |
| FCLM_BRM_RU_ASGN | Rule Assignment to Bank |
| ICPLMGMTDFT | I_CASHPOOLMGMTTP I_CASHPOOLMGMTTP |
| FCLM_BAM_REQACNT | Change Request:Bank Accounts |
| FCLM_LP_EX_BAL | Liquidity Items used as Balance |
| FCLM_BAM_SIGPTN1 | Singatory Pattern Definition I: General Case |
| FCLM_MAP | Field mapping from BSEG to target flow table |
| FCLM_LP_ACTIVE | Active Settings |
| ICCFISUBDRAFT | I_CASHFLOWITEMTP I_CASHFLOWSUBITEMTP |
| FCLM_BAM_WFMODE | Define Group Mode of Signatory Mass Change Requests |
| FCLM_LP_RD_LQ | Read-Only Liquidity Items |
| FCLM_CUR_CON_RU | Currency Conversion Rule |
| FCLM_BRM_NOTE | SDOK: Table for document contents (import/export) |
| FCLM_BAM_REQACTD | Documents for Bank Account |
| FCLM_BKACNT_ADDT | [Obseleted]The additional found bank accounts |
| FCLM_BAM_REQFLD | Sensitive fields definition which will trigger workflow |
| FCLM_BRM_BSB_DOC | Bank Service Billing File |
| FCLM_R001 | Reporting Configuration Check Table |
| FCLM_BAM_SIGGRP | Signatory Group Definition |
| FCLM_MR_MIGR | Backup of memo record migration |
| FCLM_BAM_HIERRT | Hierarchy Node in Run Time |
| FCLM_BAM_CONFIG2 | configuration table: define filters for sync objects |
| FCLM_BAM_HIER | Bank Account Hierarchy |
| FCLM_MAP_CLS | Class used to Load BSEG to target flow table |
| FCLM_MAP_CLS2 | Classes used to load BSEG to target flow table, Client Dep |
| FCLM_CONFIG | Configuration for Core Cash/Full Cash Determination |
| FCLM_BAM_HIERDTT | Text table for FCLM_BAM_HIERDT |
| FCLM_LP_ORG_CUR | Planning Currencies of Planning Unit |
| ICSHCONCNBKACCTT | I_CSHCONCNTP I_CSHCONCNBKACCTTP |
| FCLM_BAM_SIGPTN2 | Singatory Pattern Definition II: Special Case (Obsolete) |
| FCLM_BAM_SYC_JOB | job information for synchronizing bank and bank accounts |
| FCLM_BAM_SIGPTND | Signatory Pattern Determination |
| FCLM_BRM_BSB_MAP | [Obsolete] Mapping table for BSB XML path and database field |
| FCLM_BAM_FGRPD | Field Group Assignment - BAM |
| FCLM_R001T | Reporting Name Text Table |
| ICSHCONCNSDT | I_CSHCONCNTP I_CSHCONCNSIMLNDETTP |
| FCLM_BRM_PRC_STS | [Obsolete] Service Pricing Status |
| FCLM_BAM_SPRULE | Field Status Special Rule Definition |
| FCLM_BPC_CONFIG | BPC related configuration |
| FCLM_MM_DELTA | Delta table for MM |
| FCLM_MR | Memo record items |
| FCLM_LP_PT_KEY | Plan Type |
| FCLM_BAM_REV | Bank Account Master Data Revsion information |
| FCLM_BRM_ASSCHRG | Assign Charge Type |
| FCLM_BRM_COND | Bank Condition |
| FCLM_BSEG_DELTA | BSEG Queue for Cash |
| FCLM_BRM_COND_I | Bank Condition Item |
| FCLM_BRM_CONDSRV | [Obsolete] Bank Service and Condition Mapping Table |
| T012_HBKID_TDC | Pre-Activation UI for House Bank |
| ICSHCONCNT | I_CSHCONCNTP I_CSHCONCNTP |
| FCLM_TG | Tolerances Groups for cash reconciliation |
| FCLM_R001_SUBT | Text table for reporting configuration |
| FCLM_BAM_HIERVC | Visibility Control |
| FCLM_BRM_CHRGTYP | Bank Fee - Charge Type |
| FCLM_BNKA_BP_FS | Relationship between Bank and Defaultable Business Partner |
| FCLM_LP_SUGG_SRC | Suggestion Source |
| FCLM_BAM_CONFIG3 | configuration table : exclude sync fields |
| FCLM_BRM_CHRGTYT | Bank Fee - Charge Type Text |
| FCLM_EODMR_PL | Define Planning Level for End of Day Memo Record |
| FCLM_BAM_CPOOL_T | Cash Pool Description |
| FCLM_BAM_SPRULED | Field Status Special Rule |
| FCLM_HC_PROF_TXT | Health Check Profile Description |
| FCLM_BAM_SPRULET | Text table for Special Rule Definition |
| FCLM_HC_PROF | Health Check Profile |
| FCLM_SD_DELTA | Queue table for SD |
| FCLM_BAM_SPRULEA | Field Status Special Rule Assignment |
| FCLM_EODMR_SI | Define Statistics Indicator for End of Day Memo Record |
| FCLM_BRM_RULE | Rules of Periodic Appointments |
| FCLM_BANK_EXTRA | [Obseleted]additional bank and bank accounts found in other |
| FCLM_BAM_SV | Selection Variant |
| ICCFITPDRAFT | I_CASHFLOWITEMTP I_CASHFLOWITEMTP |