SAP Table WELP
Competitor: Price Entry Document (Item)
WELP (Competitor: Price Entry Document (Item)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link WELP to other SAP tables.
Source: WELP (Competitor: Price Entry Document (Item))
WELP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||
| MBELN | Competitor: document number of price entry document | MBELN | WELK | CHAR | 10 | 0 | ||||||||||||
| MBELP | Item number of competitor price entry document | MBELP | NUMC | 5 | 0 | |||||||||||||
| ERWRK | Competitor prices: entry plant | ERWRK | CHAR | 4 | 0 | |||||||||||||
| ERLNR | Competitor prices: number of entry list | ERLNR | NUMC | 5 | 0 | |||||||||||||
| MBWNR | Customer number of competitor | MBWNR | CHAR | 10 | 0 | |||||||||||||
| VKORG | Sales Organization | VKORG | CHAR | 4 | 0 | |||||||||||||
| VTWEG | Distribution Channel | VTWEG | CHAR | 2 | 0 | |||||||||||||
| WERKS | Plant | WERKS_D | CHAR | 4 | 0 | |||||||||||||
| PLTYP | Price list type | PLTYP | T189 | CHAR | 2 | 0 | ||||||||||||
| KVEWE | Usage of the condition table | KVEWE | CHAR | 1 | 0 | |||||||||||||
| KAPPL | Application | KAPPL | CHAR | 2 | 0 | |||||||||||||
| KSCHL | Condition Type | KSCHL | CHAR | 4 | 0 | |||||||||||||
| KOTABNR | Condition table | KOTABNR | NUMC | 3 | 0 | |||||||||||||
| KDUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | 0 | |||||||||||||
| MATNR | Material Number | MATNR | CHAR | 18 | 0 | |||||||||||||
| VRKME | Sales unit | VRKME | UNIT | 3 | 0 | |||||||||||||
| MBETR | Rate (condition amount or percentage) | KBETR | CURR | 11 | 2 | |||||||||||||
| MWAER | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||||
| MPEIN | Condition pricing unit | KPEIN | DEC | 5 | 0 | |||||||||||||
| MMEIN | Condition unit | KMEIN | T006 | UNIT | 3 | 0 | ||||||||||||
| VKKAB | Sales conditions valid from | VKKAB | DATS | 8 | 0 | |||||||||||||
| VKKBI | Sales conditions valid to | VKKBI | DATS | 8 | 0 | |||||||||||||
| KNUMH | Condition record number | KNUMH | CHAR | 10 | 0 | |||||||||||||
| BPSTA | Item status for competitor price entry document | BPSTA_EL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PDUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | 0 | |||||||||||||
WELP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| WELP | MANDT | WELP | MANDT | T000 | Clients | MANDT |
| WELP | MBELN | WELP | MANDT | WELK | Competitor: Price Entry Document (Header) | MANDT |
| WELP | MBELN | WELP | MBELN | WELK | Competitor: Price Entry Document (Header) | MBELN |
| WELP | MMEIN | SYS | MANDT | T006 | Units of Measurement | MANDT |
| WELP | MMEIN | WELP | MMEIN | T006 | Units of Measurement | MSEHI |
| WELP | MWAER | SYS | MANDT | TCURC | Currency Codes | MANDT |
| WELP | MWAER | WELP | MWAER | TCURC | Currency Codes | WAERS |
| WELP | PLTYP | SYS | MANDT | T189 | Conditions: Price List Categories | MANDT |
| WELP | PLTYP | WELP | PLTYP | T189 | Conditions: Price List Categories | PLTYP |
