SAP table UMSVZ (Advance Return for Tax on Sls/Pur.Period)
SAP table UMSVZ has 3 primary key fields being MANDT,LAUFD,LAUFI.
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 | |
| LAUFD | Date on Which the Program Is to Be Run | DATS | 8 | 0 | LAUFD | ||
| LAUFI | Additional Identification | CHAR | 6 | 0 | LAUFI | ||
| BUDT1 | Start Date of the Advance Tax Return Period | DATS | 8 | 0 | USTDAT1 | ||
| BUDT2 | End Date of the Advance Tax Return Period | DATS | 8 | 0 | USTDAT2 | ||
| MONA1 | Fiscal Period with Which an Advance Tax Return Period Starts | NUMC | 2 | 0 | MONAT1 | ||
| MONA2 | Fiscal Period with Which an Advance Tax Return Period Ends | NUMC | 2 | 0 | MONAT2 | ||
| GJAHR | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| BLDT1 | Start Date of the Advance Tax Return Period | DATS | 8 | 0 | USTDAT1 | ||
| BLDT2 | End Date of the Advance Tax Return Period | DATS | 8 | 0 | USTDAT2 |
UMSVZ foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 UMSVZ | MANDT | T000 | Clients | MANDT |