SAP table MDG_BUS_SYS_TECH (Technical information of a Business System)
SAP table MDG_BUS_SYS_TECH has 2 primary key fields being MANDT,BUSINESS_SYSTEM.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | MANDT | ||
| BUSINESS_SYSTEM | Business System | CHAR | 60 | 0 | MDG_BUSINESS_SYSTEM | ||
| BUS_SYS_ID | Internal ID of business system | CHAR | 22 | 0 | MDG_BUSINESS_SYSTEM_ID | ||
| LOGSYS | Logical system | CHAR | 10 | 0 | TBDLS | LOGSYS | |
| RFCDEST | Logical destination (specified in function call) | CHAR | 32 | 0 | RFCDES | RFCDEST | |
| FILE_PATH | Logical File Path | CHAR | 60 | 0 | MDG_PATH_NAME | ||
| DEF_STORAGE_SERV | Download to Presentation Server | CHAR | 1 | 0 | MDG_STORAGE_SERVER | ||
| UNICODE_SYSTEM | System Supports Unicode | CHAR | 1 | 0 | MDG_UNICODE_SYSTEM | ||
| UNICODE_CODE_PAG | Unicode Code Page | NUMC | 4 | 0 | TCP00 | MDG_TREX_CODEPAGE_CHAR | |
| DISABLED | Business System Temporarily Disabled for Replication | CHAR | 1 | 0 | MDG_BUS_SYS_DISABLED |
MDG_BUS_SYS_TECH foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 MDG_BUS_SYS_TECH | LOGSYS | TBDLS | Logical system | LOGSYS |
| 1 MDG_BUS_SYS_TECH | UNICODE_CODE_PAG | TCP00 | SAP code page catalog | CPCODEPAGE |