	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

167 COLUMNS | 2 INDEXES | ERP 6.0 | DFKKOP_REP TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting :: Contract Accounts Receivable and Payable
1	ERP EHP7	6.0	DFKKOP_REP	167	2	Open Items from FPO4	Contract Accounts Receivable and Payable

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT CLIENT, KEYDT, INTNR, LFDNR, MANDT, OPBEL, OPUPW, OPUPK, OPUPZ, BUKRS, GSBER, BUPLA, SEGMENT, PRCTR, AUGST, GPART, VTREF, VTPOS, VTRE2, VKONT, ABWBL, ABWTP, ABWKT, APPLK, HVORG, TVORG, KOFIZ, SPART, HKONT, MWSKZ, MWSZKZ, XANZA, STAKZ, BLDAT, BUDAT, OPTXT, WAERS, FAEDN, FAEDS, VERKZ, STUDT, SKTPZ, XMANL, KURSF, BETRH, BETRW, BETR2, BETR3, SKFBT, SBETH, SBETW, SBET2, SBET3, MWSKO, MWVKO, TXRUL, SPZAH, PYMET, PYBUK, PERNR, GRKEY, PERSL, XAESP, AUGDT, AUGBL, AUGBD, AUGRD, AUGWA, AUGBT, AUGBS, AUGSK, AUGVD, AUGOB, WHANG, WHGRP, XEIPH, MAHNV, MANSP, XAUGP, ABRZU, ABRZO, FDGRP, FDLEV, FDZTG, FDWBT, XTAUS, AUGRS, PYGRP, PDTYP, SPERZ, INFOZ, TXJCD, TXDAT, VBUND, KONTT, KONTL, OPSTA, BLART, EMGPA, EMBVT, EMADR, IKEY, EUROU, XRAGL, XWHPO, ASTKZ, ASBLG, XBLNR, INKPS, RNDPS, QSSKZ, QSSEW, QSPTP, QSSHB, QBSHB, QSPRZ, QSZNR, XWHEX, RFUPK, STRKZ, FITPR, XPYOR, LANDL, INTBU, EMCRD, C4EYE, CFOPN, C4EYP, TXGRP, SCTAX, STTAX, STZAL, ORUPZ, NEGBU, SUBAP, PSWSL, PSWBT, PSWTX, PSGRP, XCOLC, AASTA, XCSHA, REACC, REBUK, XUSTPD, PTITM, EMMND, PNNUM, PNHKF, PNEXD, PNCTR, FINRE, RDSTA, RDSTB, FMTYP, ORIGFIKRS, FIPEX, FISTL, FONDS, FKBER, MEASURE, GRANT_NBR, BUDGETYEAR, BUDGET_PD, COPY, WAERH, MARK FROM DFKKOP_REP

