SAP ABAP Table E3LFA1M (Segment for general vendor data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MD-BP-VM (Application Component) Vendor Master
     ⤷ CGVCORE (Package) CGCORE

Basic Data

Table Category	INTTAB	Structure
Structure	E3LFA1M	Table Relationship Diagram
Short Description	Segment for general vendor data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MSGFN	☑	MSGFN	MSGFN	CHAR	3	0	Function
2	LIFNR	☑	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
3	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
4	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
5	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
6	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
7	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
8	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
9	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
10	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
11	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
12	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
13	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
14	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
15	ESRNR	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
16	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
17	KTOKK	☐	KTOKK	KTOKK	CHAR	4	0	Vendor account group	*
18	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
19	LAND1	☐	LAND	LAND1	CHAR	3	0	Country of company	*
20	LNRZA	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
21	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
22	NAME1	☐	NAME	NAME	CHAR	35	0	Name
23	NAME2	☐	NAME	NAME	CHAR	35	0	Name
24	NAME3	☐	NAME	NAME	CHAR	35	0	Name
25	NAME4	☐	NAME	NAME	CHAR	35	0	Name
26	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
27	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
28	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
29	PSTL2	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
30	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
31	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
32	SORTL	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
33	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
34	SPERM	☐	SPERM_X	XFELD	CHAR	1	0	Centrally imposed purchasing block
35	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
36	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
37	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
38	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
39	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
40	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
41	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
42	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
43	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
44	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
45	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
46	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
47	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
48	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
49	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
50	FISKN	☐	FISKN_K	LIFNR	CHAR	10	0	Account number of the master record with fiscal address	*
51	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
52	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
53	SPERQ	☐	QSPERRFKT	QSPERRFKT	CHAR	2	0	Function That Will Be Blocked	*
54	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
55	MCOD1	☐	MCDK1	CHAR25	CHAR	25	0	Search term for matchcode search
56	MCOD2	☐	MCDK2	CHAR25	CHAR	25	0	Search term for matchcode search
57	MCOD3	☐	MCDK3	CHAR25	CHAR	25	0	Search term for matchcode search
58	GBORT	☐	GBORT_Q	TEXT25	CHAR	25	0	Place of birth of the person subject to withholding tax
59	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
60	SEXKZ	☐	SEXKZ	SEXKZ	CHAR	1	0	Key for the Sex of the Person Subject to Withholding Tax
61	KRAUS	☐	KRAUS_CM	CHAR11	CHAR	11	0	Credit information number
62	REVDB	☐	REVDB_CM	DATUM	DATS	8	0	Last review (external)
63	QSSYS	☐	QSSYS_IST	QSSYSFAM	CHAR	4	0	Vendor's QM system	*
64	KTOCK	☐	KTOCK	KTOKK	CHAR	4	0	Reference Account Group for One-Time Account (Vendor)	*
65	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
66	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
67	LTSNA	☐	LTSNA	XFELD	CHAR	1	0	Indicator: vendor sub-range relevant
68	WERKR	☐	WERKR	XFELD	CHAR	1	0	Indicator: plant level relevant
69	PLKAL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	*
70	DUEFL	☐	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
71	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*

History

Last changed by/on	SAP	20130529
SAP Release Created in