KOTE005 SAP table for – Customer Hierarchy/Material

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

SAP KOTE005 table

Table KOTE005 technical data

TableKOTE005
Data storingCustomer Hierarchy/Material
ModuleSD
ComponentSD-MD
SAP PackageVKON
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • KNUMA : Agreement (various conditions grouped together)
    Its a key field. Its data type is C (Character String) with field length 10
  • 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
  • VKORG : Sales Organization
    Its a key field. Its data type is C (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its a key field. Its data type is C (Character String) with field length 2
  • SPART : Division
    Its a key field. Its data type is C (Character String) with field length 2
  • 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