SAP ABAP Table VMDS_EI_EXTRACT_CENTRAL_DATA (Tables for Central Data Compl. Structure Vendor)
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_CENTRAL_DATA   Table Relationship Diagram
Short Description Tables for Central Data Compl. Structure Vendor    
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 LFA1 LFA1   STRU 0   0    
2 MANDT MANDT MANDT CLNT 3   0   Client  
3 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor  
4 LAND1 LAND1_GP LAND1 CHAR 3   0   Country Key  
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)  
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  
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  
37 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number  
38 LNRZA LNRZA LIFNR CHAR 10   0   Account Number of the Alternative Payee  
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  
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  
56 FISKN FISKN_K LIFNR CHAR 10   0   Account number of the master record with fiscal address  
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  
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  
66 KTOCK KTOCK KTOKK CHAR 4   0   Reference Account Group for One-Time Account (Vendor)  
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  
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  
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  
77 LZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered  
78 XLFZA XLFZA XFELD CHAR 1   0   Indicator: Alternative payee using account number  
79 DLGRP DLGRP DLGRP CHAR 4   0   Service agent procedure group  
80 FITYP J_1AFITP_D J_1AFITP CHAR 2   0   Tax type  
81 STCDT J_1ATOID J_1ATOID CHAR 2   0   Tax Number Type  
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  
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  
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  
95 J_1KFTIND INDTYP INDTYP CHAR 30   0   Type of Industry  
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  
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  
117 LEGALNAT J_1BLEGALNAT J_1BLEGALNAT NUMC 4   0   Legal Nature  
118 CRTN J_1BCRTN J_1BCRTN CHAR 1   0   CRT Number  
119 ICMSTAXPAY J_1BICMSTAXPAY J_1BICMSTAXPAY CHAR 2   0   ICMS Taxpayer  
120 INDTYP J_1BINDTYP J_1BINDTYP CHAR 2   0   Industry Main Type  
121 TDT J_1BTDT J_1BTDT CHAR 2   0   Tax Declaration Type  
122 COMSIZE J_1BCOMSIZE J_1BCOMSIZE CHAR 2   0   Company Size  
123 DECREGPC J_1BDECREGPC J_1BDECREGPC CHAR 2   0   Declaration Regimen for PIS/COFINS  
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  
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  
129 PMT_OFFICE FMFG_PMT_OFF FMFG_PMT_OFF CHAR 5   0   Payment Office  
130 .INCLU--AP       0   0   Local Authority Additional Fields (Address)  
131 PSOFG PSOFG PSOFG CHAR 10   0   Processor group  
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  
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 LFAS VMDS_LFAS_T   TTYP 0   0    
148 LFAT VMDS_LFAT_T   TTYP 0   0    
149 LFBK VMDS_LFBK_T   TTYP 0   0    
150 LFA1_TEXT VMDS_LFA1_TEXT_T   TTYP 0   0    
151 IBAN CVIS_IBAN_T   TTYP 0   0    
152 KNVK VMDS_KNVK_T   TTYP 0   0    
153 WYT1 VMDS_WYT1_T   TTYP 0   0    
154 WYT1T VMDS_WYT1T_T   TTYP 0   0    
History
Last changed by/on SAP  20131127 
SAP Release Created in 600