SAP LFA1 Vendor Master (General Section) Table data and field list

LFA1 is a standard SAP Table which is used to store Vendor Master (General Section) data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The LFA1 table consists of various fields, each holding specific information or linking keys about Vendor Master (General Section) data available in SAP. These include LIFNR (Account Number of Vendor or Creditor), LAND1 (Country Key), NAME1 (Name 1), NAME2 (Name 2)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

LFA1 table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP LFA1 table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the LFA1 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
LIFNR	Account Number of Vendor or Creditor	LIFNR	CHAR	10		ALPHA	LIFNR	LIF	KRED_C
LAND1	Country Key	LAND1_GP	CHAR	3	T005		LAND1		C_LAND1
NAME1	Name 1	NAME1_GP	CHAR	35			NAME
NAME2	Name 2	NAME2_GP	CHAR	35			NAME
NAME3	Name 3	NAME3_GP	CHAR	35			NAME
NAME4	Name 4	NAME4_GP	CHAR	35			NAME
ORT01	City	ORT01_GP	CHAR	35			TEXT35
ORT02	District	ORT02_GP	CHAR	35			TEXT35
PFACH	PO Box	PFACH	CHAR	10			PFACH
PSTL2	P.O. Box Postal Code	PSTL2	CHAR	10			PSTLZ
PSTLZ	Postal Code	PSTLZ	CHAR	10			PSTLZ
REGIO	STATE (State, Province, County)	REGIO	CHAR	3	T005S		REGIO
SORTL	Sort field	SORTL	CHAR	10			CHAR10
STRAS	House number and street	STRAS_GP	CHAR	35			TEXT35
ADRNR	Address	ADRNR	CHAR	10	Assigned to domain	ALPHA	ADRNR
MCOD1	Search term for matchcode search	MCDK1	CHAR	25			CHAR25
MCOD2	Search term for matchcode search	MCDK2	CHAR	25			CHAR25
MCOD3	Search term for matchcode search	MCDK3	CHAR	25			CHAR25
ANRED	Title	ANRED	CHAR	15			TEXT15
BAHNS	Train station	BAHNS	CHAR	25			BAHNH
BBBNR	International location number (part 1)	BBBNR	NUMC	7			NUM07
BBSNR	International location number (Part 2)	BBSNR	NUMC	5			NUM05
BEGRU	Authorization Group	BRGRU	CHAR	4	Assigned to domain		BRGRU
BRSCH	Industry key	BRSCH	CHAR	4	T016		BRSCH
BUBKZ	Check digit for the international location number	BUBKZ	NUMC	1			NUM01
DATLT	Data communication line no.	DATLT	CHAR	14			TEXT14
DTAMS	Indicator for Data Medium Exchange	DTAMS	CHAR	1			DTAMS
DTAWS	Instruction key for data medium exchange	DTAWS	CHAR	2	Assigned to domain		DTAWS
ERDAT	Date on which the Record Was Created	ERDAT_RF	DATS	8			DATUM
ERNAM	Name of Person who Created the Object	ERNAM_RF	CHAR	12			USNAM
ESRNR	ISR Subscriber Number	ESRNR	CHAR	11			ESRNR
KONZS	Group key	KONZS	CHAR	10			KONZS
KTOKK	Vendor account group	KTOKK	CHAR	4	T077K		KTOKK	KGK
KUNNR	Customer Numbers	KUNNR	CHAR	10	KNA1	ALPHA	KUNNR	KUN	C_KUNNR
LNRZA	Account Number of the Alternative Payee	LNRZA	CHAR	10	LFA1	ALPHA	LIFNR
LOEVM	Central Deletion Flag for Master Record	LOEVM_X	CHAR	1			XFELD
SPERR	Central posting block	SPERB_X	CHAR	1			XFELD
SPERM	Centrally imposed purchasing block	SPERM_X	CHAR	1			XFELD
SPRAS	Language Key	SPRAS	LANG	1	T002	ISOLA	SPRAS	SPR	H_T002
STCD1	Tax Number 1	STCD1	CHAR	16			STCD1
STCD2	Tax Number 2	STCD2	CHAR	11			STCD2
STKZA	Indicator: Business Partner Subject to Equalization Tax?	STKZA	CHAR	1			STKZA
STKZU	Liable for VAT	STKZU	CHAR	1			XFELD
TELBX	Telebox number	TELBX	CHAR	15			TEXT15
TELF1	First telephone number	TELF1	CHAR	16			TEXT16
TELF2	Second telephone number	TELF2	CHAR	16			TEXT16
TELFX	Fax Number	TELFX	CHAR	31			TEXT31
TELTX	Teletex number	TELTX	CHAR	30			TEXT30
TELX1	Telex number	TELX1	CHAR	30			TEXT30
XCPDK	Indicator: Is the account a one-time account?	XCPDK	CHAR	1			XFELD
XZEMP	Indicator: Alternative payee in document allowed ?	XZEMP	CHAR	1			XFELD
VBUND	Company ID of trading partner	RASSC	CHAR	6	T880	ALPHA	RCOMP	PGS
FISKN	Account number of the master record with fiscal address	FISKN_K	CHAR	10	LFA1	ALPHA	LIFNR
STCEG	VAT Registration Number	STCEG	CHAR	20			STCEG
STKZN	Natural Person	STKZN	CHAR	1			STKZN
SPERQ	Function That Will Be Blocked	QSPERRFKT	CHAR	2	TQ04A		QSPERRFKT
GBORT	Place of birth of the person subject to withholding tax	GBORT_Q	CHAR	25			TEXT25
GBDAT	Date of birth of the person subject to withholding tax	GBDAT_Q	DATS	8			DATUM
SEXKZ	Key for the Sex of the Person Subject to Withholding Tax	SEXKZ	CHAR	1			SEXKZ
KRAUS	Credit information number	KRAUS_CM	CHAR	11			CHAR11
REVDB	Last review (external)	REVDB_CM	DATS	8			DATUM
QSSYS	Vendor's QM system	QSSYS_IST	CHAR	4	TQ02B		QSSYSFAM
KTOCK	Reference Account Group for One-Time Account (Vendor)	KTOCK	CHAR	4	T077K		KTOKK
PFORT	PO Box city	PFORT_GP	CHAR	35			TEXT35
WERKS	Plant (Own or External)	WERKS_EXT	CHAR	4	Assigned to domain		WERKS	WRK	SH_T001W_EXTS
LTSNA	Indicator: vendor sub-range relevant	LTSNA	CHAR	1			XFELD
WERKR	Indicator: plant level relevant	WERKR	CHAR	1			XFELD
PLKAL	Factory calendar key	FABKL	CHAR	2	TFACD		WFCID
DUEFL	Status of Data Transfer into Subsequent Release	DUEFL_BKPF	CHAR	1			DUEFL_BKPF
TXJCD	Tax Jurisdiction	TXJCD	CHAR	15	TTXJ		TXJCD	TXJ
SPERZ	Payment Block	SPERZ	CHAR	1			XFELD
SCACD	Standard carrier access code	SCACD	CHAR	4			SCACD
SFRGR	Forwarding agent freight group	SFRGR	CHAR	4	TSFG		SFRGR
LZONE	Transportation zone to or from which the goods are delivered	LZONE	CHAR	10	TZONE		ZONE
XLFZA	Indicator: Alternative payee using account number	XLFZA	CHAR	1			XFELD
DLGRP	Service agent procedure group	DLGRP	CHAR	4	TVFCD		DLGRP
FITYP	Tax type	J_1AFITP_D	CHAR	2	J_1AFITP		J_1AFITP
STCDT	Tax Number Type	J_1ATOID	CHAR	2	J_1ATODC		J_1ATOID
REGSS	Registered for Social Insurance	J_1AREGSS	CHAR	1			XFELD
ACTSS	Activity Code for Social Insurance	J_1AACTSS	CHAR	3	J_1AACT		J_1AACTSS
STCD3	Tax Number 3	STCD3	CHAR	18			CHAR18
STCD4	Tax Number 4	STCD4	CHAR	18			CHAR18
STCD5	Tax Number 5	STCD5	CHAR	60			CHAR60
IPISP	Tax Split	J_1BINDEQU	CHAR	1			XFELD
TAXBS	Tax Base in Percentage	TAXBS	NUMC	1			TAXBS
PROFS	Profession	PROFS	CHAR	30			TEXT30
STGDL	Shipment: statistics group, transportation service agent	STGDL	CHAR	2	VTSGD		STGDL
EMNFR	External manufacturer code name or number	EMNFR	CHAR	10			CHAR10
LFURL	Uniform Resource Locator	URL	CHAR	132			TEXT132
J_1KFREPRE	Name of Representative	REPRES	CHAR	10			REPRES
J_1KFTBUS	Type of Business	GESTYP	CHAR	30	BUSTYPE		GESTYP
J_1KFTIND	Type of Industry	INDTYP	CHAR	30	INDUSTYPE		INDTYP
CONFS	Status of Change Authorization (Central)	CONFS_X	CHAR	1			CHAR1
UPDAT	Date on Which the Changes Were Confirmed	UPDAT_RF	DATS	8			DATUM
UPTIM	Time of Last Change Confirmation	UPTIM_RF	TIMS	6			AS4TIME
NODEL	Central deletion block for master record	NODEL_X	CHAR	1			XFELD
QSSYSDAT	Validity date of certification	QQSSYSDAT	DATS	8			QQSSYSDAT
PODKZB	Vendor indicator relevant for proof of delivery	PODKZB	CHAR	1			PODKZB
FISKU	Account Number of Master Record of Tax Office Responsible	FISKU	CHAR	10	LFA1	ALPHA	LIFNR
STENR	Tax Number at Responsible Tax Authority	STENR	CHAR	18			CHAR18
CARRIER_CONF	Carrier confirmation is expected	/SPE/CARRIER_CNF	CHAR	1			/SPE/CARRIER_CONF
MIN_COMP	Micro company indicator	J_1BMICRO_COMP	CHAR	1			XFELD
TERM_LI	Terms of Liability	J_1BTERMS_LIAB	CHAR	1			XFELD
CRC_NUM	CRC number	J_1BCRC_NUM	CHAR	25			CHAR25
RG	RG Number	J_1BRG	CHAR	11			J_1BRG
EXP	Issued by	J_1BEXP	CHAR	3			J_1BEXP
UF	State	J_1BUF	CHAR	2			J_1BUF
RGDATE	RG Issue Date	J_1BRGDATE	DATS	8			DATUM
RIC	RIC Number	J_1BRIC	NUMC	11			J_1BRIC
RNE	Foreign National Registration	J_1BRNE	CHAR	10			J_1BRNE
RNEDATE	RNE Issue Date	J_1BRNEDATE	DATS	8			DATUM
CNAE	CNAE	J_1BCNAE	CHAR	7	J_1BTCNAE		J_1BCNAE
LEGALNAT	Legal Nature	J_1BLEGALNAT	NUMC	4	J_1BTLEGALNAT		J_1BLEGALNAT
CRTN	CRT Number	J_1BCRTN	CHAR	1			J_1BCRTN
ICMSTAXPAY	ICMS Taxpayer	J_1BICMSTAXPAY	CHAR	2	J_1BTICMSTAXPAY		J_1BICMSTAXPAY
INDTYP	Industry Main Type	J_1BINDTYP	CHAR	2	J_1BTINDTYP		J_1BINDTYP
TDT	Tax Declaration Type	J_1BTDT	CHAR	2	J_1BTTDT		J_1BTDT
COMSIZE	Company Size	J_1BCOMSIZE	CHAR	2	J_1BTCOMSIZE		J_1BCOMSIZE
DECREGPC	Declaration Regimen for PIS/COFINS	J_1BDECREGPC	CHAR	2	J_1BTDECREGPC		J_1BDECREGPC
.INCLU--AP				0
DUNSP4	DUNS+4 number (the last four digit)	/SAPHT/RN_DUNSP4	CHAR	4			CHAR4
.INCLU--AP				0
J_SC_CAPITAL	Capital Amount	/SAPNEA/J_SC_CAPITAL	CURR	15(2)			/SAPNEA/J_SC_CAPITAL
J_SC_CURRENCY	Currency	/SAPNEA/J_SC_CURRENCY	CUKY	5	TCURC		WAERS
.INCLU--AP				0
ALC	Agency Location Code	FMFG_ALC	CHAR	8	FMFGT_ALC		FMFG_ALC	FMFG_ALC
PMT_OFFICE	Payment Office	FMFG_PMT_OFF	CHAR	5	FMFGT_PO		FMFG_PMT_OFF	FMFG_PMT_OFFICE
PPA_RELEVANT	Vendor is PPA relevant	FMFG_PPA_RELEVANT	CHAR	1			XFELD
.INCLU--AP				0
PSOFG	Processor group	PSOFG	CHAR	10	PSO19		PSOFG
PSOIS	Subledger acct preprocessing procedure	PSOIS	CHAR	20			CHAR20
PSON1	Name 1	NAME1_GP	CHAR	35			NAME
PSON2	Name 2	NAME2_GP	CHAR	35			NAME
PSON3	Name 3	NAME3_GP	CHAR	35			NAME
PSOVN	First Name	PSOVN	CHAR	35			NAME
PSOTL	Title	PSOTL	CHAR	20			FMPSOTL
PSOHS	House number: is no longer used from Release 4.6B	PSOHS	CHAR	6			CHAR06
PSOST	Street: No longer used from Release 4.6B	PSOST	CHAR	28			PSOST
.INCLU--AP				0
BORGR_DATUN	Date Limit for External Document Identification	BORGR_DATUN	DATS	8			DATE
BORGR_YEAUN	Annual Repetition of Date Limit	BORGR_YEAUN	CHAR	1			XFELD
.INCLU--AP				0
TRANSPORT_CHAIN	Transportation Chain	WRF_PSCD_TC_ID	CHAR	10	WRF_PSCD_TCHAINH		WRF_PSCD_TC_ID
STAGING_TIME	Staging Time in Days	WRF_PSCD_MST	DEC	3			WRF_PSCD_MST
SCHEDULING_TYPE	Scheduling Procedure	WRF_PSCD_SCHED_TYPE	CHAR	1			WRF_PSCD_SCHED_TYPE
SUBMI_RELEVANT	Cross Docking: Relevant for Collective Numbering	WRF_SUBMI_RELEVANT	CHAR	1			XFELD
.INCLU--AP				0
PERREF				0
RATING				0
MOBILE				0

