SAP ABAP Table BBP_SUS_USER_SEA (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | BBP_SUS_USER_SEA | Table Relationship Diagram |
Short Description | Generated Table for View |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
2 | BNAME | XUBNAME | XUBNAME | CHAR | 12 | 0 | User Name in User Master Record | USR02 | |
3 | DATE_FROM | AD_DATE_FR | DATUM | DATS | 8 | 0 | Valid-from date - in current Release only 00010101 possible | ||
4 | DATE_FROM_ADR6 | AD_DATE_FR | DATUM | DATS | 8 | 0 | Valid-from date - in current Release only 00010101 possible | ||
5 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
6 | PERSNUMBER | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | ||
7 | NATION | AD_NATION | AD_NATION | CHAR | 1 | 0 | Version ID for International Addresses | TSADV | |
8 | CLIENT_ADR6 | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
9 | ADDRNUMBER | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | ADRC | |
10 | PERSNUMBER_ADR6 | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | ADRP | |
11 | CONSNUMBER | AD_CONSNUM | NUMC3 | NUMC | 3 | 0 | Sequence Number | ||
12 | KOSTL | XUKOSTL | CHAR8 | CHAR | 8 | 0 | Cost center | ||
13 | DATE_TO | AD_DATE_TO | DATUM | DATS | 8 | 0 | Valid-to date in current Release only 99991231 possible | ||
14 | NAME_FIRST | AD_NAMEFIR | TEXT40 | CHAR | 40 | 0 | First name | ||
15 | NAME_LAST | AD_NAMELAS | TEXT40 | CHAR | 40 | 0 | Last name | ||
16 | NAME_TEXT | AD_NAMTEXT | TEXT80 | CHAR | 80 | 0 | Full Name of Person | ||
17 | LANGU | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
18 | MC_NAMEFIR | AD_MC_NMFI | CHAR25 | CHAR | 25 | 0 | First name in upper case for search help | ||
19 | MC_NAMELAS | AD_MC_NMLA | CHAR25 | CHAR | 25 | 0 | Last name in upper-case for search help | ||
20 | SMTP_ADDR | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
21 | SMTP_SRCH | AD_SMTPAD2 | CHAR20 | CHAR | 20 | 0 | E-Mail Address Search Field | ||
22 | VALID_FROM | AD_VALFROM | TIMESTMP | CHAR | 14 | 0 | Communication Data: Valid From (YYYYMMDDHHMMSS) | ||
23 | VALID_TO | AD_VALTO | TIMESTAMP | CHAR | 14 | 0 | Communication Data: Valid To (YYYYMMDDHHMMSS) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BBP_SUS_USER_SEA | ADDRNUMBER | ADRC | ADDRNUMBER | REF | C | CN |
2 | BBP_SUS_USER_SEA | BNAME | USR02 | BNAME | |||
3 | BBP_SUS_USER_SEA | CLIENT | T000 | MANDT | KEY | 1 | CN |
4 | BBP_SUS_USER_SEA | CLIENT_ADR6 | T000 | MANDT | KEY | 1 | CN |
5 | BBP_SUS_USER_SEA | LANGU | T002 | SPRAS | REF | C | CN |
6 | BBP_SUS_USER_SEA | NATION | TSADV | NATION | KEY | 1 | CN |
7 | BBP_SUS_USER_SEA | PERSNUMBER_ADR6 | ADRP | PERSNUMBER | REF | C | CN |
History
Last changed by/on | SAP | 20140120 |
SAP Release Created in |