SAP Table LFM2
Vendor Master Record: Purchasing Data
LFM2 (Vendor Master Record: Purchasing Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link LFM2 to other SAP tables.
LFM2 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 | 0 | ||||||||||||||
| EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||||||||||
| LTSNR | Vendor Subrange | LTSNR | WYT1 | CHAR | 6 | 0 | ||||||||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||||||||
| SPERM | Purchasing block at purchasing organization level | SPERM_M | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| LOEVM | Delete flag for vendor at purchasing level | LOEVM_M | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| LFABC | ABC indicator | LFABC | CHAR | 1 | 0 | |||||||||||||||
| WAERS | Purchase order currency | BSTWA | TCURC | CUKY | 5 | 0 | ||||||||||||||
| VERKF | Responsible Salesperson at Vendor's Office | EVERK | CHAR | 30 | 0 | |||||||||||||||
| TELF1 | Vendor's telephone number | TELFE | CHAR | 16 | 0 | |||||||||||||||
| MINBW | Minimum order value | MINBW | CURR | 13 | 2 | |||||||||||||||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | 0 | |||||||||||||||
| INCO1 | Incoterms (Part 1) | INCO1 | TINC | CHAR | 3 | 0 | ||||||||||||||
| INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | 0 | |||||||||||||||
| WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| KZABS | Order Acknowledgment Requirement | KZABS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| KALSK | Group for Calculation Schema (Vendor) | KALSK | TMKK | CHAR | 2 | 0 | ||||||||||||||
| KZAUT | Automatic Generation of Purchase Order Allowed | KZAUT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| EXPVZ | Mode of Transport for Foreign Trade | EXPVZ | T618 | CHAR | 1 | 0 | ||||||||||||||
| ZOLLA | Customs Office: Office of Exit/Entry for Foreign Trade | DZOLLS | T615 | CHAR | 6 | 0 | ||||||||||||||
| MEPRF | Price Determination (Pricing) Date Control | MEPRF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 | 0 | ||||||||||||||
| XERSY | Evaluated Receipt Settlement (ERS) | XERSY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | 0 | |||||||||||||||
| MRPPP | Planning calendar | MRPPP_W | T439G | CHAR | 3 | 0 | ||||||||||||||
| LFRHY | Planning cycle | LFRHY | T439G | CHAR | 3 | 0 | ||||||||||||||
| LIBES | Order entry by vendor | LIBES | CHAR | 1 | 0 | |||||||||||||||
| LIPRE | Price marking, vendor | LIPRE | TWYAZ | CHAR | 2 | 0 | ||||||||||||||
| LISER | Rack-jobbing: vendor | LISER | CHAR | 1 | 0 | |||||||||||||||
| DISPO | MRP Controller (Materials Planner) | DISPO | T024D | CHAR | 3 | 0 | ||||||||||||||
| BOIND | Field Not Used (Subsequent Settlement) | BOIND_UNUSED | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| BSTAE | Confirmation Control Key | BSTAE | T163L | CHAR | 4 | 0 | ||||||||||||||
| RDPRF | Rounding Profile | RDPRF | RDPR | CHAR | 4 | 0 | ||||||||||||||
| MEGRU | Unit of Measure Group | MEGRU | TWMEG | CHAR | 4 | 0 | ||||||||||||||
| BOPNR | Restriction Profile for PO-Based Load Building | BOPNR | TWBO1 | CHAR | 4 | 0 | ||||||||||||||
| XERSR | Automatic evaluated receipt settlement for return items | XERSR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| ABUEB | Release Creation Profile | ABUEB | T163P | CHAR | 4 | 0 | ||||||||||||||
| PAPRF | Profile for transferring material data via IDoc PROACT | WVMI_PAPRF | TWVMO | CHAR | 4 | 0 | ||||||||||||||
| XNBWY | Revaluation allowed | XNBWY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| LEBRE | Indicator for Service-Based Invoice Verification | LEBRE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| BOLRE | Field Not Used (Subsequent Settlement) | BOLRE_UNUSED | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| UMSAE | Field Not Used (Subsequent Settlement) | UMSAE_UNUSED | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| TRANSPORT_CHAIN | Transportation Chain | WRF_PSCD_TC_ID | WRF_PSCD_TCHAINH | CHAR | 10 | 0 | ||||||||||||||
| STAGING_TIME | Staging Time in Days | WRF_PSCD_MST | DEC | 3 | 0 | |||||||||||||||
LFM2 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| LFM2 | ABUEB | LFM2 | ABUEB | T163P | Release Creation Profile | ABUEB |
| LFM2 | ABUEB | LFM2 | MANDT | T163P | Release Creation Profile | MANDT |
| LFM2 | ABUEB | LFM2 | WERKS | T163P | Release Creation Profile | WERKS |
| LFM2 | BOPNR | * | TWBO1 | Customizing table for opt. PO-based load building profiles | BOTYPI | |
| LFM2 | BOPNR | LFM2 | MANDT | TWBO1 | Customizing table for opt. PO-based load building profiles | MANDT |
| LFM2 | BOPNR | LFM2 | BOPNR | TWBO1 | Customizing table for opt. PO-based load building profiles | BOPNR |
| LFM2 | BOPNR | * | TWBO1 | Customizing table for opt. PO-based load building profiles | BORESTRI | |
| LFM2 | BSTAE | LFM2 | MANDT | T163L | Confirmation Control Keys | MANDT |
| LFM2 | BSTAE | LFM2 | BSTAE | T163L | Confirmation Control Keys | BSTAE |
| LFM2 | DISPO | LFM2 | MANDT | T024D | MRP controllers | MANDT |
| LFM2 | DISPO | LFM2 | WERKS | T024D | MRP controllers | WERKS |
| LFM2 | DISPO | LFM2 | DISPO | T024D | MRP controllers | DISPO |
| LFM2 | EKGRP | LFM2 | EKGRP | T024 | Purchasing Groups | EKGRP |
| LFM2 | EKGRP | SYST | MANDT | T024 | Purchasing Groups | MANDT |
| LFM2 | EKORG | LFM2 | EKORG | T024E | Purchasing Organizations | EKORG |
| LFM2 | EKORG | LFM2 | MANDT | T024E | Purchasing Organizations | MANDT |
| LFM2 | EXPVZ | *T001 | LAND1 | T618 | Foreign Trade: Modes of Transport | LAND1 |
| LFM2 | EXPVZ | LFM2 | EXPVZ | T618 | Foreign Trade: Modes of Transport | EXPVZ |
| LFM2 | EXPVZ | SYST | MANDT | T618 | Foreign Trade: Modes of Transport | MANDT |
| LFM2 | INCO1 | LFM2 | INCO1 | TINC | Customers: Incoterms | INCO1 |
| LFM2 | INCO1 | SYST | MANDT | TINC | Customers: Incoterms | MANDT |
| LFM2 | KALSK | SYST | MANDT | TMKK | Group for Calculation Schema (Vendor) | MANDT |
| LFM2 | KALSK | LFM2 | KALSK | TMKK | Group for Calculation Schema (Vendor) | KALSK |
| LFM2 | LFRHY | SYST | MANDT | T439G | PPplanning periods: header table | MANDT |
| LFM2 | LFRHY | LFM2 | WERKS | T439G | PPplanning periods: header table | WERKS |
| LFM2 | LFRHY | LFM2 | LFRHY | T439G | PPplanning periods: header table | MRPPP |
| LFM2 | LIFNR | LFM2 | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| LFM2 | LIFNR | LFM2 | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| LFM2 | LIPRE | SYST | MANDT | TWYAZ | Price Marking Agreement | MANDT |
| LFM2 | LIPRE | LFM2 | LIPRE | TWYAZ | Price Marking Agreement | LIPRE |
| LFM2 | LTSNR | LFM2 | MANDT | WYT1 | Vendor Subrange | MANDT |
| LFM2 | LTSNR | LFM2 | LIFNR | WYT1 | Vendor Subrange | LIFNR |
| LFM2 | LTSNR | LFM2 | LTSNR | WYT1 | Vendor Subrange | LTSNR |
| LFM2 | MANDT | LFM2 | MANDT | T000 | Clients | MANDT |
| LFM2 | MEGRU | LFM2 | MANDT | TWMEG | Unit of measure group | MANDT |
| LFM2 | MEGRU | LFM2 | MEGRU | TWMEG | Unit of measure group | MEGRU |
| LFM2 | MEGRU | * | TWMEG | Unit of measure group | MEINS | |
| LFM2 | MRPPP | LFM2 | MRPPP | T439G | PPplanning periods: header table | MRPPP |
| LFM2 | MRPPP | SYST | MANDT | T439G | PPplanning periods: header table | MANDT |
| LFM2 | MRPPP | LFM2 | WERKS | T439G | PPplanning periods: header table | WERKS |
| LFM2 | PAPRF | LFM2 | PAPRF | TWVMO | Control profiles for transferring material data to vendor | PAPRF |
| LFM2 | PAPRF | LFM2 | MANDT | TWVMO | Control profiles for transferring material data to vendor | MANDT |
| LFM2 | RDPRF | LFM2 | RDPRF | RDPR | Rounding profile | RDPRF |
| LFM2 | RDPRF | * | RDPR | Rounding profile | RDZAE | |
| LFM2 | RDPRF | LFM2 | MANDT | RDPR | Rounding profile | MANDT |
| LFM2 | RDPRF | LFM2 | WERKS | RDPR | Rounding profile | WERKS |
| LFM2 | TRANSPORT_CHAIN | * | WRF_PSCD_TCHAINH | Transportation Chain, Header | TC_MODE | |
| LFM2 | TRANSPORT_CHAIN | SYST | MANDT | WRF_PSCD_TCHAINH | Transportation Chain, Header | MANDT |
| LFM2 | TRANSPORT_CHAIN | LFM2 | TRANSPORT_CHAIN | WRF_PSCD_TCHAINH | Transportation Chain, Header | TC_ID |
| LFM2 | WAERS | SYST | MANDT | TCURC | Currency Codes | MANDT |
| LFM2 | WAERS | LFM2 | WAERS | TCURC | Currency Codes | WAERS |
| LFM2 | WERKS | LFM2 | MANDT | T001W | Plants/Branches | MANDT |
| LFM2 | WERKS | LFM2 | WERKS | T001W | Plants/Branches | WERKS |
| LFM2 | ZOLLA | SYST | MANDT | T615 | Foreign Trade: Customs Offices | MANDT |
| LFM2 | ZOLLA | *T001 | LAND1 | T615 | Foreign Trade: Customs Offices | LAND1 |
| LFM2 | ZOLLA | LFM2 | ZOLLA | T615 | Foreign Trade: Customs Offices | ZOLLA |
