1. Home
  2. Resources
  3. SAP Tables
  4. EWAWA_DL_EVBS - DL EVBS

SAP Table EWAWA_DL_EVBS

DL EVBS

EWAWA_DL_EVBS (DL EVBS) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EWAWA_DL_EVBS to other SAP tables.

EWAWA_DL_EVBS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VSTELLE Premise VSTELLE CHAR 10 0
HAUS Connection Object HAUS CHAR 30 0
STR_ERG2 Street 3 AD_STRSPP2 CHAR 40 0
HAUS_NUM2 House number supplement AD_HSNM2 CHAR 10 0
TXTLANGU Language Key SPRAS T002 LANG 1 0
LGZUSATZ Additional Information on Location LGZUSATZ CHAR 40 0
VBSART Type of premise VBSART TE102 CHAR 8 0
EIGENT Owner E_GPARTNER BUT000 CHAR 10 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
TPLNUMMER Number of functional location TPLNUMMER IFLOT CHAR 30 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BEGRU Authorization Group BEGRU CHAR 4 0
LOEVM Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No
ANZPERS Number of persons ANZ_PERS NUMC 3 0
FLOOR Floor in building AD_FLOOR CHAR 10 0
ROOMNUMBER Room or Appartment Number AD_ROOMNUM CHAR 10 0
HPTWHNSITZ Main residence MAINRESI CHAR 1 0
NULL Field inactive
X Field active
STR_ERG4 Street 5 AD_LCTN CHAR 40 0
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
TITLE Form-of-Address Key AD_TITLE CHAR 4 0
NAME1 Name 1 AD_NAME1 CHAR 40 0
NAME2 Name 2 AD_NAME2 CHAR 40 0
NAME_TXT Converted name field (with form of address) AD_NAMETXT CHAR 50 0
CITY1 City AD_CITY1 CHAR 40 0
CITY2 District AD_CITY2 CHAR 40 0
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
COUNTRY Country Key LAND1 CHAR 3 0
STREET Street AD_STREET CHAR 60 0
HOUSE_NUM1 House Number AD_HSNM1 CHAR 10 0
REGION Region (State, Province, County) REGIO CHAR 3 0
ADDR_SHORT Business partner address BP_ADDR_C CHAR 80 0

EWAWA_DL_EVBS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EWAWA_DL_EVBS EIGENT EWAWA_DL_EVBS MANDT BUT000 BP: General data I CLIENT
EWAWA_DL_EVBS EIGENT EWAWA_DL_EVBS EIGENT BUT000 BP: General data I PARTNER
EWAWA_DL_EVBS MANDT EWAWA_DL_EVBS MANDT T000 Clients MANDT
EWAWA_DL_EVBS OBJNR EWAWA_DL_EVBS MANDT ONR00 General Object Number MANDT
EWAWA_DL_EVBS OBJNR EWAWA_DL_EVBS OBJNR ONR00 General Object Number OBJNR
EWAWA_DL_EVBS TPLNUMMER EWAWA_DL_EVBS MANDT IFLOT Functional Location (Table) MANDT
EWAWA_DL_EVBS TPLNUMMER EWAWA_DL_EVBS TPLNUMMER IFLOT Functional Location (Table) TPLNR
EWAWA_DL_EVBS TXTLANGU EWAWA_DL_EVBS TXTLANGU T002 Language Keys (Component BC-I18) SPRAS
EWAWA_DL_EVBS VBSART EWAWA_DL_EVBS MANDT TE102 Premise Types MANDT
EWAWA_DL_EVBS VBSART EWAWA_DL_EVBS VBSART TE102 Premise Types VBSART