SAP ABAP View USS_JOIN_STH_08 (Tables BUT020, BUT100, ADRC)
Hierarchy
☛
SEM-BW (Software Component) SEM-BW: Strategic Enterprise Management
⤷
FIN-SEM-SRM (Application Component) Stakeholder Relationship Management
⤷
USS (Package) SEM-SRM: Stakeholder Relationship Management
SEM-BW (Software Component) SEM-BW: Strategic Enterprise Management⤷
FIN-SEM-SRM (Application Component) Stakeholder Relationship Management⤷
USS (Package) SEM-SRM: Stakeholder Relationship Management
Basic Data
| View Type | D | Database View |
| Database View | USS_JOIN_STH_08 | |
| Short Description | Tables BUT020, BUT100, ADRC | |
| Root table | BUT020 | BP: Addresses |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | BUT020 |
BUT020 | ||
| 2 | BUT100 |
BUT100 | ||
| 3 | ADRC |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | BUT020 |
CLIENT | JL | EQ | 0 | 0 | ||||
| 2 | BUT100 |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 3 | BUT020 |
PARTNER | JL | EQ | 0 | 0 | ||||
| 4 | BUT100 |
PARTNER | JR | EQ | AND | 0 | 0 | |||
| 5 | BUT020 |
CLIENT | JL | EQ | 0 | 0 | ||||
| 6 | ADRC |
CLIENT | JR | EQ | AND | 0 | 0 | |||
| 7 | BUT020 |
ADDRNUMBER | JL | EQ | 0 | 0 | ||||
| 8 | ADRC |
ADDRNUMBER | JR | EQ | AND | 0 | 0 | |||
| 9 | BUT100 |
RLTYP | EQ | 'SRM000' | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
BUT100 |
MANDT | MANDT | Client | |||
| 2 | PARTNER |
BUT100 |
PARTNER | BU_PARTNER | Business Partner Number | |||
| 3 | COUNTRY |
ADRC |
COUNTRY | LAND1 | Country Key | |||
| 4 | CITY1 |
ADRC |
CITY1 | AD_CITY1 | City | |||
| 5 | MC_CITY1 |
ADRC |
MC_CITY1 | AD_MC_CITY | City name in upper case for search help | |||
| 6 | XDFADR |
BUT020 |
XDFADR | BU_XDFADR | Indicator: Address is standard address | |||
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 | 3.1A |
