1. SAP Tutorial
  2. FI Module

DFKKREV07 SAP table for – Report on Tax on Sales/Purchases (clearing time)

Here we would like to draw your attention to DFKKREV07 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). DFKKREV07 is a SAP standard transp table used for storing Report on Tax on Sales/Purchases (clearing time) related data in SAP. It comes under the package EEREV_REP.

SAP DFKKREV07 table

Table DFKKREV07 technical data

TableDFKKREV07
Data storingReport on Tax on Sales/Purchases (clearing time)
ModuleFI
Sub ModuleFI-CA
SAP PackageEEREV_REP
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKREV07 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 DFKKREV07 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
  • MZPKT : Report Time For Sales/Purchase Tax
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • MUMFA : Scope Of Data For Sales/Purchase Tax Explanation
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 1
  • 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
  • HKONT : General ledger account
    Its data type is CHAR (Character String) with field length 10
  • XREFS : Reference To Other Taxes
    Its data type is CHAR (Character String) with field length 1
  • BETRH : Amount In Local Currency With +/- Signs
    Its data type is CURR (Currency Field) with field length 13
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • GBETH : Total amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • GBETW : Total amount 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
  • REGIO : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • COUNC : County Code
    Its data type is CHAR (Character String) with field length 3
  • GRICD : Activity Code for Gross Income Tax
    Its data type is CHAR (Character String) with field length 2
  • GITYP : Distribution Type for Employment Tax
    Its data type is CHAR (Character String) with field length 2
  • REPCLS : Report Classification
    Its data type is CHAR (Character String) with field length 2
  • 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
  • AUGRD : Clearing Reason
    Its data type is CHAR (Character String) with field length 2
  • 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
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • DFKKREV07 related tables

    • DFKKREV07 : Report on Tax on Sales/Purchases (clearing time)
    • TFK009_REV : Definition of Report Time / Type of Sales / Purchase Taxes
    • DFKKREV06 : Report for Tax on Sales/Purchases (bill. time or triggered)

    Related References

    Related Tutorials

    DFKKREV06 SAP table for – Report for Tax on Sales/Purchases (bill. time or triggered)

    DFKKREV06 table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

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

    DFKKREP07 table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    TVAT001 SAP table for – Customizing of Tax on Sales/Purchases – Control of Screen

    TVAT001 table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Customizing...

    FAGL_CASHACC_TAX SAP table for – Cash Account from Tax on Sales/Purchases Indicator

    FAGL_CASHACC_TAX table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Cash...

    DFKKREP06 SAP table for – Tax Report Data (Invoicing Time or Triggered)

    DFKKREP06 table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    IDFIAA_JP_RESULT SAP table for – Results of Property Tax Report (Japan)

    IDFIAA_JP_RESULT table in SAP FI (Asset Accounting in FI) module. This table is used for storing data of Results of...

    DFKKREP06_S SAP table for – Tax Report Data – Shadow Table for Posting Date

    DFKKREP06_S table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    «
    »