SAP table JBDKKON (SAP Banking: Business Partner Account)
SAP table JBDKKON has 3 primary key fields being MANDT,RBKONT,BUKRS.
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
Client
CLNT
3
0
T000
MANDT
Account Number
CHAR
16
0
JBRBKONT
Company Code
CHAR
4
0
T001
BUKRS
REXTNR
External Account Number
CHAR
18
0
JBREXTNR
RPARTN
Business Partner Number
CHAR
10
0
BUT000
BP_PARTNR_NEW
WKWAER
Currency of Business Partner Account
CUKY
5
0
TCURC
JBWKWAER
DERFAS
Created on
DATS
8
0
JBDERFAS
TERFAS
Time of entry
TIMS
6
0
JBTERFAS
RRBKONT
Reference Account Number
CHAR
16
0
JBDKKON
JBRRBKONT
RBUKRS
Reference Company Code
CHAR
4
0
T001
JBRBUKRS
OBJNR
Object Number for Financial Transactions
CHAR
22
0
JBDOBJ1
JBOBJNR
ACCMAIN
Account Management
CHAR
1
0
JBACCMAIN
Possible values
0
Not specified
1
With balances carried forward and turnovers
2
With daily balances
JBDKKON foreign key relationships
Table
Field
Check Table
Check Field
0 JBDKKON
BUKRS
T001 Company Codes
BUKRS
1 JBDKKON
MANDT
T000 Clients
MANDT
0 JBDKKON
OBJNR
JBDOBJ1 Object Table for Financial Transactions, General Part
OBJNR
1 JBDKKON
RBUKRS
T001 Company Codes
BUKRS
0 JBDKKON
RPARTN
BUT000 BP: General data I
PARTNER
1 JBDKKON
RRBKONT
JBDKKON SAP Banking: Business Partner Account
BUKRS
0 JBDKKON
WKWAER
TCURC Currency Codes
MANDT
0 JBDKKON
WKWAER
TCURC Currency Codes
WAERS