SAP ABAP Table DKOKP (Open Item Account Balance Audit Trail)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FREP (Package) RF reporting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DKOKP	Table Relationship Diagram
Short Description	Open Item Account Balance Audit Trail

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	Open Item Account Balance Audit Trail Key
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	KOART	☑	KOART	KOART	CHAR	1	0	Account type
4	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
5	KONTO	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
6	.INCLUDE	☑				0	0	Open Item Account Balance Audit Trail Key
7	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
8	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
9	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
10	EMPFG	☐	EMPFG	EMPFG	CHAR	16	0	Payee code
11	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
12	UMSAT	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
13	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
14	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
15	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
16	BUPEM	☐	BUPEM	BUPEM	NUMC	2	0	Posting Period Month in Form MM
17	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
18	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
19	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
20	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
21	AUGCP	☐	AUGCP	DATUM	DATS	8	0	Clearing Entry Date
22	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
23	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
24	ALTKZ	☐	ALTKZ	XFELD	CHAR	1	0	Full audit trail:ID:Altern.acct no. filled with credit acct
25	ALTKT	☐	ALTKT	ALTKT	CHAR	10	0	Account Number in Group
26	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
27	STAKZ	☐	STAKZ	CHAR1	CHAR	1	0	Indicator. object is statistical
28	DBBLG	☐	DBBLG	BELNR	CHAR	10	0	Recurring Entry Document Number
29	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
30	UPDDT	☐	UPDDT	DATUM	DATS	8	0	Date of the Last Document Update
31	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
32	XKRES	☐	XKRES	XFELD	CHAR	1	0	Indicator: Can Line Items Be Displayed by Account?
33	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
34	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
35	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
36	XUMSW	☐	XUMSW	XFELD	CHAR	1	0	Indicator: Sales-Related Item ?
37	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
38	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
39	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
40	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
41	MWSTS	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
42	WMWST	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
43	MWSHB	☐	MWSHB	WRTV7	CURR	13	2	Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign
44	XZAHL	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
45	ZINKZ	☐	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
46	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
47	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
48	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
49	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
50	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
51	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
52	NETDT	☐	NETDT	DATUM	DATS	8	0	Due Date for Net Payment
53	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
54	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
55	MDSHB	☐	MDSHB	WRTV7	CURR	13	2	Tax on Sales/Purchases amount in Local Curr. with +/- Sign
56	HWBAS	☐	HWBAS	WERT7	CURR	13	2	Tax Base Amount in Local Currency
57	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
58	FWBAS	☐	FWBAS	WERT7	CURR	13	2	Tax Base Amount in Document Currency
59	BSTNR	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	*
60	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
61	GKART	☐	GKART	GKART	CHAR	1	0	Offsetting Account Type
62	GKONT	☐	GKONT	GKONT	CHAR	10	0	Offsetting Account Number
63	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
64	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	*
65	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
66	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
67	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
68	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
69	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
70	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
71	NEBTR	☐	NEBTR	WERT7	CURR	13	2	Net Payment Amount
72	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
73	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
74	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
75	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
76	BVORG	☐	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
77	XNEGP	☐	XNEGP	XFELD	CHAR	1	0	Indicator: Negative posting

History

Last changed by/on	SAP	20130529
SAP Release Created in