SAP table MARV (Material Control Record)
SAP table MARV has 2 primary key fields being MANDT,BUKRS.
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 | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| LFGJA | Fiscal Year of Current Period | NUMC | 4 | 0 | LFGJA | ||
| LFMON | Current period (posting period) | NUMC | 2 | 0 | LFMON | ||
| VMGJA | Fiscal year of previous period | NUMC | 4 | 0 | VMGJA | ||
| VMMON | Month of previous period | NUMC | 2 | 0 | VMMON | ||
| VJGJA | Fiscal year of last period of previous year | NUMC | 4 | 0 | VJGJA | ||
| VJMON | Last month of previous year | NUMC | 2 | 0 | VJMON | ||
| XRUEM | Allow Posting to Previous Period (Backposting) | CHAR | 1 | 0 | XRUEM | ||
| XRUEV | Indicator: Disallow backposting after a change of period | CHAR | 1 | 0 | XRUEV | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| LAEDA | Date of Last Change | DATS | 8 | 0 | LAEDA | ||
| UZEIT | Time | TIMS | 6 | 0 | UZEIT | ||
| KZINV | Indicator: Initialize company code | CHAR | 1 | 0 | KZINV | ||
| VVMGJ | Fiscal year of period before last | NUMC | 4 | 0 | VVMGJ | ||
| VVMMO | Month of period before last | NUMC | 2 | 0 | VVMMO | ||
| VVJGJ | Fiscal year of last period of year before last | NUMC | 4 | 0 | VVJGJ | ||
| VVJMO | Last period of year before last | NUMC | 2 | 0 | VVJMN | ||
| GJA_40C | Fiscal year of 1st period with dynamic closing | NUMC | 4 | 0 | GJA_40C | ||
| MON_40C | 1st period with dynamic closing | NUMC | 2 | 0 | MON_40C | ||
| GJA_46C | Fiscal Year of 1st Period After 4.6C Upgrade | NUMC | 4 | 0 | GJA_46C | ||
| MON_46C | 1st Period After 4.6C Upgrade | NUMC | 2 | 0 | MON_46C |
MARV foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 MARV | BUKRS | T001 | Company Codes | BUKRS |
| 1 MARV | MANDT | T000 | Clients | MANDT |