SAP Table KOKP
Open Item Account Balance Audit Trail: Items of ALL Accounts
KOKP (Open Item Account Balance Audit Trail: Items of ALL Accounts) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link KOKP to other SAP tables.
KOKP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||||
|
KOART
Account Type
|
KOART |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BUKRS
Company Code
|
BUKRS |
CHAR
|
4 | 0 | ||||||||||||||
|
KONTO
Customer Number
|
KUNNR |
CHAR
|
10 | 0 | ||||||||||||||
|
EMPFG
Payee code
|
EMPFG |
CHAR
|
16 | 0 | ||||||||||||||
|
SAART
Record Type for Accumulated Balance Audit Trail
|
SAART |
CHAR
|
1 | 0 | ||||||||||||||
|
UMSKS
Special G/L Transaction Type
|
UMSKS |
CHAR
|
1 | 0 | ||||||||||||||
|
UMSAT
Special G/L Indicator
|
UMSKZ |
CHAR
|
1 | 0 | ||||||||||||||
|
HKONT
General Ledger Account
|
HKONT |
CHAR
|
10 | 0 | ||||||||||||||
|
POART
Item Sort Indicator in the Balance Audit Trail
|
POART_KOKP |
CHAR
|
1 | 0 | ||||||||||||||
|
AUGDT
Clearing Date
|
AUGDT |
DATS
|
8 | 0 | ||||||||||||||
|
AUGBL
Document Number of the Clearing Document
|
AUGBL |
CHAR
|
10 | 0 | ||||||||||||||
|
BUPER
Posting period in the form YYYYMM
|
BUPER |
ACCP
|
6 | 0 | ||||||||||||||
|
BUDAT
Posting Date in the Document
|
BUDAT |
DATS
|
8 | 0 | ||||||||||||||
|
BELNR
Accounting Document Number
|
BELNR_D |
CHAR
|
10 | 0 | ||||||||||||||
|
BUZEI
Number of Line Item Within Accounting Document
|
BUZEI |
NUMC
|
3 | 0 | ||||||||||||||
|
CPUDT
Day On Which Accounting Document Was Entered
|
CPUDT |
DATS
|
8 | 0 | ||||||||||||||
|
BLART
Document Type
|
BLART |
CHAR
|
2 | 0 | ||||||||||||||
|
BLDAT
Document Date in Document
|
BLDAT |
DATS
|
8 | 0 | ||||||||||||||
|
AUGCP
Clearing Entry Date
|
AUGCP |
DATS
|
8 | 0 | ||||||||||||||
|
WAERS
Currency Key
|
WAERS |
CUKY
|
5 | 0 | ||||||||||||||
|
XBLNR
Reference Document Number
|
XBLNR1 |
CHAR
|
16 | 0 | ||||||||||||||
|
ALTKZ
Full audit trail:ID:Altern.acct no. filled with credit acct
|
ALTKZ |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ALTKT
Account Number in Group
|
ALTKT |
CHAR
|
10 | 0 | ||||||||||||||
|
USNAM
User name
|
USNAM |
CHAR
|
12 | 0 | ||||||||||||||
|
STAKZ
Indicator. object is statistical
|
STAKZ |
CHAR
|
1 | 0 | ||||||||||||||
|
DBBLG
Recurring Entry Document Number
|
DBBLG |
CHAR
|
10 | 0 | ||||||||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||||||
|
UPDDT
Date of the Last Document Update
|
UPDDT |
DATS
|
8 | 0 | ||||||||||||||
|
BKTXT
Document Header Text
|
BKTXT |
CHAR
|
25 | 0 | ||||||||||||||
|
XKRES
Indicator: Can Line Items Be Displayed by Account?
|
XKRES |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XOPVW
Indicator: Open item management?
|
XOPVW |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BSCHL
Posting Key
|
BSCHL |
CHAR
|
2 | 0 | ||||||||||||||
|
UMSKZ
Special G/L Indicator
|
UMSKZ |
CHAR
|
1 | 0 | ||||||||||||||
|
XUMSW
Indicator: Sales-related item ?
|
XUMSW |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
SHKZG
Debit/Credit Indicator
|
SHKZG |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
MWSKZ
Tax on sales/purchases code
|
MWSKZ |
CHAR
|
2 | 0 | ||||||||||||||
|
DMBTR
Amount in Local Currency
|
DMBTR |
CURR
|
13 | 2 | ||||||||||||||
|
WRBTR
Amount in document currency
|
WRBTR |
CURR
|
13 | 2 | ||||||||||||||
|
MWSTS
Tax Amount in Local Currency
|
MWSTS |
CURR
|
13 | 2 | ||||||||||||||
|
WMWST
Tax amount in document currency
|
WMWST |
CURR
|
13 | 2 | ||||||||||||||
|
MWSHB
Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign
|
MWSHB |
CURR
|
13 | 2 | ||||||||||||||
|
XZAHL
Indicator: Is the posting key used in a payment transaction?
|
XZAHL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ZINKZ
Exempted from interest calculation
|
DZINKZ |
CHAR
|
2 | 0 | ||||||||||||||
|
||||||||||||||||||
|
GSBER
Business Area
|
GSBER |
CHAR
|
4 | 0 | ||||||||||||||
|
SAKNR
G/L Account Number
|
SAKNR |
CHAR
|
10 | 0 | ||||||||||||||
|
FILKD
Account Number of the Branch
|
FILKD |
CHAR
|
10 | 0 | ||||||||||||||
|
SKNTO
Cash discount amount in local currency
|
SKNTO |
CURR
|
13 | 2 | ||||||||||||||
|
WSKTO
Cash discount amount in document currency
|
WSKTO |
CURR
|
13 | 2 | ||||||||||||||
|
ZUONR
Assignment Number
|
DZUONR |
CHAR
|
18 | 0 | ||||||||||||||
|
NETDT
Due Date for Net Payment
|
NETDT |
DATS
|
8 | 0 | ||||||||||||||
|
ZFBDT
Baseline Date for Due Date Calculation
|
DZFBDT |
DATS
|
8 | 0 | ||||||||||||||
|
SKFBT
Amount Eligible for Cash Discount in Document Currency
|
SKFBT |
CURR
|
13 | 2 | ||||||||||||||
|
MDSHB
Tax on Sales/Purchases amount in Local Curr. with +/- Sign
|
MDSHB |
CURR
|
13 | 2 | ||||||||||||||
|
HWBAS
Tax Base Amount in Local Currency
|
HWBAS |
CURR
|
13 | 2 | ||||||||||||||
|
VALUT
Value date
|
VALUT |
DATS
|
8 | 0 | ||||||||||||||
|
FWBAS
Tax Base Amount in Document Currency
|
FWBAS |
CURR
|
13 | 2 | ||||||||||||||
|
BSTNR
Purchase Order Number
|
BSTNR |
CHAR
|
10 | 0 | ||||||||||||||
|
SGTXT
Item Text
|
SGTXT |
CHAR
|
50 | 0 | ||||||||||||||
|
GKART
Offsetting Account Type
|
GKART |
CHAR
|
1 | 0 | ||||||||||||||
|
GKONT
Offsetting Account Number
|
GKONT |
CHAR
|
10 | 0 | ||||||||||||||
|
ZLSCH
Payment Method
|
DZLSCH |
CHAR
|
1 | 0 | ||||||||||||||
|
MSCHL
Dunning key
|
MSCHL |
CHAR
|
1 | 0 | ||||||||||||||
|
ZTERM
Terms of Payment Key
|
DZTERM |
CHAR
|
4 | 0 | ||||||||||||||
|
ZBD1T
Cash discount days 1
|
DZBD1T |
DEC
|
3 | 0 | ||||||||||||||
|
ZBD1P
Cash Discount Percentage 1
|
DZBD1P |
DEC
|
5 | 3 | ||||||||||||||
|
ZBD2T
Cash discount days 2
|
DZBD2T |
DEC
|
3 | 0 | ||||||||||||||
|
ZBD2P
Cash Discount Percentage 2
|
DZBD2P |
DEC
|
5 | 3 | ||||||||||||||
|
ZBD3T
Net Payment Terms Period
|
DZBD3T |
DEC
|
3 | 0 | ||||||||||||||
|
NEBTR
Net Payment Amount
|
NEBTR |
CURR
|
13 | 2 | ||||||||||||||
|
QSSKZ
Withholding Tax Code
|
QSSKZ |
CHAR
|
2 | 0 | ||||||||||||||
|
REBZG
Number of the Invoice the Transaction Belongs to
|
REBZG |
CHAR
|
10 | 0 | ||||||||||||||
|
REBZZ
Line Item in the Relevant Invoice
|
REBZZ |
NUMC
|
3 | 0 | ||||||||||||||
|
XCPDK
Indicator: Is the account a one-time account?
|
XCPDK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BVORG
Number of Cross-Company Code Posting Transaction
|
BVORG |
CHAR
|
16 | 0 | ||||||||||||||
|
XNEGP
Indicator: Negative posting
|
XNEGP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||