SAP A074 Plant/Customs Area/Material Table

Overview

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

The table A074 belongs to Cross-Application Components (CA) module and is located in the package Reuse Package for SCR 1 (QRT_RU_SCR_000001).

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

Techincal Settings of A074

Below are technical details of the table A074

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

List of A074 Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
KAPPLApplicationKAPPLT681ACHAR2
KSCHLCondition typeKSCHAT685CHAR4
WERKSPlantWERKS_DT001WCHAR4
GZOLXPreference zoneGZOLXCHAR4
MATNRMaterial NumberMATNRMARACHAR40
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 A074

Table NameFieldCardinalityCheck Table
A074KAPPL:T681A
A074KSCHL:T685
A074MANDT:T000
A074MATNR:MARA
A074WERKS:T001W

Other References