DFKKREP07 SAP table for – Tax Report Data (Clearing Time)

Here we would like to draw your attention to DFKKREP07 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). DFKKREP07 is a SAP standard transp table used for storing Tax Report Data (Clearing Time) related data in SAP. It comes under the package FKKB.

SAP DFKKREP07 table

Table DFKKREP07 technical data

TableDFKKREP07
Data storingTax Report Data (Clearing Time)
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKREP07 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 DFKKREP07 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
  • OPUPK : Item number in contract account document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • GPART : Business Partner Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • VINFO : Detailing Assignment In Tax Report
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • TZAHL : Counter For Identifying Respective Partial Payment Item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • APPLK : Application area
    Its data type is CHAR (Character String) with field length 1
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • HKONT : General ledger account
    Its data type is CHAR (Character String) with field length 10
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • STRKZ : Tax Code for Other Taxes
    Its data type is CHAR (Character String) with field length 2
  • STPRZ : Tax rate
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • XREFS : Reference To Other Taxes
    Its data type is CHAR (Character String) with field length 1
  • SBASH : Amount Subject to Tax in Local Currency (Tax Base Amount)
    Its data type is CURR (Currency Field) with field length 13
  • SBASW : Amount Subject to Tax in Transaction Currency (Tax Base Amt)
    Its data type is CURR (Currency Field) with field length 13
  • SBETH : Tax Amount in Local Currency With +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • SBETW : Tax Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • GEBTH : Total Amount Per Tax Code In Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • GEBTW : Total Amount Per Tax Code In Transaction Currency
    Its data type is CURR (Currency Field) with field length 13
  • AUGBO : Clearing Amount in Open Item Currency
    Its data type is CURR (Currency Field) with field length 13
  • AUGBH : Clearing amount in local currency with +/- sign
    Its data type is CURR (Currency Field) with field length 13
  • AUGBW : Clearing Amount in Transaction Currency (With +/- Sign)
    Its data type is CURR (Currency Field) with field length 13
  • HWAER : Local Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TWAER : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TBDAT : Posting Date Trigger Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TLDAT : Document Date For Trigger Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FAEDN : Due date for net payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VMDAT : Planned Report Date For Tax Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SDATA : Additional Data For Tax Report
    Its data type is CHAR (Character String) with field length 140
  • XBLNR : Official Document Number
    Its data type is CHAR (Character String) with field length 16
  • KTOSL : Transaction key for account determination
    Its data type is CHAR (Character String) with field length 3
  • KSCHL : Type of Tax Item for Other Tax Codes
    Its data type is CHAR (Character String) with field length 4
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • TXJCO : Jurisdiction code (specified value)
    Its data type is CHAR (Character String) with field length 15
  • AUBEL : Document Number Of Document To Be Triggered
    Its data type is CHAR (Character String) with field length 12
  • XSATZ : Record Triggered In Reporting Table
    Its data type is CHAR (Character String) with field length 1
  • REFNR : Number of Contract Accts Rec. & Payable Doc.
    Its data type is CHAR (Character String) with field length 12
  • XSTOR : Document Has Been Reversed
    Its data type is CHAR (Character String) with field length 1
  • AUGRD : Clearing Reason
    Its data type is CHAR (Character String) with field length 2
  • CPUDT : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • EXBEL_BETRH : Total amount for an official document in local currency
    Its data type is CURR (Currency Field) with field length 13
  • EXBEL_BETRW : Total amount of an official document in transaction currency
    Its data type is CURR (Currency Field) with field length 13
  • ORI_OPBEL : Tax Reporting: Document Number of Transferred Document
    Its data type is CHAR (Character String) with field length 12
  • ORI_OPUPK : Tax Reporting: Item Number of Transferred Tax Item
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Include for Insurance
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes