topic Re: report inside - programmer outside in Application Development and Automation Discussions

report inside - programmer outside

Former Member — Mon, 18 Aug 2008 06:51:16 GMT

Hi ,

plz check my code , its syntacically correct but i was unable to retrieve the data

REPORT zdc_rep_bdc_as01_test .

TABLES : anla,

ra02s,

anlz,

anlb.

**************************************************************

D A T A D E C L A R A T I O N

**************************************************************

data : begin of it_anla occurs 0,

anlkl LIKE anla-anlkl,

bukrs LIKE anla-bukrs,

txt50 LIKE anla-txt50,

menge like anla-menge,

aktiv like anla-aktiv,

end of it_anla.

data : begin of it_anlz occurs 0,

gsber LIKE anlz-gsber,

kostl LIKE anlz-kostl,

werks LIKE anlz-werks,

stort LIKE anlz-stort,

end of it_anlz.

data : begin of it_anlb occurs 0,

ndjar LIKE anlb-ndjar,

ndper LIKE anlb-ndper,

ndjar1 LIKE anlb-ndjar,

ndper1 LIKE anlb-ndper,

end of it_anlb.

DATA : BEGIN OF i_itab OCCURS 0,

anlkl LIKE anla-anlkl,

bukrs LIKE anla-bukrs,

nassets LIKE ra02s-nassets,

txt50 LIKE anla-txt50,

menge(18), " like anla-menge,

meins LIKE anla-meins,

aktiv(10)," like anla-aktiv,

gsber LIKE anlz-gsber,

kostl LIKE anlz-kostl,

werks LIKE anlz-werks,

stort LIKE anlz-stort,

ndjar LIKE anlb-ndjar,

ndper LIKE anlb-ndper,

ndjar1 LIKE anlb-ndjar,

ndper1 LIKE anlb-ndper,

END OF i_itab.

selection-screen begin of block b1 with frame title text-001.

parameter : p_bukrs like it_anla-bukrs.

selection-screen end of block b1.

START-OF-SELECTION.

PERFORM retrieve_data.

PERFORM display_data.

&----

*& Form retrieve_data

&----

text

----

--> p1 text
<-- p2 text

----

form retrieve_data.

select anlkl bukrs txt50 menge aktiv from anla into corresponding

fields of table it_anla

where bukrs = it_anla-bukrs.

*check not it_anla[] is initial.

*select gsber kostl werks stort from anlz into table it_anlz

*for all entries in it_anla where bukrs = it_anla-bukrs.

*check not it_anla[] is initial.

*select ndjar ndper from anlb into table it_anlb

*for all entries in it_anla where bukrs = it_anla-bukrs.

endform. " retrieve_data

&----

*& Form display_data

&----

text

----

--> p1 text
<-- p2 text

----

form display_data.

write 😕 it_anla-anlkl, it_anla-bukrs, it_anla-txt50, it_anla-menge,

it_anla-aktiv,

it_anlz-gsber, it_anlz-kostl,

it_anlz-werks, it_anlz-stort, it_anlb-ndjar, it_anlb-ndper.

endform. " display_data

Edited by: Julius Bussche on Aug 18, 2008 7:56 AM

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 06:53:45 GMT

Hi,

you need to loop before you can display the datas.

loop at it_anla.

PERFORM display_data.

endloop.

regards

Nicole

Re: report inside - programmer outside

Mohamed_Mukhtar — Mon, 18 Aug 2008 06:55:42 GMT

hi,

Chech this code

form retrieve_data.

select anlkl bukrs txt50 menge aktiv from anla into corresponding

fields of table it_anla

where bukrs = p_bukrs. "itab-burks.

With regards

Always Learner

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:00:23 GMT

Hi Friend,

Change the Select Statement WHERE Condition

Check this:

select anlkl bukrs txt50 menge aktiv from anla into corresponding

fields of table it_anla

where bukrs = p_bukrs.

And Moreover, you need to maintain a loop-endloop to display the data.

Regards,

Chandra Sekhar

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:00:41 GMT

You have to do two things :

1. remove condition WHERE bukrs = it_anla-bukrs

use WHERE bukrs = p_bukrs.

2. Loop before displaying

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:03:38 GMT

i have done it but when we r executing no output but processing is going

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:03:55 GMT

i have done it but when we r executing no output but processing is going

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:04:20 GMT

i have done it but when we r executing no output but processing is going

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:07:38 GMT

Hi,

set a break-point after the select-statement and take a look if the internal table is filled.

If not, your select is false.

Nicole

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:07:59 GMT

Hi Friend,

You need to use loop-endloop to display the data.

form display_data.

loop at it_anla

write 😕 it_anla-anlkl, it_anla-bukrs, it_anla-txt50, it_anla-menge,

it_anla-aktiv,

it_anlz-gsber, it_anlz-kostl,

it_anlz-werks, it_anlz-stort, it_anlb-ndjar, it_anlb-ndper.

endloop.

endform. " display_data

Regards,

Chandra Sekhar

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:16:03 GMT

Hi Friend,

I am getting the output with loop-endloop.

Regards,

Chandra Sekhar

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:17:16 GMT

Hi i kept breah point on select stmt ok

filling the data into first internal table ie it_anla

but when cursor come to 2nd internal table ie it_anlz using the for all entries not getting data and is going to dump

once check my for all entries stmt

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:17:43 GMT

Hi i kept breah point on select stmt ok

filling the data into first internal table ie it_anla

but when cursor come to 2nd internal table ie it_anlz using the for all entries not getting data and is going to dump

once check my for all entries stmt

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:18:37 GMT

Hi i kept breah point on select stmt ok

filling the data into first internal table ie it_anla

but when cursor come to 2nd internal table ie it_anlz using the for all entries not getting data and is going to dump

once check my for all entries stmt

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:18:51 GMT

put sy-subrc aftr select

if sy-subrc eq 0.

loop at table.

endif.

You put the loop for displaying the data .

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:23:41 GMT

use INTO CORRESPONDING FIELDS OF TABLE

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:28:29 GMT

once check this i am not getting

form retrieve_data.

select anlkl bukrs txt50 menge aktiv from anla into corresponding

fields of table it_anla

where bukrs = p_bukrs.

if not it_anla[] is initial.

select gsber kostl werks stort from anlz into corresponding fields of

table it_anlz for all entries in it_anla where bukrs = it_anla-bukrs.

check not it_anla[] is initial.

select ndjar ndper from anlb into corresponding fields of table it_anlb

for all entries in it_anla where bukrs = it_anla-bukrs.

endif.

endform. " retrieve_data

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:29:01 GMT

once check this

form retrieve_data.

select anlkl bukrs txt50 menge aktiv from anla into corresponding

fields of table it_anla

where bukrs = p_bukrs.

if not it_anla[] is initial.

select gsber kostl werks stort from anlz into corresponding fields of

table it_anlz for all entries in it_anla where bukrs = it_anla-bukrs.

check not it_anla[] is initial.

select ndjar ndper from anlb into corresponding fields of table it_anlb

for all entries in it_anla where bukrs = it_anla-bukrs.

endif.

endform. " retrieve_data

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:30:39 GMT


> once check this i am not getting
>

this is your code.. so you do it.

SDN is not a coaching center.

Re: report inside - programmer outside

Former Member — Mon, 18 Aug 2008 07:34:52 GMT

hello , my code was executing but not getting data that is my doubt ok if u can clarify it u do otherwise dont send that kind of answers