topic Re: internal table in Application Development and Automation Discussions

internal table

Former Member — Wed, 09 Jan 2008 08:42:25 GMT

Hi all,

in my internal table i don't want fields to be repeated with same material number. i.e. if a particular material number is there in table, it shouldn't get the same material number againg. how shall i do that.

kindly help me.

regards,

karthi.

Re: internal table

Former Member — Wed, 09 Jan 2008 08:43:45 GMT

In your select query use Syntax Select Distinct MATNR....

Regards,

Satish

Re: internal table

Former Member — Wed, 09 Jan 2008 08:44:56 GMT

Hi Subramanaian,

Use APPEND in ur code.

Thankyou,

Regards.

Re: internal table

JozsefSzikszai — Wed, 09 Jan 2008 08:45:09 GMT

hi,

SORT itab BY matnr ...

DELETE ADJACENT DUPLICATES itab COMPARING matnr.

Re: internal table

Former Member — Wed, 09 Jan 2008 08:45:33 GMT

Hi,

Data: check type matnr.

Loop at itab.

if itab-matnr = check.

delete itab.

endif.

check = itab-matnr.

endloop.

Re: internal table

Former Member — Wed, 09 Jan 2008 08:45:59 GMT

Hi,

If you want unique material number in internal table

USe DELETE ADJACENT DUPLICATE statement .

If you are fetching Ztable data with internal table and u want unique material data then use FOR ALL ENTERIES

Select ....

From Ztable

FOR ALL ENTRIES IN itab

where matnr = itab-matnr.

FOR ALL ENTRIES will avoid duplicate values.

Re: internal table

Former Member — Wed, 09 Jan 2008 08:50:22 GMT

Hi Karthi,

Define your internal table as sorted internal table with unique key as MATNR. This will make sure your internal table will allow first entry to be appended - others will return non-zero sy-subrc..

Regards,

Mohaiyuddin

Re: internal table

Former Member — Wed, 09 Jan 2008 08:51:04 GMT

Hi,

You can use the key word distinct as mentioned in the above post or you can also

sort the table after selecting all the contents of the internal table using that material number

field then you can delete the adjacent entries in the table which will eliminate the duplicates

ex:-

SORT it_work BY arbpl.

DELETE ADJACENT DUPLICATES FROM it_work COMPARING arbpl.

Reward is useful.

Re: internal table

Former Member — Wed, 09 Jan 2008 08:51:06 GMT

Oh my goodness.... this can´t be serious!

"Loop at itab.

if itab-matnr = check.

delete itab.

endif.

check = itab-matnr.

endloop."

Use the DELETE ADJACENT statement but keep in mind that you MUST sort the table by material number first.

Re: internal table

Former Member — Wed, 09 Jan 2008 08:51:42 GMT

Hi ,

If you want to have such a case then your internal table must be a sorthed table with unique key , but then you need to check/modify your code to satisfy the requirement of a sorted table , if you want to use a standard / normal internal ttable then you have to check for existance of the material in the table before you try to insert it.

Regards

Arun