SAP A071 Material per Plant Table

Overview

A071 is a standard SAP S/4HANA table that stores Material per Plant data. There are total 11 fields in the A071 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

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

Techincal Settings of A071

Below are technical details of the table A071

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

List of A071 Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
KAPPLApplicationKAPPLT681ACHAR2
KSCHLCondition typeKSCHAT685CHAR4
VKORGSales OrganizationVKORGTVKOCHAR4
VTWEGDistribution ChannelVTWEGTVTWCHAR2
WERKSPlantWERKS_DT001WCHAR4
MATNRMaterial NumberMATNRMARACHAR40
VRKMESales unitVRKMET006UNIT3
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 A071

Table NameFieldCardinalityCheck Table
A071KAPPL:T681A
A071KSCHL:T685
A071MANDT:T000
A071MATNR:MARA
A071VKORG:TVKO
A071VRKME:T006
A071VTWEG:TVTW
A071WERKS:T001W

Other References