LFA1_SRC - Master Data Consolidation: Source Table for LFA1

Master Data Consolidation: Source Table for LFA1 information is stored in SAP table LFA1_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 LFA1_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
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	*
.INCLUDE				INCL_EEW_LFA1	0
LFA1_EEW_SUPP	Dataelement Exstensibility for Supplier		LFA1_EEW_SUPP	CHAR	2
SOURCE_RECENCY	Master Data Consolidation: Recency		MDC_RECENCY	DEC	8
TARGET_ASSIGNMENT_ID	Multiple Assignment ID (Number)		MDG_BP_ASSIGNMENT_ID	NUMC	24
.INCLU--AP				BORGR_WESRC	0
.INCLUDE				BORGR_WE_LFA1	0
BORGR_DATUN	Date Limit for External Document Identification		BORGR_DATUN	DATS	16
BORGR_YEAUN	Annual Repetition of Date Limit		BORGR_YEAUN	CHAR	2
.INCLU--AP				FIAPAU_S_ABN_REASONSRC	0
AU_CARRYING_ENT	Is payer making payment in course of carrying on enterprise		FIAPAU_CARRY_ENT	CHAR	2
AU_IND_UNDER_18	Is an individual under 18 and payment does not exceed $350		FIAPAU_IND_UNDER_18	CHAR	2
AU_PAYMENT_NOT_EXCEED_75	The payment does not exceed $75, excl. GST		FIAPAU_PMNT_NOT_EXCEED	CHAR	2
AU_WHOLLY_INP_TAXED	The supply that the payment relates to is wholly input taxed		FIAPAU_INPUT_TAXED	CHAR	2
AU_PARTNER_WITHOUT_GAIN	The supply is made by an individual without gain		FIAPAU_PARTNER_NO_GAIN	CHAR	2
AU_NOT_ENTITLED_ABN	The supplier is not entitled to an ABN		FIAPAU_ABN_ELIGIBLE	CHAR	2
AU_PAYMENT_EXEMPT	The whole of the payment is exempt income.		FIAPAU_PMNT_EXEMPT	CHAR	2
AU_PRIVATE_HOBBY	An activity done as a private recreational pursuit		FIAPAU_PVT_HOBBY	CHAR	2
AU_DOMESTIC_NATURE	wholly of a private or domestic nature		FIAPAU_DOM_NATURE	CHAR	2
.INCLU--AP				FIAPKW_S_SHAREHOL_LFA1SRC	0
ADDR2_STREET	Street		AD_STREET	CHAR	120
ADDR2_HOUSE_NUM	House Number		AD_HSNM1	CHAR	20
ADDR2_POST	City postal code		AD_PSTCD1	CHAR	20
ADDR2_CITY	City		AD_CITY1	CHAR	80
ADDR2_COUNTRY	Country/Region Key		LAND1	CHAR	6	*
.INCLU--AP				FIAPUK_S_CIS_VF_EXT_LFA1SRC	0
CATEG	Subcontractor's Business Type		CIS_CATEGORY	CHAR	24
PARTNER_NAME	Partner's Trading Name		CIS_PARTNER_NAME	CHAR	60
PARTNER_UTR	Partner's Unique Tax Reference (UTR)		CIS_PARTNER_UTR	CHAR	40
STATUS	Verification Status		CIS_VFNSTATUS	CHAR	6
VFNUM	Verification Number		GB_CIS_SC_VFNNUM	CHAR	40
VFNID	Tax Status of the Verified Subcontractor		CIS_VFN_ID	CHAR	2
CRN	Companies House Registration Number		GB_CIS_CRN	CHAR	16
.INCLU--AP				FIWTFR_S_REPSRC	0
FR_OCCUPATION	Organisation Occupation		FIWTFR_OCC	CHAR	100
.INCLU--AP				J_1IMOVEND_LFA1_ASRC	0
J_1IEXCD	ECC Number		J_1IEXCD	CHAR	80
J_1IEXRN	Excise Registration Number		J_1IEXRN	CHAR	80
J_1IEXRG	Excise Range		J_1IEXRG	CHAR	120
J_1IEXDI	Excise Division		J_1IEXDI	CHAR	120
J_1IEXCO	Excise Commissionerate		J_1IEXCO	CHAR	120
J_1ICSTNO	Central Sales Tax Number		J_1ICSTNO	CHAR	80
J_1ILSTNO	Local Sales Tax Number		J_1ILSTNO	CHAR	80
J_1IPANNO	Permanent Account Number		J_1IPANNO	CHAR	80
J_1IEXCIVE	Excise tax indicator for vendor		J_1IEXCIVE	CHAR	2
J_1ISSIST	SSI Status		J_1ISSIST	CHAR	2
J_1IVTYP	Type of Vendor		J_1IVTYP	CHAR	4
J_1IVENCRE	CENVAT Scheme Participant		J_1IVENCRE	CHAR	2
AEDAT	Last Changed On		AEDAT	DATS	16
USNAM	Changed by the user		J_1IUSNAMC	CHAR	24
J_1ISERN	Service Tax Registration Number		J_1ISERN	CHAR	80
J_1IPANREF	PAN Reference Number		J_1IPANREF	CHAR	80
J_1IPANVALDT	PAN Valid From Date		J_1IPANVALDT	DATS	16
J_1I_CUSTOMS	Customs Vendor		J_1I_CUSTOMS	CHAR	2
J_1IDEDREF	Deductee Reference Number		J_1IDEDREF	CHAR	20
VEN_CLASS	Vendor Classification for GST		J_1IGTAKLD	CHAR	2
.INCLU--AP				MDC_SAPNEA_J_SC_LFA1SRC	0
J_SC_CAPITAL	Capital Amount		/SAPNEA/J_SC_CAPITAL	CURR	8
J_SC_CURRENCY	Currency		/SAPNEA/J_SC_CURRENCY	CUKY	10
.INCLU--AP				PFM_ALFA1_ISPSSRC	0
ENTPUB	Vendor is public entity?		PFM_12ENTPUB	CHAR	2
ESCRIT	Deed of public use		PFM_12ESCRIT	CHAR	160
DVALSS	Social Security certificate validity date		PFM_12DVALSS	DATS	16
FRMCSS	Social Security certificate submission form		PFM_12FRMCSS	CHAR	100
CODCAE	CAE code		PFM_12CODCAE	NUMC	10
AUSDIV	Absence of debt		PFM_12AUSDIV	CHAR	2
.INCLU--AP				WRF_LFA1_APPENDSRC	0
.INCLUDE				WRF_LFA1_STY	0
TRANSPORT_CHAIN	Transportation Chain		WRF_PSCD_TC_ID	CHAR	20	WRF_PSCD_TCHAINH
STAGING_TIME	Staging Time in Days		WRF_PSCD_MST	DEC	2
SCHEDULING_TYPE	Scheduling Procedure		WRF_PSCD_SCHED_TYPE	CHAR	2
SUBMI_RELEVANT	Cross Docking: Relevant for Collective Numbering		WRF_SUBMI_RELEVANT	CHAR	2