LFA1_ACT - Master Data Consolidation: Best Record Table for LFA1

Master Data Consolidation: Best Record Table for LFA1 information is stored in SAP table LFA1_ACT.
It is part of development package MDC_BP_MODEL in software component CA-MDG-CMP-BP. This development package consists of objects that can be grouped under "Master Data Consolidation: Business Partner Data Model".

Fields for table LFA1_ACT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
PARTNER	Business Partner Number	X	BU_PARTNER	CHAR	20
ASSIGNMENT_ID	Multiple Assignment ID (Number)	X	MDG_BP_ASSIGNMENT_ID	NUMC	24
LIFNR	Account Number of Supplier		LIFNR	CHAR	20
LAND1	Country/Region Key		LAND1_GP	CHAR	6
NAME1	Name 1		NAME1_GP	CHAR	70
NAME2	Name 2		NAME2_GP	CHAR	70
NAME3	Name 3		NAME3_GP	CHAR	70
NAME4	Name 4		NAME4_GP	CHAR	70
ORT01	City		ORT01_GP	CHAR	70
ORT02	District		ORT02_GP	CHAR	70
PFACH	PO Box		PFACH	CHAR	20
PSTL2	P.O. Box Postal Code		PSTL2	CHAR	20
PSTLZ	Postal Code		PSTLZ	CHAR	20
REGIO	Region (State, Province, County)		REGIO	CHAR	6
SORTL	Sort field		SORTL	CHAR	20
STRAS	Street and House Number		STRAS_GP	CHAR	70
ADRNR	Address		ADRNR	CHAR	20
MCOD1	Search term for matchcode search		MCDK1	CHAR	50
MCOD2	Search term for matchcode search		MCDK2	CHAR	50
MCOD3	Search term for matchcode search		MCDK3	CHAR	50
.INCLUDE				SI_LFA1	0
ANRED	Title		ANRED	CHAR	30
BAHNS	Train station		BAHNS	CHAR	50
BBBNR	International location number (part 1)		BBBNR	NUMC	14
BBSNR	International location number (Part 2)		BBSNR	NUMC	10
BEGRU	Authorization Group		BRGRU	CHAR	8	*
BRSCH	Industry key		BRSCH	CHAR	8	T016
BUBKZ	Check digit for the international location number		BUBKZ	NUMC	2
DATLT	Data communication line no.		DATLT	CHAR	28
DTAMS	Report key for data medium exchange		DTAMS	CHAR	2
DTAWS	Instruction Key for Data Medium Exchange		DTAWS	CHAR	4	*
ERDAT	Date on which the Record Was Created		ERDAT_RF	DATS	16
ERNAM	Name of Person who Created the Object		ERNAM_RF	CHAR	24
ESRNR	ISR subscriber number		ESRNR	CHAR	22
KONZS	Group key		KONZS	CHAR	20
KTOKK	Vendor account group		KTOKK	CHAR	8	T077K
KUNNR	Customer Number		KUNNR	CHAR	20	KNA1
LNRZA	Account Number of the Alternative Payee		LNRZA	CHAR	20	LFA1
LOEVM	Central Deletion Flag for Master Record		LOEVM_X	CHAR	2
SPERR	Central posting block		SPERB_X	CHAR	2
SPERM	Centrally imposed purchasing block		SPERM_X	CHAR	2
SPRAS	Language Key		SPRAS	LANG	2	T002
STCD1	Tax Number 1		STCD1	CHAR	32
STCD2	Tax Number 2		STCD2	CHAR	22
STKZA	Indicator: Business Partner Subject to Equalization Tax?		STKZA	CHAR	2
STKZU	Liable for VAT		STKZU	CHAR	2
TELBX	Telebox number		TELBX	CHAR	30
TELF1	First telephone number		TELF1	CHAR	32
TELF2	Second telephone number		TELF2	CHAR	32
TELFX	Fax Number		TELFX	CHAR	62
TELTX	Teletex number		TELTX	CHAR	60
TELX1	Telex number		TELX1	CHAR	60
XCPDK	Indicator: Is the account a one-time account?		XCPDK	CHAR	2
XZEMP	Indicator: Alternative Payee in Document Allowed?		XZEMP	CHAR	2
VBUND	Company ID of Trading Partner		RASSC	CHAR	12	T880
FISKN	Account number of the master record with fiscal address		FISKN_K	CHAR	20	LFA1
STCEG	VAT Registration Number		STCEG	CHAR	40
STKZN	Natural Person		STKZN	CHAR	2
SPERQ	Function That Will Be Blocked		QSPERRFKT	CHAR	4	TQ04A
GBORT	Place of birth of the person subject to withholding tax		GBORT_Q	CHAR	50
GBDAT	Date of Birth of the Person Subject to Withholding Tax		GBDAT_Q	DATS	16
SEXKZ	Key for the Sex of the Person Subject to Withholding Tax		SEXKZ	CHAR	2
KRAUS	Credit Information Number		KRAUS_CM	CHAR	22
REVDB	Last External Review		REVDB_CM	DATS	16
QSSYS	Supplier's QM System		QSSYS_IST	CHAR	8	TQ02B
KTOCK	Reference Account Group for One-Time Account (Vendor)		KTOCK	CHAR	8	T077K
PFORT	PO Box city		PFORT_GP	CHAR	70
WERKS	Plant (Own or External)		WERKS_EXT	CHAR	8
LTSNA	Indicator: vendor sub-range relevant		LTSNA	CHAR	2
WERKR	Indicator: plant level relevant		WERKR	CHAR	2
PLKAL	Factory calendar key		FABKL	CHAR	4	TFACD
DUEFL	Status of Data Transfer into Subsequent Release		DUEFL_BKPF	CHAR	2
TXJCD	Tax Jurisdiction		TXJCD	CHAR	30	TTXJ
SPERZ	Payment Block		SPERZ	CHAR	2
SCACD	Standard carrier access code		SCACD	CHAR	8
SFRGR	Forwarding agent freight group		SFRGR	CHAR	8	TSFG
LZONE	Transportation zone to or from which the goods are delivered		LZONE	CHAR	20	TZONE
XLFZA	Indicator: Alternative Payee Using Account Number		XLFZA	CHAR	2
DLGRP	Service agent procedure group		DLGRP	CHAR	8	TVFCD
FITYP	Tax type		J_1AFITP_D	CHAR	4	J_1AFITP
STCDT	Tax Number Type		J_1ATOID	CHAR	4	J_1ATODC
REGSS	Registered for Social Insurance		J_1AREGSS	CHAR	2
ACTSS	Activity Code for Social Insurance		J_1AACTSS	CHAR	6	J_1AACT
STCD3	Tax Number 3		STCD3	CHAR	36
STCD4	Tax Number 4		STCD4	CHAR	36
STCD5	Tax Number 5		STCD5	CHAR	120
STCD6	Tax Number 6		STCD6	CHAR	40
IPISP	Tax Split		J_1BINDEQU	CHAR	2
TAXBS	Tax Base in Percentage		TAXBS	NUMC	2
PROFS	Profession		PROFS	CHAR	60
STGDL	Shipment: statistics group, transportation service agent		STGDL	CHAR	4	VTSGD
EMNFR	External manufacturer code name or number		EMNFR	CHAR	20
LFURL	Uniform resource locator		URL	CHAR	264
J_1KFREPRE	Name of Representative		REPRES	CHAR	20
J_1KFTBUS	Type of Business		GESTYP	CHAR	60	BUSTYPE
J_1KFTIND	Type of Industry		INDTYP	CHAR	60	INDUSTYPE
CONFS	Status of Change Authorization (Central)		CONFS_X	CHAR	2
UPDAT	Date on Which the Changes Were Confirmed		UPDAT_RF	DATS	16
UPTIM	Time of Last Change Confirmation		UPTIM_RF	TIMS	12
NODEL	Central deletion block for master record		NODEL_X	CHAR	2
QSSYSDAT	Validity Date of Certification		QQSSYSDAT	DATS	16
PODKZB	Supplier indicator relevant for proof of delivery		PODKZB	CHAR	2
FISKU	Account Number of Master Record of Tax Office Responsible		FISKU	CHAR	20	LFA1
STENR	Tax Number at Responsible Tax Authority		STENR	CHAR	36
CARRIER_CONF	Carrier confirmation is expected		/SPE/CARRIER_CNF	CHAR	2
MIN_COMP	Micro company indicator		J_1BMICRO_COMP	CHAR	2
TERM_LI	Terms of Liability		J_1BTERMS_LIAB	CHAR	2
CRC_NUM	CRC number		J_1BCRC_NUM	CHAR	50
CVP_XBLCK	Business Purpose Completed Flag		CVP_XBLCK	CHAR	2
WEORA	Acceptance At Origin		WEORA	CHAR	2
.INCLUDE				LFA1BRAZIL	0
RG	RG Number		J_1BRG	CHAR	22
EXP	Issued by		J_1BEXP	CHAR	6
UF	State		J_1BUF	CHAR	4
RGDATE	RG Issuing Date		J_1BRGDATE	DATS	16
RIC	RIC Number		J_1BRIC	NUMC	22
RNE	Foreign National Registration		J_1BRNE	CHAR	20
RNEDATE	RNE Issuing Date		J_1BRNEDATE	DATS	16
CNAE	CNAE		J_1BCNAE	CHAR	14	J_1BTCNAE
LEGALNAT	Legal Nature		J_1BLEGALNAT	NUMC	8	J_1BTLEGALNAT
CRTN	CRT Number		J_1BCRTN	CHAR	2
ICMSTAXPAY	ICMS Taxpayer		J_1BICMSTAXPAY	CHAR	4	J_1BTICMSTAXPAY
INDTYP	Industry Main Type		J_1BINDTYP	CHAR	4	J_1BTINDTYP
TDT	Tax Declaration Type		J_1BTDT	CHAR	4	J_1BTTDT
COMSIZE	Company Size		J_1BCOMSIZE	CHAR	4	J_1BTCOMSIZE
DECREGPC	Declaration Regimen for PIS/COFINS		J_1BDECREGPC	CHAR	4	J_1BTDECREGPC
.INCLUDE				TWTAX_S_LFA1	0
ALLOWANCE_TYPE	TW: Allowance Type in Business Partner Extension		TWVAT_ALLOWANCE_TYPE	CHAR	2
PAYTRSN	Payment Reason		FARP_PAYT_RSN	CHAR	8	*
RECENCY	Master Data Consolidation: Recency		MDC_RECENCY	DEC	8
SOURCE_RECENCY	Master Data Consolidation: Recency		MDC_RECENCY	DEC	8
TARGET_ASSIGNMENT_ID	Multiple Assignment ID (Number)		MDG_BP_ASSIGNMENT_ID	NUMC	24