KOTE017 SAP table for – Campaign ID/Customer/Material

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

SAP KOTE017 table

Table KOTE017 technical data

TableKOTE017
Data storingCampaign ID/Customer/Material
ModuleSD
ComponentSD-MD
SAP PackageCND_EXCHANGE_GENERAL
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • 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
  • CMPGN_ID : Campaign ID
    Its a key field. Its data type is C (Character String) with field length 10
  • MATNR : Material Number
    Its a key field. Its data type is C (Character String) with field length 18
  • KNUMA : Agreement (various conditions grouped together)
    Its a key field. Its data type is C (Character String) with field length 10
  • DATAB : Validity start date of the condition record
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8