topic Re: Internal table update in Application Development and Automation Discussions

Internal table update

Former Member — Thu, 07 Jul 2011 06:36:06 GMT

Hi,

I am created a structure in se11 and using that structure i have created one table type variable.

This table type variable,i am using in my function module as export parameter .In my import parameter i am taken one a field type of my structure .

In source code i have written the select statement which retrieve records as per my requirement but problem is that,

one fileld which is blank in some cases where records r not in the database.I have fill that blank filed with corresponding data for another same type fileld. How it is possible.

Please help anyone.

Regards ,

Rajesh

Re: Internal table update

Former Member — Thu, 07 Jul 2011 07:46:29 GMT

Hi,

if you want to replace one field of a line with data from another field of that line, you have to loop at the internal table.

If you want to fill the field with a fixed value you could use "MODYFY itab FROM wa TRANSPORTING field WHERE cond".

Best regards,

Oliver

Re: Internal table update

Former Member — Thu, 07 Jul 2011 09:30:28 GMT

Just loop at your internal table and make use of field symbol.

For example:

Loop at itab assigning <fs_itab> where field eq space.

<fs_itab>-field = value.

Endloop.

Then, update your database table if necessary.

Re: Internal table update

Former Member — Thu, 07 Jul 2011 11:13:15 GMT

Hi,

This question already solved but another problem is that when i retrieve records from both table by using left outer join then records are coming with cross product of both i.e if left table match 4 record and right table match 5 record to a given condition then total records retrieves 20 records.

But i want those records which are only in left table which match or not match with the right table.If match corresponding data will come from right table otherwise that field will blank if not match with right table.

Regards,

Rajesh

Re: Internal table update

Former Member — Thu, 07 Jul 2011 12:21:29 GMT

Hi,

so isn't a INNER JOIN what you are looking for?

Best regards,

Oliver

Edited by: Oliver Hütköper on Jul 7, 2011 2:21 PM

Re: Internal table update

Former Member — Thu, 07 Jul 2011 12:31:51 GMT

Hi,

I want thsi type of results .I used inner join but that is not properly coming . So any syntax if you know please inform me so that i can get the proper result.

Re: Internal table update

Former Member — Thu, 07 Jul 2011 13:19:24 GMT

Hi,

please post your select statement.

Re: Internal table update

Former Member — Thu, 07 Jul 2011 13:34:21 GMT

left inner join is what you should be going for, but until we see your select statement we cant tell you where you go wrong.

Re: Internal table update

Clemenss — Thu, 07 Jul 2011 21:41:29 GMT

Hi Rajesh,

but that is not properly coming

Sorry I have not got enough visionary ability.

Regards,

Clemens