SAP A185 Order no./Item/Configuration no./Material/Preference zone Table

Overview

A185 is a standard SAP S/4HANA table that stores Order no./Item/Configuration no./Material/Preference zone data. There are total 11 fields in the A185 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

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

Techincal Settings of A185

Below are technical details of the table A185

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

List of A185 Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
KAPPLApplicationKAPPLT681ACHAR2
KSCHLCondition typeKSCHAT685CHAR4
AUBELSales DocumentVBELN_VACHAR10
AUPOSSales Document ItemPOSNR_VANUMC6
CUOBJConfiguration (internal object number)CUOBJNUMC18
MATNRMaterial NumberMATNRMARACHAR40
GZOLXPreference zoneGZOLXCHAR4
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 A185

Table NameFieldCardinalityCheck Table
A185KAPPL:T681A
A185KSCHL:T685
A185MANDT:T000
A185MATNR:MARA

Other References