SAP table BKKA1 (Position Manangement: General Data)

SAP table BKKA1 has 4 primary key fields being MANDT,BKKRS,CASHB_CATG,CASHB_NR.

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
CASHB_CATG Means of Payment Position Category NUMC 2 0 BKK_CASHBC
01 Check
02 Card
03 Bills of Exchange
CASHB_NR Means of Payment Position Number CHAR 13 0 BKK_CBALNR
ACCNT_NR Internal Account Number for Current Account CHAR 10 0 BKK40 BKK_ACCNT
CASHB_EX Position Number (External) CHAR 20 0 BKK_CASHBX
CASHB_TYPE Means of Payment Position Type CHAR 4 0 TBKKA1 BKK_CASHBT
CASHB_STAT Status of a Position CHAR 2 0 BKK_CBSTAT
01 Issued
02 Redeemed/Settled
03 Blocked
04 Partially Redeemed
05 Lock Removed
06 Returned
07 Issue requested
CASHB_STAR Position Status After Last Untested Posting CHAR 2 0 BKK_CBSTAR
CASHB_RCNT Number of Re-Presentations of a Position NUMC 3 0 BKK_CBRCNT
BLOCK_REAS Locking Reason NUMC 2 0 TBKKA4 BKK_LOCKR
BLOCKDATTO Lock Date To DATS 8 0 BKK_BLDTTO
CASHB_IDAT Date of Position Issue DATS 8 0 BKK_STIDAT
CASHB_ITIM Time a Position Is Created TIMS 6 0 BKK_CBITIM
UNAME_IDAT User Creating a Position CHAR 12 0 BKK_UNAMEI
CASHB_SDAT Date of Last Status Change DATS 8 0 BKK_STSDAT
CASHB_STIM Time of Last Status Change TIMS 6 0 BKK_CBSTIM
UNAME_SDAT User Changing Status of a Position CHAR 12 0 BKK_UNAMES
STACK_PLACE Key of a Location in Position Management NUMC 4 0 BKK_STACK_PLACE
REM_TEXT Comment on a Check CHAR 50 0 BKK_REM_TEXT
XDELETE Indicator: Check Was Deleted CHAR 1 0 BKK_CBDELETE
XBLOCKINFO Indicator: Notification Sent for Block CHAR 1 0 BKK_XBLOCKINFO
PAY_DATE Cashing Date of Check DATS 8 0 BKK_PAY_DATE
PAY_TIME Cashing Time of Check TIMS 6 0 BKK_PAY_TIME

BKKA1 foreign key relationships

Table Field Check Table Check Field
0 BKKA1 ACCNT_NR BKK40 Current Account Master Data: General ACNUM_INT
1 BKKA1 BKKRS TBKK01 Bank Area Table MANDT
1 BKKA1 BKKRS TBKK01 Bank Area Table BKKRS
0 BKKA1 BLOCK_REAS TBKKA4 Check void reason codes MANDT
1 BKKA1 CASHB_TYPE TBKKA1 Position Types MANDANT
0 BKKA1 MANDT T000 Clients MANDT