SAP Table USER_ADDR
Generated Table for View
USER_ADDR (Generated Table for View) 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 USER_ADDR to other SAP tables.
USER_ADDR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||
| BNAME | User Name in User Master Record | XUBNAME | USR02 | CHAR | 12 | 0 | ||
| NAME_FIRST | First name | AD_NAMEFIR | CHAR | 40 | 0 | |||
| NAME_LAST | Last name | AD_NAMELAS | CHAR | 40 | 0 | |||
| NAME_TEXTC | Full Name of Person | AD_NAMTEXT | CHAR | 80 | 0 | |||
| TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10 | 0 | |||
| KOSTL | Cost center | XUKOSTL | CHAR | 8 | 0 | |||
| BUILDING | Building (number or code) | AD_BLDNG_P | CHAR | 10 | 0 | |||
| ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | 0 | |||
| DEPARTMENT | Department | AD_DPRTMNT | CHAR | 40 | 0 | |||
| INHOUSE_ML | Int. mail postal code | AD_IH_MAIL | CHAR | 10 | 0 | |||
| NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | 0 | |||
| CITY1 | City | AD_CITY1 | CHAR | 40 | 0 | |||
| POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | 0 | |||
| MC_NAMEFIR | First name in upper case for search help | AD_MC_NMFI | CHAR | 25 | 0 | |||
| MC_NAMELAS | Last name in upper-case for search help | AD_MC_NMLA | CHAR | 25 | 0 | |||
| MC_NAME1 | Name (field NAME1) in upper case for matchcode | AD_MC_NAME | CHAR | 25 | 0 | |||
| MC_CITY1 | City name in upper case for search help | AD_MC_CITY | CHAR | 25 | 0 | |||
| COMPANY | Company address, cross-system key | USCOMP | CHAR | 42 | 0 | |||
