EQUI_ADDR SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from EQUI_ADDR
Related tables to EQUI_ADDR
Access table EQUI_ADDR




Table View field list including key, data, relationships and ABAP select examples

EQUI_ADDR is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The EQUI_ADDR table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include EQUNR (Equipment Number), ADDRNUMBER (Address number), NAME1 (Name 1), NAME2 (Name 2).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP EQUI_ADDR table view fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3T000MANDT
EQUNREquipment Number EQUNRCHAR18EQUIALPHAEQUNREQNEQUI
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
NAME1Name 1 AD_NAME1CHAR40TEXT40
NAME2Name 2 AD_NAME2CHAR40TEXT40
NAME_TEXTConverted name field (with form of address) AD_NAMETXTCHAR50TEXT50
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
ADDR_GROUPAddress Group (Key) (Business Address Services) AD_GROUPCHAR4TSAD7AD_GROUP
SORT1Search Term 1 AD_SORT1CHAR20CHAR20
SORT2Search Term 2 AD_SORT2CHAR20CHAR20
MC_NAME1Name (field NAME1) in upper case for matchcode AD_MC_NAMECHAR25CHAR25
MC_CITY1City name in upper case for search help AD_MC_CITYCHAR25CHAR25
MC_STREETStreet name in upper case for search help AD_MC_STRTCHAR25CHAR25
ABCKZABC indicator for technical object ABCKZCHAR1T370CABCKZ
EQFNRSort field EQFNRCHAR30CHAR30
SWERKMaintenance plant SWERKCHAR4T001WWERKSSWK
STORTLocation of maintenance object PMLOCCHAR10T499SAP_STAND
MSGRPRoom RAUMNRCHAR8CHAR8
BEBERPlant section BEBERCHAR3T357BEBERBBE
KOSTLCost Center KOSTLCHAR10ALPHAKOSTLKOS
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
ANLNRMain Asset Number ANLN1CHAR12ANLHALPHAANLN1AN1
ANLUNAsset Subnumber ANLN2CHAR4ANLAALPHAANLN2AN2
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVKOVVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TVTASPARTSPAC_SPART
OWNERObject reference indicator ILOM_OWNERCHAR1ILOM_OWNER
DATBIValid To Date DATBIDATS8DATUM
IWERKMaintenance Planning Plant IWERKCHAR4T399IWERKSIWK
INGRPPlanner Group for Customer Service and Plant Maintenance INGRPCHAR3T024IINGRPIHG
KUND1Customer number KUND1CHAR10KNA1ALPHAKUNNR
KUND2End customer number KUND2CHAR10KNA1ALPHAKUNNR
KUND3Operator KUND3CHAR10KNA1ALPHAKUNNR
SPRASLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
EQKTXDescription of technical object KTX01CHAR40TEXT40
TXASPPrimary language indicator for text segment KZMLACHAR1CHAR1
EQKTUEquipment description in capital letters EQKTUCHAR40CHAR40

Key field Non-key field



How do I retrieve data from SAP table EQUI_ADDR using ABAP code

The following ABAP code Example will allow you to do a basic selection on EQUI_ADDR to SELECT all data from the table
DATA: WA_EQUI_ADDR TYPE EQUI_ADDR.

SELECT SINGLE *
FROM EQUI_ADDR
INTO CORRESPONDING FIELDS OF WA_EQUI_ADDR
WHERE...

How to access SAP table EQUI_ADDR

Within an ECC or HANA version of SAP you can also view further information about EQUI_ADDR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!