SAP WDR_TEST_SCIRP7 City-Airport assignment Table
Overview
WDR_TEST_SCIRP7 is a standard SAP S/4HANA table that stores City-Airport assignment data. There are total 5 fields in the WDR_TEST_SCIRP7 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WDR_TEST_SCIRP7 belongs to Web Dynpro ABAP (BC-WD-ABA) module and is located in the package Web Dynpro: Tests (SWDP_TEST).
In addition, following links provide an overview of foreign key relationships, if any, that link WDR_TEST_SCIRP7 to other SAP tables and standard CDS views available based on WDR_TEST_SCIRP7 table in S/4HANA 2020.
Techincal Settings of WDR_TEST_SCIRP7
Below are technical details of the table WDR_TEST_SCIRP7
- Buffering allowed but switched off
- No buffering
- Storage type is Column Store
List of WDR_TEST_SCIRP7 Fields
The following table gives you an overview of the fields available in WDR_TEST_SCIRP7
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDANT | Client | MANDT | T000 | CLNT | 3 |
| CITY | City | S_CITY | SGEOCITY | CHAR | 20 |
| COUNTRY | Country/Region Key | LAND1 | SGEOCITY | CHAR | 3 |
| AIRPORT | Airport Code | S_AIRPORT | SAIRPORT | CHAR | 3 |
| MASTERCITY | City | S_CITY | SGEOCITY | CHAR | 20 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WDR_TEST_SCIRP7
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WDR_TEST_SCIRP7 | AIRPORT | 1: CN | SAIRPORT |
| WDR_TEST_SCIRP7 | CITY | 1: CN | SGEOCITY |
| WDR_TEST_SCIRP7 | COUNTRY | 1: CN | SGEOCITY |
| WDR_TEST_SCIRP7 | MANDANT | : | T000 |
| WDR_TEST_SCIRP7 | MASTERCITY | 1: CN | SGEOCITY |