1. Home
  2. Resources
  3. SAP Tables
  4. KOKP - Open Item Account Balance Audit Trail: Items of ALL Accounts

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
MANDT Client MANDT CLNT 3 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
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
X Yes
NULL No
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
X Yes
NULL No
XOPVW Indicator: Open item management? XOPVW CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
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
X Yes
NULL No
ZINKZ Exempted from interest calculation DZINKZ CHAR 2 0
A Reasons for block
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
X Yes
NULL No
BVORG Number of Cross-Company Code Posting Transaction BVORG CHAR 16 0
XNEGP Indicator: Negative posting XNEGP CHAR 1 0
X Yes
NULL No