SAP ABAP Table VMDS_EI_EXTRACT (Complex Internal Interface for Vendors)

Hierarchy

☛

SAP_APPL (Software Component) Logistics and Accounting
⤷

LO-MD-BP-VM (Application Component) Vendor Master
⤷

VMD_INTERFACE (Package) Vendor Interface

Basic Data

Table Category	INTTAB	Structure
Structure	VMDS_EI_EXTRACT	Table Relationship Diagram
Short Description	Complex Internal Interface for Vendors

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	Tables for Central Data Compl. Structure Vendor
2	LFA1	LFA1		STRU	0	0
3	MANDT	MANDT	MANDT	CLNT	3	0	Client	*
4	LIFNR	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor
5	LAND1	LAND1_GP	LAND1	CHAR	3	0	Country Key
6	NAME1	NAME1_GP	NAME	CHAR	35	0	Name 1
7	NAME2	NAME2_GP	NAME	CHAR	35	0	Name 2
8	NAME3	NAME3_GP	NAME	CHAR	35	0	Name 3
9	NAME4	NAME4_GP	NAME	CHAR	35	0	Name 4
10	ORT01	ORT01_GP	TEXT35	CHAR	35	0	City
11	ORT02	ORT02_GP	TEXT35	CHAR	35	0	District
12	PFACH	PFACH	PFACH	CHAR	10	0	PO Box
13	PSTL2	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
14	PSTLZ	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
15	REGIO	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
16	SORTL	SORTL	CHAR10	CHAR	10	0	Sort field
17	STRAS	STRAS_GP	TEXT35	CHAR	35	0	House number and street
18	ADRNR	ADRNR	ADRNR	CHAR	10	0	Address	*
19	MCOD1	MCDK1	CHAR25	CHAR	25	0	Search term for matchcode search
20	MCOD2	MCDK2	CHAR25	CHAR	25	0	Search term for matchcode search
21	MCOD3	MCDK3	CHAR25	CHAR	25	0	Search term for matchcode search
22	.INCLUDE				0	0	Vendor Master (General Section)
23	ANRED	ANRED	TEXT15	CHAR	15	0	Title
24	BAHNS	BAHNS	BAHNH	CHAR	25	0	Train station
25	BBBNR	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
26	BBSNR	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
27	BEGRU	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
28	BRSCH	BRSCH	BRSCH	CHAR	4	0	Industry key	*
29	BUBKZ	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
30	DATLT	DATLT	TEXT14	CHAR	14	0	Data communication line no.
31	DTAMS	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
32	DTAWS	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
33	ERDAT	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
34	ERNAM	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
35	ESRNR	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
36	KONZS	KONZS	KONZS	CHAR	10	0	Group key
37	KTOKK	KTOKK	KTOKK	CHAR	4	0	Vendor account group	*
38	KUNNR	KUNNR	KUNNR	CHAR	10	0	Customer Number
39	LNRZA	LNRZA	LIFNR	CHAR	10	0	Account Number of the Alternative Payee	*
40	LOEVM	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
41	SPERR	SPERB_X	XFELD	CHAR	1	0	Central posting block
42	SPERM	SPERM_X	XFELD	CHAR	1	0	Centrally imposed purchasing block
43	SPRAS	SPRAS	SPRAS	LANG	1	0	Language Key
44	STCD1	STCD1	STCD1	CHAR	16	0	Tax Number 1
45	STCD2	STCD2	STCD2	CHAR	11	0	Tax Number 2
46	STKZA	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
47	STKZU	STKZU	XFELD	CHAR	1	0	Liable for VAT
48	TELBX	TELBX	TEXT15	CHAR	15	0	Telebox number
49	TELF1	TELF1	TEXT16	CHAR	16	0	First telephone number
50	TELF2	TELF2	TEXT16	CHAR	16	0	Second telephone number
51	TELFX	TELFX	TEXT31	CHAR	31	0	Fax Number
52	TELTX	TELTX	TEXT30	CHAR	30	0	Teletex number
53	TELX1	TELX1	TEXT30	CHAR	30	0	Telex number
54	XCPDK	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
55	XZEMP	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
56	VBUND	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
57	FISKN	FISKN_K	LIFNR	CHAR	10	0	Account number of the master record with fiscal address	*
58	STCEG	STCEG	STCEG	CHAR	20	0	VAT Registration Number
59	STKZN	STKZN	STKZN	CHAR	1	0	Natural Person
60	SPERQ	QSPERRFKT	QSPERRFKT	CHAR	2	0	Function That Will Be Blocked	*
61	GBORT	GBORT_Q	TEXT25	CHAR	25	0	Place of birth of the person subject to withholding tax
62	GBDAT	GBDAT_Q	DATUM	DATS	8	0	Date of birth of the person subject to withholding tax
63	SEXKZ	SEXKZ	SEXKZ	CHAR	1	0	Key for the Sex of the Person Subject to Withholding Tax
64	KRAUS	KRAUS_CM	CHAR11	CHAR	11	0	Credit information number
65	REVDB	REVDB_CM	DATUM	DATS	8	0	Last review (external)
66	QSSYS	QSSYS_IST	QSSYSFAM	CHAR	4	0	Vendor's QM system	*
67	KTOCK	KTOCK	KTOKK	CHAR	4	0	Reference Account Group for One-Time Account (Vendor)	*
68	PFORT	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
69	WERKS	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)
70	LTSNA	LTSNA	XFELD	CHAR	1	0	Indicator: vendor sub-range relevant
71	WERKR	WERKR	XFELD	CHAR	1	0	Indicator: plant level relevant
72	PLKAL	FABKL	WFCID	CHAR	2	0	Factory calendar key	*
73	DUEFL	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
74	TXJCD	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
75	SPERZ	SPERZ	XFELD	CHAR	1	0	Payment Block
76	SCACD	SCACD	SCACD	CHAR	4	0	Standard carrier access code
77	SFRGR	SFRGR	SFRGR	CHAR	4	0	Forwarding Agent Freight Group	*
78	LZONE	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
79	XLFZA	XLFZA	XFELD	CHAR	1	0	Indicator: Alternative payee using account number
80	DLGRP	DLGRP	DLGRP	CHAR	4	0	Service agent procedure group	*
81	FITYP	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	*
82	STCDT	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	*
83	REGSS	J_1AREGSS	XFELD	CHAR	1	0	Registered for Social Insurance
84	ACTSS	J_1AACTSS	J_1AACTSS	CHAR	3	0	Activity Code for Social Insurance	*
85	STCD3	STCD3	CHAR18	CHAR	18	0	Tax Number 3
86	STCD4	STCD4	CHAR18	CHAR	18	0	Tax Number 4
87	STCD5	STCD5	CHAR60	CHAR	60	0	Tax Number 5
88	IPISP	J_1BINDEQU	XFELD	CHAR	1	0	Tax Split
89	TAXBS	TAXBS	TAXBS	NUMC	1	0	Tax Base in Percentage
90	PROFS	PROFS	TEXT30	CHAR	30	0	Profession
91	STGDL	STGDL	STGDL	CHAR	2	0	Shipment: statistics group, transportation service agent	*
92	EMNFR	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
93	LFURL	URL	TEXT132	CHAR	132	0	Uniform resource locator
94	J_1KFREPRE	REPRES	REPRES	CHAR	10	0	Name of Representative
95	J_1KFTBUS	GESTYP	GESTYP	CHAR	30	0	Type of Business	*
96	J_1KFTIND	INDTYP	INDTYP	CHAR	30	0	Type of Industry	*
97	CONFS	CONFS_X	CHAR1	CHAR	1	0	Status of Change Authorization (Central)
98	UPDAT	UPDAT_RF	DATUM	DATS	8	0	Date on Which the Changes Were Confirmed
99	UPTIM	UPTIM_RF	AS4TIME	TIMS	6	0	Time of Last Change Confirmation
100	NODEL	NODEL_X	XFELD	CHAR	1	0	Central deletion block for master record
101	QSSYSDAT	QQSSYSDAT	QQSSYSDAT	DATS	8	0	Validity date of certification
102	PODKZB	PODKZB	PODKZB	CHAR	1	0	Vendor indicator relevant for proof of delivery
103	FISKU	FISKU	LIFNR	CHAR	10	0	Account Number of Master Record of Tax Office Responsible	*
104	STENR	STENR	CHAR18	CHAR	18	0	Tax Number at Responsible Tax Authority
105	CARRIER_CONF	/SPE/CARRIER_CNF	/SPE/CARRIER_CONF	CHAR	1	0	Carrier confirmation is expected
106	MIN_COMP	J_1BMICRO_COMP	XFELD	CHAR	1	0	Micro company indicator
107	TERM_LI	J_1BTERMS_LIAB	XFELD	CHAR	1	0	Terms of Liability
108	CRC_NUM	J_1BCRC_NUM	CHAR25	CHAR	25	0	CRC number
109	.INCLUDE				0	0	Vendor Master Data - Brazil
110	RG	J_1BRG	J_1BRG	CHAR	11	0	RG Number
111	EXP	J_1BEXP	J_1BEXP	CHAR	3	0	Issued by
112	UF	J_1BUF	J_1BUF	CHAR	2	0	State
113	RGDATE	J_1BRGDATE	DATUM	DATS	8	0	RG Issue Date
114	RIC	J_1BRIC	J_1BRIC	NUMC	11	0	RIC Number
115	RNE	J_1BRNE	J_1BRNE	CHAR	10	0	Foreign National Registration
116	RNEDATE	J_1BRNEDATE	DATUM	DATS	8	0	RNE Issue Date
117	CNAE	J_1BCNAE	J_1BCNAE	CHAR	7	0	CNAE	*
118	LEGALNAT	J_1BLEGALNAT	J_1BLEGALNAT	NUMC	4	0	Legal Nature	*
119	CRTN	J_1BCRTN	J_1BCRTN	CHAR	1	0	CRT Number
120	ICMSTAXPAY	J_1BICMSTAXPAY	J_1BICMSTAXPAY	CHAR	2	0	ICMS Taxpayer	*
121	INDTYP	J_1BINDTYP	J_1BINDTYP	CHAR	2	0	Industry Main Type	*
122	TDT	J_1BTDT	J_1BTDT	CHAR	2	0	Tax Declaration Type	*
123	COMSIZE	J_1BCOMSIZE	J_1BCOMSIZE	CHAR	2	0	Company Size	*
124	DECREGPC	J_1BDECREGPC	J_1BDECREGPC	CHAR	2	0	Declaration Regimen for PIS/COFINS	*
125	.INCLU--AP				0	0	Subcontractor Information
126	J_SC_CAPITAL	/SAPNEA/J_SC_CAPITAL	/SAPNEA/J_SC_CAPITAL	CURR	15	2	Capital Amount
127	J_SC_CURRENCY	/SAPNEA/J_SC_CURRENCY	WAERS	CUKY	5	0	Currency	*
128	.INCLU--AP				0	0	US Federal Government Vendor Master Data Additional Fields
129	ALC	FMFG_ALC	FMFG_ALC	CHAR	8	0	Agency Location Code	*
130	PMT_OFFICE	FMFG_PMT_OFF	FMFG_PMT_OFF	CHAR	5	0	Payment Office	*
131	.INCLU--AP				0	0	Local Authority Additional Fields (Address)
132	PSOFG	PSOFG	PSOFG	CHAR	10	0	Processor group	*
133	PSOIS	PSOIS	CHAR20	CHAR	20	0	Subledger acct preprocessing procedure
134	.INCLUDE				0	0	Local Authority Additional Fields (Address)
135	PSON1	NAME1_GP	NAME	CHAR	35	0	Name 1
136	PSON2	NAME2_GP	NAME	CHAR	35	0	Name 2
137	PSON3	NAME3_GP	NAME	CHAR	35	0	Name 3
138	PSOVN	PSOVN	NAME	CHAR	35	0	First Name
139	PSOTL	PSOTL	FMPSOTL	CHAR	20	0	Title
140	PSOHS	PSOHS	CHAR06	CHAR	6	0	House number: is no longer used from Release 4.6B
141	PSOST	PSOST	PSOST	CHAR	28	0	Street: No longer used from Release 4.6B
142	.INCLU--AP				0	0	LFA1 Extension with New Fields - Seasonal Procurement
143	.INCLUDE				0	0	LFA1 Extension with New Fields - Seasonal Procurement
144	TRANSPORT_CHAIN	WRF_PSCD_TC_ID	WRF_PSCD_TC_ID	CHAR	10	0	Transportation Chain
145	STAGING_TIME	WRF_PSCD_MST	WRF_PSCD_MST	DEC	3	0	Staging Time in Days
146	SCHEDULING_TYPE	WRF_PSCD_SCHED_TYPE	WRF_PSCD_SCHED_TYPE	CHAR	1	0	Scheduling Procedure
147	SUBMI_RELEVANT	WRF_SUBMI_RELEVANT	XFELD	CHAR	1	0	Cross Docking: Relevant for Collective Numbering
148	LFAS	VMDS_LFAS_T		TTYP	0	0
149	LFAT	VMDS_LFAT_T		TTYP	0	0
150	LFBK	VMDS_LFBK_T		TTYP	0	0
151	LFA1_TEXT	VMDS_LFA1_TEXT_T		TTYP	0	0
152	IBAN	CVIS_IBAN_T		TTYP	0	0
153	KNVK	VMDS_KNVK_T		TTYP	0	0
154	WYT1	VMDS_WYT1_T		TTYP	0	0
155	WYT1T	VMDS_WYT1T_T		TTYP	0	0
156	.INCLUDE				0	0	Tables for Company Code Data Compl. Structure Vendor
157	LFB1	VMDS_LFB1_T		TTYP	0	0
158	LFB5	VMDS_LFB5_T		TTYP	0	0
159	LFBW	VMDS_LFBW_T		TTYP	0	0
160	LFB1_TEXT	VMDS_LFB1_TEXT_T		TTYP	0	0
161	.INCLUDE				0	0	Complex Internal Structure for Purchasing Org. Data Vendor
162	LFM1	VMDS_LFM1_T		TTYP	0	0
163	WYT3	VMDS_WYT3_T		TTYP	0	0
164	LFM1_TEXT	VMDS_LFM1_TEXT_T		TTYP	0	0
165	LFM2	VMDS_LFM2_T		TTYP	0	0
166	.INCLUDE				0	0	Complex Structure Address Type 1 Data
167	T1_ADRC	ADRC_TAB		TTYP	0	0
168	.INCLUDE				0	0	Complex Structure Address Type 1-Data Communication Data
169	T1_ADR2	ADR2_TAB		TTYP	0	0
170	T1_ADR3	ADR3_TAB		TTYP	0	0
171	T1_ADR4	ADR4_TAB		TTYP	0	0
172	T1_ADR5	ADR5_TAB		TTYP	0	0
173	T1_ADR6	ADR6_TAB		TTYP	0	0
174	T1_ADR7	ADR7_TAB		TTYP	0	0
175	T1_ADR8	ADR8_TAB		TTYP	0	0
176	T1_ADR9	ADR9_TAB		TTYP	0	0
177	T1_ADR10	ADR10_TAB		TTYP	0	0
178	T1_ADR11	ADR11_TAB		TTYP	0	0
179	T1_ADR12	ADR12_TAB		TTYP	0	0
180	T1_ADR13	ADR13_TAB		TTYP	0	0
181	T1_ADRCT	ADRCT_TAB		TTYP	0	0
182	T1_ADRT	ADRT_TAB		TTYP	0	0
183	.INCLUDE				0	0	Complex Structure Address Data Type 2
184	T2_ADRC	ADRC_TAB		TTYP	0	0
185	T2_ADRP	ADRP_TAB		TTYP	0	0
186	.INCLUDE				0	0	Complex Structure Address Type 2-Data Communication Data
187	T2_ADR2	ADR2_TAB		TTYP	0	0
188	T2_ADR3	ADR3_TAB		TTYP	0	0
189	T2_ADR4	ADR4_TAB		TTYP	0	0
190	T2_ADR5	ADR5_TAB		TTYP	0	0
191	T2_ADR6	ADR6_TAB		TTYP	0	0
192	T2_ADR7	ADR7_TAB		TTYP	0	0
193	T2_ADR8	ADR8_TAB		TTYP	0	0
194	T2_ADR9	ADR9_TAB		TTYP	0	0
195	T2_ADR10	ADR10_TAB		TTYP	0	0
196	T2_ADR11	ADR11_TAB		TTYP	0	0
197	T2_ADR12	ADR12_TAB		TTYP	0	0
198	T2_ADR13	ADR13_TAB		TTYP	0	0
199	T2_ADRCT	ADRCT_TAB		TTYP	0	0
200	T2_ADRT	ADRT_TAB		TTYP	0	0
201	.INCLUDE				0	0	Complex Structure Address Data Type 3
202	T3_ADCP	ADCP_TAB		TTYP	0	0
203	T3_ADRP	ADRP_TAB		TTYP	0	0
204	T3_ADRC	ADRC_TAB		TTYP	0	0
205	.INCLUDE				0	0	Complex Structure Address Type 2-Data Communication Data
206	T3_ADR2	ADR2_TAB		TTYP	0	0
207	T3_ADR3	ADR3_TAB		TTYP	0	0
208	T3_ADR4	ADR4_TAB		TTYP	0	0
209	T3_ADR5	ADR5_TAB		TTYP	0	0
210	T3_ADR6	ADR6_TAB		TTYP	0	0
211	T3_ADR7	ADR7_TAB		TTYP	0	0
212	T3_ADR8	ADR8_TAB		TTYP	0	0
213	T3_ADR9	ADR9_TAB		TTYP	0	0
214	T3_ADR10	ADR10_TAB		TTYP	0	0
215	T3_ADR11	ADR11_TAB		TTYP	0	0
216	T3_ADR12	ADR12_TAB		TTYP	0	0
217	T3_ADR13	ADR13_TAB		TTYP	0	0
218	T3_ADRT	ADRT_TAB		TTYP	0	0