Key field

Non-key field

< LF041_ZUO - Allocation of new line items to old line items (SAPLF041) LFA1BRAZIL - Vendor Master Data - Brazil >

How do I retrieve data from SAP table LFA1 using ABAP code

The following ABAP code Example will allow you to do a basic selection on LFA1 to SELECT all data from the table
DATA: WA_LFA1 TYPE LFA1.

SELECT SINGLE *
FROM LFA1
INTO CORRESPONDING FIELDS OF WA_LFA1
WHERE...

How to access SAP table LFA1

Within an ECC or HANA version of SAP you can also view further information about LFA1 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to LFA1

    BOSG - Uppermost Hierarchy Segment for BRF
        BKPF - Accounting Document Header
    KNKK - Credit Management Cust. Mstr: Control Area Data
    KNC1 - Customer Master (Transaction Figures)
    KNC3 - Customer Master (Special G/L Transaction Figures)
        LFA1 - Vendor Master (General Section)
            LFBK - Vendor Master (Bank Details)
            LFB1 - Vendor Master (Company Code)
                LFB5 - Vendor Master (Dunning Data)
                LFC1 - Vendor Master (Transaction Figures)
                LFC3 - Vendor Master (Transaction Figures) Special Ledger
        SKA1 - G/L Account Master Record (Chart of Accounts)
    BSEG - Accounting Document Segment
    SKB1 - G/L Account Master Record (Company Code)
        SKC1A - G/L Sales Segment Derived from GLDB - Internal
        SKC1C - G/L Account C-Segment from GLT0 -Currency Amounts-
    BSET - Tax Data Document Segment
    FAGLFREESEL - General Ledger: Custom Selections (Enhanced)
        KNA1 - General Data in Customer Master
            KNBK - Customer Master (Bank Details)
            KNB1 - Customer Master (Company Code)
                KNB4 - Customer Payment History
                KNB5 - Customer Master (Dunning Data)

    LFA1 - Vendor Master (General Section)
        ADDR1_VAL - Address Data
    BSIKEXT - Secondary Index & Additions Section (BSEGA)
    BKPF - Accounting Document Header
        BSEG - Accounting Document Segment
            WITH_ITEM - Witholding Tax Info.per W/Tax Type and FI Line Itm
            GSEG - Offsetting Items for B-Segment in Reporting
        LFAS - Vendor Master (General Part EU Tax Number)
        LFBK - Vendor Master (Bank Details)
        LFB1 - Vendor Master (Company Code)
            LFB5 - Vendor Master (Dunning Data)
            LFC1 - Vendor Master (Transaction Figures)
            LFC3 - Vendor Master (Transaction Figures) Special Ledger
            BSIK - Accounting: Secondary Index for Vendors
                ADMI_FILES - Archive Files