SAP table TWEW (External Material Groups)

SAP table TWEW (External Material Groups) is used to store information about external material groups that are maintained outside of the standard SAP material group hierarchy. These external material groups are often utilized for mapping or integration purposes, such as aligning SAP data with external systems or categorization standards. Each entry in the table typically includes a unique identifier and descriptive information for the external material group.

the text descripions for external material groups can be found in SAP table TWEWT (Descriptions for External Material Groups).

SAP table TWEW has 2 primary key fields being MANDT,EXTWG.

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.