SAP ABAP Table WAAL (Material-to-vendor assignment in price maintenance (promo.))
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ WAKT (Package) Application development R/3 Promotions
Basic Data
Table Category TRANSP    Transparent table 
Transparent table WAAL   Table Relationship Diagram
Short Description Material-to-vendor assignment in price maintenance (promo.)    
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 AKTNR WAKTION WAKTION CHAR 10   0   Promotion WAKH
3 ARTNR MATNR MATNR CHAR 18   0   Material Number MARA
4 MEBME W_MEBME MEINS UNIT 3   0   Sales unit T006
5 LIFNR W_LIFNR LIFNR CHAR 10   0   Vendor number LFA1
6 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
7 KUNNR LOCNR KUNNR CHAR 10   0   Customer Number for Plant KNA1
8 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
9 LIFTY W_LIFTY LIFTY CHAR 1   0   Vendor Category - Retail  
10 RELIF RELIF XFELD CHAR 1   0   Regular Vendor  
11 VZWRK W_VZWERK WERKS CHAR 4   0   Plant number for vendor number of DC T001W
12 BZQFI BZQFI BZQFI CHAR 1   0   ID: how source of supply is determined  
13 EKGRP EKGRP EKGRP CHAR 3   0   Purchasing group T024
14 PLEKP W_PLEKP PREIS CURR 11   2   Purchase price for promotion item  
15 WAEEK W_WAEEK WAERS CUKY 5   0   Purchase price currency TCURC
16 EPEIN EPEIN DEC5 DEC 5   0   Price unit  
17 MEBPR BBPRM MEINS UNIT 3   0   Order Price Unit (purchasing) T006
18 EKKPS W_EKKPS EKKPS CHAR 1   0   Maintenance status of purchase price conditions  
19 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
20 EXTLI W_EXTLI LIFNR CHAR 10   0   External vendor LFA1
21 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
22 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
23 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
24 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 WAAL AKTNR WAKH AKTNR C N
2 WAAL ARTNR MARA MATNR C N
3 WAAL EKGRP T024 EKGRP C N
4 WAAL EKORG T024E EKORG C N
5 WAAL EXTLI LFA1 LIFNR C N
6 WAAL KUNNR KNA1 KUNNR C N
7 WAAL LIFNR LFA1 LIFNR C N
8 WAAL MANDT T000 MANDT    
9 WAAL MEBME T006 MSEHI C N
10 WAAL MEBPR T006 MSEHI C N
11 WAAL VZWRK T001W WERKS C N
12 WAAL WAEEK TCURC WAERS C N
13 WAAL WERKS T001W WERKS C N
History
Last changed by/on SAP  20110901 
SAP Release Created in