topic Re: problem in sapquery( abap query ) in Application Development and Automation Discussions

problem in sapquery( abap query )

Former Member — Thu, 10 Dec 2009 03:51:09 GMT

Hi All,

I am modifying a standard query . i added 4 fields to the query and maintained coding for that fields and included in a internal table . I have 4 records in internal table.

Problem :

Normally the standard query printing 1 record along with my fields(in standard query only one record is presented ). It is printing last record of my inernal table.But i want the output like 4 records should print (the standard query record should print 4 times with along with my internal table means duplication should maintained).

How to solve this problem

Thanks in advance

Regards,

Sudhakar

Re: problem in sapquery( abap query )

Former Member — Thu, 10 Dec 2009 04:12:18 GMT

You need to populate these new fields into all the records of the resultant table.

Get proper logic to do so and populate these to all records.

Re: problem in sapquery( abap query )

Former Member — Thu, 10 Dec 2009 04:12:42 GMT

HI,

I think you might have used inner join.

Try outer join.

Regards,

Sunny

Re: problem in sapquery( abap query )

Former Member — Thu, 10 Dec 2009 04:35:11 GMT

Hi,

I didnot used any joins.i have written coding in SQ02.But the problem it is printing only one record because for standard query output executes only one time.I want to execuite multiple times of output based upon my internal table.

How to do it?

Regards

Sudhakar

Re: problem in sapquery( abap query )

Former Member — Thu, 10 Dec 2009 04:47:19 GMT

Hi,

Then just append the data in internal table with your own logic.

Regards,

sunny

Re: problem in sapquery( abap query )

Former Member — Thu, 10 Dec 2009 04:59:53 GMT

Hi,

The final internal table is in standard query . How can i get that data ? and how my 4 records will append to final internal table?

How to do it?

Regards,

Sudhakar