A147 is a standard SAP table in SAP ECC (or) S/4HANA which stores Customer Hierarchy (Sales Deal) data. There are total 17 fields in A147 table.This blog post provides key technical details of SAP table A147, including its availability across SAP S/4HANA versions and the list of CDS views for A147 table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Full table is passed to buffer |
| Package | Application development Conditions (VKON) |
| Technical Component | Conditions (SD-MD-CM) |
SAP A147 Table Fields
The following is the list of fields that are available in SAP A147 table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| KAPPL | Application | KAPPL | KAPPL | T681A | CHAR (2) |
| KSCHL | Condition type | KSCHA | KSCHL | T685 | CHAR (4) |
| VKORG | Sales Organization | VKORG | VKORG | TVKO | CHAR (4) |
| VTWEG | Distribution Channel | VTWEG | VTWEG | TVTW | CHAR (2) |
| SPART | Division | SPART | SPART | TSPA | CHAR (2) |
| VKBUR | Sales office | VKBUR | VKBUR | TVBUR | CHAR (4) |
| VKGRP | Sales group | VKGRP | VKGRP | TVKGR | CHAR (3) |
| KDGRP | Customer Group | KDGRP | KDGRP | T151 | CHAR (2) |
| KUNRG | Payer | KUNRG | KUNNR | KNA1 | CHAR (10) |
| KUNAG | Sold-To Party | KUNAG | KUNNR | KNA1 | CHAR (10) |
| KUNWE | Ship-to party | KUNWE | KUNNR | KNA1 | CHAR (10) |
| KNUMA_AG | Sales deal | KNUMA_AG | KNUMA | KONA | CHAR (10) |
| DATBI | Validity end date of the condition record | KODATBI | DATUM | DATS (8) | |
| DATAB | Validity start date of the condition record | KODATAB | DATUM | DATS (8) | |
| KEXCL_D | Indicator condition exclusive | KEXCL | XFELD | CHAR (1) | |
| KNUMH | Number of the Condition Record | KNUMH | KNUMH | CHAR (10) |
Availability
The SAP table A147 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for A147 table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
