The A145 table in SAP ERP or S/4HANA stores Sales Deal – Customer/Material data. There are total 11 fields in A145 table. The Sales Deal – Customer/Material table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database.Additionally we provide an overview of the structure and fields of A145 table. It is in Application development Conditions (VKON) ABAP package and is part of the Conditions (SD-MD-CM) module.
SAP A145 Table Fields
Following is the list of fields that are available in SAP A145 table. The primary key fields of the table are MANDT (Client), KAPPL (Application), KSCHL (Condition type), KNUMA_AG (Sales deal), VKORG (Sales Organization), KUNNR (Customer number), KDGRP (Customer Group), MATNR (Material Number), DATBI (Validity end date of the condition record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| KAPPL | Application | KAPPL | T681A | CHAR (2) |
| KSCHL | Condition type | KSCHA | T685 | CHAR (4) |
| KNUMA_AG | Sales deal | KNUMA_AG | KONA | CHAR (10) |
| VKORG | Sales Organization | VKORG | TVKO | CHAR (4) |
| KUNNR | Customer number | KUNNR_V | KNA1 | CHAR (10) |
| KDGRP | Customer Group | KDGRP | T151 | CHAR (2) |
| MATNR | Material Number | MATNR | MARA | CHAR (40) |
| 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) |
