SAP ABAP View V_T7PIQ_GB_COUNM (GB: Mapping SAP Country/Region/County codes to UCAS/HESA)
Hierarchy
☛
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
⤷
IS-HER-CM-GB (Application Component) United Kingdom
⤷
PMIQ_GB (Package) Campus Management (Great Britain)
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING⤷
IS-HER-CM-GB (Application Component) United Kingdom⤷
PMIQ_GB (Package) Campus Management (Great Britain)
Basic Data
| View Type | C | Maintenance View |
| Maintenance View | V_T7PIQ_GB_COUNM | |
| Short Description | GB: Mapping SAP Country/Region/County codes to UCAS/HESA | |
| Root table | T7PIQ_GB_COUNTYM | GB: Mapping table SAP country & county codes to UCAS/HESA |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | T7PIQ_GB_COUNTYM |
T7PIQ_GB_COUNTYM | ||
| 2 | T005 |
T7PIQ_GB_COUNTYM | COUNTRY | E |
| 3 | T005S |
T7PIQ_GB_COUNTYM | COUNTY | E |
| 4 | T005T |
T005 | LAND1 | I |
| 5 | T005U |
T005S | BLAND | I |
| 6 | T005E |
T7PIQ_GB_COUNTYM | COUNTYC | E |
| 7 | T005F |
T005E | COUNC | I |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  NTYMANDT |
T7PIQ_GB_COUNTYM |
MANDT | MANDT | Client | |||
| 2 | LAND1 |
T7PIQ_GB_COUNTYM |
COUNTRY | LAND1 | Country Key | |||
| 3 | REGIO |
T7PIQ_GB_COUNTYM |
COUNTY | REGIO | Region (State, Province, County) | |||
| 4 | COUNC |
T7PIQ_GB_COUNTYM |
COUNTYC | COUNC | County Code | |||
| 5 | LANDX |
T005T |
LANDX | R | LANDX | Country Name | ||
| 6 | BEZEI1 |
T005U |
BEZEI | R | BEZEI20 | Description | ||
| 7 | BEZEI2 |
T005F |
BEZEI | R | BEZEI20 | Description | ||
| 8 | UCAS_COUNTY |
T7PIQ_GB_COUNTYM |
UCAS_COUNTY | PIQ_GB_UCAS_COUNTY | UCAS: County / Country code | |||
| 9 | HESA_COUNTY |
T7PIQ_GB_COUNTYM |
HESA_COUNTY | PIG_GB_HESA_COUNTY | HESA: Country/County code | |||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in |
