DKKOP - Balance Audit Trail

Balance Audit Trail information is stored in SAP table DKKOP.
It is part of development package FREP in software component FI-GL-IS. This development package consists of objects that can be grouped under "RF reporting".

Fields for table DKKOP

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		KKOP_KEY	0
MANDT	Client	X	MANDT	CLNT	6	*
KOART	Account type	X	KOART	CHAR	2
BUKRS	Company Code	X	BUKRS	CHAR	8
KONTO	Customer Number	X	KUNNR	CHAR	20
GJAHR	Fiscal Year	X	GJAHR	NUMC	8
GSBER	Business Area	X	GSBER	CHAR	8	*
SAART	Record Type for Accumulated Balance Audit Trail	X	SAART	CHAR	2
UMSKS	Special G/L Transaction Type	X	UMSKS	CHAR	2
UMSAT	Special G/L Indicator	X	UMSKZ	CHAR	2	*
BUPER	Posting period in the form YYYYMM	X	BUPER	ACCP	12
BUDAT	Posting Date in the Document	X	BUDAT	DATS	16
BELNR	Document Number of an Accounting Document	X	BELNR_D	CHAR	20
BUZEI	Number of Line Item Within Accounting Document	X	BUZEI	NUMC	6
.INCLUDE				KKOP_DATA	0
HKONT	General Ledger Account		HKONT	CHAR	20	*
ALTKZ	Full Audit Trail:ID: Altern.Acct No. Filled with Credit Acct		ALTKZ	CHAR	2
ALTKT	Account Number in Group		ALTKT	CHAR	20
BLART	Document Type		BLART	CHAR	4	*
BLDAT	Document Date in Document		BLDAT	DATS	16
UMSKZ	Special G/L Indicator		UMSKZ	CHAR	2	*
WAERS	Currency Key		WAERS	CUKY	10	*
XBLNR	Reference Document Number		XBLNR1	CHAR	32
CPUDT	Day On Which Accounting Document Was Entered		CPUDT	DATS	16
USNAM	User Name		USNAM	CHAR	24	*
STAKZ	Indicator. Object Is Statistical		STAKZ	CHAR	2
DBBLG	Recurring Entry Document Number		DBBLG	CHAR	20
BKTXT	Document Header Text		BKTXT	CHAR	50
XUMSW	Indicator: Sales-Related Item ?		XUMSW	CHAR	2
XOPVW	Indicator: Open Item Management?		XOPVW	CHAR	2
BSCHL	Posting Key		BSCHL	CHAR	4	*
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
BUZID	Identification of the Line Item		BUZID	CHAR	2
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	*
FIPLS	Financial Budget Item		FIPLS	NUMC	6
DMBTR	Amount in local currency		DMBTR	CURR	12
GSBE1	Business Area		GSBER	CHAR	8	*
WRBTR	Amount in document currency		WRBTR	CURR	12
WSKTO	Cash Discount Amount in Document Currency		WSKTO	CURR	12
WMWST	Tax Amount in Document Currency		WMWST	CURR	12
MWSHB	Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign		MWSHB	CURR	12
AUGBL	Document Number of the Clearing Document		AUGBL	CHAR	20
AUGDT	Clearing Date		AUGDT	DATS	16
AUGCP	Clearing Entry Date		AUGCP	DATS	16
MSCHL	Dunning Key		MSCHL	CHAR	2	*
NETDT	Net Due Date		NETDT	DATS	16
SKFBT	Amount Eligible for Cash Discount in Document Currency		SKFBT	CURR	12
MWSTS	Tax Amount in Local Currency		MWSTS	CURR	12
MDSHB	Tax on Sales/Purchases Amount in Local Curr. with +/- Sign		MDSHB	CURR	12
SKNTO	Cash Discount Amount in Local Currency		SKNTO	CURR	12
HWBAS	Tax Base Amount in Local Currency		HWBAS	CURR	12
VALUT	Value date		VALUT	DATS	16
FWBAS	Tax Base Amount in Document Currency		FWBAS	CURR	12
PERNR	Personnel Number		PERNR_D	NUMC	16
ABPER	Settlement Period		ABPER_RF	ACCP	12
KOSTL	Cost Center		KOSTL	CHAR	20	*
SGTXT	Item Text		SGTXT	CHAR	100
GKART	Offsetting Account Type		GKART	CHAR	2
GKONT	Offsetting Account Number		GKONT	CHAR	20
VBUND	Company ID of Trading Partner		RASSC	CHAR	12	*
EGMLD	Reporting Country/Region for Delivery of Goods Within the EU		EGMLD_BSEZ	CHAR	6	*
STCEG	VAT Registration Number		STCEG	CHAR	40
BVORG	Number of Cross-Company Code Posting Transaction		BVORG	CHAR	32
XNEGP	Indicator: Negative Posting		XNEGP	CHAR	2