DFKKTXINV SAP table for – Tax Invoices

Here we would like to draw your attention to DFKKTXINV 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). DFKKTXINV is a SAP standard transp table used for storing Tax Invoices related data in SAP. It comes under the package FKK_TAXINV.

SAP DFKKTXINV table

Table DFKKTXINV technical data

TableDFKKTXINV
Data storingTax Invoices
ModuleFI
Sub ModuleFI-CA-BT
SAP PackageFKK_TAXINV
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKTXINV 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 DFKKTXINV table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • OPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • TXINVZ : Counter for Tax Invoice
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • GPART : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • VKONT : Contract Account Number
    Its data type is CHAR (Character String) with field length 12
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DRUCKDAT : Print Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XCANC : Document Reversed
    Its data type is CHAR (Character String) with field length 1
  • TXINV : Number of Tax Invoice
    Its data type is CHAR (Character String) with field length 16
  • TXYER : Year of Tax Return
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BETRH : Amount In Local Currency With +/- Signs
    Its data type is CURR (Currency Field) with field length 13