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 |