SAP ABAP Table WALED (Processing of records in WALE table)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MD-PCT (Application Component) Product Catalog
⤷ WAKT (Package) Application development R/3 Promotions
⤷ CRM-MD-PCT (Application Component) Product Catalog
⤷ WAKT (Package) Application development R/3 Promotions
Basic Data
Table Category | INTTAB | Structure |
Structure | WALED | Table Relationship Diagram |
Short Description | Processing of records in WALE table |
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 store assignment to promotion | |||||
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 | KUNNR | LOCNR | KUNNR | CHAR | 10 | 0 | Customer Number for Plant | KNA1 | |
7 | CLINT | CLINT | CLINT | NUMC | 10 | 0 | Internal Class Number | KLAH | |
8 | WALNR | WA_WALNR | WA_NUM10 | NUMC | 10 | 0 | Plant - material of promotion in message control | ||
9 | AKTHE | W_AKTHE | THEMA | CHAR | 4 | 0 | Promotion theme | TWAT | |
10 | ERLIS | ERLIS | ERLIS | CHAR | 1 | 0 | Error cat. after listing rule check | ||
11 | GENLI | W_GENLI | FLAG | CHAR | 1 | 0 | Execute generation if listing check error detected | ||
12 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
13 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
14 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
15 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
16 | EKGRP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
17 | LIFNR | W_LIFNR | LIFNR | CHAR | 10 | 0 | Vendor number | LFA1 | |
18 | LIFTY | W_LIFTY | LIFTY | CHAR | 1 | 0 | Vendor Category - Retail | ||
19 | VZWRK | W_VZWERK | WERKS | CHAR | 4 | 0 | Plant number for vendor number of DC | T001W | |
20 | INFWK | INFWK | XFELD | CHAR | 1 | 0 | Info record at plant level | ||
21 | VZEKO | VZEKORG | EKORG | CHAR | 4 | 0 | Purchasing organization of distribution center | T024E | |
22 | VZVKO | VZVKORG | VKORG | CHAR | 4 | 0 | Sales organization of distribution center | TVKO | |
23 | VZVTW | VZVTWEG | VTWEG | CHAR | 2 | 0 | Distribution channel of distribution center | TVTW | |
24 | VZSPA | VZSPART | SPART | CHAR | 2 | 0 | Division of distribution center | TSPA | |
25 | EXTLI | W_EXTLI | LIFNR | CHAR | 10 | 0 | External vendor | LFA1 | |
26 | BZQFI | W_BZQFI | BZQFA | CHAR | 1 | 0 | Supply Source Determination Status | ||
27 | BEKTB | W_BEKTB | AAVIT | CHAR | 4 | 0 | Announcement category - plant | T626 | |
28 | BEKTV | W_BEKTV | AAVIT | CHAR | 4 | 0 | Announcement category - distribution center | T626 | |
29 | ABDTB | AFIDT | DATUM | DATS | 8 | 0 | Confirmation request date | ||
30 | RUDAB | W_RUDAB | DATUM | DATS | 8 | 0 | Reply date plant | ||
31 | RUDAV | W_RUDAV | DATUM | DATS | 8 | 0 | Reply date DC | ||
32 | RUSTB | W_RUSTB | XFELD | CHAR | 1 | 0 | Status of reply to announcement - plant | ||
33 | RUSTV | W_RUSTV | XFELD | CHAR | 1 | 0 | Status of reply to announcement - DC | ||
34 | BESTB | W_BESTB | XFELD | CHAR | 1 | 0 | Confirmation can be carried out for plant | ||
35 | BESTV | W_BESTV | XFELD | CHAR | 1 | 0 | Confirmation can be carried out for DC | ||
36 | AENDB | W_AENDB | XFELD | CHAR | 1 | 0 | Send change to plant | ||
37 | AENDV | W_AENDV | XFELD | CHAR | 1 | 0 | Send change to DC | ||
38 | PLEKP | W_PLEKP_WALE | PREIS | CURR | 11 | 2 | Basic purchase price (gross) per plant/material | ||
39 | WAEEK | W_WAEEK | WAERS | CUKY | 5 | 0 | Purchase price currency | TCURC | |
40 | PLVKP | W_PLVKP | PREIS | CURR | 11 | 2 | Sales price for promotion item | ||
41 | WAELA | W_WAELA | WAERS | CUKY | 5 | 0 | Currency current promotion - planning | TCURC | |
42 | EKDAB | W_EKDAB | DATUM | DATS | 8 | 0 | Purchase price conditions valid from | ||
43 | EKDBI | W_EKDBI | DATUM | DATS | 8 | 0 | Purchase price conditions valid to | ||
44 | VKDAB | W_VKDAB | DATUM | DATS | 8 | 0 | On Sale to Consumers From | ||
45 | VKDBI | W_VKDBI | DATUM | DATS | 8 | 0 | On Sale To Consumers To | ||
46 | SPANE | SPANE | WERTV6 | CURR | 11 | 2 | Margin (net) in sales price calculation | ||
47 | SPABR | SPABR | WERTV6 | CURR | 11 | 2 | Margin (gross) in sales price calculation | ||
48 | AUFSG | AUFSG | WERTV6 | CURR | 11 | 2 | Actual Markup in Sales Price Calculation | ||
49 | VSPAN | W_SPANE | WERTV6 | CURR | 11 | 2 | Net warehouse margin | ||
50 | VSPAB | W_SPABR | WERTV6 | CURR | 11 | 2 | Gross warehouse margin | ||
51 | VAUFS | W_AUFSG | WERTV6 | CURR | 11 | 2 | Warehouse markup | ||
52 | VABGM | W_MEBME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
53 | VABGP | W_VABGP | PREIS | CURR | 11 | 2 | Transfer price, distribution center | ||
54 | PARKZ | W_PARKZ | W_PARKZ | CHAR | 1 | 0 | Price type indicator (gross, net) | ||
55 | EPEIN | EPEIN | DEC5 | DEC | 5 | 0 | Price unit | ||
56 | VZEPE | W_VZEPE | DEC5 | DEC | 5 | 0 | Price unit Transfer price DC | ||
57 | VPEIN | VPEIN | DEC5 | DEC | 5 | 0 | Sales price unit | ||
58 | MEBPR | BBPRM | MEINS | UNIT | 3 | 0 | Order Price Unit (purchasing) | T006 | |
59 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
60 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
61 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
62 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
63 | LIGEN | W_LIGEN | LIGEN | CHAR | 1 | 0 | Listing generation status | ||
64 | AUGEN | W_AUGEN | AKAST | CHAR | 1 | 0 | Allocation table creation status | ||
65 | VKGEN | W_VKGEN | VKKPS | CHAR | 1 | 0 | Sales price generation status | ||
66 | EKGEN | W_EKGEN | EKKPS | CHAR | 1 | 0 | Purchase price generation status | ||
67 | BEGEB | W_BEGEB | BEKST | CHAR | 1 | 0 | Generation status of announcement - plant | ||
68 | BEGEV | W_BEGEV | BEKST | CHAR | 1 | 0 | Announcement status - DC | ||
69 | BEDEB | W_BEDEB | BEDEB | CHAR | 1 | 0 | Detailed status of promotion announcement - plant | ||
70 | BEDEV | W_BEDEV | ABAST | CHAR | 1 | 0 | Detailed status of promotion announcement - DC | ||
71 | RELIF | RELIF | XFELD | CHAR | 1 | 0 | Regular Vendor | ||
72 | ADGEN | W_ADGEN | CHAR1 | CHAR | 1 | 0 | Additionals maintained | ||
73 | WMNGE | WMNGE | MENG13 | QUAN | 13 | 3 | Quantity requested by store | ||
74 | AUFME | W_BESTM | MENG13 | QUAN | 13 | 3 | Corrected/confirmed allocation quantity for a promotion item | ||
75 | PABBM | W_PABBM | MENGE | QUAN | 13 | 3 | Planned Sales Qty. of Promotion Material in Sales Units | ||
76 | MIAMG | W_MIAMG | MENGE | QUAN | 13 | 3 | Minimum order qty for promotional material | ||
77 | EKPNN | W_EKPNN | WERTV6 | CURR | 11 | 2 | Purchase price (net/net) | ||
78 | VKPNN | W_VKPNN | WERTV6 | CURR | 11 | 2 | Sales price (net) | ||
79 | ECKPKZ | F_VKPKZ | FLAG | CHAR | 1 | 0 | Indicates whether price point tables should override price | ||
80 | PAUFME | W_PAUFME | MENG13 | QUAN | 13 | 3 | Planned allocation quantity for promotion item for a plant | ||
81 | ALIVO | ALIVO | DATUM | DATS | 8 | 0 | Starting date for activating DC transfer prices | ||
82 | ALIBI | ALIBI | DATUM | DATS | 8 | 0 | Final date for activating DC transfer prices | ||
83 | EPRGR | EPRGR | EPRGR | CHAR | 6 | 0 | Price point group | * | |
84 | NVKP | W_NVKP_WALE | PREIS | CURR | 11 | 2 | Standard sales price at plant level | ||
85 | SPGRU | W_SPGRU | SPGRU | CHAR | 1 | 0 | Reason for promotion block | ||
86 | SELKZ | SELKZ | SELKZ | CHAR | 1 | 0 | Selection flag | ||
87 | UPDKZ | UPDKZ_D | UPDKZ | CHAR | 1 | 0 | Update indicator | ||
88 | P_WAKP | W_TABIX | W_TABIX | INT4 | 10 | 0 | Pointer to an entry in an internal table | ||
89 | P_WAGU | W_TABIX | W_TABIX | INT4 | 10 | 0 | Pointer to an entry in an internal table | ||
90 | ATTYP | ATTYP | ATTYP | CHAR | 2 | 0 | Material Category | ||
91 | SATNR | SATNR | MATNR | CHAR | 18 | 0 | Cross-Plant Configurable Material | * | |
92 | PMATA | PMATN | MATNR | CHAR | 18 | 0 | Pricing Reference Material | * | |
93 | EKKPS | W_EKKPS | EKKPS | CHAR | 1 | 0 | Maintenance status of purchase price conditions | ||
94 | VKKPS | W_VKKPS | VKKPS | CHAR | 1 | 0 | Maintenance status of sales price conditions | ||
95 | KALKE | W_AKTART | AKTART | CHAR | 1 | 0 | Activation type for sales prices | ||
96 | KALKR | W_KALKR | XFELD | CHAR | 1 | 0 | Reference record for price calculation is used | ||
97 | IMNGU | IMNGU | MENG13 | QUAN | 13 | 3 | Confirmed qty of plant | ||
98 | PMNGU | W_PMNGU | MENG13 | QUAN | 13 | 3 | Planned allocation quantity for an allocation table item | ||
99 | MEAUF | W_MEAUF | MEINS | UNIT | 3 | 0 | Allocation table unit | * | |
100 | VZKPS | W_VZKPS | VZKPS | CHAR | 1 | 0 | Maintenance status of DC conditions | ||
101 | ADDEL | W_ADDEL | CHAR1 | CHAR | 1 | 0 | Additional deleted | ||
102 | REB_STATUS | REB_STATUS | REB_STATUS | CHAR | 1 | 0 | Discount Status |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | WALED | AKTHE | TWAT | AKTHE | KEY | 1 | CN |
2 | WALED | AKTNR | WAKH | AKTNR | KEY | 1 | CN |
3 | WALED | ARTNR | MARA | MATNR | KEY | 1 | CN |
4 | WALED | BEKTB | T626 | AAVIT | |||
5 | WALED | BEKTV | T626 | AAVIT | |||
6 | WALED | CLINT | KLAH | CLINT | |||
7 | WALED | EKGRP | T024 | EKGRP | C | N | |
8 | WALED | EKORG | T024E | EKORG | KEY | 1 | CN |
9 | WALED | EXTLI | LFA1 | LIFNR | |||
10 | WALED | KUNNR | KNA1 | KUNNR | |||
11 | WALED | LIFNR | LFA1 | LIFNR | KEY | 1 | CN |
12 | WALED | MANDT | T000 | MANDT | KEY | 1 | CN |
13 | WALED | MEBME | T006 | MSEHI | KEY | 1 | CN |
14 | WALED | MEBPR | T006 | MSEHI | KEY | 1 | CN |
15 | WALED | SPART | TSPA | SPART | C | N | |
16 | WALED | VABGM | T006 | MSEHI | |||
17 | WALED | VKORG | TVKO | VKORG | KEY | 1 | CN |
18 | WALED | VTWEG | TVTW | VTWEG | KEY | 1 | CN |
19 | WALED | VZEKO | T024E | EKORG | C | N | |
20 | WALED | VZSPA | TSPA | SPART | C | N | |
21 | WALED | VZVKO | TVKO | VKORG | C | N | |
22 | WALED | VZVTW | TVTW | VTWEG | C | N | |
23 | WALED | VZWRK | T001W | WERKS | |||
24 | WALED | WAEEK | TCURC | WAERS | KEY | 1 | CN |
25 | WALED | WAELA | TCURC | WAERS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |