SAP ABAP Table WAALD (Structure: Mat. - vendor assignmnt in price main. Promotions)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ WAKT (Package) Application development R/3 Promotions

Basic Data

Table Category	INTTAB	Structure
Structure	WAALD	Table Relationship Diagram
Short Description	Structure: Mat. - vendor assignmnt in price main. Promotions

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Material-to-vendor assignment in price maintenance (promo.)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
4	ARTNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	MEBME	☐	W_MEBME	MEINS	UNIT	3	0	Sales unit	T006
6	LIFNR	☐	W_LIFNR	LIFNR	CHAR	10	0	Vendor number	LFA1
7	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
8	KUNNR	☐	LOCNR	KUNNR	CHAR	10	0	Customer Number for Plant	KNA1
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	LIFTY	☐	W_LIFTY	LIFTY	CHAR	1	0	Vendor Category - Retail
11	RELIF	☐	RELIF	XFELD	CHAR	1	0	Regular Vendor
12	VZWRK	☐	W_VZWERK	WERKS	CHAR	4	0	Plant number for vendor number of DC	T001W
13	BZQFI	☐	BZQFI	BZQFI	CHAR	1	0	ID: how source of supply is determined
14	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
15	PLEKP	☐	W_PLEKP	PREIS	CURR	11	2	Purchase price for promotion item
16	WAEEK	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
17	EPEIN	☐	EPEIN	DEC5	DEC	5	0	Price unit
18	MEBPR	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
19	EKKPS	☐	W_EKKPS	EKKPS	CHAR	1	0	Maintenance status of purchase price conditions
20	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
21	EXTLI	☐	W_EXTLI	LIFNR	CHAR	10	0	External vendor	LFA1
22	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
23	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
24	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
25	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
26	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
27	SELKZ	☐	XFELD	XFELD	CHAR	1	0	Checkbox
28	ICON	☐	CLICON	CHAR50	CHAR	50	0	Classification status: icon
29	FOLNR	☐	W_FOLNR	NUMC2	NUMC	2	0	Subsequent no. for plant-specific DC records
30	VZVKO	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
31	VZVTW	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
32	VZSPA	☐	SPART	SPART	CHAR	2	0	Division	*
33	VTLSP	☐	W_VTLSP	FLAG	CHAR	1	0	Distribution chain check

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WAALD	AKTNR	WAKH	AKTNR		C	N
2	WAALD	ARTNR	MARA	MATNR		C	N
3	WAALD	EKGRP	T024	EKGRP		C	N
4	WAALD	EKORG	T024E	EKORG		C	N
5	WAALD	EXTLI	LFA1	LIFNR		C	N
6	WAALD	KUNNR	KNA1	KUNNR		C	N
7	WAALD	LIFNR	LFA1	LIFNR		C	N
8	WAALD	MANDT	T000	MANDT
9	WAALD	MEBME	T006	MSEHI		C	N
10	WAALD	MEBPR	T006	MSEHI		C	N
11	WAALD	VZWRK	T001W	WERKS		C	N
12	WAALD	WAEEK	TCURC	WAERS		C	N
13	WAALD	WERKS	T001W	WERKS		C	N

History

Last changed by/on	SAP	20130529
SAP Release Created in