Sunday, May 19, 2024

SAP Table A106 – Price List/Material Group

A106 is a standard SAP table in SAP ECC (or) S/4HANA which stores Price List/Material Group data. There are total 11 fields in A106 table.This blog post provides key technical details of SAP table A106, including its availability across SAP S/4HANA versions and the list of CDS views for A106 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 A106 Table Fields

The following is the list of fields that are available in SAP A106 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)
PLTYP Price List Type PLTYP PLTYP T189 CHAR (2)
WAERK SD document currency WAERK WAERS TCURC CUKY (5)
MATKL Material Group MATKL MATKL T023 CHAR (9)
DATBI Validity end date of the condition record KODATBI DATUM DATS (8)
DATAB Validity start date of the condition record KODATAB DATUM DATS (8)
KNUMH Number of the Condition Record KNUMH KNUMH CHAR (10)

Availability

The SAP table A106 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 A106 table

There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.