DSKOS SAP (Balance Audit Trail) Table details

Dictionary Type: Table
Description: Balance Audit Trail




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




Table field list including key, data, relationships and ABAP select examples

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

The DSKOS table consists of various fields, each holding specific information or linking keys about Balance Audit Trail data available in SAP. These include MANDT (Client), KOART (Account Type), BUKRS (Company Code), KONTO (Customer Numbers).. 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: Not classified


SAP DSKOS 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 MANDTCLNT3Assigned to domainMANDT
KOARTAccount Type KOARTCHAR1KOART
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
KONTOCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
SAARTRecord Type for Accumulated Balance Audit Trail SAARTCHAR1CHAR1
KTOKSG/L Account Group KTOKSCHAR4Assigned to domainKTOKS
SKBEZText TXT50CHAR50TEXT50
ZUAWAKey for sorting according to assignment numbers DZUAWACHAR3Assigned to domainZUAWA
XBILKIndicator: Account is a balance sheet account? XBILKCHAR1XFELD
MITKZAccount is reconciliation account MITKZCHAR1MITKZ
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
FIPLSFinancial Budget Item FIPLSNUMC3FIPLS
ZUBEZText TXT30CHAR30TEXT30
WMETHIndicator: account managed in external system WMETHCHAR2WMETH
XKOARCash receipt account / cash disbursement account XGKONCHAR1XFELD
KSARTCheckbox XFELDCHAR1XFELD
ALTKZFull audit trail:ID:Altern.acct no. filled with credit acct ALTKZCHAR1XFELD
ALTKTAccount Number in Group ALTKTCHAR10ALPHAALTKT
VZSKZInterest calculation indicator VZSKZCHAR2Assigned to domainVZSKZ
ZINDTKey date of the last interest calculation DZINDTDATS8DATUM
DATLZDate of the last interest calculation run DATLZDATS8DATUM
ZINRTInterest calculation frequency in months DZINRTNUMC2ZINRT
SPRASLanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
SLVFWBalance carried forward in foreign currency SLVFWCURR15(2) WRTV8
UMSAVBalance Carried Forward in Local Currency UMSAVCURR15(2) WRTV8
UM01STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM01HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM02STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM02HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM03STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM03HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM04STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM04HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM05STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM05HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM06STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM06HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM07STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM07HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM08STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM08HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM09STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM09HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM10STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM10HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM11STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM11HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM12STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM12HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM13STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM13HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM14STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM14HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM15STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM15HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
UM16STotal of the Credit Postings for the Month UMXXHCURR15(2) WRTV8
UM16HTotal of the Debit Postings for the Month UMXXSCURR15(2) WRTV8
WM01SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM01HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM02SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM02HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM03SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM03HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM04SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM04HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM05SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM05HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM06SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM06HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM07SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM07HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM08SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM08HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM09SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM09HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM10SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM10HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM11SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM11HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM12SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM12HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM13SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM13HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM14SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM14HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM15SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM15HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8
WM16SMonthly debit postings total in account currency WMXXSCURR15(2) WERT8
WM16HMonthly credit postings total in account currency WMXXHCURR15(2) WERT8

Key field Non-key field



How do I retrieve data from SAP table DSKOS using ABAP code

The following ABAP code Example will allow you to do a basic selection on DSKOS to SELECT all data from the table
DATA: WA_DSKOS TYPE DSKOS.

SELECT SINGLE *
FROM DSKOS
INTO CORRESPONDING FIELDS OF WA_DSKOS
WHERE...

How to access SAP table DSKOS

Within an ECC or HANA version of SAP you can also view further information about DSKOS 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!