ERP 6.0: Top 10 requests

	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

	Product	Version	Table	Columns	Indexes	Description	Module
Logistics - General :: Agency Business Global Trade
1	ERP EHP7	6.0	TMFK	158	1	Agency Business: Billing Document Types	Agency Business Global Trade

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	LFART	Agency business: Billing document type	nvarchar	4	Allow NULL?
3	LFTYP	Agency business: Billing category	nvarchar	2	Allow NULL?
4	KAPPL	AB: Price Determination Application	nvarchar	2	Allow NULL?
5	NUMKI	Number range in the case of internal number assignment	nvarchar	2	Allow NULL?
6	NUMKE	Number range in the case of external number assignment	nvarchar	2	Allow NULL?
7	INCPO	Increment of item no. of vendor billing document	nvarchar	6	Allow NULL?
8	RFBFK	Blocked for transfer to accounting	char	1	Allow NULL?
9	NARVF	Vendor billing document is relevant for subseq. settlement	char	1	Allow NULL?
10	LFARTS	Reversal type: vendor billing document	nvarchar	4	Allow NULL?
11	KAPPL_NA	Application for output conditions	nvarchar	2	Allow NULL?
12	KALSMK	Output determination procedure	nvarchar	6	Allow NULL?
13	KALSMP	Procedure for item output	nvarchar	6	Allow NULL?
14	KSCHL	Output Type	nvarchar	4	Allow NULL?
15	ABART	Settlement Type	char	1	Allow NULL?
16	STATI	Update statistics	char	1	Allow NULL?
17	LFART_RL	Remuneration List Type, Vendor Billing Document	nvarchar	4	Allow NULL?
18	RELEP	Forward Remuneration Lists with Line Items to FI	char	1	Allow NULL?
19	PARGK	Partner schema for the billing doc.header	nvarchar	4	Allow NULL?
20	PARGP	Partner schema for the billing doc.item	nvarchar	4	Allow NULL?
21	KALVG	Document schema for determining calculation schema	nvarchar	2	Allow NULL?
22	WERKM	Vendor billing document: Entry with plant data	char	1	Allow NULL?
23	PRDVO	Agency business: price date default	char	1	Allow NULL?
24	INFOL	Vendor billing document: read info record	char	1	Allow NULL?
25	XBLNR_FI	Vendor billing document: FI assignment no.	char	1	Allow NULL?
26	XRBLN_FI	Vendor billing doc.: FI doc. reference no.	char	1	Allow NULL?
27	KIDNO_LF	Vendor billing document: Payment reference number FI	char	1	Allow NULL?
28	BLART	Document Type	nvarchar	2	Allow NULL?
29	XNEGP	Negative posting	char	1	Allow NULL?
30	XVALGS	Credit memo with value date	char	1	Allow NULL?
31	WZFBD	Copy Payment Data from Remuneration List to Billing Docs	char	1	Allow NULL?
32	WZLSPR	Payment block for payment recipient	char	1	Allow NULL?
33	WZLSPL	Clear Payment/Dunning Block in Remuneration List Run	char	1	Allow NULL?
34	LFGRU_VO	Agency business: Default reason (reason for activity)	nvarchar	3	Allow NULL?
35	KTOSL_VE	Account key for settlement line in settlement request	nvarchar	3	Allow NULL?
36	KTOSL_VM	Account key, clearing account, vendor billing document	nvarchar	3	Allow NULL?
37	KTOSL_MG	Account Key: Offsetting Account for Material Adjustment	nvarchar	3	Allow NULL?
38	WZUSPL	Assignment as Splitting Criterion for Remuneration Lists	char	1	Allow NULL?
39	WKIDSP	Payment Reference as Splitting Criterion in Remuner. Lists	char	1	Allow NULL?
40	WFDATSP	Document date as splitting criterion for lists	char	1	Allow NULL?
41	WZTERMSP	Terms of payment as splitting criterion for lists	char	1	Allow NULL?
42	WZLSCHSP	Payment Method as Split Criterion for Lists	char	1	Allow NULL?
43	WPYCURSP	Payment currency as splitting criteria for lists	char	1	Allow NULL?
44	WITEMSP	Maximum number of items in a list	nvarchar	6	Allow NULL?
45	TXTGR	Text determination procedure: Header	nvarchar	2	Allow NULL?
46	TXTGR_I	Text determination procedure: Item	nvarchar	2	Allow NULL?
47	TDID	Text ID for text edit control	nvarchar	4	Allow NULL?
48	TDID_I	Text ID for TextEdit control (item level)	nvarchar	4	Allow NULL?
49	WPOINT	Agency business: Change document processing active	char	1	Allow NULL?
50	WPYCUR	Agency business: Different payment currency active	char	1	Allow NULL?
51	KUDVO	Agency Business: Default Exchange Rate Date	char	1	Allow NULL?
52	PRCHGRP	Price change group	nvarchar	2	Allow NULL?
53	AR_OBJECT	Document type	nvarchar	10	Allow NULL?
54	KURST	Exchange Rate Type	nvarchar	4	Allow NULL?
55	WERN	Item amounts can be zero	char	1	Allow NULL?
56	KSCHLP	Output Type	nvarchar	4	Allow NULL?
57	WBART_FI	Valuation Procedure When Releasing to Accounting	char	1	Allow NULL?
58	DOCPARTY	Business Partners in Billing Document	char	1	Allow NULL?
59	KALSMC	Account determination procedure	nvarchar	6	Allow NULL?
60	LFART_BL	Settlement request: Billing doc. category - posting list	nvarchar	4	Allow NULL?
61	LFART_BD	Agency Business: Billing Type for Customer Settlement	nvarchar	4	Allow NULL?
62	NETWN	Negative Net Value Indicator	char	1	Allow NULL?
63	BUSTW	Alternative Posting String for Values	nvarchar	4	Allow NULL?
64	HEADDATA	Include Document Header Data at Item Level Also	char	1	Allow NULL?
65	RRLCHANGEKONV	AB: Consideration of Billg Cat. with Follow-On Doc. Creation	char	1	Allow NULL?
66	RRLTAX	Agency Business: Tax Determination Method	char	1	Allow NULL?
67	BLART_CUSTOMER	Different FI Document Type for Customer for Split	nvarchar	2	Allow NULL?
68	KTOSL_VE_CUST	Different Sales Settlement Account for Customer Payment	nvarchar	3	Allow NULL?
69	WCONSP	Contract Number as Split Criterion	char	1	Allow NULL?
70	BW_DELTA	BW Update	char	1	Allow NULL?
71	DUPD_SINGLE	BW Control for Single Settlement Documents	char	1	Allow NULL?
72	WTREE	Display Reference Documents in TREE	char	1	Allow NULL?
73	CANCEL_TYPE	Agency Business: FI Cancellation Method	char	1	Allow NULL?
74	XREF_RRL	AB: Remuneration List Number in FI Documents Original Docs	char	1	Allow NULL?
75	HITYP_VENDOR	Hierarchy category: vendor hierarchy	char	1	Allow NULL?
76	HITYP_CUSTOMER	Hierarchy type for pricing	char	1	Allow NULL?
77	COPA_ACTIVE	AB: Profitability Analysis Active	char	1	Allow NULL?
78	FILL_REF_DOC	AB: Fill Reference Document Data	char	1	Allow NULL?
79	CANCEL_VARIANT	AB: Cancellation Variant	char	1	Allow NULL?
80	LFART_SL	Agency Business: Billing Doc. Type - Settlement Req. List	nvarchar	4	Allow NULL?
81	LFART_VS	Agency Business: Billing Doc. Type - Vendor Settlement	nvarchar	4	Allow NULL?
82	SET_SGTXT_FI	AB: Set Item Text FI	char	1	Allow NULL?
83	LNRZB_NOT_ACTIVE	AB: No Different Payment Recipient	char	1	Allow NULL?
84	DOCUMENT_INDEX	AB: Document Index Active	char	1	Allow NULL?
85	DOC_INDEX_DELETE	AB: Delete Document Index After Posting	char	1	Allow NULL?
86	DEF_IDOBJ_TYPE_V	AB: Identification Object Type Vendor	nvarchar	4	Allow NULL?
87	DEF_IDOBJ_TYPE_C	AB: Identification Object Type Customer	nvarchar	4	Allow NULL?
88	VENDOR_INPUT	AB: Entry - Invoicing Party	char	1	Allow NULL?
89	CUSTOMER_INPUT	AB: Entry of Invoice Recipient	char	1	Allow NULL?
90	DEF_IDNLF_TYPE	AB: Article Number Type - Vendor	nvarchar	4	Allow NULL?
91	KSTAT_ACCOUNT	AB: Posting Statistical Conditions to Accounting	char	1	Allow NULL?
92	MATERIAL_INPUT	AB: Entry of Material	char	1	Allow NULL?
93	DEF_POST_RULE_K	AB: Creditor Posting Rule	nvarchar	2	Allow NULL?
94	DEF_POST_RULE_D	AB: Debtor Posting Rule	nvarchar	2	Allow NULL?
95	CHECK_WFDAT	AB: Check Posting Date on Entry	char	1	Allow NULL?
96	ITEM_CANCEL	AB: Item Cancellation Allowed	char	1	Allow NULL?
97	CM_ACTIVE	Credit Management	char	1	Allow NULL?
98	CRMGR	Document credit group	nvarchar	2	Allow NULL?
99	CM_CHECK	Agency Business: Credit Limit Check Time	char	1	Allow NULL?
100	COCO_DET	AB: Carry Out Condition Contract Determination	char	1	Allow NULL?
101	BILLTOPARTY	Invoice Recipient	nvarchar	2	Allow NULL?
102	BILLFROMPARTY	AB: Diff. Partner Function for Determining Invoicing Party	nvarchar	2	Allow NULL?
103	EVENT_RELEVANT	Agency Business: Control of Event Call-Up	char	1	Allow NULL?
104	CONTEXT	Context	nvarchar	10	Allow NULL?
105	CONF_ALLWD	Configuration at Item Level is Allowed	char	1	Allow NULL?
106	TAX_CODE_ACTIVE	AB: Tax Code Active	char	1	Allow NULL?
107	KTOSL_AS	Account Key for Posting of Exchange Rate Differences	nvarchar	3	Allow NULL?
108	KTOSL_ACC	AB: Account Key for Materials Without Value Update	nvarchar	3	Allow NULL?
109	POST_CANCEL_DOC	AB: Posting of Reversal Document	char	1	Allow NULL?
110	DI_RELEVANT	AB: Invoice Correction Control from Customer Invoices	char	1	Allow NULL?
111	SMT_CONTEXT	Context	nvarchar	10	Allow NULL?
112	TDID_HS1	AB: Text ID for Adoption of Text at Enterprise Services	nvarchar	4	Allow NULL?
113	TDID_HS2	AB: Text ID for Adoption of Text at Enterprise Services	nvarchar	4	Allow NULL?
114	TDID_HS3	AB: Text ID for Adoption of Text at Enterprise SOA Services	nvarchar	4	Allow NULL?
115	TDID_IS1	AB: Text ID for Adoption of Text at Enterprise SOA Services	nvarchar	4	Allow NULL?
116	CANCEL_ONLY	Billing Type May Only Be Used for Cancellation	char	1	Allow NULL?
117	ITEM_BASED	Generate Partner Lines at Item Level	char	1	Allow NULL?
118	INSERT_MODE	Insert Mode for FI Doc. Line Items	char	1	Allow NULL?
119	FIELDSTATUSGROUP	Field Status Group	nvarchar	4	Allow NULL?
120	COLSORTGROUP	Column Sorting Group	nvarchar	4	Allow NULL?
121	PARVW_LIFNR_FI	Partner Role of Alternative Creditor	nvarchar	2	Allow NULL?
122	LIFNR_FI_NOT_ACT	AB: No Alternative Creditor	char	1	Allow NULL?
123	DISTRIBUTION	AB: Distribution Active	char	1	Allow NULL?
124	EFFWR_NEG	Negative Effective Value Allowed	char	1	Allow NULL?
125	POSNR_MAIN_ACTIV	Main Item Active	char	1	Allow NULL?
126	KALSMCB_K	Calcultn. Schema f. Determ. Vendor Reconciliation Account	nvarchar	6	Allow NULL?
127	KALSMCB_D	Calcultn. Schema f. Determ. Customer Reconciliation Account	nvarchar	6	Allow NULL?
128	CALC_PYAMT	AB: Determination of Amount in Payment Currency	char	1	Allow NULL?
129	ACC_DETERM_TYPE	AB: Account Determination Procedure	char	1	Allow NULL?
130	INTRASTAT_PROC	Process Control for Intrastat Declarations	char	1	Allow NULL?
131	INTRASTAT_FLOW	Type of Goods Flow for Intrastat Declarations	char	1	Allow NULL?
132	DOC_INDEX_TYPE	Document Index Update	char	1	Allow NULL?
133	SET_LANDTX	Propose Tax Departure Country	char	1	Allow NULL?
134	SET_LAND1TX	Propose Tax Destination Country	char	1	Allow NULL?
135	SET_LAND_PRIC_K	Set Country Key for Vendor Pricing	char	1	Allow NULL?
136	SET_LAND_PRIC_D	Set Country Key for Customer Pricing	char	1	Allow NULL?
137	HANDLE_STCEG	Handling for Vendor VAT ID	char	1	Allow NULL?
138	HANDLE_STCEGD	Handling for Customer VAT ID	char	1	Allow NULL?
139	DEF_STCEG	Default Logic for Vendor VAT ID	char	1	Allow NULL?
140	DEF_STCEGD	Default Logic for Customer VAT ID	char	1	Allow NULL?
141	CHECK_STCEG	Check for Vendor VAT ID	char	1	Allow NULL?
142	CHECK_STCEGD	Check for Customer VAT ID	char	1	Allow NULL?
143	WZLSPRD	Debtor Payment Block	char	1	Allow NULL?
144	PRICING_COMP_K	Execute Final Processing for Vendor Pricing	char	1	Allow NULL?
145	PRICING_COMP_D	Execute Final Processing for Customer Pricing	char	1	Allow NULL?
146	CHECK_OWN_STCEG	Check Availability of Own VAT ID	char	1	Allow NULL?
147	WEIGHT_VOLUME	Level on which You Enter Weight and Volume	char	1	Allow NULL?
148	SET_XEGDR	Set Triangular Deal Indicator	char	1	Allow NULL?
149	INCOTERMS_ACTIVE	Agency Business: Incoterms Active	char	1	Allow NULL?
150	NO_KNTYP_CHECK	No Pricinf Condition Check in Calculation Schema	char	1	Allow NULL?
151	DET_PARTNER	AB: Transfer Partner from Master Data	char	1	Allow NULL?
152	PROCESS_TYPE	Process Category	nvarchar	4	Allow NULL?
153	CHECK_AP_RG	Check Alternative Payee/Payer	char	1	Allow NULL?
154	ZTERM_CASH_DISC	Variant Cash Discount % Allowed(Deviating from Payment Term)	char	1	Allow NULL?
155	LFART_COLL	AD: Billing Type for Collection of Settlement Requests	nvarchar	4	Allow NULL?
156	BANKDATA_TRANSFER	AD: Transfer Control for Bank Data	char	1	Allow NULL?
157	IVGROUP	Check Group	nvarchar	4	Allow NULL?
158	USE_CASE	Use Case Type	nvarchar	2	Allow NULL?

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

158 COLUMNS | 1 INDEXES | ERP 6.0 | TMFK TABLE

TOP ERP 6.0 | TMFK COLUMNS

TOP ERP 6.0 | TMFK 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

158 COLUMNS | 1 INDEXES | ERP 6.0 | TMFK TABLE

TOPERP 6.0 | TMFK COLUMNS

TOPERP 6.0 | TMFK INDEXES

TOP ERP 6.0 | TMFK COLUMNS

TOP ERP 6.0 | TMFK INDEXES