SAP LFM2 Vendor Master Record: Purchasing Data Table data and field list

LFM2 is a standard SAP Table which is used to store Vendor Master Record: Purchasing Data data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The LFM2 table consists of various fields, each holding specific information or linking keys about Vendor Master Record: Purchasing Data data available in SAP. These include LIFNR (Account Number of Vendor or Creditor), EKORG (Purchasing Organization), LTSNR (Vendor Subrange), WERKS (Plant)... 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. .

LFM2 table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP LFM2 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 LFM2 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
MANDTClient MANDTCLNT3T000MANDT
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
LTSNRVendor Subrange LTSNRCHAR6WYT1LTSNR
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
SPERMPurchasing block at purchasing organization level SPERM_MCHAR1XFELD
LOEVMDelete flag for vendor at purchasing level LOEVM_MCHAR1XFELD
LFABCABC indicator LFABCCHAR1LFABC
WAERSPurchase order currency BSTWACUKY5TCURCWAERS
VERKFResponsible Salesperson at Vendor's Office EVERKCHAR30TEXT30
TELF1Vendor's telephone number TELFECHAR16TEXT16
MINBWMinimum order value MINBWCURR13(2) WERT7
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
INCO1Incoterms (Part 1) INCO1CHAR3TINCINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
WEBREIndicator: GR-Based Invoice Verification WEBRECHAR1XFELD
KZABSOrder Acknowledgment Requirement KZABSCHAR1XFELD
KALSKGroup for Calculation Schema (Vendor) KALSKCHAR2TMKKKALSK
KZAUTAutomatic Generation of Purchase Order Allowed KZAUTCHAR1XFELD
EXPVZMode of Transport for Foreign Trade EXPVZCHAR1T618EXPVZ
ZOLLACustoms Office: Office of Exit/Entry for Foreign Trade DZOLLSCHAR6T615ZOLLS
MEPRFPrice Determination (Pricing) Date Control MEPRFCHAR1MEPRF
EKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
XERSYEvaluated Receipt Settlement (ERS) XERSYCHAR1XFELD
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
MRPPPPlanning calendar MRPPP_WCHAR3T439GMRPPP
LFRHYPlanning cycle LFRHYCHAR3T439GMRPPP
LIBESOrder entry by vendor LIBESCHAR1CHAR1
LIPREPrice marking, vendor LIPRECHAR2TWYAZLIPRE
LISERRack-jobbing: vendor LISERCHAR1CHAR1
DISPOMRP Controller (Materials Planner) DISPOCHAR3T024DDISPODGRHS_T024D
BOINDField Not Used (Subsequent Settlement) BOIND_UNUSEDCHAR1XFELD
BSTAEConfirmation Control Key BSTAECHAR4T163LBSTAE
RDPRFRounding Profile RDPRFCHAR4RDPRRDPRF
MEGRUUnit of Measure Group MEGRUCHAR4TWMEGMEGRU
BOPNRRestriction Profile for PO-Based Load Building BOPNRCHAR4TWBO1CHAR4
XERSRAutomatic evaluated receipt settlement for return items XERSRCHAR1XFELD
ABUEBRelease Creation Profile ABUEBCHAR4T163PABUEB
PAPRFProfile for transferring material data via IDoc PROACT WVMI_PAPRFCHAR4TWVMOWVMI_PAPRF
XNBWYRevaluation allowed XNBWYCHAR1XFELD
LEBREIndicator for Service-Based Invoice Verification LEBRECHAR1XFELD
BOLREField Not Used (Subsequent Settlement) BOLRE_UNUSEDCHAR1XFELD
UMSAEField Not Used (Subsequent Settlement) UMSAE_UNUSEDCHAR1XFELD
.INCLU--AP 0
UPPRSPricing on Subitems (MPN/SUS) UPPRSCHAR1UPPRS
.INCLU--AP 0
TRANSPORT_CHAINTransportation Chain WRF_PSCD_TC_IDCHAR10WRF_PSCD_TCHAINHWRF_PSCD_TC_ID
STAGING_TIMEStaging Time in Days WRF_PSCD_MSTDEC3WRF_PSCD_MST

Key field Non-key field



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

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

SELECT SINGLE *
FROM LFM2
INTO CORRESPONDING FIELDS OF WA_LFM2
WHERE...

How to access SAP table LFM2

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

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