	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	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	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	OSRN	20	Serial Numbers Master Data
10	OINM	101	Whse Journal

158 COLUMNS | 1 INDEXES | ERP 6.0 | TMFK TABLE

	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

SQL: selectupdate insert create

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

SELECT MANDT, LFART, LFTYP, KAPPL, NUMKI, NUMKE, INCPO, RFBFK, NARVF, LFARTS, KAPPL_NA, KALSMK, KALSMP, KSCHL, ABART, STATI, LFART_RL, RELEP, PARGK, PARGP, KALVG, WERKM, PRDVO, INFOL, XBLNR_FI, XRBLN_FI, KIDNO_LF, BLART, XNEGP, XVALGS, WZFBD, WZLSPR, WZLSPL, LFGRU_VO, KTOSL_VE, KTOSL_VM, KTOSL_MG, WZUSPL, WKIDSP, WFDATSP, WZTERMSP, WZLSCHSP, WPYCURSP, WITEMSP, TXTGR, TXTGR_I, TDID, TDID_I, WPOINT, WPYCUR, KUDVO, PRCHGRP, AR_OBJECT, KURST, WERN, KSCHLP, WBART_FI, DOCPARTY, KALSMC, LFART_BL, LFART_BD, NETWN, BUSTW, HEADDATA, RRLCHANGEKONV, RRLTAX, BLART_CUSTOMER, KTOSL_VE_CUST, WCONSP, BW_DELTA, DUPD_SINGLE, WTREE, CANCEL_TYPE, XREF_RRL, HITYP_VENDOR, HITYP_CUSTOMER, COPA_ACTIVE, FILL_REF_DOC, CANCEL_VARIANT, LFART_SL, LFART_VS, SET_SGTXT_FI, LNRZB_NOT_ACTIVE, DOCUMENT_INDEX, DOC_INDEX_DELETE, DEF_IDOBJ_TYPE_V, DEF_IDOBJ_TYPE_C, VENDOR_INPUT, CUSTOMER_INPUT, DEF_IDNLF_TYPE, KSTAT_ACCOUNT, MATERIAL_INPUT, DEF_POST_RULE_K, DEF_POST_RULE_D, CHECK_WFDAT, ITEM_CANCEL, CM_ACTIVE, CRMGR, CM_CHECK, COCO_DET, BILLTOPARTY, BILLFROMPARTY, EVENT_RELEVANT, CONTEXT, CONF_ALLWD, TAX_CODE_ACTIVE, KTOSL_AS, KTOSL_ACC, POST_CANCEL_DOC, DI_RELEVANT, SMT_CONTEXT, TDID_HS1, TDID_HS2, TDID_HS3, TDID_IS1, CANCEL_ONLY, ITEM_BASED, INSERT_MODE, FIELDSTATUSGROUP, COLSORTGROUP, PARVW_LIFNR_FI, LIFNR_FI_NOT_ACT, DISTRIBUTION, EFFWR_NEG, POSNR_MAIN_ACTIV, KALSMCB_K, KALSMCB_D, CALC_PYAMT, ACC_DETERM_TYPE, INTRASTAT_PROC, INTRASTAT_FLOW, DOC_INDEX_TYPE, SET_LANDTX, SET_LAND1TX, SET_LAND_PRIC_K, SET_LAND_PRIC_D, HANDLE_STCEG, HANDLE_STCEGD, DEF_STCEG, DEF_STCEGD, CHECK_STCEG, CHECK_STCEGD, WZLSPRD, PRICING_COMP_K, PRICING_COMP_D, CHECK_OWN_STCEG, WEIGHT_VOLUME, SET_XEGDR, INCOTERMS_ACTIVE, NO_KNTYP_CHECK, DET_PARTNER, PROCESS_TYPE, CHECK_AP_RG, ZTERM_CASH_DISC, LFART_COLL, BANKDATA_TRANSFER, IVGROUP, USE_CASE FROM TMFK

