DKOKS - Open Item Account Balance Audit Trail Master Record

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

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
.INCLUDEXKOKS_KEY0
MANDTClientXMANDTCLNT6
KOARTAccount typeXKOARTCHAR2
BUKRSCompany CodeXBUKRSCHAR8
KONTOCustomer NumberXKUNNRCHAR20
EMPFGPayment Recipient CodeXEMPFGCHAR32
SAARTRecord Type for Accumulated Balance Audit TrailSAARTCHAR2
ALTKZFull Audit Trail:ID: Altern.Acct No. Filled with Credit AcctALTKZCHAR2
ALTKTAccount Number in GroupALTKTCHAR20
ANREDTitleANREDCHAR30
NAME1NameNAME1CHAR60
NAME2Name 2NAME2CHAR60
PSTLZPostal CodePSTLZCHAR20
ORT01CityORT01CHAR50
LAND1Country/Region KeyLAND1CHAR6
STRASStreet and House NumberSTRASCHAR60
PFACHPO BoxPFACHCHAR20
PSTL2P.O. Box Postal CodePSTL2CHAR20
ORT02DistrictORT02CHAR50
REGIORegion (State, Province, County)REGIOCHAR6
COUNCCounty CodeCOUNCCHAR6
CITYCCity CodeCITYCCHAR8
XCPDKIndicator: Is the account a one-time account?XCPDKCHAR2
XZEMPIndicator: Alternative Payee in Document Allowed?XZEMPCHAR2
BLNKZ(Obsolete) Subsidy Ind. for Determining the Reduction RateBLNKZCHAR4
KTOKSG/L Account GroupKTOKSCHAR8
KTOKKVendor account groupKTOKKCHAR8
KTOKDCustomer Account GroupKTOKDCHAR8
BANKNBank account numberBANKNCHAR36
BANKLBank KeysBANKKCHAR30
BANKSCountry/Region Key of BankBANKSCHAR6
BANKAName of Financial InstitutionBANKACHAR120
PSKTOPO Bank Current Acct No. or Building Society Ref. No.PSKTOCHAR32
BKONTBank Control KeyBKONTCHAR4
BANKPCheck Digit for Bank No./AccountBANKPCHAR4
SWIFTSWIFT/BIC for International PaymentsSWIFTCHAR22
KNRZAAccount Number of an Alternative PayerKNRZACHAR20
BRSCHIndustry keyBRSCHCHAR8
KONZSGroup keyKONZSCHAR20
KDNREHead Office Account Number (in branch accounts)KNRZECHAR20
TELF1First telephone numberTELF1CHAR32
TELX1Telex numberTELX1CHAR60
TELFXFax NumberTELFXCHAR62
TELTXTeletex numberTELTXCHAR60
DATLTData communication line no.DATLTCHAR28
TELBXTelebox numberTELBXCHAR30
SORTLSort fieldSORTLCHAR20
WAERSCurrency KeyWAERSCUKY10
SPRASLanguage KeySPRASLANG2
LIFNRAccount Number of SupplierLIFNRCHAR20
KUNNRCustomer NumberKUNNRCHAR20
KLIMGCredit limit: Total limit across all control areasKLIMGCURR12
BBBNRInternational location number (part 1)BBBNRNUMC14
BBSNRInternational location number (Part 2)BBSNRNUMC10
BUBKZCheck digit for the international location numberBUBKZNUMC2
STCD1Tax Number 1STCD1CHAR32
STCD2Tax Number 2STCD2CHAR22
FISKNAccount number of the master record with the fiscal addressFISKN_DCHAR20
STKZULiable for VATSTKZUCHAR2
STKZAIndicator: Business Partner Subject to Equalization Tax?STKZACHAR2
ESRNRISR subscriber numberESRNRCHAR22
AKONTReconciliation Account in General LedgerAKONTCHAR20
BEGRUAuthorization GroupBEGRUCHAR8
EIKTOShipper's (Our) Account Number at the Customer or VendorEIKTOCHAR24
ERNAMName of Person Responsible for Creating the ObjectERNAMCHAR24
MAHNSDunning LevelMAHNS_DNUMC2
KLIMKCustomer's credit limitKLIMKCURR12
VZSKZInterest IndicatorVZSKZCHAR4
DATLZDate of Last Interest Calculation RunDATLZDATS16
VBUNDCompany ID of Trading PartnerRASSCCHAR12
BUSABAccounting Clerk AbbreviationBUSABCHAR4
KNRZEHead Office Account Number (in branch accounts)KNRZECHAR20
PERRNPeriod IndicatorPERKZCHAR2
WAKONTerms of Payment Key for Bill of Exchange ChargesWAKONCHAR8
MSCHLDunning KeyMSCHLCHAR2
WEBTRBill of Exchange Limit (in Local Currency)WEBTRCURR12
REMITNext payeeREMITCHAR20
FDGRVPlanning GroupFDGRVCHAR20
QSZNRCertificate Number of the Withholding Tax ExemptionQSZNRCHAR20
QSZDTValidity Date for Withholding Tax Exemption CertificateQSZDTDATS16
VRSNRInsurance NumberVRSNRCHAR20
REPRFCheck Flag for Double Invoices or Credit MemosREPRFCHAR2
DTAWSInstruction Key for Data Medium ExchangeDTAWSCHAR4
DTAMSReport key for data medium exchangeDTAMSCHAR2
Privacy Policy