Internal table update

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi,

please post your select statement.

BR

[Clemenss]

Hi Rajesh,

but that is not properly coming

Sorry I have not got enough visionary ability.

Regards,

Clemens