LFB1_SRC - Master Data Consolidation: Source Table for LFB1

Master Data Consolidation: Source Table for LFB1 information is stored in SAP table LFB1_SRC.
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_SRC

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
.INCLUDE	SOURCE_KEY	X		MDC_SOURCE_KEY	0
SOURCE_SYSTEM	Source System	X	MDC_BUSINESS_SYSTEM	CHAR	120
SOURCE_ID	Master Data Consolidation: ID of a Source Objects	X	MDC_SOURCE_ID	CHAR	120
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	*
.INCLUDE				INCL_EEW_LFB1	0
LFB1_EEW_CC	Dataelement for the Extension Company Code		LFB1_EEW_CC	CHAR	2
SOURCE_RECENCY	Master Data Consolidation: Recency		MDC_RECENCY	DEC	8
LIFNR	Account Number of Supplier		LIFNR	CHAR	20
TARGET_ASSIGNMENT_ID	Multiple Assignment ID (Number)		MDG_BP_ASSIGNMENT_ID	NUMC	24
.INCLU--AP				FIAPKR_S_LFB1SRC	0
BRSCH	Industry key		BRSCH	CHAR	8	*
WRBTR	Amount for Payment Program		KR_AMOUNT_CS	CURR	7
WAERS	Currency Key		WAERS	CUKY	10	*
.INCLU--AP				FIAPKW_S_SHAREHOLSRC	0
FORGN	Foreign Shareholder		FIWTKW_LOCALITY	CHAR	2
SHARE_IN_FOREIGN	Share in Dividend Paying Company		FIWTKW_OWNED_SHARE	DEC	3
NOTES	Notes		FIWTKW_NOTES	CHAR	400
ACTIVE	Boolean Variable ('X'=Shareholder is active, ''=not active)		FIWTKW_SHR_ACTIVE	CHAR	2
.INCLU--AP				FIWTUS_S_FATCA_REPSRC	0
US_REC_COUNTRY	Country/Region Key		LAND1	CHAR	6	*
US_GIIN	US Recipient GIIN		FIWTUS_RECIPIENT_GIIN	CHAR	38
US_FTID	US Recipient Foreign Tax ID		FIWTUS_RECIPIENT_FTID	CHAR	44
US_REC_DOB	US Recipient Date Of Birth		FIWTUS_RECIPIENT_DOB	DATS	16
US_LOB_CODE	LOB Treaty Code		FIWTUS_LOB_CODE	CHAR	4
US_W8_RECVDATE	US W8 Form Received Date		FIWTUS_W8_RECV_DATE	DATS	16
US_W9_RECVDATE	US W8 Form Received Date		FIWTUS_W9_RECV_DATE	DATS	16
US_TIN_NOTICE	Second TIN Notice from IRS		FIWTUS_SECOND_TIN_NOTICE	CHAR	2
US_PARTNERSHIP_IND	Partnership Interest Indicator		FIWTUS_PARTNERSHIP_IND	CHAR	2
.INCLU--AP				MDC_ATL_VALFB1SRC	0
.INCLUDE				/ATL/VFI00001	0
.INCLU--AP				MDC_ATL_VBLFB1SRC	0
.INCLU--AP				MDC_SAPNEA_J_SC_LFB1SRC	0
J_SC_SUBCONTYPE	Subcontractor Type		/SAPNEA/J_SC_SUBCONTYPE	CHAR	2
J_SC_COMPDATE	Completion Date Of Inspection		/SAPNEA/J_SC_COMPLETIONDATE	NUMC	6
J_SC_OFFSM	Offset Method		/SAPNEA/J_SC_OFFSM	CHAR	2
J_SC_OFFSR	Offset Percentage		/SAPNEA/J_SC_OFFSR	NUMC	6
.INCLU--AP				WRF_LFB1_APPENDSRC	0
.INCLUDE				WRF_LFB1_STY	0
PREPAY_RELEVANT	Prepayment Relevance (Supplier Master)		WRF_PREPAY_RELEVANT	CHAR	2
ASSIGN_TEST	Assignment Test Group		WRF_MRM_ASSIGN_GROUP	CHAR	8	WRF_ASSIGN_GRP