TMGW3 SAP (Change Restrictions for structured Materials) Table details
Description: Change Restrictions for structured Materials
Table field list including key, data, relationships and ABAP select examples
TMGW3 is a standard SAP Table which is used to store Change Restrictions for structured Materials data and is available within R/3 SAP systems depending on the version and release level.
The TMGW3 table consists of various fields, each holding specific information or linking keys about Change Restrictions for structured Materials data available in SAP. These include STRCATEG (Category of structured material), STRAPPL (Application where structured material is used), CHECKDOC (Check if corresponding documents exist), CHGALLOWED (Changes allowed if corresponding documents exist).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP TMGW3 table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| STRCATEG | Category of structured material | MGW2TYP | CHAR | 2 | MGW2TYP | ||||
| STRAPPL | Application where structured material is used | WSTN_APPL | CHAR | 2 | WSTN_APPL | ||||
| CHECKDOC | Check if corresponding documents exist | WSTN_CHECK | CHAR | 1 | XFELD | ||||
| CHGALLOWED | Changes allowed if corresponding documents exist | WSTN_ALLOWED | CHAR | 1 | XFELD | ||||
| CHECKAUTH | Check authorization of user if documents exist | WSTN_AUTH | CHAR | 1 | XFELD | ||||
| MESSAGE_ID | Message Class | SYMSGID | CHAR | 20 | Assigned to domain | ARBGB | |||
| MESSAGE_TYPE | Message Type | SYMSGTY | CHAR | 1 | SYCHAR01 | ||||
| MESSAGE_NUMBER | Message Number | SYMSGNO | NUMC | 3 | SYMSGNO | ||||
| SENDMSG | Send message as info if changes are allowed | WSTN_MSG | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP table TMGW3 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TMGW3 to SELECT all data from the tableDATA: WA_TMGW3 TYPE TMGW3.
SELECT SINGLE *
FROM TMGW3
INTO CORRESPONDING FIELDS OF WA_TMGW3
WHERE...
How to access SAP table TMGW3
Within an ECC or HANA version of SAP you can also view further information about TMGW3 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects