SAP Bank Customer Accounts Tables
Are you looking for the right table related to SAP Bank Customer Accounts 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 Bank Customer Accounts (IS-B-BCA) module.
Top 10 tables in Bank Customer Accounts
| Table | Description |
|---|---|
| BKK_PAR_INTERVAL | Assigned Intervals |
| TRTP_US_GEN | General data for a retirement plan |
| TBKK_PAR_MAXNUM | Number of Maximum Possible Numbers per Application |
| BCA_US_DEA_HIST | Correspondence History |
| TBKKTIME | Time Units |
| TBKKCRBD | Switch On RBD-IVA solution |
| TBKK11 | BCA Lists: Field Catalog for List Tool (KKBLO_FIELDCAT) |
| BCA_US_BKK44A | Current account master data: Amount-dependent blocks |
| BKKARCPERIOD | Archived Periods |
| TRTP_US_CONTT | Contribution codes for a retirement plan |
List of tables in Bank Customer Accounts
| Table | Description |
|---|---|
| BKK_PAR_INTERVAL | Assigned Intervals |
| TRTP_US_GEN | General data for a retirement plan |
| TBKK_PAR_MAXNUM | Number of Maximum Possible Numbers per Application |
| BCA_US_DEA_HIST | Correspondence History |
| TBKKTIME | Time Units |
| TBKKCRBD | Switch On RBD-IVA solution |
| TBKK11 | BCA Lists: Field Catalog for List Tool (KKBLO_FIELDCAT) |
| BCA_US_BKK44A | Current account master data: Amount-dependent blocks |
| BKKARCPERIOD | Archived Periods |
| TRTP_US_CONTT | Contribution codes for a retirement plan |
| TRTP_US_TRANS | Witholding transaction type information |
| TRTP_US_DFLT | Default values for screen input fields |
| TRTP_US_JLIFE | Joint life expectancy |
| BKKBENCH | Benchmark Results |
| TRTP_US_LIM_ID | Contribution limits for a retirement plan |
| BKKARCPERIODFILE | Archived Periods per Archive File |
| TRTP_US_DIST_PER | Distribution period (For Use by Owners) |
| TBKKOBJECTT | Texts on Objects in BCA |
| BCA_US_BC_ADDR | Addresses Associated with Bank Cheques |
| TBKK14 | Time Unit for BCA Archiving |
| TBKK_PRNTE_TYP_T | Prenote Type Description |
| TBKK01T | Texts for Bank Areas |
| BKKSONT | Payment Notes of Standing Orders |
| TBKK_REP_OBJMTHT | Texts Object Methods Authorizations Periodic Tasks |
| BKK_PRENOTE | Prenotes |
| TBKKCORR | BCA: Table showing if Correspondence is Active |
| TBKK_CLS_BAL | Settings for accnt. balancing date during accnt. closure |
| RTP_US_ACC | Linking table between a retirement plan and an account |
| BCA_PO_CHEQ_REL | Payment order and Cheque relationship for Banking |
| TBKKOBJMETH | Objects - Methods Assignment |
| TRTP_US_FSTAT | Field status for screen fields |
| TBKKBENCH | Global Settings for BCA Benchmark |
| TBKK_PRNTE_TOLR | Prenote Tolerance Range |
| BKK45_CORR | Correspondence Receiver Administration |
| TBKK02 | Check Digit Calculation Method Categories |
| TBKKTIMET | Description for Time Units |
| BKKBENCHACBAL | Benchmark Results Account Balancing |
| TBKK03 | Check Digit Calculation Methods |
| TRTP_US_SLIFE | Single life expectancy |
| TBKKAUTGRP | Authorization Groups |
| BKK45_DISP_MAP | Map Format and Dispatch Type to Dispatch Control |
| TBKK_REASON_T | Text table for account closure/reactivation reason |
| BCAREVPO_BS | Payment Items and Add. Payment Orders fm Curr. Convers. (AS) |
| BCA_US_OD_PLAN | Account master data: Overdraft plan |
| TRTP_US_PLANTYPE | Type of retirement plan |
| TRTP_US_PLANTYPT | Type of retirement plan |
| TRTP_US_CONT | Contribution codes for a retirement plan |
| TBKK_REP_OBJMTH | Object Methods for Authorizations Periodic Tasks |
| TBKK03A | Parameters for Modulo Methods of Check Digit Calculation |
| BKKSO_VAR_AMNT | Standing Order: Variable Amounts |
| BCA_US_COMP | BCA US specific settings |
| TRTP_US_CONT_TYP | Contribution limits for a retirement plan type |
| BKKSO_PAORN | BCA: Payment Orders of a Standing Order |
| BKK02 | Key Date for Archiving |
| TBKK_JUMP | Fields for Jump (Supported in BKK_JUMP) |
| TBKKAUTGRPOBJ | Authorization Group Objects |
| TRTP_US_D_REL | IRS Distribution codes |
| BCAREVPO | Original PO and additional POs from currency swap |
| BKKTERMPPRC | Term Agreements in Postprocessing Status |
| TRTP_US_PLAN_INF | Plan information for a type of retirement plan |
| TBKK_PRNTE_TYP | Prenote Type |
| TBKK_SCRN_FLDS_T | Text able for screen fields of BCA |
| BCA_US_BKK_TD | BCA: Time deposit account data |
| TBKK_SCR_FLD_LIS | Table for screen field names |
| BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments |
| TRTP_US_BP_ED | Special business partner roles for an ESA |
| BKK_RATE | Master Data for Installment Savings |
| BCA_US_MEM_ITEMS | Memo item table |
| BKKSO | BCA: Standing Orders |
| TBKK02T | Texts for Check Digit Calculation Method Categories |
| TBKK_REA_CLASS_T | Text table for the reason class |
| BKKARCHDATEBUF | Temporary Database Buffer for Admin. of Archived Periods |
| BCA_US_DEA_ESCH | Escheat Accounts Data |
| TBKKAUTGRPOBJT | Authorization Group Objects: Texts |
| TBKK_REA_CLASS | Reason class |
| BKKINDX | BCA: Cluster Table |
| BKK58 | Master Data Savings Prod: Fxd-Term Deposit, Installmnt Savgs |
| TRTP_US_AGE_LIM | Age limits for contributions made to a retirement plan |
| TBKK_PRENOTE_RES | Maintain Residence Time for BKKPRENOTE Archiving |
| BKKTERM | Term Agreement for Fixed-Term Deposit and Installmt Savings |
| TRTP_US_AMNTID | Amount identifier |
| BKKBENCHBKSTAT | Benchmark Results Bank Statement |
| BKKCORRACCNT | Auxiliary Table: Accounts for Adjustments |
| BKKSO_PACK | Saving Packages for Standing Order Posting |
| TBKK_REASON | Reasons for account closure/reactivation |
| TBKK_CLS_OBJ_TMN | Settings for accnt. dependant objects during account closure |
| BCA_US_BUT000 | US Specific Enhancements to BP |
| BKKARCHDATEF | Archived Periods per Archiving Run |
| TRTP_US_AM_CAT | Posting categories and Amount ID's assignment |
| BCA_US_OD_TRANS | Transaction details for Overdraft protection |
| TBKKOBJECT | Objects in BCA |
| BKK_PRNTE_REFENQ | Prenote Refernce Id Enqueue |
| BCA_US_OD_REL | Accounts - US specific overdraft relation details |
| TBKK14T | Text Table for Time Unit BCA Archiving |
| BKKARCHDATE | To Date of Archiving |
| BKK01D | Bank area: Posting Date Payment Transactions/Balancing |
| RTP_US_BP_PLAN | Business partners associated with a retirement plan |
| TBCA_US_CAL_INDT | Description for Calculation indicators |
| TBKKTRMMINDEP | Minimum Deposit for Each Term |
| TBKK01A | Additional Bank Keys for Bank Area |
| RTP_US_RMD | Required minimum distribution |
| TRTP_US_DISTT | IRS Distribution codes |
| TBCA_US_DEA_DEDT | Deduction Codes Text Description |
| TBCA_US_CAL_IND | Cust. table for maintaining Calculation indicators |
| RTP_US_TOT | Total amounts for a retirement plan |
| TBCA_US_DEA_DELT | Escheat Property Deletion Codes Description |
| TBCA_US_DEA_COR | Dormancy Correspondence Codes |
| TRTP_US_LIM_IDT | Description for contribution limit code of a retirement plan |
| TBKK06 | Country-Specific Function Modules for BBAN Assignment |
| TBKKMETHOD | Methods in BCA |
| TFIPR_SETTCOMB | Feature Combination |
| TRTP_US_CONT_LIM | Contribution limits for a retirement plan |
| TBKK01 | Bank Area Table |
| TBCA_BESTKONT | Bal. Sheet Accts for Currency Swap |
| TBCA_US_DEA_PROT | Property Type Codes Text Description |
| TBCA_US_DEA_DED | Cross Reference Escheat Deduction Codes |
| RTP_US_PLAN | Retirement plan data (US enhancement) |
| TBCA_OD_METHODT | Description for overdraft protection methods |
| TBKK_REPENQ | Lock Table for Double Processing of Reports in BCA |
| TBCACHCKDIGPROCT | Text Table for Check Digit Calculation Procedure |
| TBCA_US_H_TYPET | Texts For Hold Types |
| TBKKSOAUTH | Amount Authorization/Dual Control Standing Order |
| TBCA_US_TRAN_SEQ | Overdraft transaction priority sequence for Products |
| TBKK12 | Archiving Period (Obsolete) |
| TBKK01B | Assign Business Partner To Bank Key |
| TBCA_US_BCSTACKS | Configuration of Stacks used for Bank Checks |
| TBKK_PAR_WPTYP | Method for Assigning the Numbers |
| TBCA_US_DEA_ADD | Property Addition Codes |
| TBKKTRACE | Extended Output for Error Analysis? |
| TBKK_PAR_MODE | Method for Assigning the Numbers |
| RTP_US_BEN | Beneficiary table for a retirement plan |
| TBCACHCKDIGPROC | Check Digit Calculation Procedure |
| TRTP_US_DIST_S | IRS Distribution codes |
| TRTP_US_AMNTIDT | Amount identifier |
| TBCA_US_R_HOLD | Refrence adjustment types that can be created |
| TBCA_US_BC_TCODE | Transaction Type: Bank Checks |
| TBCA_US_PAY_AMT | Overdraft transaction sequence for Products |
| TBKKARCHEVENTS | Events in Archiving |
| TRTP_US_CONT_DAT | Contribution dates for a retirement plan |
| TBKKNUMRG | Number of Number Ranges per Bank Area |
| TBKK_SCRN_FLDS | Customizable Screen fields of BCA |
| TBKK_EMP_OBJMTH | Object Methods Checked for Authorization Employee Accounts |
| TBKKARCPERIOD | Archiving Periods |
| TBKK10 | BCA Lists |
| TBCA_US_DEA_CORT | Dormancy Correspondence Codes Description |
| TBCA_IHCCC | Currency swap for IHC |
| TBCA_US_DEA_DEL | Escheat Property Deletion Codes |
| TBKK01_CC | Bank Area: Currency Changeover |
| TBKK_EMP_OBJMTHT | Texts Object Methods Auth. Employee Accounts |
| TBCA_US_R_HOLDT | Text table for reference table |
| TBCATDAUTH | Time Deposit: Interest Dependent Authority |
| TBKK030 | Check Digit Calculation Methods |
| TBKK13T | Text Table for Tables/Table Groups |
| TBCA_US_DEA1 | Maintain Escheat Attributes |
| TBCA_US_DEA_REL | Cross Reference Escheat Relationship Codes |
| TBKKAUTGRPT | Authorization Groups: Texts |
| TBKK10T | BCA Lists: Texts |
| RTP_US_HIST | Retirement plan history and audit table |
| TBKKMETHODT | Texts on Methods in BCA |
| TBCA_US_DEA_PRO | Cross Reference Escheat Property Codes |
| TBKK13 | Tables/Table Groups That Can Be Archived |
| TBCA_IHCAK | Determine rate type for currency swap |
| TBCA_US_DEA_REF | Escheat Account Closure Reference Data |
| TBCA_OD_METHOD | Method of Overdraft protection transfer |
| TBKK00 | Cross-Bank Area Settings |
| TBCA_US_DEA_RELT | Relationship Codes Text Description |
| TBCA_US_DEA_ADDT | Escheat Property Addition Codes Description |
| TBKK00T | Settings Independent of Bank Area, Dependent on Language |