SAP table BKDF (Document Header Supplement for Recurring Entry)

SAP table BKDF has 4 primary key fields being MANDT,BUKRS,BELNR,GJAHR.

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
BUKRS Company Code CHAR 4 0 T001 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
DBMON Run Frequency (Recurring Entry) NUMC 2 0 DBMON
01 Per month
02 Every 2 months
03 Every 3 months
04 Every 4 months
05 Every 5 months
06 Every 6 months
07 Every 7 months
08 Every 8 months
09 Every 9 months
10 Every 10 months
11 Every 11 months
12 Every 12 months
DBTAG Run Date (Recurring Entry) NUMC 2 0 DBTAG
DBBDT Recurring Entry Starting Date DATS 8 0 DBBDT
DBATR Next Calculation Date of the Recurring Entry DATS 8 0 DBATR
DBEDT Recurring Entry End Date DATS 8 0 DBEDT
XDELT Indicator: Recurring Entry Carried Out (Can Be Deleted)? CHAR 1 0 XDELT
DBZHL Number of Runs (Recurring Entries) DEC 5 0 DBZHL
DBAKZ Run Schedule for Recurring Entries CHAR 4 0 T054 DBAKZ_T054
XFWHW Indicator: Transfer FC and LC Amounts in Original Document CHAR 1 0 XFWHW_BKDF
XSFHW Indicator: Also Transfer Tax Amounts in Local Currency CHAR 1 0 XSFHW_BKDF
XBLLT Copy Texts CHAR 1 0 XBLLT
RECURRENCE_TYPE Recurrence Type CHAR 1 0 FAC_RJET_RECURRENCE_TYPE
1 Monthly
2 Weekly
3 By Posting Period
FREQUENCY Recurrence Frequency INT2 5 0 FAC_RJET_FREQUENCY
OCCUR_DAY_TYPE Occurrence Type CHAR 1 0 FAC_RJET_OCCUR_DAY_TYPE
1 First Day
2 Last Day
3 Specific Day
OCCUR_DAY Occurrence Day NUMC 3 0 FAC_RJET_OCCUR_DAY
FIRST_OCCUR_DATE First Occurrence Date DATS 8 0 FAC_RJET_FIRST_OCCUR_DATE
END_BY_TYPE Recurrence End Type CHAR 1 0 FAC_RJET_END_BY_TYPE
1 By
2 After
LAST_OCCUR_DATE Recurrence End Date DATS 8 0 FAC_RJET_LAST_OCCUR_DATE
NUMBER_OF_OCCUR Number of Occurrences INT2 5 0 FAC_RJET_NUMBER_OF_OCCUR
BLOCKED_FOR_POSTING Blocked For Posting CHAR 1 0 FAC_RJET_BLOCKED_FOR_POSTING
RECUR_SCHEDULE_USED Use Recurrence Schedule CHAR 1 0 FAC_RJET_RECUR_SCHEDULE_USED
CREATED_IN_SFIN Recurring Journal Entry: Created by Fiori App Manage Rec JEs CHAR 1 0 FAC_RJET_CREATED_IN_SFIN
LOGNUMBER Application Log Number CHAR 20 0 FAC_BALOGNR
SFIN_MIG_STATUS Migration of the Rec. Journal Entry to Fiori App: Status CHAR 1 0 FAC_RJET_SFIN_MIGRATION_STATUS
Not migrated to Fiori app
X Migrated to Fiori app
Y Migration to Fiori app reverted

BKDF foreign key relationships

Table Field Check Table Check Field
0 BKDF BUKRS T001 Company Codes BUKRS
1 BKDF DBAKZ T054 Run Schedule for Recurring Documents MANDT
0 BKDF MANDT T000 Clients MANDT