SAP AMDP_SCHEMA_MAP AMDP: Mapping of Logical Schema to Physical Schema Table
Overview
AMDP_SCHEMA_MAP is a standard SAP S/4HANA table that stores AMDP: Mapping of Logical Schema to Physical Schema data. There are total 7 fields in the AMDP_SCHEMA_MAP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AMDP_SCHEMA_MAP belongs to ABAP Syntax, Compiler, Runtime (BC-ABA-LA) module and is located in the package AMDP Schema Management (SABP_AMDP_SCHEMA).
In addition, following links provide an overview of foreign key relationships, if any, that link AMDP_SCHEMA_MAP to other SAP tables and standard CDS views available based on AMDP_SCHEMA_MAP table in S/4HANA 2020.
Techincal Settings of AMDP_SCHEMA_MAP
Below are technical details of the table AMDP_SCHEMA_MAP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AMDP_SCHEMA_MAP Fields
The following table gives you an overview of the fields available in AMDP_SCHEMA_MAP
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| LOGICAL_SCHEMA_NAME | Database Schema | DB_SCHEMA | CHAR | 30 | |
| CHANGED_AT | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| CHANGED_BY_USER | User Name | SYUNAME | CHAR | 12 | |
| CHANGED_BY_CLIENT | Client ID | SYMANDT | * | CLNT | 3 |
| CHANGED_BY_SYSID | Name of SAP System | SYSYSID | CHAR | 8 | |
| CHANGED_BY_HOSTNAME | Application Server | SYHOST | CHAR | 32 | |
| TOUCHED_AT | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 21 |
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 AMDP_SCHEMA_MAP