SAP table TKBBA (Document Types)

SAP table TKBBA has 3 primary key fields being MANDT,BLTYP,BLART.

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
BLTYP Earmarked Funds Document Category NUMC 3 0 FMRE_BLTYP
002 Funds transfer
020 Funds Block
030 Funds reservation
040 Funds precommitment
050 Funds commitment
060 Forecast of revenue
BLART Earmarked Fund Document Type CHAR 2 0 FMRE_BLART
NUMKR Number Range for Earmarked Funds CHAR 2 0 NRIV FM_RE_NKNR
FSTAGRE Funds Reservation Field Status Group CHAR 4 0 TREG FSTAGRE
VORLAGEART Group Key for Earmarked Fund Copying Template CHAR 4 0 TVA01 VORLAGEART
REFERART Group Key for Transfer from Reference Documents CHAR 4 0 TVA02 REFERART
WORKFLWART Group Key for Workflow-Relevant Fields CHAR 4 0 TREWF WORKFLWART
WF_START Start Workflow CHAR 1 0 WF_START
NEGVAL Negative Document CHAR 1 0 FR_NEGVAL
RESZ Residence Time (Calendar Months) NUMC 3 0 KBLRESZ
FORM_NAME Name of a Form Object CHAR 30 0 FPNAME
GLACCDRV Indicator: Derivation of G/L Account from FM Account Ass. CHAR 1 0 FMR_GLACCDRV
ADDITIV_CONS_LOG Additive Consumption Logic of Earmarked Funds CHAR 1 0 ADDITIV_CONSUMPTION_LOGIC
TOLSL Tolerance Key for Overrun Tolerance CHAR 4 0 FMR_TOLS FMR_TOLSL
FORMTYPE Form Formatting Type CHAR 1 0 FPTOOLTYPE
Smart Forms
P PDF-Based Forms
FMRO_TEMPLATE Indicator that document is a recurring obligations template CHAR 1 0 FMRO_TEMPLATE

TKBBA foreign key relationships

Table Field Check Table Check Field
0 TKBBA FSTAGRE TREG Field Status Groups for Funds Reservations MANDT
0 TKBBA FSTAGRE TREG Field Status Groups for Funds Reservations FSTAGRE
1 TKBBA NUMKR NRIV Number Range Intervals CLIENT
1 TKBBA NUMKR NRIV Number Range Intervals SUBOBJECT
1 TKBBA NUMKR NRIV Number Range Intervals NRRANGENR
1 TKBBA NUMKR NRIV Number Range Intervals TOYEAR
0 TKBBA REFERART TVA02 Variant for Transfers from Reference Documents for Fds Rsvn REFERART
1 TKBBA TOLSL FMR_TOLS Tolerance Key for Overrun Tolerance MANDT
1 TKBBA TOLSL FMR_TOLS Tolerance Key for Overrun Tolerance TOLSL
0 TKBBA VORLAGEART TVA01 Variant for Funds Reservation Copying Template VORLAGEART
1 TKBBA WORKFLWART TREWF Group Keys for Selection of Workflow-Relevant Fields MANDT
1 TKBBA WORKFLWART TREWF Group Keys for Selection of Workflow-Relevant Fields WORKFLWART