SAP table V_T006_L (Generated Table for View)
SAP table V_T006_L has 3 primary key fields being MANDT,SPRAS,MSEHI.
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 | T000 | MANDT | |
| SPRAS | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| MSEHI | Unit of Measurement | UNIT | 3 | 0 | MSEHI | ||
| MSEH3 | External Unit of Measurement in Commercial Format (3-Char.) | CHAR | 3 | 0 | MSEH3 | ||
| MSEHL | Unit of Measurement Text (Maximum 30 Characters) | CHAR | 30 | 0 | MSEHL | ||
| DIMID | Dimension key | CHAR | 6 | 0 | T006D | DIMID |
V_T006_L foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 V_T006_L | DIMID | T006D | Dimensions | DIMID |
| 1 V_T006_L | MANDT | T000 | Clients | MANDT |
| 0 V_T006_L | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |