DFKKREP06_S SAP (Tax Report Data - Shadow Table for Posting Date) Table details
Description: Tax Report Data - Shadow Table for Posting Date
Table field list including key, data, relationships and ABAP select examples
DFKKREP06_S is a standard SAP Table which is used to store Tax Report Data - Shadow Table for Posting Date data and is available within R/3 SAP systems depending on the version and release level.
The DFKKREP06_S table consists of various fields, each holding specific information or linking keys about Tax Report Data - Shadow Table for Posting Date 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_S 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 in transaction currency | GBETW_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_S using ABAP code
The following ABAP code Example will allow you to do a basic selection on DFKKREP06_S to SELECT all data from the tableDATA: WA_DFKKREP06_S TYPE DFKKREP06_S.
SELECT SINGLE *
FROM DFKKREP06_S
INTO CORRESPONDING FIELDS OF WA_DFKKREP06_S
WHERE...
How to access SAP table DFKKREP06_S
Within an ECC or HANA version of SAP you can also view further information about DFKKREP06_S 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