topic Re: internal table question? in Application Development and Automation Discussions

internal table question?

Former Member — Thu, 20 Sep 2007 21:31:40 GMT

Hi,

1)i have internal table with material ,plant , stlal fields.

for same material and plant ...stlal has different values.

so i have select the material and plant which has minimum stlal value.

please tell how to select the value ..or pls give me sample code.

2) i have internal table with material number and plant.

There may be more than on material for same plant.

so i have to pass material numbers and plant to other program based on plant wise.

please give me sample code ... other program has selection screen which has material number as selection option and plant as parameter.

i have to use submit statement for this condition.

please help by giving sample code

thanks

satish

Re: internal table question?

Former Member — Fri, 21 Sep 2007 01:43:26 GMT

Ans1. Suppose ur internal table name is itab containing 3 fields matnr,werks,stlal.Now u want the mat and plant with min stlal value.heres the code

sort itab by stlal descending.

read table itab into ls_tab index 1.

Now ls_tab is a work area which will contain the material and plant values which has min stlal value.

Ans2.

Declare a range table lt_matnr for all the material no corresponding to the plant.

Now

Loop at itab into ls_tab where plant = lv_plant.

ls_matnr-sign = 'I'.

ls_matnr-option='EQ'.

ls_matnr-low = ls_tab-matnr.

Append ls_matnr to lt_matnr.

Clear ls_matnr,ls_tab.

Endloop.

so now lt_matnr will contain all the matnr corresponding to each plant.

thanks,

ashish.

Re: internal table question?

Former Member — Fri, 21 Sep 2007 01:52:00 GMT

I have seen answer suggested by Ashish.

Question 2 is answered correctly.

For question 1

select matnr werks stlal into itab.

sort itab.

delete adjacent duplicates from itab comparing matnr werks.

This will delete duplicate entries from itab for each material and plat. As this is sorted ascending first record will contain min value for STLAL and this is your requirement.

In itab declaration, field sequence should be MATNR WERKS STLAL.

Re: internal table question?

Former Member — Fri, 21 Sep 2007 02:28:45 GMT

hi ashish d,

thanks for your answer...how to declare ranges can u pls given example...

thanks

satish

Re: internal table question?

Former Member — Fri, 21 Sep 2007 02:36:10 GMT

ranges: r_matnr for mara-matnr.

This is the way you declare ranges.

Re: internal table question?

Former Member — Fri, 21 Sep 2007 03:01:30 GMT

HI,

how to write full code..i m getting error..

ranges : ls_matnr for mara-matnr.

Loop at itab into ls_tab where plant = lv_plant.

ls_matnr-sign = 'I'.

ls_matnr-option='EQ'.

ls_matnr-low = ls_tab-matnr.

Append ls_matnr to lt_matnr.

Clear ls_matnr,ls_tab.

Endloop.

wt is ls_tab...wt is lv_plant..

can u pls explain..

please

thanks

satish

Re: internal table question?

Former Member — Fri, 21 Sep 2007 03:05:05 GMT

ranges : ls_matnr for mara-matnr.

Loop at itab into ls_tab where plant = lv_plant.

ls_matnr-sign = 'I'.

ls_matnr-option='EQ'.

ls_matnr-low = ls_tab-matnr.

Append ls_matnr.

Clear ls_matnr.

Endloop.

This will populate all material values to ranges LS_MATNR which you can pass to other program. It will act as a select option.

Re: internal table question?

Former Member — Fri, 21 Sep 2007 03:31:43 GMT

hi,

wr will we get the value of lv_plant ? in internal table of i have plant ,material number values..

please explain..i m fresher...i m doing one samll example ..please

Re: internal table question?

Former Member — Fri, 21 Sep 2007 03:32:40 GMT

one more doubt

Re: internal table question?

Former Member — Fri, 21 Sep 2007 03:39:03 GMT

You have internal table with plant and material. One Plant can have multiple Material entries.

So for the Plant entry of internal table, you are populating all materials into ranges.

Re: internal table question?

Former Member — Fri, 21 Sep 2007 03:43:25 GMT

ya that is correct. How i will get the value of lv_plant from internal table.

thanks

satish

Re: internal table question?

KN-Nampoothiry — Fri, 21 Sep 2007 04:04:43 GMT

Hi Dude,

as said above in all posts, once you sort the itab ascending based on the stlal value, the entry with the least stlal value is on top.

So use this.

data : wa_itab type itab. " To decalre a work area in case your itab has no header line.

then

sort itab asecnding by stlal.
read table itab into wa_itab index 1.
lv_palnt = wa_itab-plant

if your itab has header line then code chabges as :

sort itab asecnding by stlal.
read table itab  index 1.
lv_palnt = itab-plant.

Reward if useful.