LFB1_ACT - Master Data Consolidation: Best Record Table for LFB1

Master Data Consolidation: Best Record Table for LFB1 information is stored in SAP table LFB1_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 LFB1_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
BUKRS	Company Code	X	BUKRS	CHAR	8
ASSIGNMENT_ID	Multiple Assignment ID (Number)	X	MDG_BP_ASSIGNMENT_ID	NUMC	24
PERNR	Personnel Number		PERNR_D	NUMC	16
.INCLUDE				SI_LFB1	0
ERDAT	Date on which the Record Was Created		ERDAT_RF	DATS	16
ERNAM	Name of Person who Created the Object		ERNAM_RF	CHAR	24
SPERR	Posting block for company code		SPERB_B	CHAR	2
LOEVM	Deletion Flag for Master Record (Company Code Level)		LOEVM_B	CHAR	2
AKONT	Reconciliation Account in General Ledger		AKONT	CHAR	20	SKB1
BEGRU	Authorization Group		BRGRU	CHAR	8	*
VZSKZ	Interest Indicator		VZSKZ	CHAR	4	T056
XVERR	Indicator: Clearing between customer and vendor?		XVERR_LFB1	CHAR	2
EIKTO	Our account number with the vendor		EIKTO_K	CHAR	24
KVERM	Memo		KVERM	CHAR	60
FDGRV	Planning Group		FDGRV	CHAR	20	T035
BUSAB	Accounting Clerk Abbreviation		BUSAB	CHAR	4	T001S
LNRZE	Head office account number		LNRZE	CHAR	20	LFA1
LNRZB	Account number of the alternative payee		LNRZB	CHAR	20	LFA1
DATLZ	Date of Last Interest Calculation Run		DATLZ	DATS	16
XDEZV	Indicator: Local Processing?		XDEZV	CHAR	2
WEBTR	Bill of Exchange Limit (in Local Currency)		WEBTR_CS	CURR	7
KULTG	Probable Time Until Check Is Paid		KULTG	DEC	2
REPRF	Check Flag for Double Invoices or Credit Memos		REPRF	CHAR	2
TOGRU	Tolerance Group for Business Partner/G/L Account		TOGRU	CHAR	8	T043G
HBKID	Short Key for a House Bank		HBKID	CHAR	10	T012
XPORE	Indicator: Pay All Items Separately?		XPORE	CHAR	2
QSZNR	Certificate Number of the Withholding Tax Exemption		QSZNR	CHAR	20
QSZDT	Validity Date for Withholding Tax Exemption Certificate		QSZDT	DATS	16
QSSKZ	Withholding Tax Code		QSSKZ	CHAR	4	*
BLNKZ	(Obsolete) Subsidy Ind. for Determining the Reduction Rate		BLNKZ	CHAR	4	*
MINDK	Minority Indicator		MINDK	CHAR	6	T059M
ALTKN	Previous Master Record Number		ALTKN	CHAR	20
MGRUP	Key for Dunning Notice Grouping		MGRUP	CHAR	4	T047R
UZAWE	Payment method supplement		UZAWE	CHAR	4	T042F
QSREC	Vendor Recipient Type		QSREC	CHAR	4	T059A
QSBGR	Authority for Exemption from Withholding Tax		QSBGR	CHAR	2
QLAND	Withholding Tax Country/Region Key		QLAND	CHAR	6	T005Q
XEDIP	Indicator: Send Payment Advices by EDI		XEDIP	CHAR	2
FRGRP	Release Approval Group		FRGRP	CHAR	8	VBWF08
TOGRR	Tolerance Group in Invoice Verification		TOGRR	CHAR	8	T169L
TLFXS	Accounting clerk's fax number at the customer/vendor		TLFXS	CHAR	62
INTAD	Internet address of partner company clerk		INTAD	CHAR	260
XLFZB	Indicator: Alternative Payee Using Account Number		XLFZB	CHAR	2
GUZTE	Payment Terms Key for Credit Memos		GUZTE	CHAR	8
GRICD	Activity Code for Gross Income Tax		J_1AGICD_D	CHAR	4	J_1AGICD
GRIDT	Distribution Type for Employment Tax		J_1ADTYP_D	CHAR	4	J_1ADTYP
XAUSZ	Indicator for Periodic Account Statements		XAUSZ	CHAR	2	T048K
CERDT	Certification Date		CERDT	DATS	16
CONFS	Status of Change Authorization (Company Code Level)		CONFS_B	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	Deletion bock for master record (company code level)		NODEL_B	CHAR	2
TLFNS	Accounting clerk's telephone number at business partner		TLFNS	CHAR	60
AVSND	Indicator: Send Payment Advice by XML		AVSND	CHAR	2
AD_HASH	E-Mail Address for Avis: Hash Value		ADHASH	CHAR	20
CVP_XBLCK_B	Business Purpose Completed Flag		CVP_XBLCK	CHAR	2
CIIUCODE	Main economic activity		CIIUCODE	NUMC	8
PAYMENTCLEARINGGRPID	Payment Clearing Group ID		FAR_PAYMENT_CLEARING_GROUP	CHAR	16	FAR_PYMT_CLG_GRP
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