SAP ABAP Table M_SHUSPE (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | M_SHUSPE | 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 | T000 | |
2 | VMFLNO | VIGWVMFLNO | VVINTRENO | CHAR | 13 | 0 | VIGWVMFL | ||
3 | VERSION | VIGWSVERSION | VIGWVERSION | NUMC | 4 | 0 | Version Indicator | ||
4 | DGUELBIS | VIGWSGUELBIS | DDAT | DATS | 8 | 0 | Date: Valid To | ||
5 | DGUELAB | VIGWGUELAB | DDAT | DATS | 8 | 0 | Valid-from date | ||
6 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
7 | SWENR | SWENR | SWENR | CHAR | 8 | 0 | Business Entity Number | VIOB01 | |
8 | FLLBEZ | VIGWFFLBEZ | XTEXT30 | CHAR | 30 | 0 | Flächenbezeichnung einer Mietfläche | ||
9 | FLID | VIGWFFLID | VIGWUFLID | CHAR | 13 | 0 | Rental Space | ||
10 | FLOT | VIGWSFFLOT | VIGWFLOT | NUMC | 4 | 0 | Flächentyp | TIG03 | |
11 | FLAAIND | VIGWFLRAIND | VIGWFLRAIND | NUMC | 1 | 0 | |||
12 | FLAA | VIGWSFFLAA | VIGWFLAA | NUMC | 10 | 0 | Characteristics Key | TIG01N | |
13 | HCOUNT_P | VIGWHCNTP | VIGWHCNT | NUMC | 4 | 0 | Personenbelegung (theoretisch) | ||
14 | HCOUNT_I | VIGWHCNTI | VIGWHCNT | NUMC | 4 | 0 | Personenbelegung (Ist) | ||
15 | BERGRP | VVBERGRP | VVBERGRP | CHAR | 40 | 0 | Authorization group | TIVAG | |
16 | DRV_KOND | VIGWDRV_KOND | JANE | CHAR | 1 | 0 | Konditionen werden vererbt | ||
17 | SGENR | SGENR | SGENR | CHAR | 8 | 0 | Building Number | ||
18 | SGRNR | SGRNR | SGRNR | CHAR | 8 | 0 | Land Number for BE | ||
19 | A_FLLBEZ | VIGWARFLBEZ | XTEXT30 | CHAR | 30 | 0 | Flächenbezeichnung einer arch. Fläche | ||
20 | A_FLID | VIGWASPID | VIGWFFLID | CHAR | 13 | 0 | |||
21 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
22 | PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
23 | ORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
24 | STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
25 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
26 | ORT01_MC | VVXORT01MC | CHAR16 | CHAR | 16 | 0 | IS-IS: City 1 in upper case characters for matchcode search | ||
27 | STRAS_MC | VVXSTRASMC | CHAR16 | CHAR | 16 | 0 | IS-IS: Street in upper case characters for matchcode search | ||
28 | DGUELAB1 | VIGWGUELAB | DDAT | DATS | 8 | 0 | Valid-from date | ||
29 | DGUELBIS1 | VIGWSGUELBIS | DDAT | DATS | 8 | 0 | Date: Valid To | ||
30 | DGUELAB2 | VIGWGUELAB | DDAT | DATS | 8 | 0 | Valid-from date | ||
31 | DGUELBIS2 | VIGWSGUELBIS | DDAT | DATS | 8 | 0 | Date: Valid To | ||
32 | OBJTYPE | VIGWVMOBJTYPE | VIGWVMOBJTYPE | CHAR | 1 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | M_SHUSPE | BERGRP | TIVAG | BERGRP | |||
2 | M_SHUSPE | BUKRS | T001 | BUKRS | |||
3 | M_SHUSPE | FLAA | TIG01N | FLAA | REF | C | CN |
4 | M_SHUSPE | FLOT | TIG03 | FLOT | KEY | 1 | CN |
5 | M_SHUSPE | LAND1 | T005 | LAND1 | KEY | 1 | 1 |
6 | M_SHUSPE | MANDT | T000 | MANDT | KEY | 1 | CN |
7 | M_SHUSPE | REGIO | T005S | BLAND | KEY | 1 | 1 |
8 | M_SHUSPE | SWENR | VIOB01 | SWENR | |||
9 | M_SHUSPE | VMFLNO | VIGWVMFL | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |