SAP ABAP Table WELP (Competitor: Price Entry Document (Item))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WVKP (Package) IS-R: Sales pricing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	WELP	Table Relationship Diagram
Short Description	Competitor: Price Entry Document (Item)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MBELN	☑	MBELN	MBELN	CHAR	10	0	Competitor: document number of price entry document	WELK
3	MBELP	☑	MBELP	MBELP	NUMC	5	0	Item number of competitor price entry document
4	.INCLUDE	☐				0	0	Data Part of Table WELP (Competitor Price Entry Doc.: Item)
5	.INCLUDE	☐				0	0	Competitor: Data Base Part of Entry List Header
6	ERWRK	☐	ERWRK	WERKS	CHAR	4	0	Competitor prices: entry plant	*
7	ERLNR	☐	ERLNR	NUMC5	NUMC	5	0	Competitor prices: number of entry list
8	MBWNR	☐	MBWNR	KUNNR	CHAR	10	0	Customer number of competitor	*
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
10	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
11	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
12	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
13	KVEWE	☐	KVEWE	KVEWE	CHAR	1	0	Usage of the Condition Table	*
14	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	*
15	KSCHL	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
16	KOTABNR	☐	KOTABNR	KOTABNR	NUMC	3	0	Condition table	*
17	.INCLUDE	☐				0	0	Competitor: Customer-Specific Part of Entry List Header
18	KDUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
19	.INCLUDE	☐				0	0	Competitor: Bata Base Part of Entry List Item
20	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
21	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
22	MBETR	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
23	MWAER	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
24	MPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
25	MMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
26	VKKAB	☐	VKKAB	DATUM	DATS	8	0	Sales conditions valid from
27	VKKBI	☐	VKKBI	DATUM	DATS	8	0	Sales conditions valid to
28	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
29	BPSTA	☐	BPSTA_EL	BPSTA_EL	CHAR	1	0	Item status for competitor price entry document
30	.INCLUDE	☐				0	0	Competitor: Customer-Specific Part of Entry List Item
31	PDUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WELP	MANDT	T000	MANDT	KEY
2	WELP	MBELN	WELK	MBELN	KEY
3	WELP	MMEIN	T006	MSEHI
4	WELP	MWAER	TCURC	WAERS
5	WELP	PLTYP	T189	PLTYP

History

Last changed by/on	SAP	20020506
SAP Release Created in