SAP Table LFA1

Vendor Master (General Section)

The table LFA1 (Vendor Master (General Section)) is a standard table in SAP ERP. It belongs to the package FBASCORE.

Technical Information

Table	LFA1
Short Text	Vendor Master (General Section)
Package	FBASCORE
Table Type	Transparent Table

Fields for Table LFA1

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