SAP table BKORM (Accounting Correspondence Requests)

SAP table BKORM has 10 primary key fields being MANDT,EVENT,BUKRS,KOART,KONTO,BELNR,GJAHR,USNAM,DATUM,UZEIT.

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
EVENT Identification for Correspondence CHAR 5 0 T048 EVENT_KORR
BUKRS Company Code CHAR 4 0 T001 BUKRS
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
KONTO Open Item Account Number CHAR 10 0 KONKO
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
USNAM User Name CHAR 12 0 * USNAM
DATUM Date DATS 8 0 DATUM
UZEIT Time TIMS 6 0 UZEIT
ERLDT Date of Printing DATS 8 0 ERLDT_BKOR
PARAM Parameters for the Reports Requested CHAR 80 0 PARAM_BKOR
AVSID Payment Advice Number CHAR 16 0 AVSID
BBUKR Source Company Code CHAR 4 0 * AUSBK
CAJON Cash Journal Number CHAR 4 0 * CJNR

BKORM foreign key relationships

Table Field Check Table Check Field
0 BKORM BUKRS T001 Company Codes BUKRS
1 BKORM EVENT T048 Correspondence Types EVENT
0 BKORM MANDT T000 Clients MANDT