SAP ABAP Table DKOKS (Open Item Account Balance Audit Trail Master Record)

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	DKOKS	Table Relationship Diagram
Short Description	Open Item Account Balance Audit Trail Master Record

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	EMPFG	☑	EMPFG	EMPFG	CHAR	16	0	Payee code
7	SAART	☐	SAART	CHAR1	CHAR	1	0	Record Type for Accumulated Balance Audit Trail
8	ALTKZ	☐	ALTKZ	XFELD	CHAR	1	0	Full audit trail:ID:Altern.acct no. filled with credit acct
9	ALTKT	☐	ALTKT	ALTKT	CHAR	10	0	Account Number in Group
10	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
11	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
12	NAME2	☐	NAME2	TEXT30	CHAR	30	0	Name 2
13	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
14	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
15	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
16	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
17	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
18	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
19	ORT02	☐	ORT02	TEXT25	CHAR	25	0	District
20	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
21	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
22	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
23	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
24	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
25	BLNKZ	☐	BLNKZ	BLNKZ	CHAR	2	0	Subsidy Indicator for Determining the Reduction Rates	*
26	KTOKS	☐	KTOKS	KTOKS	CHAR	4	0	G/L Account Group	*
27	KTOKK	☐	KTOKK	KTOKK	CHAR	4	0	Vendor account group	*
28	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
29	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
30	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
31	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
32	BANKA	☐	BANKA	TEXT60	CHAR	60	0	Name of bank
33	PSKTO	☐	PSKTO	PSKTO	CHAR	16	0	Account Number of Bank Account At Post Office
34	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
35	BANKP	☐	BANKP	BANKP	CHAR	2	0	Check Digit for Bank No./Account
36	SWIFT	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
37	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	*
38	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
39	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
40	KDNRE	☐	KNRZE	KUNNR	CHAR	10	0	Head office account number (in branch accounts)	*
41	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
42	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
43	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
44	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
45	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
46	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
47	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
48	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
49	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
50	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
51	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
52	KLIMG	☐	KLIMG	WERT8	CURR	15	2	Credit limit: Total limit across all control areas
53	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
54	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
55	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
56	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
57	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
58	FISKN	☐	FISKN_D	KUNNR	CHAR	10	0	Account number of the master record with the fiscal address	*
59	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
60	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
61	ESRNR	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
62	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	*
63	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
64	EIKTO	☐	EIKTO	CHAR12	CHAR	12	0	Shipper's (Our) Account Number at the Customer or Vendor
65	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
66	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	*
67	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
68	ZAMIM	☐	DZAMIM	XFELD	CHAR	1	0	Indicator: Payment notice to customer (with cleared items)?
69	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
70	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	*
71	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
72	KLIMK	☐	KLIMK	WERT8	CURR	15	2	Customer's credit limit
73	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	*
74	ZINDT	☐	DZINDT	DATUM	DATS	8	0	Key date of the last interest calculation
75	ZINRT	☐	DZINRT	ZINRT	NUMC	2	0	Interest calculation frequency in months
76	DATLZ	☐	DATLZ	DATUM	DATS	8	0	Date of the last interest calculation run
77	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
78	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	*
79	KNRZE	☐	KNRZE	KUNNR	CHAR	10	0	Head office account number (in branch accounts)	*
80	PERRN	☐	PERKZ	PERKZ	CHAR	1	0	Period indicator
81	WAKON	☐	WAKON	ZTERM	CHAR	4	0	Terms of payment key for bill of exchange charges
82	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	*
83	WEBTR	☐	WEBTR	WERT7	CURR	13	2	Bill of exchange limit (in local currency)
84	REMIT	☐	REMIT	KUNNR	CHAR	10	0	Next payee	*
85	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	*
86	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
87	QSZDT	☐	QSZDT	DATUM	DATS	8	0	Validity Date for Withholding Tax Exemption Certificate
88	VRSNR	☐	VRSNR	CHAR10	CHAR	10	0	Insurance number
89	REPRF	☐	REPRF	XFELD	CHAR	1	0	Check Flag for Double Invoices or Credit Memos
90	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
91	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange

History

Last changed by/on	SAP	20130529
SAP Release Created in