topic Re: Problem with logic in Application Development and Automation Discussions

Problem with logic

Former Member — Thu, 28 Feb 2008 17:30:16 GMT

Hello Experts.

i have 5 items in a table itab1.

item delivery num

10 2100000000

20 2100000030

...

... my query is like this

Loop at itab1.

....

...

SELECT SINGLE a~vtext INTO (tvkggt-text)

FROM vbkd AS a

INNER JOIN tvkggt AS b

ON a_{kdkg1 = b}kdkgr

WHERE a~vbeln EQ itab1-vbeln_vauf

AND a~posnr EQ itab1-posnr_vauf.

.....

....

endloop.

this tvkggt-text is used in printing the text in the layout.tvkggt table will have the text .according to the above query the last line item text will be picked and that will be

printed .

ex : 10 2100000000 sap

20 2100000030 oracle

30 2200000021 myapps

40 2300030000 java

50 2399990000 cobal

in the above case according to our query the text cobal will be taken into tvkggt-text and that will be printed. My requirement is that if text java is there for any line item it may be 1st one or 3rd one etc , then hjave to be printed not the last item text . if oracle is there but not java then oracle should be given preference. if both java and cobal is there then

java should be given preference. If both are not there at that time the last line

item text should be printed. I made some changes to above query but not completed.

so please help me to achieve it. we should not write outside the loop of itab1 because there are some more statements to it.now i declared another internal table itab2 with field text. my new Modified query is like this

Loop at itab1.

---

SELECT single b~vtext INTO ltab2

FROM vbkd AS a

INNER JOIN tvkggt AS b

ON a_{kdkg1 = b}kdkgr

WHERE a~vbeln EQ itab1-vbeln_vauf

AND a~posnr EQ itab2-posnr_vauf.

append itab2.

.....

...

endloop.

so please tell me how to achieve this.

thank you all for the valuable replies

Edited by: Alvaro Tejada Galindo on Feb 28, 2008 12:43 PM

Re: Problem with logic

Former Member — Thu, 28 Feb 2008 17:42:44 GMT

Madan,

This seems to be simple but the way oyu have explained is making difficult to understand.

i am trying to give you certian steps if you follow them i guess you can write the logic for your own.

1. first thing avoid selct in side loop(that to avaoid join )

2. you can use for all entries clause an dfetch all the text values in one data base read.

3. use loop and read combination for further processin and fetch all the texts in one internal table.

loop at itab1 into wa_itab1.

read table itab2 into wa_itab2 with key ......

if sy-subrc = 0.

move itab2-text to itab3-text.

append itab3.

endif.

now loop on itab3 and

process further as per your requirement..

like...

loop at itab3 into wa_itab3.

if wa_itab3 = 'JAVA...

endif.

Re: Problem with logic

Former Member — Thu, 28 Feb 2008 17:45:35 GMT

Also if no. of records are only 5 and if they will not change in no.

then simply take 5 string variables, get the value of text in each varaible and compare them laterwords as per the required sequence and get the final text printed. then it will be a case of simple if ...elseif...endif statemenst.