Skip to Content
0
Former Member
Feb 26, 2008 at 05:27 PM

SHORT DUMP IN SELECT STATEMENT

153 Views

Hi Guys!

I´m making a badi in BW, but i have a problem with a select statement that gets me a dump, can you help me to fix it.? the code is:

TYPES: BEGIN OF tp_mat_sales,

salesorg TYPE /bi0/pmat_sales-salesorg,

distr_chan TYPE /bi0/pmat_sales-distr_chan,

mat_sales TYPE /bi0/pmat_sales-mat_sales,

fcushpdt TYPE /bi0/pmat_sales-/bic/fcushpdt,

commmgmt TYPE /bi0/pmat_sales-/bic/commmgmt,

END OF tp_mat_sales.

DATA: t_mat_sales TYPE HASHED TABLE OF tp_mat_sales WITH UNIQUE KEY mat_sales salesorg distr_chan,

i_mat_sales TYPE tp_mat_sales.

SELECT salesorg distr_chan mat_sales /bic/commmgmt

INTO TABLE t_mat_sales

FROM /bi0/pmat_sales

FOR ALL ENTRIES IN t_data_in

WHERE mat_sales = t_data_in-mat_sales

AND salesorg = t_data_in-salesorg

AND distr_chan = t_data_in-distr_chan

AND objvers = 'A'.

Regards!!