SE11 ABAP Dictionary SE11 LFA1

Popular:

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

LFA1

Vendor Master (General Section)

SAP MM Transparent Table 119 Fields

Primary Key:

MANDT LIFNR

#	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	LAND1	-	Country	CHAR	3	-	T005	Country Key
4	NAME1	-	Name	CHAR	35	-	-	Name 1
5	NAME2	-	Name 2	CHAR	35	-	-	Name 2
6	NAME3	-	Name 3	CHAR	35	-	-	Name 3
7	NAME4	-	Name 4	CHAR	35	-	-	Name 4
8	ORT01	-	City	CHAR	35	-	-	City
9	ORT02	-	District	CHAR	35	-	-	District
10	PFACH	-	PO Box	CHAR	10	-	-	PO Box
11	PSTL2	-	PO Box pcd	CHAR	10	-	-	P.O. Box Postal Code
12	PSTLZ	-	Post.Code	CHAR	10	-	-	Postal Code
13	REGIO	-	Region	CHAR	3	-	-	Region (State, Province, County)
14	SORTL	-	SearchTerm	CHAR	10	-	-	Sort field
15	STRAS	-	Street	CHAR	35	-	-	House number and street
16	ADRNR	-	Address	CHAR	10	-	-	Address
17	MCOD1	-	Name	CHAR	25	-	-	Search term for matchcode search
18	MCOD2	-	Name 2	CHAR	25	-	-	Search term for matchcode search
19	MCOD3	-	City	CHAR	25	-	-	Search term for matchcode search
20	ANRED	-	Title	CHAR	15	-	-	Title
21	BAHNS	-	Train stat	CHAR	25	-	-	Train station
22	BBBNR	-	Loc.no. 1	NUMC	7	-	-	International location number (part 1)
23	BBSNR	-	Loc.no. 2	NUMC	5	-	-	International location number (Part 2)
24	BEGRU	-	Authoriz.	CHAR	4	-	-	Authorization Group
25	BRSCH	-	Industry	CHAR	4	-	-	Industry key
26	BUBKZ	-	Chk.digit	NUMC	1	-	-	Check digit for the international location number
27	DATLT	-	Data line	CHAR	14	-	-	Data communication line no.
28	DTAMS	-	DME Ind.	CHAR	1	-	-	Indicator for Data Medium Exchange
29	DTAWS	-	Instr.key	CHAR	2	-	-	Instruction key for data medium exchange
30	ERDAT	-	Creat.date	DATS	8	-	-	Date on which the Record Was Created
31	ERNAM	-	Created by	CHAR	12	-	-	Name of Person who Created the Object
32	ESRNR	-	ISR No.	CHAR	11	-	-	ISR Subscriber Number
33	KONZS	-	Group	CHAR	10	-	-	Group key
34	KTOKK	-	Acct Group	CHAR	4	-	-	Vendor account group
35	KUNNR	-	Customer	CHAR	10	-	KNA1	Customer Number 1
36	LNRZA	-	Alt. payee	CHAR	10	-	-	Account Number of the Alternative Payee
37	LOEVM	-	Del.flag	CHAR	1	-	-	Central Deletion Flag for Master Record
38	SPERR	-	PstBlock	CHAR	1	-	-	Central posting block
39	SPERM	-	Pur. block	CHAR	1	-	-	Centrally imposed purchasing block
40	SPRAS	-	Language	LANG	1	-	T002	Language Key
41	STCD1	-	Tax No. 1	CHAR	16	-	-	Tax Number 1
42	STCD2	-	Tax No. 2	CHAR	11	-	-	Tax Number 2
43	STKZA	-	Equal.tax	CHAR	1	-	-	Indicator: Business Partner Subject to Equalization Tax?
44	STKZU	-	VAT	CHAR	1	-	-	Liable for VAT
45	TELBX	-	Telebox	CHAR	15	-	-	Telebox number
46	TELF1	-	Telephone1	CHAR	16	-	-	First telephone number
47	TELF2	-	Telephone2	CHAR	16	-	-	Second telephone number
48	TELFX	-	Fax Number	CHAR	31	-	-	Fax Number
49	TELTX	-	Teletex	CHAR	30	-	-	Teletex number
50	TELX1	-	Telex	CHAR	30	-	-	Telex number
51	XCPDK	-	One-time	CHAR	1	-	-	Indicator: Is the account a one-time account?
52	XZEMP	-	Payee i.dc	CHAR	1	-	-	Indicator: Alternative payee in document allowed ?
53	VBUND	-	Tradg Part	CHAR	6	-	-	Company ID of trading partner
54	FISKN	-	Fisc.addr.	CHAR	10	-	-	Account number of the master record with fiscal address
55	STCEG	-	VAT Reg.No	CHAR	20	-	-	VAT Registration Number
56	STKZN	-	Nat.Person	CHAR	1	-	-	Natural Person
57	SPERQ	-	Block func	CHAR	2	-	-	Function That Will Be Blocked
58	GBORT	-	Birthplace	CHAR	25	-	-	Place of birth of the person subject to withholding tax
59	GBDAT	-	Birth date	DATS	8	-	-	Date of birth of the person subject to withholding tax
60	SEXKZ	-	Sex	CHAR	1	-	-	Key for the Sex of the Person Subject to Withholding Tax
61	KRAUS	-	Info	CHAR	11	-	-	Credit information number
62	REVDB	-	Lst review	DATS	8	-	-	Last review (external)
63	QSSYS	-	QM system	CHAR	4	-	-	Vendor's QM system
64	KTOCK	-	Ref.ActGr.	CHAR	4	-	-	Reference Account Group for One-Time Account (Vendor)
65	PFORT	-	P.O.Bx cty	CHAR	35	-	-	PO Box city
66	WERKS	-	Plant	CHAR	4	-	T001W	Plant (Own or External)
67	LTSNA	-	VSR	CHAR	1	-	-	Indicator: vendor sub-range relevant
68	WERKR	-	Plant rel.	CHAR	1	-	-	Indicator: plant level relevant
69	PLKAL	-	Calendar	CHAR	2	-	-	Factory calendar key
70	DUEFL	-	Status	CHAR	1	-	-	Status of Data Transfer into Subsequent Release
71	TXJCD	-	Tax Jur.	CHAR	15	-	-	Tax Jurisdiction
72	SPERZ	-	Pmnt block	CHAR	1	-	-	Payment Block
73	SCACD	-	SCAC	CHAR	4	-	-	Standard carrier access code
74	SFRGR	-	CarFrgtGrp	CHAR	4	-	-	Forwarding agent freight group
75	LZONE	-	Zone	CHAR	10	-	-	Transportation zone to or from which the goods are delivered
76	XLFZA	-	AltPayeeAc	CHAR	1	-	-	Indicator: Alternative payee using account number
77	DLGRP	-	SA group	CHAR	4	-	-	Service agent procedure group
78	FITYP	-	Tax type	CHAR	2	-	-	Tax type
79	STCDT	-	Tax no.ty.	CHAR	2	-	-	Tax Number Type
80	REGSS	-	Soc. Ins.	CHAR	1	-	-	Registered for Social Insurance
81	ACTSS	-	SI Code	CHAR	3	-	-	Activity Code for Social Insurance
82	STCD3	-	Tax No. 3	CHAR	18	-	-	Tax Number 3
83	STCD4	-	Tax No. 4	CHAR	18	-	-	Tax Number 4
84	IPISP	-	Tax split	CHAR	1	-	-	Tax Split
85	TAXBS	-	Tax base	NUMC	1	-	-	Tax Base in Percentage
86	PROFS	-	Profession	CHAR	30	-	-	Profession
87	STGDL	-	St.grp ag.	CHAR	2	-	-	Shipment: statistics group, transportation service agent
88	EMNFR	-	Ex. manuf.	CHAR	10	-	-	External manufacturer code name or number
89	LFURL	-	URL	CHAR	132	-	-	Uniform Resource Locator
90	J_1KFREPRE	-	Rep's Name	CHAR	10	-	-	Name of Representative
91	J_1KFTBUS	-	TOB	CHAR	30	-	-	Type of Business
92	J_1KFTIND	-	TOI	CHAR	30	-	-	Type of Industry
93	CONFS	-	Conf.St.	CHAR	1	-	-	Status of Change Authorization (Central)
94	UPDAT	-	Conf.date	DATS	8	-	-	Date on Which the Changes Were Confirmed
95	UPTIM	-	Conf.time	TIMS	6	-	-	Time of Last Change Confirmation
96	NODEL	-	Del.block	CHAR	1	-	-	Central deletion block for master record
97	QSSYSDAT	-	Valid to	DATS	8	-	-	Validity date of certification
98	PODKZB	-	POD-rel.	CHAR	1	-	-	Vendor indicator relevant for proof of delivery
99	FISKU	-	Tax Office	CHAR	10	-	-	Account Number of Master Record of Tax Office Responsible
100	STENR	-	Tax no.	CHAR	18	-	-	Tax Number at Responsible Tax Authority
101	CARRIER_CONF	-	Carrier cf	CHAR	1	-	-	Carrier confirmation is expected
102	J_SC_CAPITAL	-	Capital	CURR	15	2	-	Capital Amount
103	J_SC_CURRENCY	-	Currency	CUKY	5	-	-	Currency
104	ALC	-	ALC	CHAR	8	-	-	Agency Location Code
105	PMT_OFFICE	-	Pmt Off	CHAR	5	-	-	Payment Office
106	PPA_RELEVANT	-	PPA Relev.	CHAR	1	-	-	Vendor is PPA relevant
107	PSOFG	-	Process.gp	CHAR	10	-	-	Processor group
108	PSOIS	-	SLA PreprP	CHAR	20	-	-	Subledger acct preprocessing procedure
109	PSON1	-	Name	CHAR	35	-	-	Name 1
110	PSON2	-	Name 2	CHAR	35	-	-	Name 2
111	PSON3	-	Name 3	CHAR	35	-	-	Name 3
112	PSOVN	-	First Name	CHAR	35	-	-	First Name
113	PSOTL	-	Title	CHAR	20	-	-	Title
114	PSOHS	-	House no.	CHAR	6	-	-	House number: is no longer used from Release 4.6B
115	PSOST	-	Street	CHAR	28	-	-	Street: No longer used from Release 4.6B
116	TRANSPORT_CHAIN	-	TrChain	CHAR	10	-	-	Transportation Chain
117	STAGING_TIME	-	Stg Time	DEC	3	-	-	Staging Time in Days
118	SCHEDULING_TYPE	-	Scheduling	CHAR	1	-	-	Scheduling Procedure
119	SUBMI_RELEVANT	-	Coll.No.	CHAR	1	-	-	Cross Docking: Relevant for Collective Numbering

Related References & SQL

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

Interactive ERD Diagrams

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

Standard T-Codes

XK03 XK01 XK02 FK03 MK03 FBL1N ME23N

Related Tables

T005 KNA1 T002 T001W LFBK LFM1 LFM2 LFB1

ANSI SQL Query

SELECT a.LIFNR,
       a.LAND1,
       a.NAME1,
       a.NAME2,
       a.NAME3,
       a.NAME4
FROM LFA1 AS a
WHERE a.LIFNR = '0000100001';

ABAP OpenSQL (7.40+)

SELECT a~lifnr,
       a~land1,
       a~name1,
       a~name2,
       a~name3,
       a~name4
  FROM lfa1 AS a
  WHERE a~lifnr = '0000100001'
  INTO TABLE @DATA(lt_lfa1)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 LFA1

LFA1

Dictionary Fields Fields

Related References & SQL