SAP table EQUI_ADDR (Generated Table for View)

SAP table EQUI_ADDR has 40 primary key fields being CLIENT,EQUNR,ADDRNUMBER,NAME1,NAME2,NAME_TEXT,CITY1,POST_CODE1,STREET,HOUSE_NUM1,ADDR_GROUP,SORT1,SORT2,MC_NAME1,MC_CITY1,MC_STREET,ABCKZ,EQFNR,SWERK,STORT,MSGRP,BEBER,KOSTL,BUKRS,ANLNR,ANLUN,VKORG,VTWEG,SPART,OWNER,DATBI,IWERK,INGRP,KUND1,KUND2,KUND3,SPRAS,EQKTX,TXASP,EQKTU.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
ADDRNUMBER Address Number CHAR 10 0 AD_ADDRNUM
NAME1 Name 1 CHAR 40 0 AD_NAME1
NAME2 Name 2 CHAR 40 0 AD_NAME2
NAME_TEXT Converted name field (with form of address) CHAR 50 0 AD_NAMETXT
CITY1 City CHAR 40 0 AD_CITY1
POST_CODE1 City postal code CHAR 10 0 AD_PSTCD1
STREET Street CHAR 60 0 AD_STREET
HOUSE_NUM1 House Number CHAR 10 0 AD_HSNM1
ADDR_GROUP Address Group (Key) (Business Address Services) CHAR 4 0 TSAD7 AD_GROUP
SORT1 Search Term 1 CHAR 20 0 AD_SORT1
SORT2 Search Term 2 CHAR 20 0 AD_SORT2
MC_NAME1 Name (Field NAME1) in Uppercase for Search Help CHAR 25 0 AD_MC_NAME
MC_CITY1 City name in Uppercase for Search Help CHAR 25 0 AD_MC_CITY
MC_STREET Street Name in Uppercase for Search Help CHAR 25 0 AD_MC_STRT
ABCKZ ABC Indicator for Technical Object CHAR 1 0 T370C ABCKZ
EQFNR Sort Field CHAR 30 0 EQFNR
SWERK Maintenance Plant CHAR 4 0 T001W SWERK
STORT Location of maintenance object CHAR 10 0 T499S PMLOC
MSGRP Room CHAR 8 0 RAUMNR
BEBER Plant Section CHAR 3 0 T357 BEBER
KOSTL Cost Center CHAR 10 0 KOSTL
BUKRS Company Code CHAR 4 0 T001 BUKRS
ANLNR Main Asset Number CHAR 12 0 ANLH ANLN1
ANLUN Asset Subnumber CHAR 4 0 ANLA ANLN2
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
SPART Division CHAR 2 0 TVTA SPART
OWNER Object reference indicator CHAR 1 0 ILOM_OWNER
Equipment, current time segment
1 Equipment, historical time segment
2 Functional location
3 Maintenance item without object reference
4 Notification, current, without object reference
5 Notification, historical
6 Order, current, without object reference
7 Order, historical
DATBI Valid To Date DATS 8 0 DATBI
IWERK Maintenance Planning Plant CHAR 4 0 T399I IWERK
INGRP Planner Group for Customer Service and Plant Maintenance CHAR 3 0 T024I INGRP
KUND1 Customer number CHAR 10 0 KNA1 KUND1
KUND2 End customer number CHAR 10 0 KNA1 KUND2
KUND3 Operator CHAR 10 0 KNA1 KUND3
SPRAS Language Key LANG 1 0 T002 SPRAS
EQKTX Description of technical object CHAR 40 0 KTX01
TXASP Primary language indicator for text segment CHAR 1 0 KZMLA
EQKTU Equipment description in capital letters CHAR 40 0 EQKTU

EQUI_ADDR foreign key relationships

Table Field Check Table Check Field
0 EQUI_ADDR ABCKZ T370C ABC indicator for technical objects MANDT
1 EQUI_ADDR ADDR_GROUP TSAD7 Address Groups (Business Address Services) ADDR_GROUP
0 EQUI_ADDR ANLNR ANLH Main asset number BUKRS
0 EQUI_ADDR ANLNR ANLH Main asset number ANLN1
1 EQUI_ADDR ANLUN ANLA Asset Master Record Segment BUKRS
1 EQUI_ADDR ANLUN ANLA Asset Master Record Segment ANLN1
1 EQUI_ADDR ANLUN ANLA Asset Master Record Segment ANLN2
0 EQUI_ADDR BEBER T357 Plant Section MANDT
0 EQUI_ADDR BEBER T357 Plant Section BEBER
1 EQUI_ADDR BUKRS T001 Company Codes BUKRS
0 EQUI_ADDR CLIENT T000 Clients MANDT
1 EQUI_ADDR EQUNR EQUI Equipment master data MANDT
0 EQUI_ADDR INGRP T024I Maintenance planner groups INGRP
1 EQUI_ADDR IWERK T399I Planning plant parameters MANDT
0 EQUI_ADDR KUND1 KNA1 General Data in Customer Master MANDT
0 EQUI_ADDR KUND1 KNA1 General Data in Customer Master KUNNR
1 EQUI_ADDR KUND2 KNA1 General Data in Customer Master MANDT
1 EQUI_ADDR KUND2 KNA1 General Data in Customer Master KUNNR
0 EQUI_ADDR KUND3 KNA1 General Data in Customer Master MANDT
0 EQUI_ADDR KUND3 KNA1 General Data in Customer Master KUNNR
1 EQUI_ADDR SPART TVTA Organizational Unit: Sales Area(s) MANDT
1 EQUI_ADDR SPART TVTA Organizational Unit: Sales Area(s) VKORG
1 EQUI_ADDR SPART TVTA Organizational Unit: Sales Area(s) VTWEG
1 EQUI_ADDR SPART TVTA Organizational Unit: Sales Area(s) SPART
0 EQUI_ADDR SPRAS T002 Language Keys (Component BC-I18) SPRAS
1 EQUI_ADDR STORT T499S Location MANDT
1 EQUI_ADDR STORT T499S Location WERKS
0 EQUI_ADDR SWERK T001W Plants/Branches MANDT
0 EQUI_ADDR SWERK T001W Plants/Branches WERKS
1 EQUI_ADDR VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 EQUI_ADDR VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 EQUI_ADDR VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
0 EQUI_ADDR VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
0 EQUI_ADDR VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG