WELP SAP table for – Competitor: Price Entry Document (Item)

Here we would like to draw your attention to WELP table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). WELP is a SAP standard transparent table used for storing Competitor: Price Entry Document (Item) related data in SAP. It comes under the package WVKP.

SAP WELP table

Table WELP technical data

TableWELP
Data storingCompetitor: Price Entry Document (Item)
ModuleLO
ComponentLO-MD
SAP PackageWVKP
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • PLTYP : Price list type
    Its data type is C (Character String) with field length 2
  • KVEWE
    Its data type is C (Character String) with field length 1
  • KAPPL : Application
    Its data type is C (Character String) with field length 2
  • KSCHL : Condition Type
    Its data type is C (Character String) with field length 4
  • KOTABNR
    Its data type is N (Character String with Digits Only) with field length 3
  • KDUMMY
    Its data type is C (Character String) with field length 1
  • MBELN
    Its a key field. Its data type is C (Character String) with field length 10
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • VRKME : Sales unit
    Its data type is C (Character String) with field length 3
  • MBETR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • MWAER
    Its data type is C (Character String) with field length 5
  • MPEIN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • MMEIN
    Its data type is C (Character String) with field length 3
  • VKKAB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VKKBI
    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
  • BPSTA
    Its data type is C (Character String) with field length 1
  • MBELP
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • PDUMMY
    Its data type is C (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is EWELP
  • ERWRK
    Its data type is C (Character String) with field length 4
  • ERLNR
    Its data type is N (Character String with Digits Only) with field length 5
  • MBWNR
    Its data type is C (Character String) with field length 10
  • VKORG : Sales Organization
    Its data type is C (Character String) with field length 4