SAP table KOKP (Open Item Account Balance Audit Trail: Items of ALL Accounts)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
BUKRS Company Code CHAR 4 0 BUKRS
KONTO Customer Number CHAR 10 0 KUNNR
EMPFG Payment Recipient Code CHAR 16 0 EMPFG
SAART Record Type for Accumulated Balance Audit Trail CHAR 1 0 SAART
UMSKS Special G/L Transaction Type CHAR 1 0 UMSKS
UMSAT Special G/L Indicator CHAR 1 0 UMSKZ
HKONT General Ledger Account CHAR 10 0 HKONT
POART Item Sort Indicator in the Balance Audit Trail CHAR 1 0 POART_KOKP
AUGDT Clearing Date DATS 8 0 AUGDT
AUGBL Document Number of the Clearing Document CHAR 10 0 AUGBL
BUPER Posting period in the form YYYYMM ACCP 6 0 BUPER
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
BLART Document Type CHAR 2 0 BLART
BLDAT Document Date in Document DATS 8 0 BLDAT
AUGCP Clearing Entry Date DATS 8 0 AUGCP
WAERS Currency Key CUKY 5 0 WAERS
XBLNR Reference Document Number CHAR 16 0 XBLNR1
ALTKZ Full Audit Trail:ID: Altern.Acct No. Filled with Credit Acct CHAR 1 0 ALTKZ
ALTKT Account Number in Group CHAR 10 0 ALTKT
USNAM User Name CHAR 12 0 USNAM
STAKZ Indicator. Object Is Statistical CHAR 1 0 STAKZ
DBBLG Recurring Entry Document Number CHAR 10 0 DBBLG
AEDAT Last Changed On DATS 8 0 AEDAT
UPDDT Date of the Last Document Update DATS 8 0 UPDDT
BKTXT Document Header Text CHAR 25 0 BKTXT
XKRES Indicator: Can Line Items Be Displayed by Account? CHAR 1 0 XKRES
XOPVW Indicator: Open Item Management? CHAR 1 0 XOPVW
BSCHL Posting Key CHAR 2 0 BSCHL
UMSKZ Special G/L Indicator CHAR 1 0 UMSKZ
XUMSW Indicator: Sales-Related Item ? CHAR 1 0 XUMSW
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
DMBTR Amount in local currency CURR 23 2 DMBTR
WRBTR Amount in document currency CURR 23 2 WRBTR
MWSTS Tax Amount in Local Currency CURR 23 2 MWSTS
WMWST Tax Amount in Document Currency CURR 23 2 WMWST
MWSHB Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign CURR 23 2 MWSHB
XZAHL Indicator: Is Posting Key Used in a Payment Transaction? CHAR 1 0 XZAHL
ZINKZ Exempted from Interest Calculation CHAR 2 0 DZINKZ
GSBER Business Area CHAR 4 0 GSBER
SAKNR G/L Account Number CHAR 10 0 SAKNR
FILKD Account Number of the Branch CHAR 10 0 FILKD
SKNTO Cash Discount Amount in Local Currency CURR 23 2 SKNTO
WSKTO Cash Discount Amount in Document Currency CURR 23 2 WSKTO
ZUONR Assignment number CHAR 18 0 DZUONR
NETDT Net Due Date DATS 8 0 NETDT
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
SKFBT Amount Eligible for Cash Discount in Document Currency CURR 23 2 SKFBT
MDSHB Tax on Sales/Purchases Amount in Local Curr. with +/- Sign CURR 23 2 MDSHB
HWBAS Tax Base Amount in Local Currency CURR 23 2 HWBAS
VALUT Value date DATS 8 0 VALUT
FWBAS Tax Base Amount in Document Currency CURR 23 2 FWBAS
BSTNR Purchase order number CHAR 10 0 BSTNR
SGTXT Item Text CHAR 50 0 SGTXT
GKART Offsetting Account Type CHAR 1 0 GKART
GKONT Offsetting Account Number CHAR 10 0 GKONT
ZLSCH Payment Method CHAR 1 0 DZLSCH
MSCHL Dunning Key CHAR 1 0 MSCHL
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZBD1T Cash discount days 1 DEC 3 0 DZBD1T
ZBD1P Cash discount percentage 1 DEC 5 3 DZBD1P
ZBD2T Cash discount days 2 DEC 3 0 DZBD2T
ZBD2P Cash Discount Percentage 2 DEC 5 3 DZBD2P
ZBD3T Net Payment Terms Period DEC 3 0 DZBD3T
NEBTR Net Payment Amount CURR 23 2 NEBTR
QSSKZ Withholding Tax Code CHAR 2 0 QSSKZ
REBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
REBZZ Line Item in the Relevant Invoice NUMC 3 0 REBZZ
XCPDK Indicator: Is the account a one-time account? CHAR 1 0 XCPDK
BVORG Number of Cross-Company Code Posting Transaction CHAR 16 0 BVORG
XNEGP Indicator: Negative Posting CHAR 1 0 XNEGP