DFKKREP06 SAP (Tax Report Data (Invoicing Time or Triggered)) Table details
Description: Tax Report Data (Invoicing Time or Triggered)
Table field list including key, data, relationships and ABAP select examples
DFKKREP06 is a standard SAP Table which is used to store Tax Report Data (Invoicing Time or Triggered) data and is available within R/3 SAP systems depending on the version and release level.
The DFKKREP06 table consists of various fields, each holding specific information or linking keys about Tax Report Data (Invoicing Time or Triggered) data available in SAP. These include OPBEL (Number of Contract Accts Rec. & Payable Doc.), OPUPK (Item number in contract account document), GPART (Business Partner Number), VINFO (Detailing Assignment In Tax Report).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DFKKREP06 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | 80B | |
OPUPK | Item number in contract account document | OPUPK_KK | NUMC | 4 | OPUPK_KK | ||||
GPART | Business Partner Number | GPART_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | |
VINFO | Detailing Assignment In Tax Report | VINFO_KK | CHAR | 20 | CHAR20 | ||||
TZAHL | Counter For Identifying Respective Partial Payment Item | TZAHL_KK | NUMC | 3 | NUM3 | ||||
APPLK | Application area | APPLK_KK | CHAR | 1 | APPLK_KK | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
HKONT | General ledger account | HKONT_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAKO | |
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
STRKZ | Tax Code for Other Taxes | STRKZ_KK | CHAR | 2 | Assigned to domain | STRKZ_KK | |||
STPRZ | Tax rate | STPRZ_KK | NUMC | 6 | STPRZ_KK | ||||
SBASH | Amount Subject to Tax in Local Currency (Tax Base Amount) | SBASH_KK | CURR | 13(2) | WRTV7 | ||||
SBASW | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | SBASW_KK | CURR | 13(2) | WRTV7 | ||||
SBETH | Tax Amount in Local Currency With +/- Sign | SBETH_KK | CURR | 13(2) | WRTV7 | ||||
SBETW | Tax Amount in Transaction Currency with +/- Sign | SBETW_KK | CURR | 13(2) | WRTV7 | ||||
HWAER | Local Currency Key | HWAER_KK | CUKY | 5 | Assigned to domain | WAERS | |||
TWAER | Transaction Currency | TWAER | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
UBDAT | Posting Date Original Document | UBDAT_KK | DATS | 8 | DATUM | ||||
ULDAT | Original Document Date | ULDAT_KK | DATS | 8 | DATUM | ||||
FAEDN | Due date for net payment | FAEDN_KK | DATS | 8 | DATUM | ||||
VMDAT | Planned Report Date For Tax Item | VMDAT_KK | DATS | 8 | DATUM | ||||
SDATA | Additional Data For Tax Report | SDATA_KK | CHAR | 140 | CHAR140 | ||||
XBLNR | Official Document Number | EXBEL_KK | CHAR | 16 | ALPHA | EXBEL_KK | |||
KTOSL | Transaction key for account determination | KTOSL_KK | CHAR | 3 | CHAR3 | ||||
KSCHL | Type of Tax Item for Other Tax Codes | KSCHL_STRKZ_KK | CHAR | 4 | CHAR4 | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
TXJCO | Tax Jurisdiction Code (Entered value) | TXJCO_KK | CHAR | 15 | Assigned to domain | TXJCD | |||
AUBEL | Document Number Of Document To Be Triggered | AUBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
XNABE | Special Entry in Tax Reporting Table | XNABE_KK | CHAR | 1 | XNABE_KK | ||||
NUREL | Item Number In Sales/Purchase Tax Report List | NUREL_KK | NUMC | 10 | NUMC10 | ||||
REFNR | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | 80B | |
XSTOR | Document Has Been Reversed | XSTOR_KK | CHAR | 1 | XFELD | ||||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
XTEIL | Document Must be Reread Due to Partial Reset | XTEIL_KK | CHAR | 1 | XFELD | ||||
GEBTH | Total Amount Per Tax Code In Local Currency | GEBTH_KK | CURR | 13(2) | WRTV7 | ||||
GEBTW | Total Amount Per Tax Code In Transaction Currency | GEBTW_KK | CURR | 13(2) | WRTV7 | ||||
EXBEL_BETRH | Total amount for an official document in local currency | EXBEL_BETRH | CURR | 13(2) | WRTV7 | ||||
EXBEL_BETRW | Total amount of an official document in transaction currency | EXBEL_BETRW | CURR | 13(2) | WRTV7 | ||||
ORI_OPBEL | Tax Reporting: Document Number of Transferred Document | ORI_OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
ORI_OPUPK | Tax Reporting: Item Number of Transferred Tax Item | ORI_OPUPK_KK | NUMC | 4 | OPUPK_KK |
Key field | Non-key field |
How do I retrieve data from SAP table DFKKREP06 using ABAP code
The following ABAP code Example will allow you to do a basic selection on DFKKREP06 to SELECT all data from the tableDATA: WA_DFKKREP06 TYPE DFKKREP06.
SELECT SINGLE *
FROM DFKKREP06
INTO CORRESPONDING FIELDS OF WA_DFKKREP06
WHERE...
How to access SAP table DFKKREP06
Within an ECC or HANA version of SAP you can also view further information about DFKKREP06 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects