SAP Table T007L
Table for Grouping Tax Balances
T007L (Table for Grouping Tax Balances) 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 T007L to other SAP tables.
T007L table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||
| VERSION | Grouping Version for Advance Return for Tax on Sales/Purch. | VERSTAX | CHAR | 4 | 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
|
||||||
| STEGRUNO | Group Number for Tax Amounts | STEGRUNO | NUMC | 2 | 0 | |||||||
| OPERA | Type of Arithmetical Operation | OPER_TYPE | CHAR | 1 | 0 | |||||||
T007L foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T007L | LAND1 | T007L | MANDT | T005 | Countries | MANDT |
| T007L | LAND1 | T007L | LAND1 | T005 | Countries | LAND1 |
| T007L | MANDT | T007L | MANDT | T000 | Clients | MANDT |
| T007L | MWSKZ | T007L | MANDT | T007A | Tax Keys | MANDT |
| T007L | MWSKZ | * | T007A | Tax Keys | KALSM | |
| T007L | MWSKZ | T007L | MWSKZ | T007A | Tax Keys | MWSKZ |
