A042 SAP table for – Country/State/City/Customer Classif.3/Material Classif.3

Here we would like to draw your attention to A042 table in SAP. As we know it is being mainly used with the SAP SD-MD (Master Data in SD) component which is coming under SD module (Sales & Distribution). A042 is a SAP standard transparent table used for storing Country/State/City/Customer Classif.3/Material Classif.3 related data in SAP. It comes under the package VKON.

SAP A042 table

Table A042 technical data

TableA042
Data storingCountry/State/City/Customer Classif.3/Material Classif.3
ModuleSD
ComponentSD-MD
SAP PackageVKON
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP A042 Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in A042 table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • DATAB : Validity start date of the condition record
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KNUMH : Condition record number
    Its data type is C (Character String) with field length 10
  • KAPPL : Application
    Its a key field. Its data type is C (Character String) with field length 2
  • KSCHL : Condition Type
    Its a key field. Its data type is C (Character String) with field length 4
  • ALAND : Departure country (country from which the goods are sent)
    Its a key field. Its data type is C (Character String) with field length 3
  • REGIO : Region (State, Province, County)
    Its a key field. Its data type is C (Character String) with field length 3
  • CITYC : City Code
    Its a key field. Its data type is C (Character String) with field length 4
  • TAXK3 : Tax classification 3 for customer
    Its a key field. Its data type is C (Character String) with field length 1
  • TAXM3 : Tax classification material
    Its a key field. Its data type is C (Character String) with field length 1
  • DATBI : Validity end date of the condition record
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8