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

SAP table WELP has 3 primary key fields being MANDT,MBELN,MBELP.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MBELN Competitor: document number of price entry document CHAR 10 0 WELK MBELN
MBELP Item number of competitor price entry document NUMC 5 0 MBELP
ERWRK Competitor prices: entry plant CHAR 4 0 ERWRK
ERLNR Competitor prices: number of entry list NUMC 5 0 ERLNR
MBWNR Customer number of competitor CHAR 10 0 * MBWNR
VKORG Sales Organization CHAR 4 0 VKORG
VTWEG Distribution Channel CHAR 2 0 VTWEG
WERKS Plant CHAR 4 0 WERKS_D
PLTYP Price List Type CHAR 2 0 T189 PLTYP
KVEWE Usage of the condition table CHAR 1 0 * KVEWE
KAPPL Application CHAR 2 0 * KAPPL
KSCHL Condition Type CHAR 4 0 * KSCHL
KOTABNR Number of the Condition Table CHAR 3 0 * KOTABNR
KDUMMY Dummy function in length 1 CHAR 1 0 DUMMY
MATNR Material Number CHAR 40 0 MATNR
VRKME Sales unit UNIT 3 0 * VRKME
MBETR Condition Amount or Percentage CURR 11 2 KBETR
MWAER Currency Key CUKY 5 0 TCURC WAERS
MPEIN Condition Pricing Unit DEC 5 0 KPEIN
MMEIN Condition Unit UNIT 3 0 T006 KMEIN
VKKAB Sales conditions valid from DATS 8 0 VKKAB
VKKBI Sales conditions valid to DATS 8 0 VKKBI
KNUMH Number of the Condition Record CHAR 10 0 KNUMH
BPSTA Item status for competitor price entry document CHAR 1 0 BPSTA_EL
A New, prices not activated
B Changed, prices not activated
C Prices activated
D Marked for deletion
E Cancelled
PDUMMY Dummy function in length 1 CHAR 1 0 DUMMY

WELP foreign key relationships

Table Field Check Table Check Field
0 WELP MANDT T000 Clients MANDT
1 WELP MBELN WELK Competitor: Price Entry Document (Header) MANDT
1 WELP MBELN WELK Competitor: Price Entry Document (Header) MBELN
0 WELP MMEIN T006 Units of Measurement MANDT
1 WELP MWAER TCURC Currency Codes MANDT
1 WELP MWAER TCURC Currency Codes WAERS
0 WELP PLTYP T189 Conditions: Price List Types MANDT
0 WELP PLTYP T189 Conditions: Price List Types PLTYP