SAP Table
T137 Industries for materials
SAP table T137 has 2 primary key fields being MANDT,MBRSH.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
T137 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | * | MANDT | |
| KeyMBRSH | Industry Sector | CHAR | 1 | 0 | MBRSH | ||
| BRARE | Reference industry sector | CHAR | 1 | 0 | BRARE | ||
| BBREF | Screen reference depending on the industry sector | CHAR | 1 | 0 | BBREF | ||
| FLREF | Field reference for material master | CHAR | 4 | 0 | T130A | FLREF_MG |
/ Relationships
T137 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| T137 | FLREF | T130A | Material master field selection | MANDT |