SE11 ABAP Dictionary SE11 LFM2

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

LFM2

Vendor Master Record: Purchasing Data

SAP SAP Transparent Table 47 Fields

Primary Key:

MANDT LIFNR EKORG LTSNR WERKS

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	LIFNR	KEY	Vendor	CHAR	10	-	LFA1	Account Number of Vendor or Creditor
3	EKORG	KEY	Purch.Org.	CHAR	4	-	-	Purchasing Organization
4	LTSNR	KEY	Subrange	CHAR	6	-	-	Vendor Subrange
5	WERKS	KEY	Plant	CHAR	4	-	T001W	Plant
6	ERDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
7	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
8	SPERM	-	Pur. block	CHAR	1	-	-	Purchasing block at purchasing organization level
9	LOEVM	-	Del. flag	CHAR	1	-	-	Delete flag for vendor at purchasing level
10	LFABC	-	ABC ind.	CHAR	1	-	-	ABC indicator
11	WAERS	-	Currency	CUKY	5	-	TCURC	Purchase order currency
12	VERKF	-	Salespers.	CHAR	30	-	-	Responsible Salesperson at Vendor's Office
13	TELF1	-	Telephone	CHAR	16	-	-	Vendor's telephone number
14	MINBW	-	Min. value	CURR	13	2	-	Minimum order value
15	ZTERM	-	Payt Terms	CHAR	4	-	-	Terms of Payment Key
16	INCO1	-	Incoterms	CHAR	3	-	-	Incoterms (Part 1)
17	INCO2	-	Inco. 2	CHAR	28	-	-	Incoterms (Part 2)
18	WEBRE	-	GR-BasedIV	CHAR	1	-	-	Indicator: GR-Based Invoice Verification
19	KZABS	-	Ackn. Reqd	CHAR	1	-	-	Order Acknowledgment Requirement
20	KALSK	-	Schema Grp	CHAR	2	-	-	Group for Calculation Schema (Vendor)
21	KZAUT	-	Automat.PO	CHAR	1	-	-	Automatic Generation of Purchase Order Allowed
22	EXPVZ	-	TranspMode	CHAR	1	-	-	Mode of Transport for Foreign Trade
23	ZOLLA	-	CustomsOff	CHAR	6	-	-	Customs Office: Office of Exit/Entry for Foreign Trade
24	MEPRF	-	PrDateCntr	CHAR	1	-	-	Price Determination (Pricing) Date Control
25	EKGRP	-	Purch. Grp	CHAR	3	-	-	Purchasing Group
26	XERSY	-	ERS	CHAR	1	-	-	Evaluated Receipt Settlement (ERS)
27	PLIFZ	-	Plnd Dely	DEC	3	-	-	Planned Delivery Time in Days
28	MRPPP	-	Calendar	CHAR	3	-	-	Planning calendar
29	LFRHY	-	Plng cycle	CHAR	3	-	-	Planning cycle
30	LIBES	-	PO: vendor	CHAR	1	-	-	Order entry by vendor
31	LIPRE	-	Price mkg.	CHAR	2	-	-	Price marking, vendor
32	LISER	-	Rack-jobb.	CHAR	1	-	-	Rack-jobbing: vendor
33	DISPO	-	MRP Cont.	CHAR	3	-	-	MRP Controller (Materials Planner)
34	BOIND	-	SS Index	CHAR	1	-	-	Field Not Used (Subsequent Settlement)
35	BSTAE	-	ConfContr.	CHAR	4	-	-	Confirmation Control Key
36	RDPRF	-	R. Profile	CHAR	4	-	-	Rounding Profile
37	MEGRU	-	UoM Group	CHAR	4	-	-	Unit of Measure Group
38	BOPNR	-	Profile	CHAR	4	-	-	Restriction Profile for PO-Based Load Building
39	XERSR	-	AutEvGRSet	CHAR	1	-	-	Automatic evaluated receipt settlement for return items
40	ABUEB	-	Profile	CHAR	4	-	-	Release Creation Profile
41	PAPRF	-	PA prof.	CHAR	4	-	-	Profile for transferring material data via IDoc PROACT
42	XNBWY	-	Reval.	CHAR	1	-	-	Revaluation allowed
43	LEBRE	-	S-Based IV	CHAR	1	-	-	Indicator for Service-Based Invoice Verification
44	BOLRE	-	Subs.Sett.	CHAR	1	-	-	Field Not Used (Subsequent Settlement)
45	UMSAE	-	BVC	CHAR	1	-	-	Field Not Used (Subsequent Settlement)
46	TRANSPORT_CHAIN	-	TrChain	CHAR	10	-	-	Transportation Chain
47	STAGING_TIME	-	Stg Time	DEC	3	-	-	Staging Time in Days

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk LFM2.

Interactive ERD Diagrams

SAP FI/CO - Accounts Payable (Vendor Master Data) →

Standard T-Codes

SE11 SE16

Related Tables

LFA1 T001W TCURC LFBK LFM1 LFB1 LFB5

ANSI SQL Query

SELECT a.LIFNR,
       a.EKORG,
       a.LTSNR,
       a.WERKS,
       a.ERDAT,
       a.ERNAM,
       a.SPERM
FROM LFM2 AS a
WHERE a.LIFNR = '0000100001'
  AND a.EKORG = '0001';

ABAP OpenSQL (7.40+)

SELECT a~lifnr,
       a~ekorg,
       a~ltsnr,
       a~werks,
       a~erdat,
       a~ernam,
       a~sperm
  FROM lfm2 AS a
  WHERE a~lifnr = '0000100001'
  and a~ekorg = '0001'
  INTO TABLE @DATA(lt_lfm2)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 LFM2

LFM2

Dictionary Fields Fields

Related References & SQL