DFKKREP06_S SAP (Tax Report Data - Shadow Table for Posting Date) Table details

Dictionary Type: Table
Description: Tax Report Data - Shadow Table for Posting Date




ABAP Code to SELECT data from DFKKREP06_S
Related tables to DFKKREP06_S
Access table DFKKREP06_S




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
MANDTClient MANDTCLNT3T000MANDT
OPBELNumber of Contract Accts Rec. & Payable Doc. OPBEL_KKCHAR12Assigned to domainALPHAOPBEL_KK80B
OPUPKItem number in contract account document OPUPK_KKNUMC4OPUPK_KK
GPARTBusiness Partner Number GPART_KKCHAR10Assigned to domainALPHABU_PARTNERBPA
VINFODetailing Assignment In Tax Report VINFO_KKCHAR20CHAR20
TZAHLCounter For Identifying Respective Partial Payment Item TZAHL_KKNUMC3NUM3
APPLKApplication area APPLK_KKCHAR1APPLK_KK
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BUPLABusiness Place BUPLACHAR4Assigned to domainJ_1BBRANCH
HKONTGeneral ledger account HKONT_KKCHAR10Assigned to domainALPHASAKNRSAKO
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
STRKZTax Code for Other Taxes STRKZ_KKCHAR2Assigned to domainSTRKZ_KK
STPRZTax rate STPRZ_KKNUMC6STPRZ_KK
SBASHAmount Subject to Tax in Local Currency (Tax Base Amount) SBASH_KKCURR13(2) WRTV7
SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt) SBASW_KKCURR13(2) WRTV7
SBETHTax Amount in Local Currency With +/- Sign SBETH_KKCURR13(2) WRTV7
SBETWTax Amount in Transaction Currency with +/- Sign SBETW_KKCURR13(2) WRTV7
HWAERLocal Currency Key HWAER_KKCUKY5Assigned to domainWAERS
TWAERTransaction Currency TWAERCUKY5Assigned to domainWAERSFWS
UBDATPosting Date Original Document UBDAT_KKDATS8DATUM
ULDATOriginal Document Date ULDAT_KKDATS8DATUM
FAEDNDue date for net payment FAEDN_KKDATS8DATUM
VMDATPlanned Report Date For Tax Item VMDAT_KKDATS8DATUM
SDATAAdditional Data For Tax Report SDATA_KKCHAR140CHAR140
XBLNROfficial Document Number EXBEL_KKCHAR16ALPHAEXBEL_KK
KTOSLTransaction key for account determination KTOSL_KKCHAR3CHAR3
KSCHLType of Tax Item for Other Tax Codes KSCHL_STRKZ_KKCHAR4CHAR4
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
TXJCOTax Jurisdiction Code (Entered value) TXJCO_KKCHAR15Assigned to domainTXJCD
AUBELDocument Number Of Document To Be Triggered AUBEL_KKCHAR12Assigned to domainALPHAOPBEL_KK
XNABESpecial Entry in Tax Reporting Table XNABE_KKCHAR1XNABE_KK
NURELItem Number In Sales/Purchase Tax Report List NUREL_KKNUMC10NUMC10
REFNRNumber of Contract Accts Rec. & Payable Doc. OPBEL_KKCHAR12Assigned to domainALPHAOPBEL_KK80B
XSTORDocument Has Been Reversed XSTOR_KKCHAR1XFELD
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
XTEILDocument Must be Reread Due to Partial Reset XTEIL_KKCHAR1XFELD
GEBTHTotal Amount Per Tax Code In Local Currency GEBTH_KKCURR13(2) WRTV7
GEBTWTotal amount in transaction currency GBETW_KKCURR13(2) WRTV7
EXBEL_BETRHTotal amount for an official document in local currency EXBEL_BETRHCURR13(2) WRTV7
EXBEL_BETRWTotal amount of an official document in transaction currency EXBEL_BETRWCURR13(2) WRTV7
ORI_OPBELTax Reporting: Document Number of Transferred Document ORI_OPBEL_KKCHAR12Assigned to domainALPHAOPBEL_KK
ORI_OPUPKTax Reporting: Item Number of Transferred Tax Item ORI_OPUPK_KKNUMC4OPUPK_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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!