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".
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 |
|---|---|---|---|---|---|---|
| .INCLUDE | X | KOKS_KEY | 0 | |||
| MANDT | Client | X | MANDT | CLNT | 6 | * |
| KOART | Account type | X | KOART | CHAR | 2 | |
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | |
| KONTO | Customer Number | X | KUNNR | CHAR | 20 | |
| .INCLUDE | X | KOKP_KEY | 0 | |||
| GJAHR | Fiscal Year | X | GJAHR | NUMC | 8 | |
| BELNR | Document Number of an Accounting Document | X | BELNR_D | CHAR | 20 | |
| BUZEI | Number of Line Item Within Accounting Document | X | BUZEI | NUMC | 6 | |
| EMPFG | Payment Recipient Code | EMPFG | CHAR | 32 | ||
| UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 2 | ||
| UMSAT | Special G/L Indicator | UMSKZ | CHAR | 2 | ||
| HKONT | General Ledger Account | HKONT | CHAR | 20 | ||
| AUGDT | Clearing Date | AUGDT | DATS | 16 | ||
| AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 20 | ||
| BUPEM | Posting Period Month in Form MM | BUPEM | NUMC | 4 | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 16 | ||
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 16 | ||
| BLART | Document Type | BLART | CHAR | 4 | ||
| BLDAT | Document Date in Document | BLDAT | DATS | 16 | ||
| AUGCP | Clearing Entry Date | AUGCP | DATS | 16 | ||
| WAERS | Currency Key | WAERS | CUKY | 10 | ||
| XBLNR | Reference Document Number | XBLNR1 | CHAR | 32 | ||
| ALTKZ | Full Audit Trail:ID: Altern.Acct No. Filled with Credit Acct | ALTKZ | CHAR | 2 | ||
| ALTKT | Account Number in Group | ALTKT | CHAR | 20 | ||
| USNAM | User Name | USNAM | CHAR | 24 | ||
| STAKZ | Indicator. Object Is Statistical | STAKZ | CHAR | 2 | ||
| DBBLG | Recurring Entry Document Number | DBBLG | CHAR | 20 | ||
| AEDAT | Last Changed On | AEDAT | DATS | 16 | ||
| UPDDT | Date of the Last Document Update | UPDDT | DATS | 16 | ||
| BKTXT | Document Header Text | BKTXT | CHAR | 50 | ||
| XKRES | Indicator: Can Line Items Be Displayed by Account? | XKRES | CHAR | 2 | ||
| XOPVW | Indicator: Open Item Management? | XOPVW | CHAR | 2 | ||
| BSCHL | Posting Key | BSCHL | CHAR | 4 | ||
| UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 2 | ||
| XUMSW | Indicator: Sales-Related Item ? | XUMSW | CHAR | 2 | ||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 2 | ||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 4 | ||
| DMBTR | Amount in local currency | DMBTR | CURR | 12 | ||
| WRBTR | Amount in document currency | WRBTR | CURR | 12 | ||
| MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 12 | ||
| WMWST | Tax Amount in Document Currency | WMWST | CURR | 12 | ||
| MWSHB | Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign | MWSHB | CURR | 12 | ||
| XZAHL | Indicator: Is Posting Key Used in a Payment Transaction? | XZAHL | CHAR | 2 | ||
| GSBER | Business Area | GSBER | CHAR | 8 | ||
| SAKNR | G/L Account Number | SAKNR | CHAR | 20 | ||
| FILKD | Account Number of the Branch | FILKD | CHAR | 20 | ||
| SKNTO | Cash Discount Amount in Local Currency | SKNTO | CURR | 12 | ||
| WSKTO | Cash Discount Amount in Document Currency | WSKTO | CURR | 12 | ||
| NETDT | Net Due Date | NETDT | DATS | 16 | ||
| SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 12 | ||
| MDSHB | Tax on Sales/Purchases Amount in Local Curr. with +/- Sign | MDSHB | CURR | 12 | ||
| HWBAS | Tax Base Amount in Local Currency | HWBAS | CURR | 12 | ||
| VALUT | Value date | VALUT | DATS | 16 | ||
| FWBAS | Tax Base Amount in Document Currency | FWBAS | CURR | 12 | ||
| BSTNR | Purchase order number | BSTNR | CHAR | 20 | ||
| SGTXT | Item Text | SGTXT | CHAR | 100 | ||
| GKART | Offsetting Account Type | GKART | CHAR | 2 | ||
| GKONT | Offsetting Account Number | GKONT | CHAR | 20 | ||
| MSCHL | Dunning Key | MSCHL | CHAR | 2 | ||
| NEBTR | Net Payment Amount | NEBTR | CURR | 12 | ||
| QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 4 | ||
| REBZG | Document No. of the Invoice to Which the Transaction Belongs | REBZG | CHAR | 20 | ||
| REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 6 | ||
| XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 2 | ||
| BVORG | Number of Cross-Company Code Posting Transaction | BVORG | CHAR | 32 | ||
| XNEGP | Indicator: Negative Posting | XNEGP | CHAR | 2 |