SAP table TBKKG3 (Transaction types)

SAP table TBKKG3 has 2 primary key fields being MANDT,TRNSTYPE.

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
TRNSTYPE Transaction Type CHAR 4 0 BKK_TTYPE
XINPMNT Transaction Type Initiates a Credit CHAR 1 0 BKK_INPMNT
XCHK_BUPA Business Partner Check CHAR 1 0 BKK_CHKBUP
XCHK_ACCNT Account Check CHAR 1 0 BKK_CHKACC
XCHK_VALUE Indicator: Process Checks for Value Date? CHAR 1 0 BKK_CHKVAL
XCHK_LIMIT Limit Checks CHAR 1 0 BKK_CHKLIM
XCHEQUE Indicator: Check with Check Management CHAR 1 0 BKK_XCHEQ
CASHB_TYPE Means of Payment Position Type CHAR 4 0 TBKKA1 BKK_CASHBT
XDIRDEB Check if Direct Debit Order Available CHAR 1 0 BKK_DIRDEB
XCOLAUTH Check for Collection Authorization Agreement CHAR 1 0 BKK_COLAUT
XSUBTOCOL Indicator: Subject to Final Payment (S.F.P.) CHAR 1 0 BKK_SUBCOL
VALUE_REQ Indicator: Value Date Specification Allowed NUMC 1 0 BKK_VALREQ
0 Value Date Entry Not Allowed
1 Value Date Entry Possible
2 Value Date Entry Mandatory
XMORE_RCV Indicator: Several Recipients Allowed CHAR 1 0 BKK_XMRCV
XPAYM_NOTE Indicator: Display Payment Notes CHAR 1 0 BKK_XPAYNTE
XPRI_PPROC Indicator: Priority in Postprocessing CHAR 1 0 BKK_XPRIPP
XREVERSAL Indicator: Reversing Allowed CHAR 1 0 BKK_XREVER
XNAMECHECK Account Call-Up Check CHAR 1 0 BKK_XNAMECHECK
XDIA_POC Indicator: Online Entry Internal Order Allowed CHAR 1 0 BKK_XDIAPC
XDIA_POR Indicator: Online Entry Return Order Allowed CHAR 1 0 BKK_XDIAPR
XDIA_POF Indicator: Online Entry Foreign Payment Order Allowed CHAR 1 0 BKK_XDIAPF
XDIALOG_PO Indicator: Online Entry External Payment Order Allowed CHAR 1 0 BKK_XDIAPO
XDIALOG_PI Indicator: Online Entry Payment Item Allowed CHAR 1 0 BKK_XDIAPI
XDIA_SO Online Entry Standing Order CHAR 1 0 BKK_DIASO
Not Used
1 Online Entry Standing Order Variable Amount
X Online Entry Standing Order Fixed Amount
XSUPPRS_REFACC Indicator: Suppress Ref. Bank Statement on Bank Statement CHAR 1 0 BKK_XSUPPREF
XERR_MANDATE Mandate Check CHAR 1 0 BKK_DTE_FLG_MND_CHK
XCHK_EXTD_MND Indicator: Execute Extended Mandate Checks CHAR 1 0 BKK_DTE_FLG_CHK_EXTD_MND
XCHK_PRENOTE Prenote Check CHAR 1 0 BKK_DTE_FLG_PRENOTE_CHK
XNO_DEL Indicator: External Sender/Turnover Item May not Be Deleted CHAR 1 0 BKK_XNODEL
XMEMO_ITEM Items are memo items CHAR 1 0 BCA_US_XMEMO
XESCHEAT Indicator: Internal Transaction CHAR 1 0 BCA_US_XESCHEAT
XAIREL Interest Penalty Calculation CHAR 1 0 BKK_AI_REL
XBLNOT Operation Relevant to Notice Period Lock CHAR 1 0 BKK_BL_NO
XFXNET Indicator: Foreign exchange netting enabled CHAR 1 0 BKK_XFXNET

TBKKG3 foreign key relationships

Table Field Check Table Check Field
0 TBKKG3 CASHB_TYPE TBKKA1 Position Types MANDANT