SE11 ABAP Dictionary SE11 LFM1

Popular:

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

LFM1

Vendor master record purchasing organization data

SAP SAP Transparent Table 55 Fields

Primary Key:

MANDT LIFNR EKORG

#	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	Vendor Account Number
3	EKORG	KEY	Purch.Org.	CHAR	4	-	-	Purchasing Organization
4	ERDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
5	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
6	SPERM	-	Pur. block	CHAR	1	-	-	Purchasing block at purchasing organization level
7	LOEVM	-	Del. flag	CHAR	1	-	-	Delete flag for vendor at purchasing level
8	LFABC	-	ABC ind.	CHAR	1	-	-	ABC indicator
9	WAERS	-	Currency	CUKY	5	-	TCURC	Purchase order currency
10	VERKF	-	Salespers.	CHAR	30	-	-	Responsible Salesperson at Vendor's Office
11	TELF1	-	Telephone	CHAR	16	-	-	Vendor's telephone number
12	MINBW	-	Min. value	CURR	13	2	-	Minimum order value
13	ZTERM	-	Payt Terms	CHAR	4	-	-	Terms of Payment Key
14	INCO1	-	Incoterms	CHAR	3	-	-	Incoterms (Part 1)
15	INCO2	-	Inco. 2	CHAR	28	-	-	Incoterms (Part 2)
16	WEBRE	-	GR-BasedIV	CHAR	1	-	-	Indicator: GR-Based Invoice Verification
17	KZABS	-	Ackn. Reqd	CHAR	1	-	-	Order Acknowledgment Requirement
18	KALSK	-	Schema Grp	CHAR	2	-	-	Group for Calculation Schema (Vendor)
19	KZAUT	-	Automat.PO	CHAR	1	-	-	Automatic Generation of Purchase Order Allowed
20	EXPVZ	-	TranspMode	CHAR	1	-	-	Mode of Transport for Foreign Trade
21	ZOLLA	-	CustomsOff	CHAR	6	-	-	Customs Office: Office of Exit/Entry for Foreign Trade
22	MEPRF	-	PrDateCntr	CHAR	1	-	-	Price Determination (Pricing) Date Control
23	EKGRP	-	Purch. Grp	CHAR	3	-	-	Purchasing Group
24	XERSY	-	ERS	CHAR	1	-	-	Evaluated Receipt Settlement (ERS)
25	PLIFZ	-	Plnd Dely	DEC	3	-	-	Planned Delivery Time in Days
26	MRPPP	-	Calendar	CHAR	3	-	-	Planning calendar
27	LFRHY	-	Plng cycle	CHAR	3	-	-	Planning cycle
28	LIBES	-	PO: vendor	CHAR	1	-	-	Order entry by vendor
29	LIPRE	-	Price mkg.	CHAR	2	-	-	Price marking, vendor
30	LISER	-	Rack-jobb.	CHAR	1	-	-	Rack-jobbing: vendor
31	PRFRE	-	Price det.	CHAR	1	-	-	Indicator: "relev. to price determination (vend. hierarchy)
32	NRGEW	-	DKd grntd.	CHAR	1	-	-	Indicator whether discount in kind granted
33	BOIND	-	Index SubS	CHAR	1	-	-	Indicator: index compilation for subseq. settlement active
34	BLIND	-	Doc. index	CHAR	1	-	-	Indicator: Doc. index compilation active for purchase orders
35	KZRET	-	Ret. vend.	CHAR	1	-	-	Indicates whether vendor is returns vendor
36	SKRIT	-	Sort crit.	CHAR	1	-	-	Vendor sort criterion for materials
37	BSTAE	-	ConfContr.	CHAR	4	-	-	Confirmation Control Key
38	RDPRF	-	R. Profile	CHAR	4	-	-	Rounding Profile
39	MEGRU	-	UoM Group	CHAR	4	-	-	Unit of Measure Group
40	VENSL	-	VenServL	DEC	4	1	-	Vendor service level
41	BOPNR	-	Profile	CHAR	4	-	-	Restriction Profile for PO-Based Load Building
42	XERSR	-	AutEvGRSet	CHAR	1	-	-	Automatic evaluated receipt settlement for return items
43	EIKTO	-	Acc.w.vend	CHAR	12	-	-	Our account number with the vendor
44	ABUEB	-	Profile	CHAR	4	-	-	Release Creation Profile
45	PAPRF	-	PA prof.	CHAR	4	-	-	Profile for transferring material data via IDoc PROACT
46	AGREL	-	Agcy busn.	CHAR	1	-	-	Indicator: Relevant for agency business
47	XNBWY	-	Reval.	CHAR	1	-	-	Revaluation allowed
48	VSBED	-	Shpg Cond.	CHAR	2	-	-	Shipping Conditions
49	LEBRE	-	S-Based IV	CHAR	1	-	-	Indicator for Service-Based Invoice Verification
50	BOLRE	-	Subs.sett.	CHAR	1	-	-	Indicator: vendor subject to subseq. settlement accounting
51	UMSAE	-	BVol.comp.	CHAR	1	-	-	Comparison/agreement of business volumes necessary
52	VENDOR_RMA_REQ	-	RMA Req.	CHAR	1	-	-	Vendor RMA Number Required
53	ACTIVITY_PROFIL	-	Act.Profil	CHAR	4	-	-	Activity Profile for PO Controlling
54	TRANSPORT_CHAIN	-	TrChain	CHAR	10	-	-	Transportation Chain
55	STAGING_TIME	-	Stg Time	DEC	3	-	-	Staging Time in Days

Related References & SQL

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

Interactive ERD Diagrams

SAP FI/CO - Accounts Payable (Vendor Master Data) → SAP Procurement & MM Document Flow - MIRO Service PO Clearing →

Standard T-Codes

MK03 MK01 XK03 ME21N ME11

Related Tables

LFA1 TCURC LFBK LFM2 LFB1 LFB5 EKKO EKPO

ANSI SQL Query

SELECT a.LIFNR,
       a.EKORG,
       a.ERDAT,
       a.ERNAM,
       a.SPERM,
       a.LOEVM,
       a.LFABC
FROM LFM1 AS a
WHERE a.LIFNR = '0000100001'
  AND a.EKORG = '0001';

ABAP OpenSQL (7.40+)

SELECT a~lifnr,
       a~ekorg,
       a~erdat,
       a~ernam,
       a~sperm,
       a~loevm,
       a~lfabc
  FROM lfm1 AS a
  WHERE a~lifnr = '0000100001'
  and a~ekorg = '0001'
  INTO TABLE @DATA(lt_lfm1)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 LFM1

LFM1

Dictionary Fields Fields

Related References & SQL