SAP ABAP Table EQUI_ADDR (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure EQUI_ADDR   Table Relationship Diagram
Short Description Generated Table for View    
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 CLIENT MANDT MANDT CLNT 3   0   Client T000
2 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number EQUI
3 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number  
4 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
5 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
6 NAME_TEXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
7 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
8 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
9 STREET AD_STREET TEXT60 CHAR 60   0   Street  
10 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
11 ADDR_GROUP AD_GROUP AD_GROUP CHAR 4   0   Address Group (Key) (Business Address Services) TSAD7
12 SORT1 AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
13 SORT2 AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
14 MC_NAME1 AD_MC_NAME CHAR25 CHAR 25   0   Name (field NAME1) in upper case for matchcode  
15 MC_CITY1 AD_MC_CITY CHAR25 CHAR 25   0   City name in upper case for search help  
16 MC_STREET AD_MC_STRT CHAR25 CHAR 25   0   Street name in upper case for search help  
17 ABCKZ ABCKZ ABCKZ CHAR 1   0   ABC Indicator for Technical Object T370C
18 EQFNR EQFNR CHAR30 CHAR 30   0   Sort Field  
19 SWERK SWERK WERKS CHAR 4   0   Maintenance Plant T001W
20 STORT PMLOC AP_STAND CHAR 10   0   Location of maintenance object T499S
21 MSGRP RAUMNR CHAR8 CHAR 8   0   Room  
22 BEBER BEBER BEBER CHAR 3   0   Organizational Area T357
23 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center  
24 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
25 ANLNR ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
26 ANLUN ANLN2 ANLN2 CHAR 4   0   Asset Subnumber ANLA
27 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
28 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVKOV
29 SPART SPART SPART CHAR 2   0   Division TVTA
30 OWNER ILOM_OWNER ILOM_OWNER CHAR 1   0   Object reference indicator  
31 DATBI DATBI DATUM DATS 8   0   Valid To Date  
32 IWERK IWERK WERKS CHAR 4   0   Maintenance Planning Plant T399I
33 INGRP INGRP INGRP CHAR 3   0   Planner Group for Customer Service and Plant Maintenance T024I
34 KUND1 KUND1 KUNNR CHAR 10   0   Customer No. KNA1
35 KUND2 KUND2 KUNNR CHAR 10   0   End customer number KNA1
36 KUND3 KUND3 KUNNR CHAR 10   0   Operator KNA1
37 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
38 EQKTX KTX01 TEXT40 CHAR 40   0   Description of technical object  
39 TXASP KZMLA CHAR1 CHAR 1   0   Primary language indicator for text segment  
40 EQKTU EQKTU CHAR40 CHAR 40   0   Equipment description in capital letters  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 EQUI_ADDR ABCKZ T370C ABCKZ REF C CN
2 EQUI_ADDR ADDR_GROUP TSAD7 ADDR_GROUP REF C CN
3 EQUI_ADDR ANLNR ANLH ANLN1 REF C CN
4 EQUI_ADDR ANLUN ANLA ANLN2 REF C CN
5 EQUI_ADDR BEBER T357 BEBER REF C CN
6 EQUI_ADDR BUKRS T001 BUKRS REF C CN
7 EQUI_ADDR CLIENT T000 MANDT KEY 1 CN
8 EQUI_ADDR EQUNR EQUI EQUNR KEY 1 CN
9 EQUI_ADDR INGRP T024I INGRP REF C CN
10 EQUI_ADDR IWERK T399I IWERK    
11 EQUI_ADDR KUND1 KNA1 KUNNR KEY 1 CN
12 EQUI_ADDR KUND2 KNA1 KUNNR KEY 1 CN
13 EQUI_ADDR KUND3 KNA1 KUNNR KEY 1 CN
14 EQUI_ADDR SPART TVTA SPART REF 1 CN
15 EQUI_ADDR SPRAS T002 SPRAS KEY 1 CN
16 EQUI_ADDR STORT T499S STAND REF C CN
17 EQUI_ADDR SWERK T001W WERKS REF 1 CN
18 EQUI_ADDR VKORG TVKO VKORG REF 1 CN
19 EQUI_ADDR VTWEG TVKOV VTWEG REF 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in