SAP table BKK40 (Current Account Master Data: General)

SAP table BKK40 has 3 primary key fields being MANDT,BKKRS,ACNUM_INT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

BKK40 foreign key relationships

Table Field Check Table Check Field
0 BKK40 BKKRS TBKK01 Bank Area Table MANDT
0 BKK40 BKKRS TBKK01 Bank Area Table BKKRS
1 BKK40 CLOSURE_REASON TBKK_REASON Reasons for account closure/reactivation MANDT
1 BKK40 CLOSURE_REASON TBKK_REASON Reasons for account closure/reactivation REASON_CLASS
1 BKK40 CLOSURE_REASON TBKK_REASON Reasons for account closure/reactivation REASON_KEY
0 BKK40 MANDT T000 Clients MANDT
1 BKK40 STATUS_ADD TBKK47 Account Status Enhancement MANDT
1 BKK40 STATUS_ADD TBKK47 Account Status Enhancement STATUS_ADD