A047 SAP table for – Material Group Prices (Plant-Specific)

Here we would like to draw your attention to A047 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). A047 is a SAP standard pooled table used for storing Material Group Prices (Plant-Specific) related data in SAP. It comes under the package VKON.

SAP A047 table

Table A047 technical data

TableA047
Data storingMaterial Group Prices (Plant-Specific)
ModuleSD
ComponentSD-MD
SAP PackageVKON
Delivery ClassA – Application table (master and transaction data)
Table CategoryPOOLED

SAP A047 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 A047 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
  • EKORG : Purchasing organization
    Its a key field. Its data type is C (Character String) with field length 4
  • LIFNR : Vendor’s account number
    Its a key field. Its data type is C (Character String) with field length 10
  • ESOKZ : Purchasing info record category
    Its a key field. Its data type is C (Character String) with field length 1
  • WERKS : Plant
    Its a key field. Its data type is C (Character String) with field length 4
  • MATKL : Material Group
    Its a key field. Its data type is C (Character String) with field length 9
  • DATBI : Validity end date of the condition record
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8