SAP ABAP Table BETR (Plants)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     WLIF (Package) IS-R: Vendor master
Basic Data
Table Category INTTAB    Structure 
Structure BETR   Table Relationship Diagram
Short Description Plants    
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   General Data in Customer Master  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number *
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 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
8 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
9 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
10 SORTL SORTL CHAR10 CHAR 10   0   Sort field  
11 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
12 TELF1 TELF1 TEXT16 CHAR 16   0   First telephone number  
13 TELFX TELFX TEXT31 CHAR 31   0   Fax Number  
14 XCPDK XCPDK XFELD CHAR 1   0   Indicator: Is the account a one-time account?  
15 ADRNR ADRNR ADRNR CHAR 10   0   Address *
16 MCOD1 MCDD1 CHAR25 CHAR 25   0   Search term for matchcode search  
17 MCOD2 MCDD2 CHAR25 CHAR 25   0   Search Term for Matchcode Search  
18 MCOD3 MCDD3 CHAR25 CHAR 25   0   Search term for matchcode search  
19 .INCLUDE       0   0   General Data in Customer Master  
20 ANRED ANRED TEXT15 CHAR 15   0   Title  
21 AUFSD AUFSD_X KAUFS CHAR 2   0   Central order block for customer TVAST
22 BAHNE BAHNE BAHNH CHAR 25   0   Express train station  
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 ERDAT ERDAT_RF DATUM DATS 8   0   Date on which the Record Was Created  
31 ERNAM ERNAM_RF USNAM CHAR 12   0   Name of Person who Created the Object  
32 EXABL EXABL XFELD CHAR 1   0   Indicator: Unloading points exist  
33 FAKSD FAKSD_X FAKSP CHAR 2   0   Central billing block for customer TVFS
34 FISKN FISKN_D KUNNR CHAR 10   0   Account number of the master record with the fiscal address KNA1
35 KNAZK KNAZK WFCID CHAR 2   0   Working Time Calendar TFACD
36 KNRZA KNRZA KUNNR CHAR 10   0   Account number of an alternative payer KNA1
37 KONZS KONZS KONZS CHAR 10   0   Group key  
38 KTOKD KTOKD KTOKD CHAR 4   0   Customer Account Group T077D
39 KUKLA KUKLA KUKLA CHAR 2   0   Customer classification TKUKL
40 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
41 LIFSD LIFSD_X LIFSP CHAR 2   0   Central delivery block for the customer TVLS
42 LOCCO LOCCO LOCCO CHAR 10   0   City Coordinates  
43 LOEVM LOEVM_X XFELD CHAR 1   0   Central Deletion Flag for Master Record  
44 NAME3 NAME3_GP NAME CHAR 35   0   Name 3  
45 NAME4 NAME4_GP NAME CHAR 35   0   Name 4  
46 NIELS NIELS NIELS CHAR 2   0   Nielsen ID TNLS
47 ORT02 ORT02_GP TEXT35 CHAR 35   0   District  
48 PFACH PFACH PFACH CHAR 10   0   PO Box  
49 PSTL2 PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
50 COUNC COUNC COUNC CHAR 3   0   County Code T005E
51 CITYC CITYC CITYC CHAR 4   0   City Code T005G
52 RPMKR RPMKR RPMKR CHAR 5   0   Regional market  
53 SPERR SPERB_X XFELD CHAR 1   0   Central posting block  
54 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
55 STCD1 STCD1 STCD1 CHAR 16   0   Tax Number 1  
56 STCD2 STCD2 STCD2 CHAR 11   0   Tax Number 2  
57 STKZA STKZA STKZA CHAR 1   0   Indicator: Business Partner Subject to Equalization Tax?  
58 STKZU STKZU XFELD CHAR 1   0   Liable for VAT  
59 TELBX TELBX TEXT15 CHAR 15   0   Telebox number  
60 TELF2 TELF2 TEXT16 CHAR 16   0   Second telephone number  
61 TELTX TELTX TEXT30 CHAR 30   0   Teletex number  
62 TELX1 TELX1 TEXT30 CHAR 30   0   Telex number  
63 LZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
64 XZEMP XREGU XFELD CHAR 1   0   Indicator: Is an alternative payer allowed in document?  
65 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner T880
66 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
67 DEAR1 DEAR1 XFELD CHAR 1   0   Indicator: Competitor  
68 DEAR2 DEAR2 XFELD CHAR 1   0   Indicator: Sales partner  
69 DEAR3 DEAR3 DEAR3 CHAR 1   0   Indicator: Sales prospect  
70 DEAR4 DEAR4 XFELD CHAR 1   0   Indicator for customer type 4  
71 DEAR5 DEAR5 XFELD CHAR 1   0   ID for default sold-to party  
72 GFORM GFORM GFORM CHAR 2   0   Legal status TVGF
73 BRAN1 BRAN1_D BRACO CHAR 10   0   Industry code 1 TBRC
74 BRAN2 BRAN2 BRACO CHAR 10   0   Industry code 2 TBRC
75 BRAN3 BRAN3 BRACO CHAR 10   0   Industry code 3 TBRC
76 BRAN4 BRAN4 BRACO CHAR 10   0   Industry code 4 TBRC
77 BRAN5 BRAN5 BRACO CHAR 10   0   Industry code 5 TBRC
78 EKONT EKONT VBELN CHAR 10   0   Initial contact VBUK
79 UMSAT UMSAT UMSAT CURR 8   2   Annual sales  
80 UMJAH UMJAH JAHR NUMC 4   0   Year For Which Sales are Given  
81 UWAER UWAER WAERS CUKY 5   0   Currency of Sales Volume TCURC
82 JMZAH JMZAH JMZAH NUMC 6   0   Yearly number of employees  
83 JMJAH JMJAH JAHR NUMC 4   0   Year for which the number of employees is given  
84 KATR1 KATR1 ATTR1 CHAR 2   0   Attribute 1 TVK1
85 KATR2 KATR2 ATTR2 CHAR 2   0   Attribute 2 TVK2
86 KATR3 KATR3 ATTR3 CHAR 2   0   Attribute 3 TVK3
87 KATR4 KATR4 ATTR4 CHAR 2   0   Attribute 4 TVK4
88 KATR5 KATR5 ATTR5 CHAR 2   0   Attribute 5 TVK5
89 KATR6 KATR6 ATTR6 CHAR 3   0   Attribute 6 TVK6
90 KATR7 KATR7 ATTR7 CHAR 3   0   Attribute 7 TVK7
91 KATR8 KATR8 ATTR8 CHAR 3   0   Attribute 8 TVK8
92 KATR9 KATR9 ATTR9 CHAR 3   0   Attribute 9 TVK9
93 KATR10 KATR10 ATTR10 CHAR 3   0   Attribute 10 TVK0
94 STKZN STKZN STKZN CHAR 1   0   Natural Person  
95 UMSA1 UMSA1 UMSA1 CURR 15   2   Annual sales  
96 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
97 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant T009
98 ABRVW ABRVW ABRVW CHAR 3   0   Usage Indicator TVLV
99 INSPBYDEBI QINSPBYDEB QKZ CHAR 1   0   Inspection Carried Out By Customer (No Inspection Lot)  
100 INSPATDEBI QINSPATDEB QKZ CHAR 1   0   Inspection for a Delivery Note After Outbound Delivery  
101 KTOCD KTOCD KTOKD CHAR 4   0   Reference Account Group for One-Time Account (Customer) T077D
102 PFORT PFORT_GP TEXT35 CHAR 35   0   PO Box city  
103 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
104 DTAMS DTAMS DTAMS CHAR 1   0   Report key for data medium exchange  
105 DTAWS DTAWS DTAWS CHAR 2   0   Instruction key for data medium exchange *
106 DUEFL DUEFL_BKPF DUEFL_BKPF CHAR 1   0   Status of Data Transfer into Subsequent Release  
107 HZUOR HZUOR HZUOR NUMC 2   0   Assignment to Hierarchy  
108 SPERZ SPERZ XFELD CHAR 1   0   Payment Block  
109 ETIKG ETIKG ETIKG CHAR 10   0   IS-R Labeling: customer/plant group TWEK
110 CIVVE CIVVE XFELD CHAR 1   0   ID for mainly non-military use  
111 MILVE MILVE XFELD CHAR 1   0   ID for mainly military use  
112 KDKG1 KDKG1 KDKGR CHAR 2   0   Customer condition group 1 TVKGG
113 KDKG2 KDKG2 KDKGR CHAR 2   0   Customer condition group 2 TVKGG
114 KDKG3 KDKG3 KDKGR CHAR 2   0   Customer condition group 3 TVKGG
115 KDKG4 KDKG4 KDKGR CHAR 2   0   Customer condition group 4 TVKGG
116 KDKG5 KDKG5 KDKGR CHAR 2   0   Customer condition group 5 TVKGG
117 XKNZA XKNZA XFELD CHAR 1   0   Indicator: Alternative payer using account number  
118 FITYP J_1AFITP_D J_1AFITP CHAR 2   0   Tax type J_1AFITP
119 STCDT J_1ATOID J_1ATOID CHAR 2   0   Tax Number Type J_1ATODC
120 STCD3 STCD3 CHAR18 CHAR 18   0   Tax Number 3  
121 STCD4 STCD4 CHAR18 CHAR 18   0   Tax Number 4  
122 STCD5 STCD5 CHAR60 CHAR 60   0   Tax Number 5  
123 XICMS J_1BTCICMS XFELD CHAR 1   0   Customer is ICMS-exempt  
124 XXIPI J_1BTCIPI XFELD CHAR 1   0   Customer is IPI-exempt  
125 XSUBT J_1BTCST J_1BTCST1 CHAR 3   0   Customer group for Substituiçao Tributária calculation J_1BTXSTG
126 CFOPC J_1BINDUS1 J_1BINDUS1 CHAR 2   0   Customer's CFOP category  
127 TXLW1 J_1BTAXLW1 J_1BTAXLW1 CHAR 3   0   Tax law: ICMS J_1BATL1
128 TXLW2 J_1BTAXLW2 J_1BTAXLW2 CHAR 3   0   Tax law: IPI J_1BATL2
129 CCC01 CCC01 XFELD CHAR 1   0   Indicator for biochemical warfare for legal control  
130 CCC02 CCC02 XFELD CHAR 1   0   Indicator for nuclear nonproliferation for legal control  
131 CCC03 CCC03 XFELD CHAR 1   0   Indicator for national security for legal control  
132 CCC04 CCC04 XFELD CHAR 1   0   Indicator for missile technology for legal control  
133 CASSD CASSD_X CASSP CHAR 2   0   Central sales block for customer  
134 KNURL URL TEXT132 CHAR 132   0   Uniform resource locator  
135 J_1KFREPRE REPRES REPRES CHAR 10   0   Name of Representative  
136 J_1KFTBUS GESTYP GESTYP CHAR 30   0   Type of Business BUSTYPE
137 J_1KFTIND INDTYP INDTYP CHAR 30   0   Type of Industry INDUSTYPE
138 CONFS CONFS_X CHAR1 CHAR 1   0   Status of Change Authorization (Central)  
139 UPDAT UPDAT_RF DATUM DATS 8   0   Date on Which the Changes Were Confirmed  
140 UPTIM UPTIM_RF AS4TIME TIMS 6   0   Time of Last Change Confirmation  
141 NODEL NODEL_X XFELD CHAR 1   0   Central deletion block for master record  
142 DEAR6 DEAR6 XFELD CHAR 1   0   Indicator: Consumer  
143 .INCLUDE       0   0   Customer Master Data - Brazil  
144 SUFRAMA J_1BSUFRAMA J_1BSUFRAMA CHAR 9   0   Suframa Code  
145 RG J_1BRG J_1BRG CHAR 11   0   RG Number  
146 EXP J_1BEXP J_1BEXP CHAR 3   0   Issued by  
147 UF J_1BUF J_1BUF CHAR 2   0   State  
148 RGDATE J_1BRGDATE DATUM DATS 8   0   RG Issue Date  
149 RIC J_1BRIC J_1BRIC NUMC 11   0   RIC Number  
150 RNE J_1BRNE J_1BRNE CHAR 10   0   Foreign National Registration  
151 RNEDATE J_1BRNEDATE DATUM DATS 8   0   RNE Issue Date  
152 CNAE J_1BCNAE J_1BCNAE CHAR 7   0   CNAE J_1BTCNAE
153 LEGALNAT J_1BLEGALNAT J_1BLEGALNAT NUMC 4   0   Legal Nature J_1BTLEGALNAT
154 CRTN J_1BCRTN J_1BCRTN CHAR 1   0   CRT Number  
155 ICMSTAXPAY J_1BICMSTAXPAY J_1BICMSTAXPAY CHAR 2   0   ICMS Taxpayer J_1BTICMSTAXPAY
156 INDTYP J_1BINDTYP J_1BINDTYP CHAR 2   0   Industry Main Type J_1BTINDTYP
157 TDT J_1BTDT J_1BTDT CHAR 2   0   Tax Declaration Type J_1BTTDT
158 COMSIZE J_1BCOMSIZE J_1BCOMSIZE CHAR 2   0   Company Size J_1BTCOMSIZE
159 DECREGPC J_1BDECREGPC J_1BDECREGPC CHAR 2   0   Declaration Regimen for PIS/COFINS J_1BTDECREGPC
160 .INCLU--AP       0   0   Append to KNA1 for Vehicle Space Optimization  
161 .INCLUDE       0   0   Additional Data for Vehicle Space Optimization for KNA1  
162 /VSO/R_PALHGT /VSO/R_PAL_BIN_HGT MENG13 QUAN 13   3   Maximum Stacking Height of the Packaging Material (VSO)  
163 /VSO/R_PAL_UL /VSO/R_PAL_UNIT_L MEINS UNIT 3   0   Unit of Length for Packaging Material (VSO) T006
164 /VSO/R_PK_MAT /VSO/M_PACK_BY_MAT /VSO/M_XFIELD CHAR 1   0   Customer-Related Packing for Each Packaging Material (VSO)  
165 /VSO/R_MATPAL /VSO/M_MATNR_PAL MATNR CHAR 18   0   Packaging Material of the Customer in VSO MARA
166 /VSO/R_I_NO_LYR /VSO/M_IPAL_NO_LYR /VSO/M_IPAL_NO_LYR NUMC 2   0   Number Layers Under an Inter-Pallet (VSO)  
167 /VSO/R_ONE_MAT /VSO/M_ONE_MAT /VSO/M_XFIELD CHAR 1   0   Packing Material-Specific for Each Packaging Material  
168 /VSO/R_ONE_SORT /VSO/M_ONE_SORT /VSO/M_XFIELD CHAR 1   0   Pack Only One Package Type for Each PKM (VSO)  
169 /VSO/R_ULD_SIDE /VSO/M_UNLOAD_SIDE_PREF /VSO/M_SIDE_PREF NUMC 1   0   Side Preference of Loading/Unloading (VSO)  
170 /VSO/R_LOAD_PREF /VSO/M_LOAD_PREF /VSO/M_LOAD_PREF NUMC 1   0   Front/Back Preference of Loading/Unloading (VSO)  
171 /VSO/R_DPOINT /VSO/R_DELIVERYPOINT /VSO/R_DELIVERYPOINT CHAR 10   0   Collective Unloading Point for VSO /VSO/R_DPOINT
172 .INCLU--AP       0   0   US Federal Government Customer Master Data Additional Fields  
173 ALC FMFG_ALC FMFG_ALC CHAR 8   0   Agency Location Code FMFGT_ALC
174 PMT_OFFICE FMFG_PMT_OFF FMFG_PMT_OFF CHAR 5   0   Payment Office FMFGT_PO
175 .INCLUDE       0   0    
176 .INCLU--AP       0   0   Local Authority Additional Fields  
177 PSOFG PSOFG PSOFG CHAR 10   0   Processor group PSO19
178 PSOIS PSOIS CHAR20 CHAR 20   0   Subledger acct preprocessing procedure  
179 .INCLUDE       0   0   Local Authority Additional Fields (Address)  
180 PSON1 NAME1_GP NAME CHAR 35   0   Name 1  
181 PSON2 NAME2_GP NAME CHAR 35   0   Name 2  
182 PSON3 NAME3_GP NAME CHAR 35   0   Name 3  
183 PSOVN PSOVN NAME CHAR 35   0   First Name  
184 PSOTL PSOTL FMPSOTL CHAR 20   0   Title  
185 PSOHS PSOHS CHAR06 CHAR 6   0   House number: is no longer used from Release 4.6B  
186 PSOST PSOST PSOST CHAR 28   0   Street: No longer used from Release 4.6B  
187 .INCLUDE       0   0   Description (Customer/Vendor Supplement)  
188 PSOO1 PSOO1 TEXT50 CHAR 50   0   Description  
189 PSOO2 PSOO1 TEXT50 CHAR 50   0   Description  
190 PSOO3 PSOO1 TEXT50 CHAR 50   0   Description  
191 PSOO4 PSOO1 TEXT50 CHAR 50   0   Description  
192 PSOO5 PSOO1 TEXT50 CHAR 50   0   Description  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 BETR /VSO/R_DPOINT /VSO/R_DPOINT /VSO/R_DPOINT    
2 BETR /VSO/R_MATPAL MARA MATNR    
3 BETR /VSO/R_PAL_UL T006 MSEHI    
4 BETR ABRVW TVLV ABRVW    
5 BETR ALC FMFGT_ALC ALC    
6 BETR AUFSD TVAST AUFSP    
7 BETR BRAN1 TBRC BRACO    
8 BETR BRAN2 TBRC BRACO    
9 BETR BRAN3 TBRC BRACO    
10 BETR BRAN4 TBRC BRACO    
11 BETR BRAN5 TBRC BRACO    
12 BETR BRSCH T016 BRSCH    
13 BETR CITYC T005G CITYC    
14 BETR CNAE J_1BTCNAE J_1BCNAE KEY    
15 BETR COMSIZE J_1BTCOMSIZE J_1BCOMSIZE KEY    
16 BETR COUNC T005E COUNC    
17 BETR DECREGPC J_1BTDECREGPC J_1BDECREGPC KEY    
18 BETR EKONT VBUK VBELN    
19 BETR ETIKG TWEK KUNGR REF 1 CN
20 BETR FAKSD TVFS FAKSP    
21 BETR FISKN KNA1 KUNNR    
22 BETR FITYP J_1AFITP J_1AFITP 1 CN
23 BETR GFORM TVGF GFORM    
24 BETR ICMSTAXPAY J_1BTICMSTAXPAY J_1BICMSTAXPAY KEY    
25 BETR INDTYP J_1BTINDTYP J_1BINDTYP KEY    
26 BETR J_1KFTBUS BUSTYPE GESTYP REF C CN
27 BETR J_1KFTIND INDUSTYPE INDTYPE REF C CN
28 BETR KATR1 TVK1 KATR1    
29 BETR KATR10 TVK0 KATR10    
30 BETR KATR2 TVK2 KATR2    
31 BETR KATR3 TVK3 KATR3    
32 BETR KATR4 TVK4 KATR4    
33 BETR KATR5 TVK5 KATR5    
34 BETR KATR6 TVK6 KATR6    
35 BETR KATR7 TVK7 KATR7    
36 BETR KATR8 TVK8 KATR8    
37 BETR KATR9 TVK9 KATR9    
38 BETR KDKG1 TVKGG KDKGR REF 1 CN
39 BETR KDKG2 TVKGG KDKGR REF 1 CN
40 BETR KDKG3 TVKGG KDKGR REF 1 CN
41 BETR KDKG4 TVKGG KDKGR REF 1 CN
42 BETR KDKG5 TVKGG KDKGR REF 1 CN
43 BETR KNAZK TFACD IDENT    
44 BETR KNRZA KNA1 KUNNR    
45 BETR KTOCD T077D KTOKD    
46 BETR KTOKD T077D KTOKD    
47 BETR KUKLA TKUKL KUKLA    
48 BETR LAND1 T005 LAND1    
49 BETR LEGALNAT J_1BTLEGALNAT J_1BLEGALNAT KEY    
50 BETR LIFNR LFA1 LIFNR    
51 BETR LIFSD TVLS LIFSP    
52 BETR LZONE TZONE ZONE1    
53 BETR MANDT T000 MANDT    
54 BETR NIELS TNLS NIELS    
55 BETR PERIV T009 PERIV    
56 BETR PMT_OFFICE FMFGT_PO PMT_OFFICE    
57 BETR PSOFG PSO19 PSOFG 1 CN
58 BETR REGIO T005S BLAND    
59 BETR SPRAS T002 SPRAS    
60 BETR STCDT J_1ATODC J_1ATODC 1 CN
61 BETR TDT J_1BTTDT J_1BTDT KEY    
62 BETR TXJCD TTXJ TXJCD    
63 BETR TXLW1 J_1BATL1 TAXLAW 1 CN
64 BETR TXLW2 J_1BATL2 TAXLAW 1 CN
65 BETR UWAER TCURC WAERS    
66 BETR VBUND T880 RCOMP    
67 BETR WERKS T001W WERKS    
68 BETR XSUBT J_1BTXSTG STGRP 1 CN
History
Last changed by/on SAP  20131127 
SAP Release Created in 470