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".
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 |
---|---|---|---|---|---|---|
.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 | |
EMPFG | Payment Recipient Code | X | EMPFG | CHAR | 32 | |
SAART | Record Type for Accumulated Balance Audit Trail | SAART | CHAR | 2 | ||
ALTKZ | Full Audit Trail:ID: Altern.Acct No. Filled with Credit Acct | ALTKZ | CHAR | 2 | ||
ALTKT | Account Number in Group | ALTKT | CHAR | 20 | ||
ANRED | Title | ANRED | CHAR | 30 | ||
NAME1 | Name | NAME1 | CHAR | 60 | ||
NAME2 | Name 2 | NAME2 | CHAR | 60 | ||
PSTLZ | Postal Code | PSTLZ | CHAR | 20 | ||
ORT01 | City | ORT01 | CHAR | 50 | ||
LAND1 | Country/Region Key | LAND1 | CHAR | 6 | ||
STRAS | Street and House Number | STRAS | CHAR | 60 | ||
PFACH | PO Box | PFACH | CHAR | 20 | ||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 20 | ||
ORT02 | District | ORT02 | CHAR | 50 | ||
REGIO | Region (State, Province, County) | REGIO | CHAR | 6 | ||
COUNC | County Code | COUNC | CHAR | 6 | ||
CITYC | City Code | CITYC | CHAR | 8 | ||
XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 2 | ||
XZEMP | Indicator: Alternative Payee in Document Allowed? | XZEMP | CHAR | 2 | ||
BLNKZ | (Obsolete) Subsidy Ind. for Determining the Reduction Rate | BLNKZ | CHAR | 4 | ||
KTOKS | G/L Account Group | KTOKS | CHAR | 8 | ||
KTOKK | Vendor account group | KTOKK | CHAR | 8 | ||
KTOKD | Customer Account Group | KTOKD | CHAR | 8 | ||
BANKN | Bank account number | BANKN | CHAR | 36 | ||
BANKL | Bank Keys | BANKK | CHAR | 30 | ||
BANKS | Country/Region Key of Bank | BANKS | CHAR | 6 | ||
BANKA | Name of Financial Institution | BANKA | CHAR | 120 | ||
PSKTO | PO Bank Current Acct No. or Building Society Ref. No. | PSKTO | CHAR | 32 | ||
BKONT | Bank Control Key | BKONT | CHAR | 4 | ||
BANKP | Check Digit for Bank No./Account | BANKP | CHAR | 4 | ||
SWIFT | SWIFT/BIC for International Payments | SWIFT | CHAR | 22 | ||
KNRZA | Account Number of an Alternative Payer | KNRZA | CHAR | 20 | ||
BRSCH | Industry key | BRSCH | CHAR | 8 | ||
KONZS | Group key | KONZS | CHAR | 20 | ||
KDNRE | Head Office Account Number (in branch accounts) | KNRZE | CHAR | 20 | ||
TELF1 | First telephone number | TELF1 | CHAR | 32 | ||
TELX1 | Telex number | TELX1 | CHAR | 60 | ||
TELFX | Fax Number | TELFX | CHAR | 62 | ||
TELTX | Teletex number | TELTX | CHAR | 60 | ||
DATLT | Data communication line no. | DATLT | CHAR | 28 | ||
TELBX | Telebox number | TELBX | CHAR | 30 | ||
SORTL | Sort field | SORTL | CHAR | 20 | ||
WAERS | Currency Key | WAERS | CUKY | 10 | ||
SPRAS | Language Key | SPRAS | LANG | 2 | ||
LIFNR | Account Number of Supplier | LIFNR | CHAR | 20 | ||
KUNNR | Customer Number | KUNNR | CHAR | 20 | ||
KLIMG | Credit limit: Total limit across all control areas | KLIMG | CURR | 12 | ||
BBBNR | International location number (part 1) | BBBNR | NUMC | 14 | ||
BBSNR | International location number (Part 2) | BBSNR | NUMC | 10 | ||
BUBKZ | Check digit for the international location number | BUBKZ | NUMC | 2 | ||
STCD1 | Tax Number 1 | STCD1 | CHAR | 32 | ||
STCD2 | Tax Number 2 | STCD2 | CHAR | 22 | ||
FISKN | Account number of the master record with the fiscal address | FISKN_D | CHAR | 20 | ||
STKZU | Liable for VAT | STKZU | CHAR | 2 | ||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 2 | ||
ESRNR | ISR subscriber number | ESRNR | CHAR | 22 | ||
AKONT | Reconciliation Account in General Ledger | AKONT | CHAR | 20 | ||
BEGRU | Authorization Group | BEGRU | CHAR | 8 | ||
EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR | 24 | ||
ERNAM | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
MAHNS | Dunning Level | MAHNS_D | NUMC | 2 | ||
KLIMK | Customer's credit limit | KLIMK | CURR | 12 | ||
VZSKZ | Interest Indicator | VZSKZ | CHAR | 4 | ||
DATLZ | Date of Last Interest Calculation Run | DATLZ | DATS | 16 | ||
VBUND | Company ID of Trading Partner | RASSC | CHAR | 12 | ||
BUSAB | Accounting Clerk Abbreviation | BUSAB | CHAR | 4 | ||
KNRZE | Head Office Account Number (in branch accounts) | KNRZE | CHAR | 20 | ||
PERRN | Period Indicator | PERKZ | CHAR | 2 | ||
WAKON | Terms of Payment Key for Bill of Exchange Charges | WAKON | CHAR | 8 | ||
MSCHL | Dunning Key | MSCHL | CHAR | 2 | ||
WEBTR | Bill of Exchange Limit (in Local Currency) | WEBTR | CURR | 12 | ||
REMIT | Next payee | REMIT | CHAR | 20 | ||
FDGRV | Planning Group | FDGRV | CHAR | 20 | ||
QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 20 | ||
QSZDT | Validity Date for Withholding Tax Exemption Certificate | QSZDT | DATS | 16 | ||
VRSNR | Insurance Number | VRSNR | CHAR | 20 | ||
REPRF | Check Flag for Double Invoices or Credit Memos | REPRF | CHAR | 2 | ||
DTAWS | Instruction Key for Data Medium Exchange | DTAWS | CHAR | 4 | ||
DTAMS | Report key for data medium exchange | DTAMS | CHAR | 2 |