SAP A023 Additional Selling Plant/Material/Unit of Measure Table

Overview

A023 is a standard SAP S/4HANA table that stores Additional Selling Plant/Material/Unit of Measure data. There are total 9 fields in the A023 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table A023 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 A023 to other SAP tables and standard CDS views available based on A023 table in S/4HANA 2020.

Techincal Settings of A023

Below are technical details of the table A023

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

List of A023 Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
KAPPLApplicationKAPPLT681ACHAR2
KSCHLCondition typeKSCHAT685CHAR4
WERKVResale plantWERKVT001WCHAR4
MATNRMaterial NumberMATNRMARACHAR40
MEEINUnit of measure of a purchased materialMEEINT006UNIT3
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 A023

Table NameFieldCardinalityCheck Table
A023KAPPL:T681A
A023KSCHL:T685
A023MANDT:T000
A023MATNR:MARA
A023MEEIN:T006
A023WERKV:T001W

Other References