SAP Table UMSV
Tax Balances per Comp.Code, Tax Code and Process.Key
UMSV (Tax Balances per Comp.Code, Tax Code and Process.Key) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link UMSV to other SAP tables.
UMSV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| LAUFD | Date on Which the Program Is to Be Run | LAUFD | DATS | 8 | 0 | |||||||
| LAUFI | Additional Identification | LAUFI | CHAR | 6 | 0 | |||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||
| LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 | 0 | ||||||
| KTOSL | Transaction Key | KTOSL | CHAR | 3 | 0 | |||||||
| SHKZG_UMSV | Indicator: Total Balance, Debit Balance or Credit Balance? | SHKZG_UMSV | CHAR | 1 | 0 |
Possible values
|
||||||
| HWBAS | Tax Base Amount in Local Currency | HWBAS_BSES | CURR | 15 | 2 | |||||||
| HWSTE | Tax Amount in Local Currency with +/- Sign | HWSTEV | CURR | 13 | 2 | |||||||
| WAERS | Currency Key | WAERS | CUKY | 5 | 0 | |||||||
UMSV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| UMSV | BUKRS | UMSV | BUKRS | T001 | Company Codes | BUKRS |
| UMSV | BUKRS | UMSV | MANDT | T001 | Company Codes | MANDT |
| UMSV | LAND1 | UMSV | MANDT | T005 | Countries | MANDT |
| UMSV | LAND1 | UMSV | LAND1 | T005 | Countries | LAND1 |
| UMSV | MANDT | UMSV | MANDT | T000 | Clients | MANDT |
| UMSV | MWSKZ | UMSV | MANDT | T007A | Tax Keys | MANDT |
| UMSV | MWSKZ | * | T007A | Tax Keys | KALSM | |
| UMSV | MWSKZ | UMSV | MWSKZ | T007A | Tax Keys | MWSKZ |
