SAP A031 Price Group/Material Pricing Group Table

Overview

A031 is a standard SAP S/4HANA table that stores Price Group/Material Pricing Group data. There are total 10 fields in the A031 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table A031 belongs to Conditions (SD-MD-CM) module and is located in the package Application development Conditions (VKON).

In addition, following links provide an overview of foreign key relationships, if any, that link A031 to other SAP tables and standard CDS views available based on A031 table in S/4HANA 2020.

Techincal Settings of A031

Below are technical details of the table A031

  • Buffering switched on
  • Full table is passed to buffer
  • Storage type is Column Store

List of A031 Fields

The following table gives you an overview of the fields available in A031

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
KAPPLApplicationKAPPLT681ACHAR2
KSCHLCondition typeKSCHAT685ACHAR4
VKORGSales OrganizationVKORGTVKOCHAR4
VTWEGDistribution ChannelVTWEGTVTWCHAR2
KONDACustomer Price GroupKONDA_VT188CHAR2
KONDMMaterial Price GroupKONDM_VT178CHAR2
DATBIValidity end date of the condition recordKODATBIDATS8
DATABValidity start date of the condition recordKODATABDATS8
KNUMHNumber of the Condition RecordKNUMHCHAR10

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 A031

Table NameFieldCardinalityCheck Table
A031KAPPL1: CNT681A
A031KONDA1: CNT188
A031KONDM1: CNT178
A031KSCHL1: CNT685A
A031MANDT1: CNT000
A031VKORG1: CNTVKO
A031VTWEG1: CNTVTW

Other References