The BKK97 table in SAP ERP or S/4HANA stores Acct Balancing: Posting Data (Temporary Data)(for Deletion) data. There are total 27 fields in BKK97 table. The Acct Balancing: Posting Data (Temporary Data)(for Deletion) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BKK97 table. It is in Bank Customer Accounts: Conditions (FKBC) ABAP package and is part of the Condition (IS-B-BCA-MD-CD) module.
SAP BKK97 Table Fields
Following is the list of fields that are available in SAP BKK97 table. The primary key fields of the table are MANDT (Client), BKKRS (Bank Area), ACNUM_INT (Internal Account Number for Current Account), CLOS_TYP (Function), CLOS_YEAR (Year of the closing period), CLOS_NR (Number of Balancing Period), CLOS_NRADD (Addition to Balancing Period Number), POSTCATG_I (Posting Category for Balancing Postings), POSTCATADD (Consecutive Number per Posting Type).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| BKKRS | Bank Area | BKK_BKKRS | CHAR (4) | |
| ACNUM_INT | Internal Account Number for Current Account | BKK_ACCNT | CHAR (10) | |
| CLOS_TYP | Function | BKK_CLSTYP | CHAR (4) | |
| CLOS_YEAR | Year of the closing period | BKK_CLYEAR | NUMC (4) | |
| CLOS_NR | Number of Balancing Period | BKK_CLNR | NUMC (3) | |
| CLOS_NRADD | Addition to Balancing Period Number | BKK_CLNRAD | NUMC (3) | |
| POSTCATG_I | Posting Category for Balancing Postings | BKK_POSTCG | CHAR (2) | |
| POSTCATADD | Consecutive Number per Posting Type | BKK_POADD | NUMC (3) | |
| BANKS | Bank country key | BANKS | CHAR (3) | |
| BANKL | Bank Keys | BANKK | CHAR (15) | |
| ACNUM_EXT | Account number for current account | BKK_ACEXT | CHAR (35) | |
| DATE_VALUE | Value date | BKK_VALDAT | DATS (8) | |
| DATE_POST | Posting date | BKK_PSTDAT | DATS (8) | |
| WAERS | Account Currency | BKK_ACUR | CUKY (5) | |
| AMOUNT | Amount in Account Currency | BKK_AAMNT | CURR (17) | |
| LCUR | Local Currency | BKK_LCUR | CUKY (5) | |
| L_AMOUNT | Amount in Local Currency | BKK_LAMNT | CURR (17) | |
| NCUR | Reporting Account Currency | BKK_NACUR | CUKY (5) | |
| N_AMOUNT | Amount in Information Account Currency | BKK_NAAMNT | CURR (17) | |
| PAYM_NOTE | Purpose | BKK_PAYNTE | CHAR (70) | |
| STATTODEL | Status for Acct. Closure | BKK_DELST | NUMC (1) | |
| REFACCT | Reference Account: Internal Control | BKK_REFACCT | NUMC (1) | |
| TRNSTYPE | Transaction Type | BKK_TTYPE | TBKKG3 | CHAR (4) |
| MEDIUM | Medium | BKK_MEDIUM | TBKKG1 | CHAR (4) |
| BALOBJCATG | Object category for balancing | BKK_BALOBJCATG | CHAR (4) | |
| XGWHTX | Posting Generated by the WHTAX/CYT Implementation | BKK_XGWHTX | CHAR (1) |
