SAP TABLES | Financial Accounting | General Ledger Accounting | Information System(FI-GL-IS) SAP FI

DKOKP SAP Open Item Account Balance Audit Trail Table and data







DKOKP is a standard SAP Table which is used to store Open Item Account Balance Audit Trail data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP DKOKP Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP DKOKP Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
.INCLUDEKOKS_KEY Open Item Account Balance Audit Trail Key
MANDTMANDTCLNT3
*
Client
KOARTKOARTCHAR1 Account Type
BUKRSBUKRSCHAR4
*
Company Code
KONTOKUNNRCHAR10
*
Customer NumberALPHA
.INCLUDEKOKP_KEY Open Item Account Balance Audit Trail Key
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
EMPFGEMPFGCHAR16 Payee code
UMSKSUMSKSCHAR1 Special G/L Transaction Type
UMSATUMSKZCHAR1
*
Special G/L Indicator
HKONTHKONTCHAR10
*
General Ledger AccountALPHA
AUGDTAUGDTDATS8 Clearing Date
AUGBLAUGBLCHAR10 Document Number of the Clearing DocumentALPHA
BUPEMBUPEMNUMC2 Posting Period Month in Form MM
BUDATBUDATDATS8 Posting Date in the Document
CPUDTCPUDTDATS8 Day On Which Accounting Document Was Entered
BLARTBLARTCHAR2
*
Document Type
BLDATBLDATDATS8 Document Date in Document
AUGCPAUGCPDATS8 Clearing Entry Date
WAERSWAERSCUKY5
*
Currency Key
XBLNRXBLNR1CHAR16 Reference Document Number
ALTKZALTKZCHAR1 Full audit trail:ID:Altern.acct no. filled with credit acct
ALTKTALTKTCHAR10 Account Number in GroupALPHA
USNAMUSNAMCHAR12
*
User name
STAKZSTAKZCHAR1 Indicator. object is statistical
DBBLGDBBLGCHAR10 Recurring Entry Document NumberALPHA
AEDATAEDATDATS8 Changed On
UPDDTUPDDTDATS8 Date of the Last Document Update
BKTXTBKTXTCHAR25 Document Header Text
XKRESXKRESCHAR1 Indicator: Can Line Items Be Displayed by Account?
XOPVWXOPVWCHAR1 Indicator: Open item management?
BSCHLBSCHLCHAR2
*
Posting Key
UMSKZUMSKZCHAR1
*
Special G/L Indicator
XUMSWXUMSWCHAR1 Indicator: Sales-related item ?
SHKZGSHKZGCHAR1 Debit/Credit Indicator
MWSKZMWSKZCHAR2
*
Tax on sales/purchases code
DMBTRDMBTRCURR13(2) Amount in Local Currency


WRBTRWRBTRCURR13(2) Amount in document currency
MWSTSMWSTSCURR13(2) Tax Amount in Local Currency
WMWSTWMWSTCURR13(2) Tax amount in document currency
MWSHBMWSHBCURR13(2) Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign
XZAHLXZAHLCHAR1 Indicator: Is the posting key used in a payment transaction?
ZINKZDZINKZCHAR2 Exempted from interest calculation
GSBERGSBERCHAR4
*
Business Area
SAKNRSAKNRCHAR10
*
G/L Account NumberALPHA
FILKDFILKDCHAR10 Account Number of the BranchALPHA
SKNTOSKNTOCURR13(2) Cash discount amount in local currency
WSKTOWSKTOCURR13(2) Cash discount amount in document currency
ZUONRDZUONRCHAR18 Assignment Number
NETDTNETDTDATS8 Due Date for Net Payment
ZFBDTDZFBDTDATS8 Baseline Date for Due Date Calculation
SKFBTSKFBTCURR13(2) Amount Eligible for Cash Discount in Document Currency
MDSHBMDSHBCURR13(2) Tax on Sales/Purchases amount in Local Curr. with +/- Sign
HWBASHWBASCURR13(2) Tax Base Amount in Local Currency
VALUTVALUTDATS8 Value date
FWBASFWBASCURR13(2) Tax Base Amount in Document Currency
BSTNRBSTNRCHAR10
*
Purchase Order NumberALPHA
SGTXTSGTXTCHAR50 Item Text
GKARTGKARTCHAR1 Offsetting Account Type
GKONTGKONTCHAR10 Offsetting Account NumberALPHA
ZLSCHDZLSCHCHAR1
*
Payment Method
MSCHLMSCHLCHAR1
*
Dunning key
ZTERMDZTERMCHAR4 Terms of Payment Key
ZBD1TDZBD1TDEC3 Cash discount days 1
ZBD1PDZBD1PDEC5(3) Cash Discount Percentage 1
ZBD2TDZBD2TDEC3 Cash discount days 2
ZBD2PDZBD2PDEC5(3) Cash Discount Percentage 2
ZBD3TDZBD3TDEC3 Net Payment Terms Period
NEBTRNEBTRCURR13(2) Net Payment Amount
QSSKZQSSKZCHAR2
*
Withholding Tax Code
REBZGREBZGCHAR10 Number of the Invoice the Transaction Belongs toALPHA
REBZZREBZZNUMC3 Line Item in the Relevant Invoice
XCPDKXCPDKCHAR1 Indicator: Is the account a one-time account?
BVORGBVORGCHAR16 Number of Cross-Company Code Posting Transaction
XNEGPXNEGPCHAR1 Indicator: Negative posting



Key field
Non-key field