A090 SAP table for – SD Document/Item/Material

Here we would like to draw your attention to A090 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). A090 is a SAP standard transparent table used for storing SD Document/Item/Material related data in SAP. It comes under the package VKON.

SAP A090 table

Table A090 technical data

TableA090
Data storingSD Document/Item/Material
ModuleSD
ComponentSD-MD
SAP PackageVKON
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP A090 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 A090 table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • 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
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • POSNR : Item number of the SD document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • MATNR : Material Number
    Its a key field. Its data type is C (Character String) with field length 18
  • DATBI : Validity end date of the condition record
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • 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