SAP ABAP View ISUCC_USER_ADDR (User According to Address Data)
Hierarchy
☛
IS-UT (Software Component) SAP Utilities/Telecommunication
⤷ IS-U-CS-FO (Application Component) Front Office
⤷ EECIC_ADJUST (Package) IS-U: CIC Downgrade/CIC Adjustment to 4.0
⤷ IS-U-CS-FO (Application Component) Front Office
⤷ EECIC_ADJUST (Package) IS-U: CIC Downgrade/CIC Adjustment to 4.0
Basic Data
View Type | D | Database View |
Database View | ISUCC_USER_ADDR | |
Short Description | User According to Address Data | |
Root table | USR21 | User Name/Address Key Assignment |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | USR21 | USR21 | ||
2 | ADRC | |||
3 | ADRP |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | ADRC | CLIENT | JL | EQ | 0 | 0 | ||||
2 | USR21 | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | ADRC | ADDRNUMBER | JL | EQ | 0 | 0 | ||||
4 | USR21 | ADDRNUMBER | JR | EQ | AND | 0 | 0 | |||
5 | ADRP | CLIENT | JL | EQ | 0 | 0 | ||||
6 | USR21 | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | ADRP | PERSNUMBER | JL | EQ | 0 | 0 | ||||
8 | USR21 | PERSNUMBER | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | USR21 | MANDT | MANDT | Client | |||
2 | BNAME | USR21 | BNAME | XUBNAME | User Name in User Master Record | |||
3 | KOSTL | USR21 | KOSTL | XUKOSTL | Cost center | |||
4 | TITLE | ADRP | TITLE | AD_TITLE | Form-of-Address Key | |||
5 | NAME_FIRST | ADRP | NAME_FIRST | AD_NAMEFIR | First name | |||
6 | NAME_LAST | ADRP | NAME_LAST | AD_NAMELAS | Last name | |||
7 | NAME2 | ADRP | NAME2 | AD_NAME2_P | Name of person at birth | |||
8 | NAMEMIDDLE | ADRP | NAMEMIDDLE | AD_NAMEMID | Middle name or second forename of a person | |||
9 | NAME_LAST2 | ADRP | NAME_LAST2 | AD_NAMLAS2 | Second surname of a person | |||
10 | NAME_TEXTC | ADRP | NAME_TEXT | AD_NAMTEXT | Full Name of Person | |||
11 | CONVERTED | ADRP | CONVERTED | AD_NAMCONV | Status of Field 'Full Name' NAME_TEXT | |||
12 | TITLE_ACA1 | ADRP | TITLE_ACA1 | AD_TITLE1 | Academic Title: Key | |||
13 | TITLE_ACA2 | ADRP | TITLE_ACA2 | AD_TITLE2 | Second academic title (key) | |||
14 | PREFIX1 | ADRP | PREFIX1 | AD_PREFIX | Name Prefix (Key) | |||
15 | PREFIX2 | ADRP | PREFIX2 | AD_PREFIX2 | 2nd name prefix (key) | |||
16 | TITLE_SPPL | ADRP | TITLE_SPPL | AD_TITLES | Name supplement, e.g. noble title (key) | |||
17 | NICKNAME | ADRP | NICKNAME | AD_NICKNAM | Nickname or name used | |||
18 | MC_NAMEFIR | ADRP | MC_NAMEFIR | AD_MC_NMFI | First name in upper case for search help | |||
19 | MC_NAMELAS | ADRP | MC_NAMELAS | AD_MC_NMLA | Last name in upper-case for search help | |||
20 | NAME3 | ADRC | NAME3 | AD_NAME3 | Name 3 | |||
21 | NAME4 | ADRC | NAME4 | AD_NAME4 | Name 4 | |||
22 | NAME_TEXT | ADRC | NAME_TEXT | AD_NAMETXT | Converted name field (with form of address) | |||
23 | NAME_CO | ADRC | NAME_CO | AD_NAME_CO | c/o name | |||
24 | CITY1 | ADRC | CITY1 | AD_CITY1 | City | |||
25 | CITY2 | ADRC | CITY2 | AD_CITY2 | District | |||
26 | POST_CODE1 | ADRC | POST_CODE1 | AD_PSTCD1 | City postal code | |||
27 | MC_NAME1 | ADRC | MC_NAME1 | AD_MC_NAME | Name (field NAME1) in upper case for matchcode | |||
28 | MC_CITY1 | ADRC | MC_CITY1 | AD_MC_CITY | City name in upper case for search help | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |