TFK042Q SAP table for – Payment Medium: Note of First Direct Debit

Here we would like to draw your attention to TFK042Q table in SAP. As we know it is being mainly used with the SAP FI-CA (Contract Accounts Receivable and Payable in FI) component which is coming under FI module (Financial Accounting). TFK042Q is a SAP standard transp table used for storing Payment Medium: Note of First Direct Debit related data in SAP. It comes under the package FKKB.

SAP TFK042Q table

Table TFK042Q technical data

TableTFK042Q
Data storingPayment Medium: Note of First Direct Debit
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP TFK042Q Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in TFK042Q table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GPA1T : Business Partner Category
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • GPA1R : Business Partner Reference
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • ZBNKS : Bank country key
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • ZBNKL : Bank number of the payee’s bank
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • ZBNKN : Bank account number of the payee
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • MASTT : Master record type for payment items
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • MASTR : Master Record Reference for Payment Item
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • LAUFD : Date ID
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAUFI : Additional Identification Characteristic
    Its data type is CHAR (Character String) with field length 6
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8