SAP TMFK Agency Business: Billing Document Types Table data and field list

TMFK is a standard SAP Table which is used to store Agency Business: Billing Document Types data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The TMFK table consists of various fields, each holding specific information or linking keys about Agency Business: Billing Document Types data available in SAP. These include LFART (Agency business: Billing document type), LFTYP (Agency business: Billing category), KAPPL (AB: Price Determination Application), NUMKI (Number range in the case of internal number assignment)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

TMFK table Technical Details:

Delivery Class: G - Customising table which is protected against SAP Update
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = TMFKT

SAP TMFK table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the TMFK table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
LFART	Agency business: Billing document type	WFART	CHAR	4			WFART	WFA
LFTYP	Agency business: Billing category	WFTYP	CHAR	2			WFTYP
KAPPL	AB: Price Determination Application	WLF_KAPPL_PRICING	CHAR	2			WLF_KAPPL_PRICING	KAP
NUMKI	Number range in the case of internal number assignment	NUMKI	CHAR	2			NUMKR
NUMKE	Number range in the case of external number assignment	NUMKE	CHAR	2			NUMKR
INCPO	Increment of item no. of vendor billing document	WINCPO	NUMC	6			NUM6
RFBFK	Blocked for transfer to accounting	WFBFK	CHAR	1			XFELD
NARVF	Vendor billing document is relevant for subseq. settlement	NARVF	CHAR	1			XFELD
LFARTS	Reversal type: vendor billing document	WFARTS	CHAR	4	TMFK		WFART
KAPPL_NA	Application for output conditions	NA_KAPPL	CHAR	2	T681A		KAPPL		NA_KAPPL
KALSMK	Output determination procedure	KALSMB	CHAR	6	T683		KALSM
KALSMP	Procedure for item output	KALSMBP	CHAR	6	T683		KALSM
KSCHL	Output Type	NA_KSCHL	CHAR	4	T685		KSCHL	NAC	CSH_NA_KSCHL
ABART	Settlement Type	NAFKT	CHAR	1			NAFKT
STATI	Update statistics	STATI	CHAR	1			XFELD
LFART_RL	Remuneration List Type, Vendor Billing Document	WFART_RL	CHAR	4	TMFK		WFART
RELEP	Forward Remuneration Lists with Line Items to FI	WRELEP	CHAR	1			XFELD
PARGK	Partner schema for the billing doc.header	WPARGK	CHAR	4	TVPG		PARGR
PARGP	Partner schema for the billing doc.item	WPARGP	CHAR	4	TVPG		PARGR
KALVG	Document schema for determining calculation schema	WKALVG	CHAR	2	TMKV		WKALVG
WERKM	Vendor billing document: Entry with plant data	WERKM	CHAR	1			XFELD
PRDVO	Agency business: price date default	WPRDV	CHAR	1			WPRDV
INFOL	Vendor billing document: read info record	WINFO	CHAR	1			XFELD
XBLNR_FI	Vendor billing document: FI assignment no.	WBLNR_FI	CHAR	1			WBLNR_FI
XRBLN_FI	Vendor billing doc.: FI doc. reference no.	WRBLN_FI	CHAR	1			WRBLN_FI
KIDNO_LF	Vendor billing document: Payment reference number FI	WIDNO_FI	CHAR	1			WIDNO_LF
BLART	Document Type	BLART	CHAR	2	T003		BLART	BAR
XNEGP	Negative posting	XNEGP_LF	CHAR	1			XNEGP_LF
XVALGS	Credit memo with value date	WVALGS	CHAR	1			XFELD
WZFBD	Copy Payment Data from Remuneration List to Billing Docs	WZFBD	CHAR	1			XFELD
WZLSPR	Payment block for payment recipient	WZLSPR	CHAR	1	T008		ZAHLS
WZLSPL	Reset Payment Block During Remuneration List Run	WZLSPL	CHAR	1			XFELD
LFGRU_VO	Agency business: Default reason (reason for activity)	WFGRU_VO	CHAR	3	TMLFG		WFGRU
KTOSL_VE	Account key for settlement line in settlement request	KTOSL_VE	CHAR	3	T687		KVSCHL
KTOSL_VM	Account key, clearing account, vendor billing document	KOTSL_VM	CHAR	3	T687		KVSCHL
KTOSL_MG	Account Key: Offsetting Account for Material Adjustment	KTOSL_MG	CHAR	3	T687		KVSCHL
WZUSPL	Assignment as Splitting Criterion for Remuneration Lists	WZUSPL	CHAR	1			XFELD
WKIDSP	Payment Reference as Splitting Criterion in Remuner. Lists	WKIDSP	CHAR	1			XFELD
WFDATSP	Document date as splitting criterion for lists	WFDATSP	CHAR	1			XFELD
WZTERMSP	Terms of payment as splitting criterion for lists	WZTERMSP	CHAR	1			XFELD
WZLSCHSP	Payment Method as Split Criterion for Lists	WZLSCHSP	CHAR	1			XFELD
WPYCURSP	Payment currency as splitting criteria for lists	WPYCURSP	CHAR	1			XFELD
WITEMSP	Maximum number of items in a list	WITEMSP	NUMC	6			NUMC6
TXTGR	Text determination procedure: Header	TXTGR_H	CHAR	2	TTXG		TXTGR
TXTGR_I	Text determination procedure: Item	TXTGR_I	CHAR	2	TTXG		TXTGR
TDID	Text ID for text edit control	TDID_TEC	CHAR	4	TTXERN		TDID
TDID_I	Text ID for TextEdit control (item level)	TDID_TECI	CHAR	4	TTXERN		TDID
WPOINT	Agency business: Change document processing active	WPOINT	CHAR	1			WPOINT
WPYCUR	Agency business: Different payment currency active	WPYCUR	CHAR	1			XFELD
KUDVO	Agency Business: Default Exchange Rate Date	WKUDVO	CHAR	1			WKUDVO
PRCHGRP	Price change group	PRCHGRP	CHAR	2	TMFK4		CHAR2
AR_OBJECT	Document type	SAEOBJART	CHAR	10	TOADV		SADC10_DV	DOK
KURST	Exchange Rate Type	KURST	CHAR	4	TCURV		KURST	KUT
WERN	Item amounts can be zero	WERN	CHAR	1			XFELD
KSCHLP	Output Type	NA_KSCHL	CHAR	4	T685		KSCHL	NAC	CSH_NA_KSCHL
WBART_FI	Valuation Procedure When Releasing to Accounting	WBART_FI	CHAR	1			WBART_FI
DOCPARTY	Business Partners in Billing Document	DOCPARTY	CHAR	1			DOCPARTY
KALSMC	Account determination procedure	KALSMC	CHAR	6	T683		KALSM
LFART_BL	Settlement request: Billing doc. category - posting list	WFART_BL	CHAR	4	TMFK		WFART
LFART_BD	Agency Business: Billing Type for Customer Settlement	WFART_BD	CHAR	4	TMFK		WFART
NETWN	Negative Net Value Indicator	NETWN	CHAR	1			WLF_NETWN
BUSTW	Alternative Posting String for Values	WBUSTW	CHAR	4	T169A		BUSTW
HEADDATA	Include Document Header Data at Item Level Also	WLF_ADD_HEADER_READ	CHAR	1			WLF_ADD_HEADER_READ
RRLCHANGEKONV	AB: Consideration of Billg Cat. with Follow-On Doc. Creation	WLF_RRL_CHANGE_KONV	CHAR	1			WLF_RRL_CHANGE_KONV
RRLTAX	Agency Business: Tax Determination Method	WLF_RRL_TAX	CHAR	1			WLF_RRL_TAX
.INCLU--AP				0
BLART_CUSTOMER	Different FI Document Type for Customer for Split	WLF_BLART_CUSTOMER	CHAR	2	T003		BLART
KTOSL_VE_CUST	Different Sales Settlement Account for Customer Payment	WLF_KTOSL_VE_CUSTOMER	CHAR	3	T687		KVSCHL
WCONSP	Contract Number as Split Criterion	WCONSP	CHAR	1			XFELD
BW_DELTA	BW Update	BW_DELTA	CHAR	1			BW_UPDATE_FLAG
DUPD_SINGLE	BW Control for Single Settlement Documents	DUPD_SINGLE	CHAR	1			DUPD_SINGLE
WTREE	Display Reference Documents in TREE	WLF_TREE	CHAR	1			WLF_TREE
CANCEL_TYPE	Agency Business: FI Cancellation Method	WLF_CANCEL_TYPE	CHAR	1			WLF_CANCEL_TYPE
XREF_RRL	AB: Remuneration List Number in FI Documents Original Docs	WLF_XREF_RRL	CHAR	1			WLF_XREF_RRL
HITYP_VENDOR	Hierarchy category: vendor hierarchy	HITYP_LH	CHAR	1	TLHIT		HITYP_LH		HITYP_LH
HITYP_CUSTOMER	Hierarchy type for pricing	HITYP_PR	CHAR	1	THIT		HITYP
COPA_ACTIVE	AB: Profitability Analysis Active	WLF_COPA_ACTIVE	CHAR	1			WLF_COPA_ACTIVE
FILL_REF_DOC	AB: Fill Reference Document Data	WLF_FILL_REF_DOC	CHAR	1			XFELD
CANCEL_VARIANT	AB: Cancellation Variant	WLF_CANCEL_VARIANT	CHAR	1			WLF_CANCEL_VARIANT
LFART_SL	Agency Business: Billing Doc. Type - Settlement Req. List	WFART_SL	CHAR	4	TMFK		WFART
LFART_VS	Agency Business: Billing Doc. Type - Vendor Settlement	WFART_VS	CHAR	4	TMFK		WFART
SET_SGTXT_FI	AB: Set Item Text FI	WLF_SET_SGTXT_FI	CHAR	1			WLF_SET_SGTXT_FI
LNRZB_NOT_ACTIVE	AB: No Different Payment Recipient	WLF_LNRZB_NOT_ACTIVE	CHAR	1			XFELD
DOCUMENT_INDEX	AB: Document Index Active	WLF_DOCUMENT_INDEX_ACTIVE	CHAR	1			XFELD
DOC_INDEX_DELETE	AB: Delete Document Index After Posting	WLF_DOC_INDEX_DEL_AFTER_POST	CHAR	1			XFELD
DEF_IDOBJ_TYPE_V	AB: Identification Object Type Vendor	WLF_IDOBJ_TYPE_VENDOR	CHAR	4	TMIDTV		WLF_IDOBJ_TYPE_VENDOR
DEF_IDOBJ_TYPE_C	AB: Identification Object Type Customer	WLF_IDOBJ_TYPE_CUSTOMER	CHAR	4	TMIDTC		WLF_IDOBJ_TYPE_CUSTOMER
VENDOR_INPUT	AB: Entry - Invoicing Party	WLF_VENDOR_INPUT	CHAR	1			WLF_VENDOR_INPUT
CUSTOMER_INPUT	AB: Entry of Invoice Recipient	WLF_CUSTOMER_INPUT	CHAR	1			WLF_CUSTOMER_INPUT
DEF_IDNLF_TYPE	AB: Article Number Type - Vendor	WLF_IDNLF_TYPE	CHAR	4	TMVMT		WLF_IDNLF_TYPE
KSTAT_ACCOUNT	AB: Posting Statistical Conditions to Accounting	WLF_KSTAT_ACCOUNTING	CHAR	1			WLF_KSTAT_ACCOUNTING
MATERIAL_INPUT	AB: Entry of Material	WLF_MATERIAL_INPUT	CHAR	1			WLF_MATERIAL_INPUT
DEF_POST_RULE_K	AB: Creditor Posting Rule	WLF_POSTING_RULE_K	CHAR	2	TMPR		WLF_POSTING_RULE
DEF_POST_RULE_D	AB: Debtor Posting Rule	WLF_POSTING_RULE_D	CHAR	2	TMPR		WLF_POSTING_RULE
CHECK_WFDAT	AB: Check Posting Date on Entry	WLF_CHECK_WFDAT	CHAR	1			WLF_CHECK_WFDAT
ITEM_CANCEL	AB: Item Cancellation Allowed	WLF_ITEM_CANCEL_ALLOWED	CHAR	1			XFELD
CM_ACTIVE	Credit Management	WLF_CM_ACTIVE	CHAR	1			WLF_CM_ACTIVE
CRMGR	Document credit group	CRMGR_CM	CHAR	2	T691D		CRMGR_CM
CM_CHECK	Agency Business: Credit Limit Check Time	WLF_CM_CHECK	CHAR	1			WLF_CM_CHECK
COCO_DET	AB: Carry Out Condition Contract Determination	WLF_COCO_DET	CHAR	1			WLF_COCO_DET
BILLTOPARTY	Invoice Recipient	WLF_PARVW_BT	CHAR	2	TPAR	PARVW	PARVW
BILLFROMPARTY	AB: Diff. Partner Function for Determining Invoicing Party	WLF_PARVW_BF	CHAR	2	TPAR	PARVW	PARVW
EVENT_RELEVANT	Agency Business: Control of Event Call-Up	WLF_EVENT_RELEVANT	CHAR	1			WLF_EVENT_RELEVANT
CONTEXT	Context	WUF_CONTEXT	CHAR	10			WUF_CONTEXT
CONF_ALLWD	Configuration at Item Level is Allowed	WLF_CONF_ALLWD	CHAR	1			WLF_CONF_ALLWD
TAX_CODE_ACTIVE	AB: Tax Code Active	WLF_TAX_CODE_ACTIVE	CHAR	1			WLF_TAX_CODE_ACTIVE
KTOSL_AS	Account Key for Posting of Exchange Rate Differences	WLF_KTOSL_AS	CHAR	3	T687		KVSCHL
.INCLU--AP				0
KTOSL_ACC	AB: Account Key for Materials Without Value Update	WLF_KTOSL_ACC	CHAR	3	T687		KVSCHL
.INCLU--AP				0
POST_CANCEL_DOC	AB: Posting of Reversal Document	WLF_POST_CANCEL_DOCUMENT	CHAR	1			WLF_POST_CANCEL_DOCUMENT
DI_RELEVANT	AB: Invoice Correction Control from Customer Invoices	WLF_DI_RELEVANT	CHAR	1			WLF_DI_RELEVANT
SMT_CONTEXT	Context	SMT_CONTEXT	CHAR	10	TSMT_CONTEXT		SMT_CONTEXT
TDID_HS1	AB: Text ID for Adoption of Text at Enterprise Services	WLF_TDID_HS1	CHAR	4	TTXERN		TDID
TDID_HS2	AB: Text ID for Adoption of Text at Enterprise Services	WLF_TDID_HS2	CHAR	4	TTXERN		TDID
TDID_HS3	AB: Text ID for Adoption of Text at Enterprise SOA Services	WLF_TDID_HS3	CHAR	4	TTXERN		TDID
TDID_IS1	AB: Text ID for Adoption of Text at Enterprise SOA Services	WLF_TDID_IS1	CHAR	4	TTXERN		TDID
CANCEL_ONLY	Billing Type May Only Be Used for Cancellation	WLF_LFART_CANCEL_ONLY	CHAR	1			XFELD
ITEM_BASED	Generate Partner Lines at Item Level	WLF_ACC_CREATE_ITEM_BASED	CHAR	1			WLF_ACC_CREATE_ITEM_BASED
INSERT_MODE	Insert Mode for FI Doc. Line Items	WLF_ACC_LINES_INSERT_MODE	CHAR	1			WLF_ACC_LINES_INSERT_MODE
FIELDSTATUSGROUP	Field Status Group	WLF_FIELDSTATUSGROUP	CHAR	4	TMFSG		WLF_FIELDSTATUSGROUP
COLSORTGROUP	Column Sorting Group	WLF_COLSORTGROUP	CHAR	4	TMCSGR		WLF_COLSORTGROUP
PARVW_LIFNR_FI	Partner Role of Alternative Creditor	WLF_PARVW_LIFNR_FI	CHAR	2	TPAR	PARVW	PARVW
LIFNR_FI_NOT_ACT	AB: No Alternative Creditor	WLF_LIFNR_FI_NOT_ACTIVE	CHAR	1			XFELD
.INCLU--AP				0
DISTRIBUTION	AB: Distribution Active	WLF_DISTRIBUTION_ACTIVE	CHAR	1			WLF_DISTRIBUTION_ACTIVE
EFFWR_NEG	Negative Effective Value Allowed	WLF_EFFWR_NEGATIVE	CHAR	1			WLF_NETWN
POSNR_MAIN_ACTIV	Main Item Active	WLF_POSNR_MAIN_ACTIVE	CHAR	1			WLF_POSNR_MAIN_ACTIVE
KALSMCB_K	Calcultn. Schema f. Determ. Vendor Reconciliation Account	WLF_KALSMCB_K	CHAR	6	T683		KALSM
KALSMCB_D	Calcultn. Schema f. Determ. Customer Reconciliation Account	WLF_KALSMCB_D	CHAR	6	T683		KALSM
CALC_PYAMT	AB: Determination of Amount in Payment Currency	WLF_CALC_PYAMT	CHAR	1			WLF_CALC_PYAMT
ACC_DETERM_TYPE	AB: Account Determination Procedure	WLF_ACCOUNT_DETERMINATION_TYPE	CHAR	1			WLF_ACCOUNT_DETERMINATION_TYPE
INTRASTAT_PROC	Process Control for Intrastat Declarations	WLF_INTRASTAT_PROCESS	CHAR	1			WLF_INTRASTAT_PROCESS
INTRASTAT_FLOW	Type of Goods Flow for Intrastat Declarations	WLF_INTRASTAT_FLOW	CHAR	1			WLF_INTRASTAT_FLOW
DOC_INDEX_TYPE	Document Index Update	WLF_DOCUMENT_INDEX_TYPE	CHAR	1			WLF_DOCUMENT_INDEX_TYPE
SET_LANDTX	Propose Tax Departure Country	WLF_SET_LANDTX	CHAR	1			XFELD
SET_LAND1TX	Propose Tax Destination Country	WLF_SET_LAND1TX	CHAR	1			XFELD
SET_LAND_PRIC_K	Set Country Key for Vendor Pricing	WLF_SET_LAND_PRICING_VENDOR	CHAR	1			WLF_SET_LAND_PRICING_VENDOR
SET_LAND_PRIC_D	Set Country Key for Customer Pricing	WLF_SET_LAND_PRICING_CUSTOMER	CHAR	1			WLF_SET_LAND_PRICING_CUSTOMER
HANDLE_STCEG	Handling for Vendor VAT ID	WLF_HANDLE_STCEG	CHAR	1			WLF_HANDLE_STCEG
HANDLE_STCEGD	Handling for Customer VAT ID	WLF_HANDLE_STCEGD	CHAR	1			WLF_HANDLE_STCEG
DEF_STCEG	Default Logic for Vendor VAT ID	WLF_DEFAULT_LOGIC_STCEG	CHAR	1			WLF_DEFAULT_LOGIC_STCEG
DEF_STCEGD	Default Logic for Customer VAT ID	WLF_DEFAULT_LOGIC_STCEGD	CHAR	1			WLF_DEFAULT_LOGIC_STCEGD
CHECK_STCEG	Check for Vendor VAT ID	WLF_CHECK_STCEG	CHAR	1			XFELD
CHECK_STCEGD	Check for Customer VAT ID	WLF_CHECK_STCEGD	CHAR	1			XFELD
WZLSPRD	Debtor Payment Block	WLF_ZLSPR_DEB	CHAR	1	T008		ZAHLS
PRICING_COMP_K	Execute Final Processing for Vendor Pricing	WLF_PRICING_COMPLETE_KRED	CHAR	1			WLF_PRICING_COMPLETE
PRICING_COMP_D	Execute Final Processing for Customer Pricing	WLF_PRICING_COMPLETE_DEB	CHAR	1			WLF_PRICING_COMPLETE
CHECK_OWN_STCEG	Check Availability of Own VAT ID	WLF_CHECK_OWN_STCEG	CHAR	1			WLF_CHECK_OWN_STCEG
WEIGHT_VOLUME	Level on which You Enter Weight and Volume	WLF_WEIGHT_VOLUME_LEVEL	CHAR	1			WLF_WEIGHT_VOLUME_LEVEL
SET_XEGDR	Set Triangular Deal Indicator	WLF_SET_XEGDR	CHAR	1			WLF_SET_XEGDR
.INCLU--AP				0
INCOTERMS_ACTIVE	Agency Business: Incoterms Active	WLF_INCOTERMS_ACTIVE	CHAR	1			XFELD
NO_KNTYP_CHECK	No Pricinf Condition Check in Calculation Schema	WLF_NO_KNTYP_CHECK	CHAR	1			XFELD
DET_PARTNER	AB: Transfer Partner from Master Data	WLF_DETERMINE_PARTNER	CHAR	1			WLF_DETERMINE_PARTNER
PROCESS_TYPE	Process Category	WLF_PROCESS_TYPE	CHAR	4	WLF_C_PROCTYPE		WLF_PROCESS_TYPE
CHECK_AP_RG	Check Alternative Payee/Payer	WLF_CHECK_LNRZB_KUNRG	CHAR	1			WLF_CHECK_LNRZB_KUNRG
.INCLU--AP				0
ZTERM_CASH_DISC	Variant Cash Discount % Allowed(Deviating from Payment Term)	WLF_HANDLE_ZTERM_CASH_DISC	CHAR	1			XFELD
LFART_COLL	AD: Billing Type for Collection of Settlement Requests	WLF_LFART_COLLECTION	CHAR	4	TMFK		WFART
BANKDATA_TRANSFER	AD: Transfer Control for Bank Data	WLF_BANKDATA_TRANSFER	CHAR	1			WLF_BANKDATA_TRANSFER
.INCLU--AP				0
IVGROUP	Check Group	WLF_IV_GROUP	CHAR	4	TMIVG	ALPHA	WLF_IV_GROUP
.INCLU--AP				0
USE_CASE	Use Case Type	WLF_USE_CASE_TYPE	CHAR	2			WLF_USE_CASE_TYPE

Key field

Non-key field

< TMFILT - Filter for Monitoring Dates TMFK1 - Price Change Group >

How do I retrieve data from SAP table TMFK using ABAP code

The following ABAP code Example will allow you to do a basic selection on TMFK to SELECT all data from the table
DATA: WA_TMFK TYPE TMFK.

SELECT SINGLE *
FROM TMFK
INTO CORRESPONDING FIELDS OF WA_TMFK
WHERE...

How to access SAP table TMFK

Within an ECC or HANA version of SAP you can also view further information about TMFK and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).