SAP ABAP Table SCUSTOMER_IDE (IDE: structure - customer data)
Hierarchy
IS-UT (Software Component) SAP Utilities/Telecommunication
   IS-U-IDE (Application Component) Intercompany Data Exchange
     EECC_EDI (Package) IS-U: Deregulation
Basic Data
Table Category INTTAB    Structure 
Structure SCUSTOMER_IDE   Table Relationship Diagram
Short Description IDE: structure - customer data    
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 NAME CHAR80 CHAR80 CHAR 80   0   Char 80  
2 .INCLUDE       0   0   CBP: General Data (Read Transfer Structure)  
3 .INCLUDE       0   0   CBP: Read general data plus standard address  
4 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number BUT000
5 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
6 .INCLUDE       0   0   BP: General Data I (Data Fields - External)  
7 .INCLUDE       0   0   CBP: General data (independent of partner cat.)  
8 .INCLUDE       0   0   CBP: General Data (not dep. on Part. Cat.), Initial Screen  
9 TYPE BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
10 BPKIND BU_BPKIND BU_KIND CHAR 4   0   Business Partner Type TB004
11 BU_GROUP BU_GROUP BU_GROUP CHAR 4   0   Business Partner Grouping TB001
12 BPEXT BU_BPEXT CHAR20 CHAR 20   0   Business Partner Number in External System  
13 .INCLUDE       0   0   CBP: General Data (not dep. on Part. Cat.), Data Screens  
14 BU_SORT1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
15 BU_SORT2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
16 SOURCE BU_SOURCE BU_SOURCE CHAR 4   0   Data Origin Types TB005
17 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
18 XDELE BU_XDELE XFELD CHAR 1   0   Central Archiving Flag  
19 XBLCK BU_XBLCK XFELD CHAR 1   0   Central Block for Business Partner  
20 AUGRP BU_AUGRP BU_AUGRP CHAR 4   0   Authorization Group *
21 TITLE_LET BU_TITLE_LET TEXT50 CHAR 50   0   Salutation  
22 BU_LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system TBDLS
23 CONTACT BU_CONTACT BU_CONTACT CHAR 1   0   Business Partner: Contact Permission  
24 NOT_RELEASED BU_XNOT_RELEASED XFELD CHAR 1   0   Indicator: Not Released  
25 NOT_LG_COMPETENT BU_NOT_LEG_COMPETENT BOOLE CHAR 1   0   Indicator: Not Legally Competent  
26 PRINT_MODE BU_PRINT_MODE BU_PRINT_MODE CHAR 1   0   Business Partner Print Format  
27 .INCLUDE       0   0   EEW Extension of BUT000 (Contains CI)  
28 BP_EEW_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
29 .INCLUDE       0   0    
30 .INCLU--AP       0   0   Cost/Revenue Type in Resource Role  
31 RATE DPR_TV_RATE DPR_RATE_TYPE CHAR 15   0   Cost Rate/Revenue Rate for Project Costing DPR_RATES
32 .INCLUDE       0   0   CBP: General data (Organization)  
33 .INCLUDE       0   0   CBP: General Data, Organization (CHAR Fields)  
34 NAME_ORG1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
35 NAME_ORG2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
36 NAME_ORG3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
37 NAME_ORG4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
38 LEGAL_ENTY BU_LEGENTY BU_LEGENTY CHAR 2   0   BP: Legal form of organization TB019
39 IND_SECTOR BU_INDSECT BU_INDSECT CHAR 10   0   Industry sector TB023
40 LEGAL_ORG BU_LEGAL_ORG BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization TB032
41 .INCLUDE       0   0   CBP: General Data, Organization (Non CHAR Fields)  
42 FOUND_DAT BU_FOUND_DAT DATUM DATS 8   0   Date organization founded  
43 LIQUID_DAT BU_LIQUID_DAT   DATS 8   0   Liquidation date of organization  
44 LOCATION_1 BBBNR NUM07 NUMC 7   0   International location number (part 1)  
45 LOCATION_2 BBSNR NUM05 NUMC 5   0   International location number (Part 2)  
46 LOCATION_3 BUBKZ NUM01 NUMC 1   0   Check digit for the international location number  
47 .INCLUDE       0   0   CBP: General Data, Person  
48 .INCLUDE       0   0   CBP: General Data, Person (CHAR Fields)  
49 NAME_LAST BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
50 NAME_FIRST BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
51 NAME_LST2 BU_NAMEPL2 BU_NAME CHAR 40   0   Other Last Name of a Person  
52 NAME_LAST2 BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
53 NAMEMIDDLE BU_NAMEMID BU_NAME CHAR 40   0   Middle name or second forename of a person  
54 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key TSAD2
55 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) TSAD2
56 TITLE_ROYL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) TSAD5
57 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) TSAD4
58 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) TSAD4
59 NAME1_TEXT BU_NAME1TX TEXT80 CHAR 80   0   Full Name  
60 NICKNAME BU_NICKNAM BU_NAME CHAR 40   0   Nickname of Business Partner (Person)  
61 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
62 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format T005N
63 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule T005
64 LANGU_CORR BU_LANGU_CORR SPRAS LANG 1   0   Business Partner: Correspondence Language T002
65 XSEXM BU_XSEXM XFELD CHAR 1   0   Selection: Business partner is male  
66 XSEXF BU_XSEXF XFELD CHAR 1   0   Selection: Business partner is female  
67 BIRTHPL BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
68 MARST BU_MARST BU_MARST CHAR 1   0   Marital Status of Business Partner TB027
69 EMPLO BU_EMPLO BU_EMPLO CHAR 35   0   Name of Employer of a Natural Person  
70 JOBGR BU_JOBGR BU_JOBGR CHAR 4   0   Occupation/group TB028
71 NATIO BU_NATIO LAND1 CHAR 3   0   Nationality T005
72 CNTAX BU_CNTAX LAND1 CHAR 3   0   Obsolete Field *
73 CNDSC BU_CNDSC LAND1 CHAR 3   0   Ctry of Origin: Non-Res. Companies T005
74 PERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
75 XSEXU BU_XSEXU XFELD CHAR 1   0   Selection: Sex of business partner is not known  
76 XUBNAME BU_XUBNAME XUBNAME CHAR 12   0   Obsolete Field USR02
77 BU_LANGU BU_LANGU SPRAS LANG 1   0   Business partner: Language T002
78 .INCLUDE       0   0   CBP: General Data, Person (Non CHAR Fields)  
79 BIRTHDT BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
80 DEATHDT BU_DEATHDT DATUM DATS 8   0   Date of death of business partner  
81 PERNO BU_PERNO PERSONID NUMC 8   0   Personnel Number  
82 CHILDREN BU_CHILDREN NUMC2 NUMC 2   0   Obsolete Field  
83 MEM_HOUSE BU_MEM_HOUSE DEC2 DEC 2   0   Obsolete Field  
84 .INCLUDE       0   0   CBP: General data (group of people)  
85 PARTGRPTYP BU_GRPTYP BU_GRPTYP CHAR 4   0   Group type TB025
86 NAME_GRP1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
87 NAME_GRP2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
88 .INCLUDE       0   0   BP: General data II  
89 .INCLUDE       0   0   BP: General Data II (CHAR Fields)  
90 LGTYP BU_LGTYP BU_LGTYP CHAR 4   0   Legitimation Type TB029
91 LGNUM BU_LGNUM BU_LGNUM CHAR 16   0   Identification number of legitimation document  
92 INFCT BU_INFCT BU_INFCT CHAR 30   0   Responsible local court  
93 COMRG BU_COMRG CHAR30 CHAR 30   0   Entry in commercial register  
94 CLBRG BU_CLBRG CHAR30 CHAR 30   0   BP: Entry in register of associations  
95 COPRG BU_COPRG CHAR30 CHAR 30   0   Entry in Register of Cooperatives  
96 .INCLUDE       0   0   BP: General Data II (Non CHAR Fields)  
97 COMREG_DAT BU_COMREG_DAT DATUM DATS 8   0   Date of entry in trade register  
98 .INCLUDE       0   0   CBP: Name fields combined (lower case)  
99 NAME1 BU_NAME1 BU_NAME CHAR 40   0   Name field 1 (name1/last name)  
100 NAME2 BU_NAME2 BU_NAME CHAR 40   0   Name field 2 (name2/first name)  
101 .INCLUDE       0   0   BP: Address Data (Read)  
102 .INCLUDE       0   0   Include structure with ADRC attributes without name fields  
103 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
104 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
105 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
106 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file ADRCITY
107 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file ADRCITYPRT
108 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
109 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file ADRCITY
110 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
111 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
112 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
113 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
114 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
115 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
116 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
117 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
118 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
119 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag TSAD12
120 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
121 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
122 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) ADRCITY
123 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
124 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
125 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
126 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
127 STREET AD_STREET TEXT60 CHAR 60   0   Street  
128 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag TSAD12
129 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File ADRSTREET
130 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
131 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
132 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
133 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
134 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
135 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
136 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
137 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
138 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
139 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
140 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
141 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
142 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
143 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
144 SORT1 AD_SORT1UL TEXT20 CHAR 20   0   Search Term 1  
145 SORT2 AD_SORT2UL TEXT20 CHAR 20   0   Search Term 2  
146 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
147 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key) TSAD6
148 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
149 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
150 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
151 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
152 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
153 REMARK AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
154 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language T002
155 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
156 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service ADDRC_DELI_SERV
157 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
158 COUNTY_CODE AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county ADRCOUNTY
159 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
160 TOWNSHIP_CODE AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township ADRTOWNSHIP
161 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
162 DEFLT_COMM AD_DFLTCMM AD_COMTYPE CHAR 3   0   Standard communication type TSADC
163 TEL_NUMBER AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
164 TEL_EXTENS AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
165 FAX_NUMBER AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
166 FAX_EXTENS AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
167 VALID_FROM BU_VALID_FROM_DATS DATUM DATS 8   0   Valid From  
168 VALID_TO BU_VALID_TO_DATS DATUM DATS 8   0   Valid To  
169 .INCLUDE       0   0   BP: Tax Numbers: General Data  
170 NATPERS BU_NATURAL_PERSON BU_NATURAL_PERSON CHAR 1   0   Business Partner Is a Natural Person Under the Tax Laws  
171 .INCLUDE       0   0   IS-U-Specific Fields for Business Partner  
172 WAKLASS WAKLASS E_WAKLASS CHAR 4   0   Employee classification TE697
173 FIRMART FIRMART FIRMART CHAR 2   0   Type of installation company TE183
174 ARBFELD ARBFELD ARBFELD CHAR 2   0   Company work field TE185
175 MITGLIED MITGLIED MITGLIED CHAR 1   0   Membership of installer  
176 SPZULASS SPZULASS SPZULASS CHAR 20   0   Division license of installer  
177 ARTZULASS ARTZULASS ARTZULASS CHAR 2   0   Installer license type TE189
178 AUSWANZ AUSWANZ AUSWANZ NUMC 2   0   Number of identifications  
179 PLOMBENZ PLOMBENZ PLOMBENZ CHAR 10   0   Sealing pliers number  
180 FREMDEVU FREMDEVU EVU CHAR 3   0   Main utility company TE187
181 STATINS STATINS STATINS CHAR 2   0   Valid status of installer in supply area TE061
182 STATDATUM STATDATUM STATDATUM DATS 8   0   Date on which status of installer comes into effect  
183 ERSTZUL ERSTZUL ERSTZUL DATS 8   0   Date of initial license of installer  
184 WERKSTATT WERKSTATT WERKSTATT DATS 8   0   Date of workshop inspection  
185 VERLZUL VERLZUL VERLZUL DATS 8   0   Date of license renewal  
186 ENDEZUL ENDEZUL ENDEZUL DATS 8   0   Date until which license is renewed  
187 ANZEVU ANZEVU ANZEVU NUMC 2   0   Number of utility companies  
188 ANZFIL ANZFIL ANZFIL NUMC 2   0   Number of branches supported by an installionr company  
189 AUSW_INST AUSW_INST AUSW_INST CHAR 10   0   Identification number for installer license  
190 DR_LICENSE_LAND1 DR_LICENSE_LAND1 LAND1 CHAR 3   0   Country in which driver's license was acquired T005
191 DR_LICENSE_REGIO DR_LICENSE_REGIO REGIO CHAR 3   0   Region in which driver's license was acquired T005S
192 DR_LICENSE DR_LICENSE DR_LICENSE CHAR 20   0   Driver's license number  
193 SOC_SECURE E_SOC_SECU E_SOC_SECU CHAR 12   0   Social Insurance Number  
194 WELFARE WELFARE WELFARE CHAR 9   0   Welfare office  
195 PLACE_EMPL PLACE_EMPL CHAR40 CHAR 40   0   Work center  
196 KTOKLASSE KTOKLASSE KTOKLASSE CHAR 4   0   Account class KONTOKLASSE
197 BUPINFOREL BUPINFOREL BUPINFOREL CHAR 2   0   Information release for business partner data TEBUPINFOREL
198 CLERK_ID E_CLERK_ID E_CLERK_ID CHAR 8   0   Business partner-specific criteria for agent determination TECLERK_ID
199 RECPTYPE E_RECPTYPE E_RECPTYPE CHAR 1   0   Category for Alternate Payee  
200 PYMET E_PYMET_DON PYMET_KK CHAR 1   0   Payment method for donations/fund payments TFK042Z
201 EMBVT E_EMBVT_DON CHAR4 CHAR 4   0   Bank details ID for donations/fund payments  
202 HKONT E_HKONT_DON SAKNR CHAR 10   0   G/L accounts for donations/fund payments SKA1
203 CLASSIFICATION E_CLASSIFICATION CHAR4 CHAR 4   0   Classification of Business Partner TE181
204 VIP E_VIP KENNZX CHAR 1   0   Indicate Very Important Business Partner  
205 IDENT_INST IDENT_INST IDENT_INST CHAR 18   0   Identification Number for Installer License  
206 .INCLUDE       0   0    
207 MUSTER_KUN MUSTER_KUN KUNNR CHAR 10   0   Reference for creating a standard customer for bus. partner *
208 ADDRESS SADDRESS_IDE   STRU 0   0    
209 ADRESSKEY ADRESSKEY   CHAR 2   0   IDE: key- address usage  
210 ADDRLINES EADRLN   STRU 0   0    
211 LINE1 LINES LINES CHAR 80   0   Address line  
212 LINE2 LINES LINES CHAR 80   0   Address line  
213 LINE3 LINES LINES CHAR 80   0   Address line  
214 LINE4 LINES LINES CHAR 80   0   Address line  
215 LINE5 LINES LINES CHAR 80   0   Address line  
216 LINE6 LINES LINES CHAR 80   0   Address line  
217 ADDRDAT EADRDAT   STRU 0   0    
218 .INCLUDE       0   0   Address return structure  
219 .INCLUDE       0   0   Address selection parameter  
220 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number  
221 ADDRHANDLE AD_HANDLE TEXT140 CHAR 140   0   Handle for Creating Addresses/Persons (Bus. Addr. Services)  
222 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses  
223 DATE AD_DATE DATUM DATS 8   0   Date referred to  
224 .INCLUDE       0   0   Address transfer structure  
225 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
226 DATE_TO AD_DATE_TO DATUM DATS 8   0   Valid-to date in current Release only 99991231 possible  
227 .INCLUDE       0   0   Include structure with name attributes of the ADRC address  
228 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key  
229 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
230 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
231 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
232 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
233 NAME_TXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
234 .INCLUDE       0   0   Include structure with ADRC attributes without name fields  
235 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
236 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
237 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
238 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file  
239 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file  
240 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
241 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file  
242 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
243 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping  
244 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
245 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
246 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
247 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
248 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
249 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
250 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
251 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag  
252 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
253 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
254 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file)  
255 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...)  
256 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country  
257 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
258 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered  
259 STREET AD_STREET TEXT60 CHAR 60   0   Street  
260 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag  
261 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File  
262 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name  
263 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
264 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
265 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
266 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
267 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
268 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
269 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
270 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
271 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
272 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
273 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key  
274 LANGU SPRAS SPRAS LANG 1   0   Language Key  
275 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County)  
276 SORT1 AD_SORT1UL TEXT20 CHAR 20   0   Search Term 1  
277 SORT2 AD_SORT2UL TEXT20 CHAR 20   0   Search Term 2  
278 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
279 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key)  
280 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
281 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
282 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone  
283 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
284 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
285 REMARK AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
286 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language  
287 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
288 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service  
289 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
290 COUNTY_CODE AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county  
291 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
292 TOWNSHIP_CODE AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township  
293 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
294 DEFLT_COMM AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services)  
295 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
296 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
297 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
298 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
299 ADDR_GROUP AD_GROUP AD_GROUP CHAR 4   0   Address Group (Key) (Business Address Services)  
300 TXTLANGU_VBS SPRAS SPRAS LANG 1   0   Language Key  
301 LAGEVBSZUS LGZUSATZ LGZUSATZ CHAR 40   0   Additional Information on Location  
302 STR_ERG2_VBS AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
303 STR_ERG4_VBS AD_LCTN TEXT40 CHAR 40   0   Street 5  
304 HAUS_NUM2_VBS AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
305 FLOOR_VBS AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
306 ROOMNUMBER_VBS AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
307 STORTGP PMLOC AP_STAND CHAR 10   0   Location of maintenance object  
308 STORTGPTXT LAGETEXT TEXT40 CHAR 40   0   Text for location  
309 STORTGPZUS STORTZUS TEXT30 CHAR 30   0   Addition to device location  
310 TITLE_MEDI AD_TITLETX TEXT30 CHAR 30   0   Title text  
311 COUNTY COUNC COUNC CHAR 3   0   County Code  
312 SMTP_ADDR AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SCUSTOMER_IDE ADDRORIGIN TSAD6 ORIGIN REF C CN
2 SCUSTOMER_IDE ARBFELD TE185 ARBFELD    
3 SCUSTOMER_IDE ARTZULASS TE189 ARTZULASS    
4 SCUSTOMER_IDE BPKIND TB004 BPKIND REF 1 CN
5 SCUSTOMER_IDE BUPINFOREL TEBUPINFOREL INFOREL    
6 SCUSTOMER_IDE BU_GROUP TB001 BU_GROUP REF 1 CN
7 SCUSTOMER_IDE BU_LANGU T002 SPRAS REF 1 CN
8 SCUSTOMER_IDE BU_LOGSYS TBDLS LOGSYS 1 CN
9 SCUSTOMER_IDE CITYH_CODE ADRCITY CITY_CODE REF C CN
10 SCUSTOMER_IDE CITYP_CODE ADRCITYPRT CITYP_CODE REF C CN
11 SCUSTOMER_IDE CITY_CODE ADRCITY CITY_CODE REF C CN
12 SCUSTOMER_IDE CITY_CODE2 ADRCITY CITY_CODE REF C CN
13 SCUSTOMER_IDE CLASSIFICATION TE181 CLASSIFICATION    
14 SCUSTOMER_IDE CLERK_ID TECLERK_ID CLERK_ID    
15 SCUSTOMER_IDE CNDSC T005 LAND1 REF 1 CN
16 SCUSTOMER_IDE COUNTRY T005 LAND1    
17 SCUSTOMER_IDE COUNTY_CODE ADRCOUNTY COUNTY_CODE REF C CN
18 SCUSTOMER_IDE DEFLT_COMM TSADC COMINT REF C CN
19 SCUSTOMER_IDE DELI_SERV_TYPE ADDRC_DELI_SERV DELI_SERV_TYPE 1 CN
20 SCUSTOMER_IDE DONT_USE_P TSAD12 UNDELIVER KEY C CN
21 SCUSTOMER_IDE DONT_USE_S TSAD12 UNDELIVER KEY C CN
22 SCUSTOMER_IDE DR_LICENSE_LAND1 T005 LAND1    
23 SCUSTOMER_IDE DR_LICENSE_REGIO T005S BLAND    
24 SCUSTOMER_IDE FIRMART TE183 FIRMART    
25 SCUSTOMER_IDE FREMDEVU TE187 EVU    
26 SCUSTOMER_IDE HKONT SKA1 SAKNR    
27 SCUSTOMER_IDE IND_SECTOR TB023 IND_SECTOR REF 1 CN
28 SCUSTOMER_IDE JOBGR TB028 JOBGR REF 1 CN
29 SCUSTOMER_IDE KTOKLASSE KONTOKLASSE KTOKL    
30 SCUSTOMER_IDE LANGU T002 SPRAS KEY 1 CN
31 SCUSTOMER_IDE LANGU_CORR T002 SPRAS REF C CN
32 SCUSTOMER_IDE LANGU_CREA T002 SPRAS REF C CN
33 SCUSTOMER_IDE LEGAL_ENTY TB019 LEGAL_ENTY KEY 1 CN
34 SCUSTOMER_IDE LEGAL_ORG TB032 LEGAL_ORG REF 1 CN
35 SCUSTOMER_IDE LGTYP TB029 LGTYP    
36 SCUSTOMER_IDE MARST TB027 MARST 1 CN
37 SCUSTOMER_IDE NAMCOUNTRY T005 LAND1 REF C CN
38 SCUSTOMER_IDE NAMEFORMAT T005N NAMEFORMAT REF C CN
39 SCUSTOMER_IDE NATIO T005 LAND1 1 CN
40 SCUSTOMER_IDE PARTGRPTYP TB025 PARTGRPTYP KEY 1 CN
41 SCUSTOMER_IDE PARTNER BUT000 PARTNER KEY 1 C
42 SCUSTOMER_IDE PO_BOX_CTY T005 LAND1 REF C CN
43 SCUSTOMER_IDE PO_BOX_REG T005S BLAND REF C CN
44 SCUSTOMER_IDE PREFIX1 TSAD4 PREFIX_KEY KEY 1 CN
45 SCUSTOMER_IDE PREFIX2 TSAD4 PREFIX_KEY KEY 1 CN
46 SCUSTOMER_IDE PYMET TFK042Z ZLSCH    
47 SCUSTOMER_IDE RATE DPR_RATES RATE KEY    
48 SCUSTOMER_IDE REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
49 SCUSTOMER_IDE REGION T005S BLAND REF C CN
50 SCUSTOMER_IDE SOURCE TB005 SOURCE KEY 1 CN
51 SCUSTOMER_IDE STATINS TE061 STATINS    
52 SCUSTOMER_IDE STREETABBR ADRSTRTYPE STRTYPEAB REF C CN
53 SCUSTOMER_IDE STREETCODE ADRSTREET STRT_CODE REF C CN
54 SCUSTOMER_IDE TIME_ZONE TTZZ TZONE REF C CN
55 SCUSTOMER_IDE TITLE TSAD3 TITLE KEY 1 CN
56 SCUSTOMER_IDE TITLE_ACA1 TSAD2 TITLE_KEY KEY 1 CN
57 SCUSTOMER_IDE TITLE_ACA2 TSAD2 TITLE_KEY KEY 1 CN
58 SCUSTOMER_IDE TITLE_ROYL TSAD5 TITLE_KEY KEY 1 CN
59 SCUSTOMER_IDE TOWNSHIP_CODE ADRTOWNSHIP TOWNSHIP_CODE REF C CN
60 SCUSTOMER_IDE TRANSPZONE TZONE ZONE1 REF C CN
61 SCUSTOMER_IDE WAKLASS TE697 WAKLASS    
62 SCUSTOMER_IDE XUBNAME USR02 BNAME KEY 1 CN
History
Last changed by/on SAP  20141109 
SAP Release Created in 462