TOP ERP 6.0 | TMFK COLUMNS

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	LFART	Agency business: Billing document type	nvarchar	4	CHAR	(N' ')	No		WFART	Allow NULL?
3	LFTYP	Agency business: Billing category	nvarchar	2	CHAR	(N' ')	Yes		WFTYP	Allow NULL?
4	KAPPL	AB: Price Determination Application	nvarchar	2	CHAR	(N' ')	Yes		WLF_KAPPL_PRICING	Allow NULL?
5	NUMKI	Number range in the case of internal number assignment	nvarchar	2	CHAR	(N' ')	Yes		NUMKI	Allow NULL?
6	NUMKE	Number range in the case of external number assignment	nvarchar	2	CHAR	(N' ')	Yes		NUMKE	Allow NULL?
7	INCPO	Increment of item no. of vendor billing document	nvarchar	6	NUMC	(N'000000')	Yes		WINCPO	Allow NULL?
8	RFBFK	Blocked for transfer to accounting	char	1	CHAR	(N' ')	Yes		WFBFK	Allow NULL?
9	NARVF	Vendor billing document is relevant for subseq. settlement	char	1	CHAR	(N' ')	Yes		NARVF	Allow NULL?
10	LFARTS	Reversal type: vendor billing document	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WFARTS	Allow NULL?
11	KAPPL_NA	Application for output conditions	nvarchar	2	CHAR	(N' ')	Yes	T681A	NA_KAPPL	Allow NULL?
12	KALSMK	Output determination procedure	nvarchar	6	CHAR	(N' ')	Yes	T683	KALSMB	Allow NULL?
13	KALSMP	Procedure for item output	nvarchar	6	CHAR	(N' ')	Yes	T683	KALSMBP	Allow NULL?
14	KSCHL	Output Type	nvarchar	4	CHAR	(N' ')	Yes	T685	NA_KSCHL	Allow NULL?
15	ABART	Settlement Type	char	1	CHAR	(N' ')	Yes		NAFKT	Allow NULL?
16	STATI	Update statistics	char	1	CHAR	(N' ')	Yes		STATI	Allow NULL?
17	LFART_RL	Remuneration List Type, Vendor Billing Document	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WFART_RL	Allow NULL?
18	RELEP	Forward Remuneration Lists with Line Items to FI	char	1	CHAR	(N' ')	Yes		WRELEP	Allow NULL?
19	PARGK	Partner schema for the billing doc.header	nvarchar	4	CHAR	(N' ')	Yes	TVPG	WPARGK	Allow NULL?
20	PARGP	Partner schema for the billing doc.item	nvarchar	4	CHAR	(N' ')	Yes	TVPG	WPARGP	Allow NULL?
21	KALVG	Document schema for determining calculation schema	nvarchar	2	CHAR	(N' ')	Yes	TMKV	WKALVG	Allow NULL?
22	WERKM	Vendor billing document: Entry with plant data	char	1	CHAR	(N' ')	Yes		WERKM	Allow NULL?
23	PRDVO	Agency business: price date default	char	1	CHAR	(N' ')	Yes		WPRDV	Allow NULL?
24	INFOL	Vendor billing document: read info record	char	1	CHAR	(N' ')	Yes		WINFO	Allow NULL?
25	XBLNR_FI	Vendor billing document: FI assignment no.	char	1	CHAR	(N' ')	Yes		WBLNR_FI	Allow NULL?
26	XRBLN_FI	Vendor billing doc.: FI doc. reference no.	char	1	CHAR	(N' ')	Yes		WRBLN_FI	Allow NULL?
27	KIDNO_LF	Vendor billing document: Payment reference number FI	char	1	CHAR	(N' ')	Yes		WIDNO_FI	Allow NULL?
28	BLART	Document Type	nvarchar	2	CHAR	(N' ')	Yes	T003	BLART	Allow NULL?
29	XNEGP	Negative posting	char	1	CHAR	(N' ')	Yes		XNEGP_LF	Allow NULL?
30	XVALGS	Credit memo with value date	char	1	CHAR	(N' ')	Yes		WVALGS	Allow NULL?
31	WZFBD	Copy Payment Data from Remuneration List to Billing Docs	char	1	CHAR	(N' ')	Yes		WZFBD	Allow NULL?
32	WZLSPR	Payment block for payment recipient	char	1	CHAR	(N' ')	Yes	T008	WZLSPR	Allow NULL?
33	WZLSPL	Clear Payment/Dunning Block in Remuneration List Run	char	1	CHAR	(N' ')	Yes		WZLSPL	Allow NULL?
34	LFGRU_VO	Agency business: Default reason (reason for activity)	nvarchar	3	CHAR	(N' ')	Yes	TMLFG	WFGRU_VO	Allow NULL?
35	KTOSL_VE	Account key for settlement line in settlement request	nvarchar	3	CHAR	(N' ')	Yes	T687	KTOSL_VE	Allow NULL?
36	KTOSL_VM	Account key, clearing account, vendor billing document	nvarchar	3	CHAR	(N' ')	Yes	T687	KOTSL_VM	Allow NULL?
37	KTOSL_MG	Account Key: Offsetting Account for Material Adjustment	nvarchar	3	CHAR	(N' ')	Yes	T687	KTOSL_MG	Allow NULL?
38	WZUSPL	Assignment as Splitting Criterion for Remuneration Lists	char	1	CHAR	(N' ')	Yes		WZUSPL	Allow NULL?
39	WKIDSP	Payment Reference as Splitting Criterion in Remuner. Lists	char	1	CHAR	(N' ')	Yes		WKIDSP	Allow NULL?
40	WFDATSP	Document date as splitting criterion for lists	char	1	CHAR	(N' ')	Yes		WFDATSP	Allow NULL?
41	WZTERMSP	Terms of payment as splitting criterion for lists	char	1	CHAR	(N' ')	Yes		WZTERMSP	Allow NULL?
42	WZLSCHSP	Payment Method as Split Criterion for Lists	char	1	CHAR	(N' ')	Yes		WZLSCHSP	Allow NULL?
43	WPYCURSP	Payment currency as splitting criteria for lists	char	1	CHAR	(N' ')	Yes		WPYCURSP	Allow NULL?
44	WITEMSP	Maximum number of items in a list	nvarchar	6	NUMC	(N'000000')	Yes		WITEMSP	Allow NULL?
45	TXTGR	Text determination procedure: Header	nvarchar	2	CHAR	(N' ')	Yes	TTXG	TXTGR_H	Allow NULL?
46	TXTGR_I	Text determination procedure: Item	nvarchar	2	CHAR	(N' ')	Yes	TTXG	TXTGR_I	Allow NULL?
47	TDID	Text ID for text edit control	nvarchar	4	CHAR	(N' ')	Yes	TTXERN	TDID_TEC	Allow NULL?
48	TDID_I	Text ID for TextEdit control (item level)	nvarchar	4	CHAR	(N' ')	Yes	TTXERN	TDID_TECI	Allow NULL?
49	WPOINT	Agency business: Change document processing active	char	1	CHAR	(N' ')	Yes		WPOINT	Allow NULL?
50	WPYCUR	Agency business: Different payment currency active	char	1	CHAR	(N' ')	Yes		WPYCUR	Allow NULL?
51	KUDVO	Agency Business: Default Exchange Rate Date	char	1	CHAR	(N' ')	Yes		WKUDVO	Allow NULL?
52	PRCHGRP	Price change group	nvarchar	2	CHAR	(N' ')	Yes	TMFK4	PRCHGRP	Allow NULL?
53	AR_OBJECT	Document type	nvarchar	10	CHAR	(N' ')	Yes	TOADV	SAEOBJART	Allow NULL?
54	KURST	Exchange Rate Type	nvarchar	4	CHAR	(N' ')	Yes	TCURV	KURST	Allow NULL?
55	WERN	Item amounts can be zero	char	1	CHAR	(N' ')	Yes		WERN	Allow NULL?
56	KSCHLP	Output Type	nvarchar	4	CHAR	(N' ')	Yes	T685	NA_KSCHL	Allow NULL?
57	WBART_FI	Valuation Procedure When Releasing to Accounting	char	1	CHAR	(N' ')	Yes		WBART_FI	Allow NULL?
58	DOCPARTY	Business Partners in Billing Document	char	1	CHAR	(N' ')	Yes		DOCPARTY	Allow NULL?
59	KALSMC	Account determination procedure	nvarchar	6	CHAR	(N' ')	Yes	T683	KALSMC	Allow NULL?
60	LFART_BL	Settlement request: Billing doc. category - posting list	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WFART_BL	Allow NULL?
61	LFART_BD	Agency Business: Billing Type for Customer Settlement	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WFART_BD	Allow NULL?
62	NETWN	Negative Net Value Indicator	char	1	CHAR	(N' ')	Yes		NETWN	Allow NULL?
63	BUSTW	Alternative Posting String for Values	nvarchar	4	CHAR	(N' ')	Yes	T169A	WBUSTW	Allow NULL?
64	HEADDATA	Include Document Header Data at Item Level Also	char	1	CHAR	(N' ')	Yes		WLF_ADD_HEADER_READ	Allow NULL?
65	RRLCHANGEKONV	AB: Consideration of Billg Cat. with Follow-On Doc. Creation	char	1	CHAR	(N' ')	Yes		WLF_RRL_CHANGE_KONV	Allow NULL?
66	RRLTAX	Agency Business: Tax Determination Method	char	1	CHAR	(N' ')	Yes		WLF_RRL_TAX	Allow NULL?
67	BLART_CUSTOMER	Different FI Document Type for Customer for Split	nvarchar	2	CHAR	(N' ')	Yes	T003	WLF_BLART_CUSTOMER	Allow NULL?
68	KTOSL_VE_CUST	Different Sales Settlement Account for Customer Payment	nvarchar	3	CHAR	(N' ')	Yes	T687	WLF_KTOSL_VE_CUSTOMER	Allow NULL?
69	WCONSP	Contract Number as Split Criterion	char	1	CHAR	(N' ')	Yes		WCONSP	Allow NULL?
70	BW_DELTA	BW Update	char	1	CHAR	(N' ')	Yes		BW_DELTA	Allow NULL?
71	DUPD_SINGLE	BW Control for Single Settlement Documents	char	1	CHAR	(N' ')	Yes		DUPD_SINGLE	Allow NULL?
72	WTREE	Display Reference Documents in TREE	char	1	CHAR	(N' ')	Yes		WLF_TREE	Allow NULL?
73	CANCEL_TYPE	Agency Business: FI Cancellation Method	char	1	CHAR	(N' ')	Yes		WLF_CANCEL_TYPE	Allow NULL?
74	XREF_RRL	AB: Remuneration List Number in FI Documents Original Docs	char	1	CHAR	(N' ')	Yes		WLF_XREF_RRL	Allow NULL?
75	HITYP_VENDOR	Hierarchy category: vendor hierarchy	char	1	CHAR	(N' ')	Yes	TLHIT	HITYP_LH	Allow NULL?
76	HITYP_CUSTOMER	Hierarchy type for pricing	char	1	CHAR	(N' ')	Yes	THIT	HITYP_PR	Allow NULL?
77	COPA_ACTIVE	AB: Profitability Analysis Active	char	1	CHAR	(N' ')	Yes		WLF_COPA_ACTIVE	Allow NULL?
78	FILL_REF_DOC	AB: Fill Reference Document Data	char	1	CHAR	(N' ')	Yes		WLF_FILL_REF_DOC	Allow NULL?
79	CANCEL_VARIANT	AB: Cancellation Variant	char	1	CHAR	(N' ')	Yes		WLF_CANCEL_VARIANT	Allow NULL?
80	LFART_SL	Agency Business: Billing Doc. Type - Settlement Req. List	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WFART_SL	Allow NULL?
81	LFART_VS	Agency Business: Billing Doc. Type - Vendor Settlement	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WFART_VS	Allow NULL?
82	SET_SGTXT_FI	AB: Set Item Text FI	char	1	CHAR	(N' ')	Yes		WLF_SET_SGTXT_FI	Allow NULL?
83	LNRZB_NOT_ACTIVE	AB: No Different Payment Recipient	char	1	CHAR	(N' ')	Yes		WLF_LNRZB_NOT_ACTIVE	Allow NULL?
84	DOCUMENT_INDEX	AB: Document Index Active	char	1	CHAR	(N' ')	Yes		WLF_DOCUMENT_INDEX_ACTIVE	Allow NULL?
85	DOC_INDEX_DELETE	AB: Delete Document Index After Posting	char	1	CHAR	(N' ')	Yes		WLF_DOC_INDEX_DEL_AFTER_POST	Allow NULL?
86	DEF_IDOBJ_TYPE_V	AB: Identification Object Type Vendor	nvarchar	4	CHAR	(N' ')	Yes	TMIDTV	WLF_IDOBJ_TYPE_VENDOR	Allow NULL?
87	DEF_IDOBJ_TYPE_C	AB: Identification Object Type Customer	nvarchar	4	CHAR	(N' ')	Yes	TMIDTC	WLF_IDOBJ_TYPE_CUSTOMER	Allow NULL?
88	VENDOR_INPUT	AB: Entry - Invoicing Party	char	1	CHAR	(N' ')	Yes		WLF_VENDOR_INPUT	Allow NULL?
89	CUSTOMER_INPUT	AB: Entry of Invoice Recipient	char	1	CHAR	(N' ')	Yes		WLF_CUSTOMER_INPUT	Allow NULL?
90	DEF_IDNLF_TYPE	AB: Article Number Type - Vendor	nvarchar	4	CHAR	(N' ')	Yes	TMVMT	WLF_IDNLF_TYPE	Allow NULL?
91	KSTAT_ACCOUNT	AB: Posting Statistical Conditions to Accounting	char	1	CHAR	(N' ')	Yes		WLF_KSTAT_ACCOUNTING	Allow NULL?
92	MATERIAL_INPUT	AB: Entry of Material	char	1	CHAR	(N' ')	Yes		WLF_MATERIAL_INPUT	Allow NULL?
93	DEF_POST_RULE_K	AB: Creditor Posting Rule	nvarchar	2	CHAR	(N' ')	Yes	TMPR	WLF_POSTING_RULE_K	Allow NULL?
94	DEF_POST_RULE_D	AB: Debtor Posting Rule	nvarchar	2	CHAR	(N' ')	Yes	TMPR	WLF_POSTING_RULE_D	Allow NULL?
95	CHECK_WFDAT	AB: Check Posting Date on Entry	char	1	CHAR	(N' ')	Yes		WLF_CHECK_WFDAT	Allow NULL?
96	ITEM_CANCEL	AB: Item Cancellation Allowed	char	1	CHAR	(N' ')	Yes		WLF_ITEM_CANCEL_ALLOWED	Allow NULL?
97	CM_ACTIVE	Credit Management	char	1	CHAR	(N' ')	Yes		WLF_CM_ACTIVE	Allow NULL?
98	CRMGR	Document credit group	nvarchar	2	CHAR	(N' ')	Yes	T691D	CRMGR_CM	Allow NULL?
99	CM_CHECK	Agency Business: Credit Limit Check Time	char	1	CHAR	(N' ')	Yes		WLF_CM_CHECK	Allow NULL?
100	COCO_DET	AB: Carry Out Condition Contract Determination	char	1	CHAR	(N' ')	Yes		WLF_COCO_DET	Allow NULL?
101	BILLTOPARTY	Invoice Recipient	nvarchar	2	CHAR	(N' ')	Yes	TPAR	WLF_PARVW_BT	Allow NULL?
102	BILLFROMPARTY	AB: Diff. Partner Function for Determining Invoicing Party	nvarchar	2	CHAR	(N' ')	Yes	TPAR	WLF_PARVW_BF	Allow NULL?
103	EVENT_RELEVANT	Agency Business: Control of Event Call-Up	char	1	CHAR	(N' ')	Yes		WLF_EVENT_RELEVANT	Allow NULL?
104	CONTEXT	Context	nvarchar	10	CHAR	(N' ')	Yes		WUF_CONTEXT	Allow NULL?
105	CONF_ALLWD	Configuration at Item Level is Allowed	char	1	CHAR	(N' ')	Yes		WLF_CONF_ALLWD	Allow NULL?
106	TAX_CODE_ACTIVE	AB: Tax Code Active	char	1	CHAR	(N' ')	Yes		WLF_TAX_CODE_ACTIVE	Allow NULL?
107	KTOSL_AS	Account Key for Posting of Exchange Rate Differences	nvarchar	3	CHAR	(N' ')	Yes	T687	WLF_KTOSL_AS	Allow NULL?
108	KTOSL_ACC	AB: Account Key for Materials Without Value Update	nvarchar	3	CHAR	(N' ')	Yes	T687	WLF_KTOSL_ACC	Allow NULL?
109	POST_CANCEL_DOC	AB: Posting of Reversal Document	char	1	CHAR	(N' ')	Yes		WLF_POST_CANCEL_DOCUMENT	Allow NULL?
110	DI_RELEVANT	AB: Invoice Correction Control from Customer Invoices	char	1	CHAR	(N' ')	Yes		WLF_DI_RELEVANT	Allow NULL?
111	SMT_CONTEXT	Context	nvarchar	10	CHAR	(N' ')	Yes	TSMT_CONTEXT	SMT_CONTEXT	Allow NULL?
112	TDID_HS1	AB: Text ID for Adoption of Text at Enterprise Services	nvarchar	4	CHAR	(N' ')	Yes	TTXERN	WLF_TDID_HS1	Allow NULL?
113	TDID_HS2	AB: Text ID for Adoption of Text at Enterprise Services	nvarchar	4	CHAR	(N' ')	Yes	TTXERN	WLF_TDID_HS2	Allow NULL?
114	TDID_HS3	AB: Text ID for Adoption of Text at Enterprise SOA Services	nvarchar	4	CHAR	(N' ')	Yes	TTXERN	WLF_TDID_HS3	Allow NULL?
115	TDID_IS1	AB: Text ID for Adoption of Text at Enterprise SOA Services	nvarchar	4	CHAR	(N' ')	Yes	TTXERN	WLF_TDID_IS1	Allow NULL?
116	CANCEL_ONLY	Billing Type May Only Be Used for Cancellation	char	1	CHAR	(N' ')	Yes		WLF_LFART_CANCEL_ONLY	Allow NULL?
117	ITEM_BASED	Generate Partner Lines at Item Level	char	1	CHAR	(N' ')	Yes		WLF_ACC_CREATE_ITEM_BASED	Allow NULL?
118	INSERT_MODE	Insert Mode for FI Doc. Line Items	char	1	CHAR	(N' ')	Yes		WLF_ACC_LINES_INSERT_MODE	Allow NULL?
119	FIELDSTATUSGROUP	Field Status Group	nvarchar	4	CHAR	(N' ')	Yes	TMFSG	WLF_FIELDSTATUSGROUP	Allow NULL?
120	COLSORTGROUP	Column Sorting Group	nvarchar	4	CHAR	(N' ')	Yes	TMCSGR	WLF_COLSORTGROUP	Allow NULL?
121	PARVW_LIFNR_FI	Partner Role of Alternative Creditor	nvarchar	2	CHAR	(N' ')	Yes	TPAR	WLF_PARVW_LIFNR_FI	Allow NULL?
122	LIFNR_FI_NOT_ACT	AB: No Alternative Creditor	char	1	CHAR	(N' ')	Yes		WLF_LIFNR_FI_NOT_ACTIVE	Allow NULL?
123	DISTRIBUTION	AB: Distribution Active	char	1	CHAR	(N' ')	Yes		WLF_DISTRIBUTION_ACTIVE	Allow NULL?
124	EFFWR_NEG	Negative Effective Value Allowed	char	1	CHAR	(N' ')	Yes		WLF_EFFWR_NEGATIVE	Allow NULL?
125	POSNR_MAIN_ACTIV	Main Item Active	char	1	CHAR	(N' ')	Yes		WLF_POSNR_MAIN_ACTIVE	Allow NULL?
126	KALSMCB_K	Calcultn. Schema f. Determ. Vendor Reconciliation Account	nvarchar	6	CHAR	(N' ')	Yes	T683	WLF_KALSMCB_K	Allow NULL?
127	KALSMCB_D	Calcultn. Schema f. Determ. Customer Reconciliation Account	nvarchar	6	CHAR	(N' ')	Yes	T683	WLF_KALSMCB_D	Allow NULL?
128	CALC_PYAMT	AB: Determination of Amount in Payment Currency	char	1	CHAR	(N' ')	Yes		WLF_CALC_PYAMT	Allow NULL?
129	ACC_DETERM_TYPE	AB: Account Determination Procedure	char	1	CHAR	(N' ')	Yes		WLF_ACCOUNT_DETERMINATION_TYPE	Allow NULL?
130	INTRASTAT_PROC	Process Control for Intrastat Declarations	char	1	CHAR	(N' ')	Yes		WLF_INTRASTAT_PROCESS	Allow NULL?
131	INTRASTAT_FLOW	Type of Goods Flow for Intrastat Declarations	char	1	CHAR	(N' ')	Yes		WLF_INTRASTAT_FLOW	Allow NULL?
132	DOC_INDEX_TYPE	Document Index Update	char	1	CHAR	(N' ')	Yes		WLF_DOCUMENT_INDEX_TYPE	Allow NULL?
133	SET_LANDTX	Propose Tax Departure Country	char	1	CHAR	(N' ')	Yes		WLF_SET_LANDTX	Allow NULL?
134	SET_LAND1TX	Propose Tax Destination Country	char	1	CHAR	(N' ')	Yes		WLF_SET_LAND1TX	Allow NULL?
135	SET_LAND_PRIC_K	Set Country Key for Vendor Pricing	char	1	CHAR	(N' ')	Yes		WLF_SET_LAND_PRICING_VENDOR	Allow NULL?
136	SET_LAND_PRIC_D	Set Country Key for Customer Pricing	char	1	CHAR	(N' ')	Yes		WLF_SET_LAND_PRICING_CUSTOMER	Allow NULL?
137	HANDLE_STCEG	Handling for Vendor VAT ID	char	1	CHAR	(N' ')	Yes		WLF_HANDLE_STCEG	Allow NULL?
138	HANDLE_STCEGD	Handling for Customer VAT ID	char	1	CHAR	(N' ')	Yes		WLF_HANDLE_STCEGD	Allow NULL?
139	DEF_STCEG	Default Logic for Vendor VAT ID	char	1	CHAR	(N' ')	Yes		WLF_DEFAULT_LOGIC_STCEG	Allow NULL?
140	DEF_STCEGD	Default Logic for Customer VAT ID	char	1	CHAR	(N' ')	Yes		WLF_DEFAULT_LOGIC_STCEGD	Allow NULL?
141	CHECK_STCEG	Check for Vendor VAT ID	char	1	CHAR	(N' ')	Yes		WLF_CHECK_STCEG	Allow NULL?
142	CHECK_STCEGD	Check for Customer VAT ID	char	1	CHAR	(N' ')	Yes		WLF_CHECK_STCEGD	Allow NULL?
143	WZLSPRD	Debtor Payment Block	char	1	CHAR	(N' ')	Yes	T008	WLF_ZLSPR_DEB	Allow NULL?
144	PRICING_COMP_K	Execute Final Processing for Vendor Pricing	char	1	CHAR	(N' ')	Yes		WLF_PRICING_COMPLETE_KRED	Allow NULL?
145	PRICING_COMP_D	Execute Final Processing for Customer Pricing	char	1	CHAR	(N' ')	Yes		WLF_PRICING_COMPLETE_DEB	Allow NULL?
146	CHECK_OWN_STCEG	Check Availability of Own VAT ID	char	1	CHAR	(N' ')	Yes		WLF_CHECK_OWN_STCEG	Allow NULL?
147	WEIGHT_VOLUME	Level on which You Enter Weight and Volume	char	1	CHAR	(N' ')	Yes		WLF_WEIGHT_VOLUME_LEVEL	Allow NULL?
148	SET_XEGDR	Set Triangular Deal Indicator	char	1	CHAR	(N' ')	Yes		WLF_SET_XEGDR	Allow NULL?
149	INCOTERMS_ACTIVE	Agency Business: Incoterms Active	char	1	CHAR	(N' ')	Yes		WLF_INCOTERMS_ACTIVE	Allow NULL?
150	NO_KNTYP_CHECK	No Pricinf Condition Check in Calculation Schema	char	1	CHAR	(N' ')	Yes		WLF_NO_KNTYP_CHECK	Allow NULL?
151	DET_PARTNER	AB: Transfer Partner from Master Data	char	1	CHAR	(N' ')	Yes		WLF_DETERMINE_PARTNER	Allow NULL?
152	PROCESS_TYPE	Process Category	nvarchar	4	CHAR	(N' ')	Yes	WLF_C_PROCTYPE	WLF_PROCESS_TYPE	Allow NULL?
153	CHECK_AP_RG	Check Alternative Payee/Payer	char	1	CHAR	(N' ')	Yes		WLF_CHECK_LNRZB_KUNRG	Allow NULL?
154	ZTERM_CASH_DISC	Variant Cash Discount % Allowed(Deviating from Payment Term)	char	1	CHAR	(N' ')	Yes		WLF_HANDLE_ZTERM_CASH_DISC	Allow NULL?
155	LFART_COLL	AD: Billing Type for Collection of Settlement Requests	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WLF_LFART_COLLECTION	Allow NULL?
156	BANKDATA_TRANSFER	AD: Transfer Control for Bank Data	char	1	CHAR	(N' ')	Yes		WLF_BANKDATA_TRANSFER	Allow NULL?
157	IVGROUP	Check Group	nvarchar	4	CHAR	(N' ')	Yes	TMIVG	WLF_IV_GROUP	Allow NULL?
158	USE_CASE	Use Case Type	nvarchar	2	CHAR	(N' ')	Yes		WLF_USE_CASE_TYPE	Allow NULL?

TOP ERP 6.0 | TMFK INDEXES

Name	Primary	Unique	Type	Columns
TMFK~0	Yes	Yes	CLUSTERED	MANDT, LFART

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