1. Home
  2. Resources
  3. SAP Tables
  4. BKK40 - Current Account Master Data: General

SAP Table BKK40

Current Account Master Data: General

BKK40 (Current Account Master Data: General) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BKK40 to other SAP tables.

BKK40 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BKKRS Bank Area BKK_BKKRS TBKK01 CHAR 4 0
ACNUM_INT Internal Account Number for Current Account BKK_ACCNT CHAR 10 0
XDELE Central Archiving Flag? BKK_XDELE CHAR 1 0
X Yes
NULL No
SEARCH1 Search term 1 BKK_SEAR1 CHAR 20 0
SEARCH2 Search term 2 BKK_SEAR2 CHAR 20 0
ERFUSER User Who Created Current Account BKK_ERUSER CHAR 12 0
ERFDATE Date on Which Current Account Was Created BKK_ERDATE DATS 8 0
ERFTIME Time at Which Current Account Was Created BKK_ERTIME TIMS 6 0
AENUSER Last changed by BKK_AEUSER CHAR 12 0
AENDATE Date on Which BCA Account was Last Changed BKK_AEDATE DATS 8 0
AENTIME Time at Which Current Account was Last Changed BKK_AETIME TIMS 6 0
STATUS Account Status BKK_STATUS CHAR 1 0
0 Inactive
1 Active
XPRINT Print Correspondence BKK_PRNT_CHG CHAR 1 0
X Yes
NULL No
DELDATE Date Account Closed BKK_DDATE DATS 8 0
PRODDATE Account Go-Live Date BKK_CPDATE DATS 8 0
BALDATE Date of Balance Transfer BKK_BLDATE DATS 8 0
STATUS_ADD Account Status Enhancement BKK_STATAD TBKK47 CHAR 4 0
XOFFER Indicator: Create Account as Offer BKK_XOFFER CHAR 1 0
X Yes
NULL No
XCHKDIG Indicator: No Check Digit Calculation BKK_XCHKDG CHAR 1 0
X Yes
NULL No
OPENDATE Date Account Opened BKK_ODATE DATS 8 0
PLANNED_CL_DATE Planned Account Closure Date BKK_DTE_CLS_PL_DT DATS 8 0
CLOSURE_REASON Reason Key BKK_DTE_REASON_KEY TBKK_REASON CHAR 2 0
CLS_REA_CLASS Reason Class BKK_DTE_REASON_CLASS CHAR 2 0
PRENOT_CLOSURE Prenotification for Account Closure BKK_DTE_CLS_PRENOT CHAR 1 0
X Yes
NULL No
PRENOT_DAYS No. of Days for Acct Closure Prenotification Correspondence BKK_DTE_CLS_PRENOT_DAYS DEC 3 0
PRENOT_PRINTED Closure Prenotification Correspondence Generated Successfull BKK_DTE_CLS_PRENOT_PRINTED CHAR 1 0
X Yes
NULL No
CLOSURE_CORR Account Closure Correspondence BKK_DTE_CLS_CORR CHAR 1 0
X Yes
NULL No
REACN_DATE Reactivation Date BKK_DTE_REACTIVATION_DATE DATS 8 0
REACN_REASON Reason Key BKK_DTE_REASON_KEY CHAR 2 0
REACN_REA_CLASS Reason Class BKK_DTE_REASON_CLASS CHAR 2 0
ROOT_ACNUM_INT Internal Account Number for Current Account BKK_ACCNT CHAR 10 0

BKK40 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BKK40 BKKRS BKK40 MANDT TBKK01 Bank Area Table MANDT
BKK40 BKKRS BKK40 BKKRS TBKK01 Bank Area Table BKKRS
BKK40 CLOSURE_REASON BKK40 CLS_REA_CLASS TBKK_REASON Reasons for account closure/reactivation REASON_CLASS
BKK40 CLOSURE_REASON BKK40 CLOSURE_REASON TBKK_REASON Reasons for account closure/reactivation REASON_KEY
BKK40 CLOSURE_REASON BKK40 MANDT TBKK_REASON Reasons for account closure/reactivation MANDT
BKK40 MANDT BKK40 MANDT T000 Clients MANDT
BKK40 STATUS_ADD BKK40 MANDT TBKK47 Account Status Enhancement MANDT
BKK40 STATUS_ADD BKK40 STATUS_ADD TBKK47 Account Status Enhancement STATUS_ADD