SAP A4AV Country/Tax Code Table
Overview
A4AV is a standard SAP S/4HANA table that stores Country/Tax Code data. There are total 8 fields in the A4AV table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table A4AV belongs to Value Added Tax (VAT) (FI-GL-GL-F) module and is located in the package Time Dependent Tax Calculation (FOT_TDT).
In addition, following links provide an overview of foreign key relationships, if any, that link A4AV to other SAP tables and standard CDS views available based on A4AV table in S/4HANA 2020.
Techincal Settings of A4AV
Below are technical details of the table A4AV
- Buffering switched on
- Full table is passed to buffer
- Storage type is Column Store
List of A4AV Fields
The following table gives you an overview of the fields available in A4AV
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| KAPPL | Application | KAPPL | T681A | CHAR | 2 |
| KSCHL | Condition type | KSCHA | T685 | CHAR | 4 |
| ALAND | Departure country (country from which the goods are sent) | ALAND | T005 | CHAR | 3 |
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | |
| DATBI | Validity end date of the condition record | KODATBI | DATS | 8 | |
| DATAB | Validity start date of the condition record | KODATAB | DATS | 8 | |
| KNUMH | Number of the Condition Record | KNUMH | CHAR | 10 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for A4AV
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| A4AV | ALAND | : | T005 |
| A4AV | KAPPL | : | T681A |
| A4AV | KSCHL | : | T685 |
| A4AV | MANDT | : | T000 |