DKOKP - Open Item Account Balance Audit Trail

Open Item Account Balance Audit Trail information is stored in SAP table DKOKP.
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 DKOKP

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
.INCLUDEXKOKS_KEY0
MANDTClientXMANDTCLNT6*
KOARTAccount typeXKOARTCHAR2
BUKRSCompany CodeXBUKRSCHAR8
KONTOCustomer NumberXKUNNRCHAR20
.INCLUDEXKOKP_KEY0
GJAHRFiscal YearXGJAHRNUMC8
BELNRDocument Number of an Accounting DocumentXBELNR_DCHAR20
BUZEINumber of Line Item Within Accounting DocumentXBUZEINUMC6
EMPFGPayment Recipient CodeEMPFGCHAR32
UMSKSSpecial G/L Transaction TypeUMSKSCHAR2
UMSATSpecial G/L IndicatorUMSKZCHAR2
HKONTGeneral Ledger AccountHKONTCHAR20
AUGDTClearing DateAUGDTDATS16
AUGBLDocument Number of the Clearing DocumentAUGBLCHAR20
BUPEMPosting Period Month in Form MMBUPEMNUMC4
BUDATPosting Date in the DocumentBUDATDATS16
CPUDTDay On Which Accounting Document Was EnteredCPUDTDATS16
BLARTDocument TypeBLARTCHAR4
BLDATDocument Date in DocumentBLDATDATS16
AUGCPClearing Entry DateAUGCPDATS16
WAERSCurrency KeyWAERSCUKY10
XBLNRReference Document NumberXBLNR1CHAR32
ALTKZFull Audit Trail:ID: Altern.Acct No. Filled with Credit AcctALTKZCHAR2
ALTKTAccount Number in GroupALTKTCHAR20
USNAMUser NameUSNAMCHAR24
STAKZIndicator. Object Is StatisticalSTAKZCHAR2
DBBLGRecurring Entry Document NumberDBBLGCHAR20
AEDATLast Changed OnAEDATDATS16
UPDDTDate of the Last Document UpdateUPDDTDATS16
BKTXTDocument Header TextBKTXTCHAR50
XKRESIndicator: Can Line Items Be Displayed by Account?XKRESCHAR2
XOPVWIndicator: Open Item Management?XOPVWCHAR2
BSCHLPosting KeyBSCHLCHAR4
UMSKZSpecial G/L IndicatorUMSKZCHAR2
XUMSWIndicator: Sales-Related Item ?XUMSWCHAR2
SHKZGDebit/Credit IndicatorSHKZGCHAR2
MWSKZTax on sales/purchases codeMWSKZCHAR4
DMBTRAmount in local currencyDMBTRCURR12
WRBTRAmount in document currencyWRBTRCURR12
MWSTSTax Amount in Local CurrencyMWSTSCURR12
WMWSTTax Amount in Document CurrencyWMWSTCURR12
MWSHBTax on Sales/Purchases Amount in Foreign Curr. with +/- SignMWSHBCURR12
XZAHLIndicator: Is Posting Key Used in a Payment Transaction?XZAHLCHAR2
GSBERBusiness AreaGSBERCHAR8
SAKNRG/L Account NumberSAKNRCHAR20
FILKDAccount Number of the BranchFILKDCHAR20
SKNTOCash Discount Amount in Local CurrencySKNTOCURR12
WSKTOCash Discount Amount in Document CurrencyWSKTOCURR12
NETDTNet Due DateNETDTDATS16
SKFBTAmount Eligible for Cash Discount in Document CurrencySKFBTCURR12
MDSHBTax on Sales/Purchases Amount in Local Curr. with +/- SignMDSHBCURR12
HWBASTax Base Amount in Local CurrencyHWBASCURR12
VALUTValue dateVALUTDATS16
FWBASTax Base Amount in Document CurrencyFWBASCURR12
BSTNRPurchase order numberBSTNRCHAR20
SGTXTItem TextSGTXTCHAR100
GKARTOffsetting Account TypeGKARTCHAR2
GKONTOffsetting Account NumberGKONTCHAR20
MSCHLDunning KeyMSCHLCHAR2
NEBTRNet Payment AmountNEBTRCURR12
QSSKZWithholding Tax CodeQSSKZCHAR4
REBZGDocument No. of the Invoice to Which the Transaction BelongsREBZGCHAR20
REBZZLine Item in the Relevant InvoiceREBZZNUMC6
XCPDKIndicator: Is the account a one-time account?XCPDKCHAR2
BVORGNumber of Cross-Company Code Posting TransactionBVORGCHAR32
XNEGPIndicator: Negative PostingXNEGPCHAR2
Privacy Policy