SAP table MARCH (Material Master C Segment: History)
SAP table MARCH has 5 primary key fields being MANDT,MATNR,WERKS,LFGJA,LFMON.
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 | ||
| MATNR | Material Number | CHAR | 40 | 0 | MATNR | ||
| WERKS | Plant | CHAR | 4 | 0 | WERKS_D | ||
| LFGJA | Fiscal Year of Current Period | NUMC | 4 | 0 | LFGJA | ||
| LFMON | Current period (posting period) | NUMC | 2 | 0 | LFMON | ||
| UMLMC | Stock in transfer (plant to plant) | QUAN | 13 | 3 | UMLME | ||
| TRAME | Stock in Transit | QUAN | 13 | 3 | TRAME | ||
| VKUMC | Stock transfer sales value (plant to plant) for VO material | CURR | 13 | 2 | VKUMC | ||
| VKTRW | Transit value at sales price for value-only material | CURR | 13 | 2 | VKTRW | ||
| GLGMG | Tied Empties Stock | QUAN | 13 | 3 | GLGMG | ||
| VKGLG | Sales value of tied empties stock | CURR | 13 | 2 | VKGLG | ||
| BWESB | Valuated Goods Receipt Blocked Stock | QUAN | 13 | 3 | BWESB | ||
| /CWM/UMLMC | Stock in transfer (plant to plant) | QUAN | 13 | 3 | UMLME | ||
| /CWM/TRAME | Stock in Transit | QUAN | 13 | 3 | TRAME | ||
| /CWM/BWESB | Valuated Goods Receipt Blocked Stock | QUAN | 13 | 3 | BWESB |