The DSKOP table in SAP ERP or S/4HANA stores Balance Audit Trail data. There are total 78 fields in DSKOP table. The Balance Audit Trail table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DSKOP table. It is in RF reporting (FREP) ABAP package and is part of the Information System (FI-GL-IS) module.
SAP DSKOP Table Fields
Following is the list of fields that are available in SAP DSKOP table. The primary key fields of the table are MANDT (Client), KOART (Account type), BUKRS (Company Code), KONTO (Customer Number), GJAHR (Fiscal Year), GSBER (Business Area), SAART (Record Type for Accumulated Balance Audit Trail), UMSKS (Special G/L Transaction Type), UMSAT (Special G/L Indicator), BUPER (Posting period in the form YYYYMM), BUDAT (Posting Date in the Document), BELNR (Accounting Document Number), BUZEI (Number of Line Item Within Accounting Document).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| KOART | Account type | KOART | CHAR (1) | |
| BUKRS | Company Code | BUKRS | CHAR (4) | |
| KONTO | Customer Number | KUNNR | CHAR (10) | |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| GSBER | Business Area | GSBER | * | CHAR (4) |
| SAART | Record Type for Accumulated Balance Audit Trail | SAART | CHAR (1) | |
| UMSKS | Special G/L Transaction Type | UMSKS | CHAR (1) | |
| UMSAT | Special G/L Indicator | UMSKZ | * | CHAR (1) |
| BUPER | Posting period in the form YYYYMM | BUPER | ACCP (6) | |
| BUDAT | Posting Date in the Document | BUDAT | DATS (8) | |
| BELNR | Accounting Document Number | BELNR_D | CHAR (10) | |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC (3) | |
| ALTKZ | Full Audit Trail:ID: Altern.Acct No. Filled with Credit Acct | ALTKZ | CHAR (1) | |
| ALTKT | Account Number in Group | ALTKT | CHAR (10) | |
| BLART | Document Type | BLART | * | CHAR (2) |
| BLDAT | Document Date in Document | BLDAT | DATS (8) | |
| UMSKZ | Special G/L Indicator | UMSKZ | * | CHAR (1) |
| WAERS | Currency Key | WAERS | * | CUKY (5) |
| XBLNR | Reference Document Number | XBLNR1 | CHAR (16) | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS (8) | |
| USNAM | User Name | USNAM | * | CHAR (12) |
| STAKZ | Indicator. Object Is Statistical | STAKZ | CHAR (1) | |
| DBBLG | Recurring Entry Document Number | DBBLG | CHAR (10) | |
| BKTXT | Document Header Text | BKTXT | CHAR (25) | |
| XKRES | Indicator: Can Line Items Be Displayed by Account? | XKRES | CHAR (1) | |
| XOPVW | Indicator: Open Item Management? | XOPVW | CHAR (1) | |
| BSCHL | Posting Key | BSCHL | * | CHAR (2) |
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR (1) | |
| BUZID | Identification of the Line Item | BUZID | CHAR (1) | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | * | CHAR (2) |
| FIPLS | Financial Budget Item | FIPLS | NUMC (3) | |
| DMBTR | Amount in local currency | DMBTR | CURR (23) | |
| DMSOL | Debit Amount in Local Currency | DMSOL | CURR (23) | |
| DMHAB | Credit Amount in Local Currency | DMHAB | CURR (23) | |
| DMSHB | Amount in Local Currency with +/- Signs | DMSHB | CURR (23) | |
| GSBE1 | Business Area | GSBER | * | CHAR (4) |
| WRBTR | Amount in document currency | WRBTR | CURR (23) | |
| WRSOL | Debit Amount in Document Currency | WRSOL | CURR (23) | |
| WRHAB | Credit Amount in Document Currency | WRHAB | CURR (23) | |
| WRSHB | Foreign Currency Amount with Signs (+/-) | WRSHB | CURR (23) | |
| WSKTO | Cash Discount Amount in Document Currency | WSKTO | CURR (23) | |
| WMWST | Tax Amount in Document Currency | WMWST | CURR (23) | |
| MWSHB | Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign | MWSHB | CURR (23) | |
| ZUONR | Assignment number | DZUONR | CHAR (18) | |
| AUGBL | Document Number of the Clearing Document | AUGBL | CHAR (10) | |
| AUGDT | Clearing Date | AUGDT | DATS (8) | |
| AUGCP | Clearing Entry Date | AUGCP | DATS (8) | |
| NETDT | Net Due Date | NETDT | DATS (8) | |
| ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS (8) | |
| SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR (23) | |
| MWSTS | Tax Amount in Local Currency | MWSTS | CURR (23) | |
| MDSHB | Tax on Sales/Purchases Amount in Local Curr. with +/- Sign | MDSHB | CURR (23) | |
| HWBAS | Tax Base Amount in Local Currency | HWBAS | CURR (23) | |
| ZINKZ | Exempted from Interest Calculation | DZINKZ | CHAR (2) | |
| VALUT | Value date | VALUT | DATS (8) | |
| FWBAS | Tax Base Amount in Document Currency | FWBAS | CURR (23) | |
| PERNR | Personnel Number | PERNR_D | NUMC (8) | |
| ABPER | Settlement Period | ABPER_RF | ACCP (6) | |
| KOSTL | Cost Center | KOSTL | * | CHAR (10) |
| SGTXT | Item Text | SGTXT | CHAR (50) | |
| AUFNR | Order Number | AUFNR | * | CHAR (12) |
| AUFPS | Order item number | AUFPS | CHAR (2) | |
| ARTNR | Product number | ARTNR | * | CHAR (40) |
| WERKS | Plant | WERKS_D | CHAR (4) | |
| MENGE | Quantity | MENGE_D | QUAN (13) | |
| MEINS | Base Unit of Measure | MEINS | * | UNIT (3) |
| EBELN | Purchasing Document Number | EBELN | CHAR (10) | |
| EBELP | Item Number of Purchasing Document | EBELP | * | NUMC (5) |
| PROJN | Old: Project number : No longer used –> PS_POSNR | PROJN | CHAR (16) | |
| PRONR | Project Number | PRONR | CHAR (16) | |
| GKART | Offsetting Account Type | GKART | CHAR (1) | |
| GKONT | Offsetting Account Number | GKONT | CHAR (10) | |
| VBUND | Company ID of Trading Partner | RASSC | * | CHAR (6) |
| EGMLD | Reporting Country for Delivery of Goods Within the EU | EGMLD_BSEZ | * | CHAR (3) |
| STCEG | VAT Registration Number | STCEG | CHAR (20) | |
| BVORG | Number of Cross-Company Code Posting Transaction | BVORG | CHAR (16) | |
| XNEGP | Indicator: Negative Posting | XNEGP | CHAR (1) |
