topic Re: Abap Query problem in Application Development and Automation Discussions

Abap Query problem

Former Member — Wed, 09 May 2007 05:13:44 GMT

I want to modify the abap query .

In my Query output there are Header and Summary.

Iam giving 2 check box in selection screen 1.Header

2.Summary.

When the user chooses Header it should display only header .

When the user chooses Summary it should display only summary data.

I found Header and summary internal tables.

Iam writing the code like this,

IF p_chkhdr = 'X' and p_chksum = ' '.

CLEAR T01.

REFRESH T01.

ENDIF.

IF p_chkhdr = ' ' and p_chksum = 'X'.

CLEAR %g00.

REFRESH %g00.

ENDIF.

Now my question is under which event i have to write above code in SQ02.

waiting for your response.

excellemt reward is compulsary.

regards,

vijay

Re: Abap Query problem

Former Member — Wed, 09 May 2007 05:18:04 GMT

You can't separate the data like header and summary and write in the Sq01/sq02 query.

You will display the data like one list after selecting required fields from infosets.

You can't keep all conditions like our SE38 report in Sq01.

Reward points if useful

Regards

Anji

Re: Abap Query problem

Former Member — Wed, 09 May 2007 05:18:09 GMT

Hi VijayKumar,

May i know your program so that i can help to my extent. Whats your abap query?

From,

Re: Abap Query problem

Former Member — Wed, 09 May 2007 05:25:26 GMT

This is my Abap Query

AQZZPR==========ZPR60_HCC_FMPD

waiting for your response.

regards,

vijay

Re: Abap Query problem

Former Member — Wed, 09 May 2007 06:09:19 GMT

Any body knows please help on this,

regards,

vijay

Re: Abap Query problem

Former Member — Wed, 09 May 2007 06:27:39 GMT

end-of-selection ==>before list output.

Regards

Prabhu

Re: Abap Query problem

Former Member — Wed, 09 May 2007 06:33:38 GMT

In the end-of-selection ==>before list output.

iam writen below code it is saying please declare T01 table.

In the Query already T01 was declared.

if i declared again it is going dump and saying already T01 is declared.

IF p_chkhdr = 'X' and p_chksum = ' '.

CLEAR T01.

REFRESH T01.

ENDIF.

Re: Abap Query problem

Former Member — Wed, 09 May 2007 08:28:10 GMT

hi,

selection-screen : begin of block blk1 with frame title text-001.

parameters : header_chk1 as checkbox,

summary_chk2 as checkbox.

selection-screen: end of block blk1.

if header_chk1 = 'X'.

select header detais.

elseif summary_chk2 = 'X'.

select summary detais.

endif.

if helpful please reward with points