SAP FSCM In-House Cash Tables
Are you looking for the right table related to SAP FSCM In-House Cash 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 FSCM In-House Cash (FIN-FSCM-IHC) module.
Top 10 tables in FSCM In-House Cash
| Table | Description |
|---|---|
| BKKPOREFA | References for EDI Payments, Position, Amount Segment |
| IHC_DB_PN_ENQ | Lock Table for Payment Order |
| IHC_TAB_AUTH_MAP | IHC: Assign Internal to External Actions, Re. Authorizations |
| IHC_DB_CMVAR | Cash Management Variants |
| IHC_TAB_GUI_ST | IHC: Status in Interface |
| IHC_TAB_LOG_CTX | IHC: Contexts in Log |
| IHC_TAB_WORKLIST | IHC: Saved Worklists |
| IHC_TAB_LOG_FLD | IHC: Field Selection for Contexts in Log |
| IHC_TAB_STAT_MAP | IHC: Mapping Between External and Internal Status |
| IHC_TAB_LOG_REFT | IHC: Reference Types in Log, Text Table |
List of tables in FSCM In-House Cash
| Table | Description |
|---|---|
| BKKPOREFA | References for EDI Payments, Position, Amount Segment |
| IHC_DB_PN_ENQ | Lock Table for Payment Order |
| IHC_TAB_AUTH_MAP | IHC: Assign Internal to External Actions, Re. Authorizations |
| IHC_DB_CMVAR | Cash Management Variants |
| IHC_TAB_GUI_ST | IHC: Status in Interface |
| IHC_TAB_LOG_CTX | IHC: Contexts in Log |
| IHC_TAB_WORKLIST | IHC: Saved Worklists |
| IHC_TAB_LOG_FLD | IHC: Field Selection for Contexts in Log |
| IHC_TAB_STAT_MAP | IHC: Mapping Between External and Internal Status |
| IHC_TAB_LOG_REFT | IHC: Reference Types in Log, Text Table |
| IHC_DB_INB_PARMS | Clearing Partner for PEXR2002 |
| IHC_DB_ORG | IHC AMS Organizational Units |
| IHC_TAB_AUTH_GRP | IHC:Authorization Groups for Amount-Dependent Authorizations |
| BKKPOGISA | EDI Payments: Reporting Data to Clearing, Segm. E1IDMU5 |
| IHC_TAB_PN_CONT | IHC: Container Fields in Payment Order |
| IHC_TAB_GUI_MAP | IHC: Mapping Table for GUI |
| IHC_TAB_GUI_ACTT | IHC: GUI Actions - Description |
| IHC_DB_CMGRP | Cash Management Groups |
| IHC_DB_CL_PRTNR | IHC: Clearing Partner |
| IHC_DB_QUEUES | Queue Management for Parallel Processing |
| IHC_DB_ROUTE | IHC: Assignment of Route to a Clearing Unit |
| IHC_TAB_DUCTR_BP | TO BE DELETED --- IHC: Principle of Dual Control |
| IHC_DB_PN_RINFO | Reference/Note to Payee Information |
| IHC_DB_BCA_EXTPO | Process Parameter External BCA Payment Orders |
| NIHC_DB_RINST | Routing Instructions |
| TBCA_ROUTE | Routing Definitions |
| TBKKIHB5 | Payt Method Determination HQ FI for Payment In-House Bank |
| IHC_DB_CMVAR_T | Text Table for Cash Management Variants |
| TBKKIHB7 | Assignment BTC <-> Posting Category IHC |
| IHC_TAB_ARCH_IDX | IHC: Archive Index Table |
| IHC_DB_CMGRP1 | Cash Management Group: Account Assignment |
| IHC_TAB_LOG_LYR | IHC: Assignment of Contexts to Layers |
| IHC_DB_CMVAR1 | Cash Management Variants: Bank Area Assignment |
| IHC_DB_DSP_TRAPO | Table Structure for displaying the Posted Item Detail |
| IHC_DB_CMGRP2 | Cash Management Group: Account Assignment |
| IHC_TAB_LOG_STR | IHC: Generated Structures for Contexts in Log |
| IHC_TAB_INST | IHC: Instruction Codes |
| IHC_TAB_INST_KEY | IHC: Instruction Key Definitions |
| NIHC_DB_PO_RINF | Reference/Note to Payee Information |
| IHC_DB_CL_XBS | IHC Bank Statement: Determine Sender or Clearing Partner |
| IHC_DB_CMSTATUS | Cash Management: Status of Individual Items |
| IHC_DB_INB_TARGT | Clearing Partner for PEXR2002 |
| IHC_DB_ROUTE_T | IHC: Text Table for Route |
| IHC_TAB_SELECT | IHC: Selections in Selection Variants |
| FINSTA_POS | Table for FINSTA Items (Used, e.g.,in CREATE_FINSTA) |
| IHC_TAB_GUI_FLD | IHC: Container Field in GUI |
| IHC_TAB_GUI_FS | IHC: Selectable Fields for Custom Selection |
| IHC_TAB_APM_TT | Automatic Payments: Determine IHC Transaction Type |
| IHC_DB_PN_BP | IHC: Address Data of Bus. Partners Involved in Payment Order |
| IHC_DB_INB_ACCTS | Clearing Partner Details for PEXR2002 |
| IHC_DB_ENQ_PN | Lock Table for Payment Order |
| IHC_TAB_VARIANT | IHC: Selection Variant |
| BKKPOGISP | EDI Payments: Reporting Data to Clearing, Segm. E1EDLA1 |
| IHC_DB_RT_TREEEN | IHC: Block Table for Route Tree |
| IHC_DB_CL_RATES | Currency Type for Foreign Currency Settlement |
| IHC_DB_PN_STATUS | IHC: Payment Order Status |
| IHC_DB_CL_TYPES | Technical Settings for AMS Update |
| NIHC_DB_PO_STAT | Status of Payment Order |
| IHC_TAB_GUI_STAC | IHC: Change Actions in External Status |
| IHC_TAB_LOG_REF | IHC: References in Log |
| IHC_DB_CMGRP_T | Text Table for Cash Management Groups |
| IHC_TAB_INSTKEYT | IHC: Text table for Instruction Key |
| TBKKIHB6 | Dispatcher per Account Number |
| IHC_TAB_PORT_MAP | IHC: Mapping Between Logical Systems and Logical Ports |
| IHC_DB_CL_AMS | IHC: Clearing Unit Data |
| IHC_DB_CL_ACCTS | Account Determination for AMS Update |
| IHC_TAB_TRANST | IHC: Transaction Type Names |
| IHC_TAB_TRN_ATTR | IHC: Processing of Transaction Types in Bank Area |
| IHC_TAB_XBS_TT | IHC: Transaction Type External Inbound Payment |
| BKKPOGISH | EDI Payments: Reporting Data to Clearing, Segm E1IDKU6 |
| IHC_DB_RT_TREE | IHC: Routing Tree |
| IHC_TAB_GUI_CTRL | IHC: Field Control in GUI |
| IHC_TAB_GUI_ACT | IHC: Interface Actions |
| BKKPOREFD | References to EDI Payments, Item, Date Segment |
| BKKPOREFR | References for EDI Payments, Position, Ref. Data Segment |
| IHC_DB_NEW_TRAPO | IHC: Customizing-Table for Posting Detail Report |
| IHC_TAB_TRANS | IHC: Transaction Types |
| IHC_DB_TRAPO | IHC: Customizing Table for Transfer Posting Report |
| IHC_DB_CL_PRTNRT | IHC: Text Table for Clearing Partner |
| IHC_DB_TOVR_ENQ | Provisional Turnover (Based on Value Date, aft.Posting Date) |
| IHC_DB_CL_IDOC | IHC: Communication Data for Clearing Unit |
| BKKPOGISL | EDI Payments: Reporting Data to Clearing, Seg. E1IDT02 |
| IHC_DB_TOVR | Provisional Turnover (Based on Value Date, aft.Posting Date) |
| IHC_DB_RT_NODE | IHC: Routing Node |
| IHC_TAB_DUAL_CTR | IHC: Principle of Dual Control |
| IHC_DB_INB_PRN | Clearing Partner for PEXR2002 |
| TBCA_ROUTEDET | Route Determination |
| IHC_TAB_GUI_TRNS | IHC: Transaction Type - Default Setting for Transactions |
| IHC_DB_PAY_MAPP | IHC: Clearing Agreement |
| BKKPOREFN | References for EDI Payments, Header Data, Doc.Number Segment |
| NIHC_DB_PO_PNTA | Source Document for Incoming Payment Orders |
| IHC_TAB_INST_TXT | IHC: Text Table for Instructions |
| IHC_DB_PN | Source Document for Incoming Payment Orders |
| IHC_TAB_GUI_WL | IHC: Setting for Browser Worklist |
| TBKKIHB4 | FI Data for Manual Outgoing Payments In-House Bank |
| TBCA_IHC_BKKRS | Bank Area as In-House Cash Center |
| TBKKIHB1 | In-House Bank ID from Payment Notes in Bank Statement |
| BKKPOREFL | References for EDI Payments, Header data, Long Texts |