SAP ABAP Table IFMLFA1 (Struktur für Lieferanten)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM-IS (Application Component) Information system
     ⤷ FMKO (Package) FM: Reporting for German Local Authorities

Basic Data

Table Category	INTTAB	Structure
Structure	IFMLFA1	Table Relationship Diagram
Short Description	Struktur für Lieferanten

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Vendor Master (General Section)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
4	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
5	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
6	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
7	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
8	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
9	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
10	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
11	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
12	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
13	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
14	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
15	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
16	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
17	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
18	MCOD1	☐	MCDK1	CHAR25	CHAR	25	0	Search term for matchcode search
19	MCOD2	☐	MCDK2	CHAR25	CHAR	25	0	Search term for matchcode search
20	MCOD3	☐	MCDK3	CHAR25	CHAR	25	0	Search term for matchcode search
21	.INCLUDE	☐				0	0	Vendor Master (General Section)
22	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
23	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
24	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
25	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
26	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
27	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
28	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
29	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
30	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
31	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
32	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
33	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
34	ESRNR	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
35	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
36	KTOKK	☐	KTOKK	KTOKK	CHAR	4	0	Vendor account group	T077K
37	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
38	LNRZA	☐	LNRZA	LIFNR	CHAR	10	0	Account Number of the Alternative Payee	LFA1
39	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
40	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
41	SPERM	☐	SPERM_X	XFELD	CHAR	1	0	Centrally imposed purchasing block
42	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
43	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
44	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
45	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
46	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
47	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
48	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
49	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
50	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
51	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
52	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
53	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
54	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
55	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
56	FISKN	☐	FISKN_K	LIFNR	CHAR	10	0	Account number of the master record with fiscal address	LFA1
57	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
58	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
59	SPERQ	☐	QSPERRFKT	QSPERRFKT	CHAR	2	0	Function That Will Be Blocked	TQ04A
60	GBORT	☐	GBORT_Q	TEXT25	CHAR	25	0	Place of birth of the person subject to withholding tax
61	GBDAT	☐	GBDAT_Q	DATUM	DATS	8	0	Date of birth of the person subject to withholding tax
62	SEXKZ	☐	SEXKZ	SEXKZ	CHAR	1	0	Key for the Sex of the Person Subject to Withholding Tax
63	KRAUS	☐	KRAUS_CM	CHAR11	CHAR	11	0	Credit information number
64	REVDB	☐	REVDB_CM	DATUM	DATS	8	0	Last review (external)
65	QSSYS	☐	QSSYS_IST	QSSYSFAM	CHAR	4	0	Vendor's QM system	TQ02B
66	KTOCK	☐	KTOCK	KTOKK	CHAR	4	0	Reference Account Group for One-Time Account (Vendor)	T077K
67	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
68	WERKS	☐	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)	*
69	LTSNA	☐	LTSNA	XFELD	CHAR	1	0	Indicator: vendor sub-range relevant
70	WERKR	☐	WERKR	XFELD	CHAR	1	0	Indicator: plant level relevant
71	PLKAL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
72	DUEFL	☐	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
73	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
74	SPERZ	☐	SPERZ	XFELD	CHAR	1	0	Payment Block
75	SCACD	☐	SCACD	SCACD	CHAR	4	0	Standard carrier access code
76	SFRGR	☐	SFRGR	SFRGR	CHAR	4	0	Forwarding Agent Freight Group	TSFG
77	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
78	XLFZA	☐	XLFZA	XFELD	CHAR	1	0	Indicator: Alternative payee using account number
79	DLGRP	☐	DLGRP	DLGRP	CHAR	4	0	Service agent procedure group	TVFCD
80	FITYP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITP
81	STCDT	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	J_1ATODC
82	REGSS	☐	J_1AREGSS	XFELD	CHAR	1	0	Registered for Social Insurance
83	ACTSS	☐	J_1AACTSS	J_1AACTSS	CHAR	3	0	Activity Code for Social Insurance	J_1AACT
84	STCD3	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
85	STCD4	☐	STCD4	CHAR18	CHAR	18	0	Tax Number 4
86	STCD5	☐	STCD5	CHAR60	CHAR	60	0	Tax Number 5
87	IPISP	☐	J_1BINDEQU	XFELD	CHAR	1	0	Tax Split
88	TAXBS	☐	TAXBS	TAXBS	NUMC	1	0	Tax Base in Percentage
89	PROFS	☐	PROFS	TEXT30	CHAR	30	0	Profession
90	STGDL	☐	STGDL	STGDL	CHAR	2	0	Shipment: statistics group, transportation service agent	VTSGD
91	EMNFR	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
92	LFURL	☐	URL	TEXT132	CHAR	132	0	Uniform resource locator
93	J_1KFREPRE	☐	REPRES	REPRES	CHAR	10	0	Name of Representative
94	J_1KFTBUS	☐	GESTYP	GESTYP	CHAR	30	0	Type of Business	BUSTYPE
95	J_1KFTIND	☐	INDTYP	INDTYP	CHAR	30	0	Type of Industry	INDUSTYPE
96	CONFS	☐	CONFS_X	CHAR1	CHAR	1	0	Status of Change Authorization (Central)
97	UPDAT	☐	UPDAT_RF	DATUM	DATS	8	0	Date on Which the Changes Were Confirmed
98	UPTIM	☐	UPTIM_RF	AS4TIME	TIMS	6	0	Time of Last Change Confirmation
99	NODEL	☐	NODEL_X	XFELD	CHAR	1	0	Central deletion block for master record
100	QSSYSDAT	☐	QQSSYSDAT	QQSSYSDAT	DATS	8	0	Validity date of certification
101	PODKZB	☐	PODKZB	PODKZB	CHAR	1	0	Vendor indicator relevant for proof of delivery
102	FISKU	☐	FISKU	LIFNR	CHAR	10	0	Account Number of Master Record of Tax Office Responsible	LFA1
103	STENR	☐	STENR	CHAR18	CHAR	18	0	Tax Number at Responsible Tax Authority
104	CARRIER_CONF	☐	/SPE/CARRIER_CNF	/SPE/CARRIER_CONF	CHAR	1	0	Carrier confirmation is expected
105	MIN_COMP	☐	J_1BMICRO_COMP	XFELD	CHAR	1	0	Micro company indicator
106	TERM_LI	☐	J_1BTERMS_LIAB	XFELD	CHAR	1	0	Terms of Liability
107	CRC_NUM	☐	J_1BCRC_NUM	CHAR25	CHAR	25	0	CRC number
108	.INCLUDE	☐				0	0	Vendor Master Data - Brazil
109	RG	☐	J_1BRG	J_1BRG	CHAR	11	0	RG Number
110	EXP	☐	J_1BEXP	J_1BEXP	CHAR	3	0	Issued by
111	UF	☐	J_1BUF	J_1BUF	CHAR	2	0	State
112	RGDATE	☐	J_1BRGDATE	DATUM	DATS	8	0	RG Issue Date
113	RIC	☐	J_1BRIC	J_1BRIC	NUMC	11	0	RIC Number
114	RNE	☐	J_1BRNE	J_1BRNE	CHAR	10	0	Foreign National Registration
115	RNEDATE	☐	J_1BRNEDATE	DATUM	DATS	8	0	RNE Issue Date
116	CNAE	☐	J_1BCNAE	J_1BCNAE	CHAR	7	0	CNAE	J_1BTCNAE
117	LEGALNAT	☐	J_1BLEGALNAT	J_1BLEGALNAT	NUMC	4	0	Legal Nature	J_1BTLEGALNAT
118	CRTN	☐	J_1BCRTN	J_1BCRTN	CHAR	1	0	CRT Number
119	ICMSTAXPAY	☐	J_1BICMSTAXPAY	J_1BICMSTAXPAY	CHAR	2	0	ICMS Taxpayer	J_1BTICMSTAXPAY
120	INDTYP	☐	J_1BINDTYP	J_1BINDTYP	CHAR	2	0	Industry Main Type	J_1BTINDTYP
121	TDT	☐	J_1BTDT	J_1BTDT	CHAR	2	0	Tax Declaration Type	J_1BTTDT
122	COMSIZE	☐	J_1BCOMSIZE	J_1BCOMSIZE	CHAR	2	0	Company Size	J_1BTCOMSIZE
123	DECREGPC	☐	J_1BDECREGPC	J_1BDECREGPC	CHAR	2	0	Declaration Regimen for PIS/COFINS	J_1BTDECREGPC
124	.INCLU--AP	☐				0	0	Subcontractor Information
125	J_SC_CAPITAL	☐	/SAPNEA/J_SC_CAPITAL	/SAPNEA/J_SC_CAPITAL	CURR	15	2	Capital Amount
126	J_SC_CURRENCY	☐	/SAPNEA/J_SC_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
127	.INCLU--AP	☐				0	0	US Federal Government Vendor Master Data Additional Fields
128	ALC	☐	FMFG_ALC	FMFG_ALC	CHAR	8	0	Agency Location Code	FMFGT_ALC
129	PMT_OFFICE	☐	FMFG_PMT_OFF	FMFG_PMT_OFF	CHAR	5	0	Payment Office	FMFGT_PO
130	.INCLU--AP	☐				0	0	Local Authority Additional Fields (Address)
131	PSOFG	☐	PSOFG	PSOFG	CHAR	10	0	Processor group	PSO19
132	PSOIS	☐	PSOIS	CHAR20	CHAR	20	0	Subledger acct preprocessing procedure
133	.INCLUDE	☐				0	0	Local Authority Additional Fields (Address)
134	PSON1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
135	PSON2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
136	PSON3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
137	PSOVN	☐	PSOVN	NAME	CHAR	35	0	First Name
138	PSOTL	☐	PSOTL	FMPSOTL	CHAR	20	0	Title
139	PSOHS	☐	PSOHS	CHAR06	CHAR	6	0	House number: is no longer used from Release 4.6B
140	PSOST	☐	PSOST	PSOST	CHAR	28	0	Street: No longer used from Release 4.6B
141	.INCLU--AP	☐				0	0	LFA1 Extension with New Fields - Seasonal Procurement
142	.INCLUDE	☐				0	0	LFA1 Extension with New Fields - Seasonal Procurement
143	TRANSPORT_CHAIN	☐	WRF_PSCD_TC_ID	WRF_PSCD_TC_ID	CHAR	10	0	Transportation Chain	WRF_PSCD_TCHAINH
144	STAGING_TIME	☐	WRF_PSCD_MST	WRF_PSCD_MST	DEC	3	0	Staging Time in Days
145	SCHEDULING_TYPE	☐	WRF_PSCD_SCHED_TYPE	WRF_PSCD_SCHED_TYPE	CHAR	1	0	Scheduling Procedure
146	SUBMI_RELEVANT	☐	WRF_SUBMI_RELEVANT	XFELD	CHAR	1	0	Cross Docking: Relevant for Collective Numbering
147	PSKTO	☐	PSKTO	PSKTO	CHAR	16	0	Account Number of Bank Account At Post Office
148	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
149	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
150	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
151	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
152	SWIFT	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IFMLFA1	ACTSS	J_1AACT	J_1AACT		1	CN
2	IFMLFA1	ALC	FMFGT_ALC	ALC
3	IFMLFA1	BRSCH	T016	BRSCH	REF	C	CN
4	IFMLFA1	CNAE	J_1BTCNAE	J_1BCNAE	KEY
5	IFMLFA1	COMSIZE	J_1BTCOMSIZE	J_1BCOMSIZE	KEY
6	IFMLFA1	DECREGPC	J_1BTDECREGPC	J_1BDECREGPC	KEY
7	IFMLFA1	DLGRP	TVFCD	DLGRP	REF	1	CN
8	IFMLFA1	FISKN	LFA1	LIFNR	REF	C	CN
9	IFMLFA1	FISKU	LFA1	LIFNR	KEY	C	CN
10	IFMLFA1	FITYP	J_1AFITP	J_1AFITP		1	CN
11	IFMLFA1	ICMSTAXPAY	J_1BTICMSTAXPAY	J_1BICMSTAXPAY	KEY
12	IFMLFA1	INDTYP	J_1BTINDTYP	J_1BINDTYP	KEY
13	IFMLFA1	J_1KFTBUS	BUSTYPE	GESTYP	REF	C	CN
14	IFMLFA1	J_1KFTIND	INDUSTYPE	INDTYPE	REF	C	CN
15	IFMLFA1	J_SC_CURRENCY	TCURC	WAERS
16	IFMLFA1	KTOCK	T077K	KTOKK	REF	C	CN
17	IFMLFA1	KTOKK	T077K	KTOKK	REF	1	CN
18	IFMLFA1	KUNNR	KNA1	KUNNR	REF	C	CN
19	IFMLFA1	LAND1	T005	LAND1	REF	C	CN
20	IFMLFA1	LEGALNAT	J_1BTLEGALNAT	J_1BLEGALNAT	KEY
21	IFMLFA1	LNRZA	LFA1	LIFNR	REF	C	CN
22	IFMLFA1	LZONE	TZONE	ZONE1	REF	C	CN
23	IFMLFA1	MANDT	T000	MANDT	KEY	1	CN
24	IFMLFA1	PLKAL	TFACD	IDENT	REF	C	CN
25	IFMLFA1	PMT_OFFICE	FMFGT_PO	PMT_OFFICE
26	IFMLFA1	PSOFG	PSO19	PSOFG		1	CN
27	IFMLFA1	QSSYS	TQ02B	QSSYSFAM	REF	C	CN
28	IFMLFA1	REGIO	T005S	BLAND	REF	C	CN
29	IFMLFA1	SFRGR	TSFG	SFRGR	REF	C	CN
30	IFMLFA1	SPERQ	TQ04A	SPERRFKT	REF	1	CN
31	IFMLFA1	SPRAS	T002	SPRAS	REF	1	CN
32	IFMLFA1	STCDT	J_1ATODC	J_1ATODC		1	CN
33	IFMLFA1	STGDL	VTSGD	STGDL
34	IFMLFA1	TDT	J_1BTTDT	J_1BTDT	KEY
35	IFMLFA1	TRANSPORT_CHAIN	WRF_PSCD_TCHAINH	TC_ID	KEY	1	N
36	IFMLFA1	TXJCD	TTXJ	TXJCD	REF	C	CN
37	IFMLFA1	VBUND	T880	RCOMP	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in	500