TOP ERP 6.0 | DFKKOP_REP COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	KEYDT	Key Date for Analysis of Open Items	nvarchar	8	0	DATS	(N'00000000')	No		OP_KEYDATE_KK	Allow NULL?
3	INTNR	Number of interval within variant	int	10	0	INT4	((0))	No		INTNR_KK	Allow NULL?
4	LFDNR	Natural Number	int	10	0	INT4	((0))	No		INT4	Allow NULL?
5	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	Yes	*	MANDT	Allow NULL?
6	OPBEL	Number of Contract Accts Rec. & Payable Doc.	nvarchar	12	0	CHAR	(N' ')	Yes	*	OPBEL_KK	Allow NULL?
7	OPUPW	Repetition Item in Contract Account Document	nvarchar	3	0	NUMC	(N'000')	Yes		OPUPW_KK	Allow NULL?
8	OPUPK	Item number in contract account document	nvarchar	4	0	NUMC	(N'0000')	Yes		OPUPK_KK	Allow NULL?
9	OPUPZ	Subitem for a Partial Clearing in Document	nvarchar	3	0	NUMC	(N'000')	Yes		OPUPZ_KK	Allow NULL?
10	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
11	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
12	BUPLA	Business Place	nvarchar	4	0	CHAR	(N' ')	Yes	J_1BBRANCH	BUPLA	Allow NULL?
13	SEGMENT	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	FAGL_SEGM	SEGMT_KK	Allow NULL?
14	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
15	AUGST	Clearing status	char	1	0	CHAR	(N' ')	Yes		AUGST_KK	Allow NULL?
16	GPART	Business Partner Number	nvarchar	10	0	CHAR	(N' ')	Yes	BUT000	GPART_KK	Allow NULL?
17	VTREF	Reference Specifications from Contract	nvarchar	20	0	CHAR	(N' ')	Yes		VTREF_KK	Allow NULL?
18	VTPOS	Contract: Item Number	nvarchar	6	0	NUMC	(N'000000')	Yes		VTPOS_KK	Allow NULL?
19	VTRE2	Additional Reference Information	nvarchar	20	0	CHAR	(N' ')	Yes		VTRE2_KK	Allow NULL?
20	VKONT	Contract Account Number	nvarchar	12	0	CHAR	(N' ')	Yes	FKKVK	VKONT_KK	Allow NULL?
21	ABWBL	Number of the substitute FI-CA document	nvarchar	12	0	CHAR	(N' ')	Yes		ABWBL_KK	Allow NULL?
22	ABWTP	Category of substitute document in FI-CA	char	1	0	CHAR	(N' ')	Yes		ABWTP_KK	Allow NULL?
23	ABWKT	Alternative contract account for collective bills	nvarchar	12	0	CHAR	(N' ')	Yes	*	ABWVK_KK	Allow NULL?
24	APPLK	Application area	char	1	0	CHAR	(N' ')	Yes		APPLK_KK	Allow NULL?
25	HVORG	Main Transaction for Line Item	nvarchar	4	0	CHAR	(N' ')	Yes	TFKHVO	HVORG_KK	Allow NULL?
26	TVORG	Subtransaction for Document Item	nvarchar	4	0	CHAR	(N' ')	Yes	TFKTVO	TVORG_KK	Allow NULL?
27	KOFIZ	Account Determination ID	nvarchar	2	0	CHAR	(N' ')	Yes		KOFIZ_KK	Allow NULL?
28	SPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	SPART_KK	Allow NULL?
29	HKONT	General ledger account	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	HKONT_KK	Allow NULL?
30	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKZ	Allow NULL?
31	MWSZKZ	Supplementary Tax	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSZKZ_KK	Allow NULL?
32	XANZA	Item is a Down Payment/Down Payment Request	char	1	0	CHAR	(N' ')	Yes		XANZA_KK	Allow NULL?
33	STAKZ	Type of statistical item	char	1	0	CHAR	(N' ')	Yes		STAKZ_KK	Allow NULL?
34	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BLDAT	Allow NULL?
35	BUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT_KK	Allow NULL?
36	OPTXT	Item text	nvarchar	50	0	CHAR	(N' ')	Yes		OPTXT_KK	Allow NULL?
37	WAERS	Transaction Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	BLWAE_KK	Allow NULL?
38	FAEDN	Due date for net payment	nvarchar	8	0	DATS	(N'00000000')	Yes		FAEDN_KK	Allow NULL?
39	FAEDS	Due Date for Cash Discount	nvarchar	8	0	DATS	(N'00000000')	Yes		FAEDS_KK	Allow NULL?
40	VERKZ	Item Can Only Be Cleared	char	1	0	CHAR	(N' ')	Yes		VERKZ_KK	Allow NULL?
41	STUDT	Deferral to	nvarchar	8	0	DATS	(N'00000000')	Yes		STUDT_KK	Allow NULL?
42	SKTPZ	Cash discount rate	decimal	5	3	DEC	((0))	Yes		SKTPZ_KK
43	XMANL	Exclude Item from Dunning Run	char	1	0	CHAR	(N' ')	Yes		XMANL_KK	Allow NULL?
44	KURSF	Exchange rate	decimal	9	5	DEC	((0))	Yes		KURSF_KK
45	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2	CURR	((0))	Yes		BETRH_KK
46	BETRW	Amount in Transaction Currency with +/- Sign	decimal	13	2	CURR	((0))	Yes		BETRW_KK
47	BETR2	Amount in second parallel currency with +/- sign	decimal	13	2	CURR	((0))	Yes		BETR2_KK
48	BETR3	Amount in third parallel currency with +/- sign	decimal	13	2	CURR	((0))	Yes		BETR3_KK
49	SKFBT	Amount eligible for cash discount in document currency	decimal	13	2	CURR	((0))	Yes		SKFBT_KK
50	SBETH	Tax Amount in Local Currency With +/- Sign	decimal	13	2	CURR	((0))	Yes		SBETH_KK
51	SBETW	Tax Amount in Transaction Currency with +/- Sign	decimal	13	2	CURR	((0))	Yes		SBETW_KK
52	SBET2	Tax amount in second parallel currency	decimal	13	2	CURR	((0))	Yes		SBET2_KK
53	SBET3	Tax amount in third parallel currency	decimal	13	2	CURR	((0))	Yes		SBET3_KK
54	MWSKO	Account for posting taxes for down payments	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	MWSKO_KK	Allow NULL?
55	MWVKO	Account for offsetting tax posting in down payments	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	MWVKO_KK	Allow NULL?
56	TXRUL	Update Rule for Tax and Tax Clearing	char	1	0	CHAR	(N' ')	Yes		TXRUL_KK	Allow NULL?
57	SPZAH	Lock Reason for Automatic Payment	char	1	0	CHAR	(N' ')	Yes	TFK008	SPZAH_KK	Allow NULL?
58	PYMET	Payment Method	char	1	0	CHAR	(N' ')	Yes	*	PYMET_KK	Allow NULL?
59	PYBUK	Company Code for Automatic Payment Transactions	nvarchar	4	0	CHAR	(N' ')	Yes	T001	PYBUK_KK	Allow NULL?
60	PERNR	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		PERNR_D	Allow NULL?
61	GRKEY	Grouping Key for Displaying Open Items	nvarchar	3	0	CHAR	(N' ')	Yes		GRKEY_KK	Allow NULL?
62	PERSL	Key for Period Assignment	nvarchar	4	0	CHAR	(N' ')	Yes	TFK001P	PERSL_KK	Allow NULL?
63	XAESP	Printing - No Changes Possible	char	1	0	CHAR	(N' ')	Yes		XAESP_KK	Allow NULL?
64	AUGDT	Clearing date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGDT_KK	Allow NULL?
65	AUGBL	Clearing Document or Printed Document	nvarchar	12	0	CHAR	(N' ')	Yes		AUGBL_KK	Allow NULL?
66	AUGBD	Clearing document posting date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGBD_KK	Allow NULL?
67	AUGRD	Clearing Reason	nvarchar	2	0	CHAR	(N' ')	Yes	TFK001A	AUGRD_KK	Allow NULL?
68	AUGWA	Clearing currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	AUGWA_KK	Allow NULL?
69	AUGBT	Clearing amount in clearing currency	decimal	13	2	CURR	((0))	Yes		AUGBT_KK
70	AUGBS	Tax amount in clearing currency	decimal	13	2	CURR	((0))	Yes		AUGBS_KK
71	AUGSK	Cash Discount Granted/Surcharge Levied in Clearing Currency	decimal	13	2	CURR	((0))	Yes		AUGSK_KK
72	AUGVD	Value date for clearing	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGVD_KK	Allow NULL?
73	AUGOB	Item Canceled	char	1	0	CHAR	(N' ')	Yes		AUGOB_KK	Allow NULL?
74	WHANG	Number of repetition items	nvarchar	3	0	NUMC	(N'000')	Yes		WHANG_KK	Allow NULL?
75	WHGRP	Repetition group	nvarchar	3	0	NUMC	(N'000')	Yes	*	WHGRP_KK	Allow NULL?
76	XEIPH	Create Line Item in General Ledger	char	1	0	CHAR	(N' ')	Yes		XEIPH_KK	Allow NULL?
77	MAHNV	Dunning Procedure	nvarchar	2	0	CHAR	(N' ')	Yes	TFK047A	MAHNV_KK	Allow NULL?
78	MANSP	Dunning Lock Reason	char	1	0	CHAR	(N' ')	Yes	TFK047S	MANSP_KK	Allow NULL?
79	XAUGP	Check Sample Record Clearing	char	1	0	CHAR	(N' ')	Yes		XAUGP_KK	Allow NULL?
80	ABRZU	Lower Limit of Settlement Period	nvarchar	8	0	DATS	(N'00000000')	Yes		ABRZU_KK	Allow NULL?
81	ABRZO	Upper Limit of the Billing Period	nvarchar	8	0	DATS	(N'00000000')	Yes		ABRZO_KK	Allow NULL?
82	FDGRP	Planning Group	nvarchar	10	0	CHAR	(N' ')	Yes	T035	FDGRP_KK	Allow NULL?
83	FDLEV	Planning level	nvarchar	2	0	CHAR	(N' ')	Yes	T036	FDLEV_KK	Allow NULL?
84	FDZTG	Additional Days for Cash Management	nvarchar	2	0	NUMC	(N'00')	Yes		FDZTG_KK	Allow NULL?
85	FDWBT	Planning amount in document currency	decimal	13	2	CURR	((0))	Yes		FDWBT
86	XTAUS	Item Split	char	1	0	CHAR	(N' ')	Yes		XTAUS_KK	Allow NULL?
87	AUGRS	Clearing restriction	char	1	0	CHAR	(N' ')	Yes		AUGRS_KK	Allow NULL?
88	PYGRP	Grouping field for automatic payments	nvarchar	10	0	CHAR	(N' ')	Yes		PYGRP_KK	Allow NULL?
89	PDTYP	Category of Payment Specification	char	1	0	CHAR	(N' ')	Yes		PDTYP_KK	Allow NULL?
90	SPERZ	Interest Lock Reason	char	1	0	CHAR	(N' ')	Yes	TFK056S	SPERZ_KK	Allow NULL?
91	INFOZ	Doubtful Item Entry/Individual Value Adjustment	nvarchar	3	0	NUMC	(N'000')	Yes		INFOZ_KK	Allow NULL?
92	TXJCD	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	TTXJ	TXJCD	Allow NULL?
93	TXDAT	Decisive Date for Calculating Taxes	nvarchar	8	0	DATS	(N'00000000')	Yes		TXDAT_KK	Allow NULL?
94	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	T880	RASSC	Allow NULL?
95	KONTT	Account Assignment Category	nvarchar	2	0	CHAR	(N' ')	Yes	TFK000K	KONTT_KK	Allow NULL?
96	KONTL	Acct assnmnt string for industry-specific account assngments	nvarchar	50	0	CHAR	(N' ')	Yes		KONTL_KK	Allow NULL?
97	OPSTA	Dunning indicator	nvarchar	3	0	CHAR	(N' ')	Yes		OPSTA_KK	Allow NULL?
98	BLART	Document Type	nvarchar	2	0	CHAR	(N' ')	Yes	TFK003	BLART_KK	Allow NULL?
99	EMGPA	Alternative Business Partner for Payments	nvarchar	10	0	CHAR	(N' ')	Yes	BUT000	EMGPA_KK	Allow NULL?
100	EMBVT	Bank Details ID of Payee	nvarchar	4	0	CHAR	(N' ')	Yes	BUT0BK	EMBVT_KK	Allow NULL?
101	EMADR	Address number	nvarchar	10	0	CHAR	(N' ')	Yes	*	AD_ADDRNUM	Allow NULL?
102	IKEY	Interest Key	nvarchar	2	0	CHAR	(N' ')	Yes	TFK056A	IKEY_KK	Allow NULL?
103	EUROU	Status of Euro Conversion	char	1	0	CHAR	(N' ')	Yes		EUROU_KK	Allow NULL?
104	XRAGL	Clearing posting reversed	char	1	0	CHAR	(N' ')	Yes		XRAGL_KK	Allow NULL?
105	XWHPO	Expanded Repetition Item	char	1	0	CHAR	(N' ')	Yes		XWHPO_KK	Allow NULL?
106	ASTKZ	Statistical Key of the Initiating Item	char	1	0	CHAR	(N' ')	Yes		ASTKZ_KK	Allow NULL?
107	ASBLG	Number of Triggering Document	nvarchar	12	0	CHAR	(N' ')	Yes	*	ASBLG_KK	Allow NULL?
108	XBLNR	Reference document number	nvarchar	16	0	CHAR	(N' ')	Yes		XBLNR_KK	Allow NULL?
109	INKPS	Collection Item	nvarchar	3	0	NUMC	(N'000')	Yes		INKPS_KK	Allow NULL?
110	RNDPS	Type of Rounding Item	char	1	0	CHAR	(N' ')	Yes		RNDPS_KK	Allow NULL?
111	QSSKZ	Withholding Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	T059Q	QSSKZ	Allow NULL?
112	QSSEW	Withholding Tax Supplement	nvarchar	2	0	CHAR	(N' ')	Yes	*	QSSEW_KK	Allow NULL?
113	QSPTP	Line Item Category From Withholding Tax View	char	1	0	CHAR	(N' ')	Yes		QSPTP_KK	Allow NULL?
114	QSSHB	Tax Base Amount	decimal	13	2	CURR	((0))	Yes		QSSHB_KK
115	QBSHB	Withholding Tax Amount (in Document Currency)	decimal	13	2	CURR	((0))	Yes		QBSHB_KK
116	QSPRZ	Withholding Tax Percentage	nvarchar	6	0	NUMC	(N'000000')	Yes		QSPRZ_KK	Allow NULL?
117	QSZNR	Certificate Number of the Withholding Tax Exemption	nvarchar	10	0	CHAR	(N' ')	Yes		QSZNR	Allow NULL?
118	XWHEX	Variable Withholding Tax in DFKKOPWH	char	1	0	CHAR	(N' ')	Yes		XWHEX_KK	Allow NULL?
119	RFUPK	Reference Item In FI-CA Document	nvarchar	4	0	NUMC	(N'0000')	Yes		RFUPK_KK	Allow NULL?
120	STRKZ	Tax Code for Other Taxes	nvarchar	2	0	CHAR	(N' ')	Yes	TFK007F	STRKZ_KK	Allow NULL?
121	FITPR	Tax type	nvarchar	2	0	CHAR	(N' ')	Yes	*	J_1AFITP_D	Allow NULL?
122	XPYOR	Item Included in a Payment Order	char	1	0	CHAR	(N' ')	Yes		XPYOR_KK	Allow NULL?
123	LANDL	Country Supplied (for Tax Notifications)	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LANDL_KK	Allow NULL?
124	INTBU	Reason for Automatic Creation of Posting	char	1	0	CHAR	(N' ')	Yes		INTBU_KK	Allow NULL?
125	EMCRD	Alternative Payment Card ID in Document	nvarchar	6	0	CHAR	(N' ')	Yes		EMCRD_KK	Allow NULL?
126	C4EYE	Check Reason for Workflows Acc. to Dual Control Principle	nvarchar	2	0	CHAR	(N' ')	Yes	*	C4EYE_KK	Allow NULL?
127	CFOPN	CFOP Code and Extension	nvarchar	10	0	CHAR	(N' ')	Yes	*	J_1BCFOP	Allow NULL?
128	C4EYP	Editing Process To Be Confirmed	char	1	0	CHAR	(N' ')	Yes		C4EYP_KK	Allow NULL?
129	TXGRP	Grouping Key for Tax Items	nvarchar	6	0	CHAR	(N' ')	Yes		TXGRP_KK	Allow NULL?
130	SCTAX	Tax Portion in FI-CA Local Currency	decimal	13	2	CURR	((0))	Yes		SCTAX_KK
131	STTAX	Tax Amount as Statistical Information in Document Currency	decimal	13	2	CURR	((0))	Yes		STTAX_KK
132	STZAL	Status of Payment Processing	char	1	0	CHAR	(N' ')	Yes		STZAL_KK	Allow NULL?
133	ORUPZ	Subitem Number before Item Split	nvarchar	3	0	CHAR	(N' ')	Yes		ORUPZ_KK	Allow NULL?
134	NEGBU	Control Field for Negative Posting	char	1	0	NUMC	(N'0')	Yes		NEGBU_KK	Allow NULL?
135	SUBAP	Subapplication in Contract Accounts Receivable and Payable	char	1	0	CHAR	(N' ')	Yes		SUBAP_KK	Allow NULL?
136	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	CUKY	(N' ')	Yes	*	PSWSL_KK	Allow NULL?
137	PSWBT	Amount for Updating in General Ledger	decimal	13	2	CURR	((0))	Yes		PSWBT_KK
138	PSWTX	Tax Amount for Update in General Ledger	decimal	13	2	CURR	((0))	Yes		PSWTX_KK
139	PSGRP	Grouping Key for Document Items	nvarchar	4	0	CHAR	(N' ')	Yes		PSGRP_KK	Allow NULL?
140	XCOLC	Item Is Included in Collection Case	char	1	0	CHAR	(N' ')	Yes		XCOLC_KK	Allow NULL?
141	AASTA	Control Field for Account Assignment Distributions	char	1	0	CHAR	(N' ')	Yes		AASTA_KK	Allow NULL?
142	XCSHA	Document Contains Assignments from Cash Flows	char	1	0	CHAR	(N' ')	Yes		XCSHA_KK	Allow NULL?
143	REACC	Originating Account in Cash Flow Anlaysis	nvarchar	10	0	CHAR	(N' ')	Yes	*	REACC_KK	Allow NULL?
144	REBUK	Partner Company Code for Cash Flow Analysis	nvarchar	4	0	CHAR	(N' ')	Yes	*	REBUK_KK	Allow NULL?
145	XUSTPD	Tax on Sales/Purchases Was Calculated by Document	char	1	0	CHAR	(N' ')	Yes		XUSTPD_KK	Allow NULL?
146	PTITM	Status of Partner Settlement Using Billable Items	char	1	0	CHAR	(N' ')	Yes		PTITM_KK	Allow NULL?
147	EMMND	SEPA Mandate Identifier	nvarchar	6	0	NUMC	(N'000000')	Yes		EMMND_KK	Allow NULL?
148	PNNUM	SEPA: Number of Direct Debit Pre-Notification	nvarchar	16	0	CHAR	(N' ')	Yes		PNNUM_KK	Allow NULL?
149	PNHKF	SEPA: Origin of Direct Debit Pre-Notification	nvarchar	2	0	CHAR	(N' ')	Yes		PNHKF_KK	Allow NULL?
150	PNEXD	SEPA: Date of Execution of Direct Debit Pre-Notifcation	nvarchar	8	0	DATS	(N'00000000')	Yes		PNEXD_KK	Allow NULL?
151	PNCTR	SEPA: Requirement for a Pre-Notification	char	1	0	CHAR	(N' ')	Yes		PNCTR_KK	Allow NULL?
152	FINRE	Contract Account of Final Recipient	nvarchar	12	0	CHAR	(N' ')	Yes	*	FINRE_KK	Allow NULL?
153	RDSTA	Current Distribution Status	char	1	0	CHAR	(N' ')	Yes		RDSTA_KK	Allow NULL?
154	RDSTB	Last Distribution Status Reported	char	1	0	CHAR	(N' ')	Yes		RDSTB_KK	Allow NULL?
155	FMTYP	Update Method for FM - FI-CA Integration	nvarchar	2	0	CHAR	(N' ')	Yes		FMTYP_KK	Allow NULL?
156	ORIGFIKRS	Original FM Area for FM Account Assignment	nvarchar	4	0	CHAR	(N' ')	Yes	*	ORIGFIKRS_KK	Allow NULL?
157	FIPEX	Commitment Item	nvarchar	24	0	CHAR	(N' ')	Yes	*	FM_FIPEX	Allow NULL?
158	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
159	FONDS	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
160	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
161	MEASURE	Funded Program	nvarchar	24	0	CHAR	(N' ')	Yes	*	FM_MEASURE	Allow NULL?
162	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
163	BUDGETYEAR	Original Year for FM Account Assignment	nvarchar	4	0	NUMC	(N'0000')	Yes		FM_START_OF_CHAIN	Allow NULL?
164	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
165	COPY	Simulated Clearing Item	char	1	0	CHAR	(N' ')	Yes		COPY_KK	Allow NULL?
166	WAERH	Local currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERH	Allow NULL?
167	MARK	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?

TOP ERP 6.0 | DFKKOP_REP INDEXES

Name	Primary	Unique	Type	Columns
DFKKOP_REP~0	Yes	Yes	CLUSTERED	LFDNR, INTNR, KEYDT, CLIENT
DFKKOP_REP~GPA	No	No	NONCLUSTERED	GPART, KEYDT, CLIENT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

167 COLUMNS | 2 INDEXES | ERP 6.0 | DFKKOP_REP TABLE

TOP ERP 6.0 | DFKKOP_REP COLUMNS

TOP ERP 6.0 | DFKKOP_REP INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

167 COLUMNS | 2 INDEXES | ERP 6.0 | DFKKOP_REP TABLE

TOPERP 6.0 | DFKKOP_REP COLUMNS

TOPERP 6.0 | DFKKOP_REP INDEXES

TOP ERP 6.0 | DFKKOP_REP COLUMNS

TOP ERP 6.0 | DFKKOP_REP INDEXES