topic Copy ABAP Query in Application Development and Automation Discussions

Copy ABAP Query

bjorn-henrik_zink — Wed, 21 Jun 2006 09:28:17 GMT

Hi,

I have copied an ABAP Query program AQ* to a custom Z* program. When executing the program via F8, I find that the selection screens differ. Anyone who can explain why? Is it possible to have the same selection screen in my custom Z* program?

Thanks.

/Elvez

Re: Copy ABAP Query

santhosh_patil — Wed, 21 Jun 2006 09:32:48 GMT

hi,

In what way it is different..?

whether..

some selection fields are missing or

some selection text is missing..?

Re: Copy ABAP Query

Former Member — Wed, 21 Jun 2006 09:32:51 GMT

this is the fault u copy abap query to a another program. it show the selection screen of z programm.

u genrate programm from abap query using sq01.

Re: Copy ABAP Query

Former Member — Wed, 21 Jun 2006 09:34:18 GMT

Hi Elvez ,

SAP query Program is Client Dependent.

Regards

Prabhu

Re: Copy ABAP Query

bjorn-henrik_zink — Wed, 21 Jun 2006 09:36:43 GMT

Hi Kishan,

the problem is that I want to control the name of the program. The reason for copying the sq01 generated program is that I don't want somebody to overwrite the program by mistake.

/Elvez

Re: Copy ABAP Query

Former Member — Wed, 21 Jun 2006 09:39:55 GMT

1) Execute the query from SQ01.

2) GO TO SE38.. you can see the name of the query program.

3) Press copy and make a new program.

rgds,

TM.

Re: Copy ABAP Query

bjorn-henrik_zink — Wed, 21 Jun 2006 09:40:36 GMT

Hi Thomas,

that is what I did.

/Elvez

Re: Copy ABAP Query

bjorn-henrik_zink — Wed, 21 Jun 2006 09:41:40 GMT

Hi SanthoshKumar,

nothing is missing, but other selection fields are displayed. Here is an example:

AQ* Selection:

Personnel number

Employment statu

Personnel area

Personnel subare

Employee group

Employee subgrou

Z* Selection:

Personnel number

Employment status

Company code

Payroll area

Pers.area/subarea/cost c

Employee group/subgroup

/Elvez

Re: Copy ABAP Query

bjorn-henrik_zink — Wed, 21 Jun 2006 09:43:39 GMT

Hi Prabhu,

thanks for the infomation, both programs are run in the same client.

/Elvez

Re: Copy ABAP Query

Former Member — Wed, 21 Jun 2006 09:48:05 GMT

do one thing...

1) go to se38.

2)enter query program name which is genrated

3)copy programm to ur z programm with all include(using copy button in se38).

4) now execute.

it is workin.

Re: Copy ABAP Query

bjorn-henrik_zink — Wed, 21 Jun 2006 10:02:41 GMT

Hi Kishan,

that is what I did. The program is working fine, but the selection screens differ.

/Elvez

Re: Copy ABAP Query

Former Member — Wed, 21 Jun 2006 10:09:42 GMT

it is fine with my system...

delete z programm and try once again.....

Re: Copy ABAP Query

Former Member — Wed, 21 Jun 2006 10:37:11 GMT

hi ,

check the two include programs of that Copied Quety program.


include /1bcdwb/iq000000000051sscr.
include /1bcdwb/iq000000000051sscrat.
<b>*----------------------------------------------------------------
*    include /1BCDWB/IQ000000000051SSCR
*----------------------------------------------------------------

selection-screen begin of block qsel
                          with frame title text-s02.
select-options sp
include /1bcdwb/iq000000000051sscr.
include /1bcdwb/iq000000000051sscrat.
<b>*----------------------------------------------------------------
*    include /1BCDWB/IQ000000000051SSCR
*----------------------------------------------------------------

selection-screen begin of block qsel
                          with frame title text-s02.
select-options sp$00001 for mast-matnr.
select-options sp$00002 for mast-werks.
selection-screen end of block qsel.
selection-screen begin of block stdsel with frame title text-s03.
parameters %layout type slis_vari modif id lay.
selection-screen end of block stdsel.</b>
 for mast-matnr.
select-options sp[code]
include /1bcdwb/iq000000000051sscr.
include /1bcdwb/iq000000000051sscrat.
<b>*----------------------------------------------------------------
*    include /1BCDWB/IQ000000000051SSCR
*----------------------------------------------------------------

selection-screen begin of block qsel
                          with frame title text-s02.
select-options sp$00001 for mast-matnr.
select-options sp$00002 for mast-werks.
selection-screen end of block qsel.
selection-screen begin of block stdsel with frame title text-s03.
parameters %layout type slis_vari modif id lay.
selection-screen end of block stdsel.</b>
[/code]2 for mast-werks.
selection-screen end of block qsel.
selection-screen begin of block stdsel with frame title text-s03.
parameters %layout type slis_vari modif id lay.
selection-screen end of block stdsel.</b>

check ur selection screen with query selectino screen., first one for Selection Screen and second one for layout.

regards

Prabhu

Re: Copy ABAP Query

bjorn-henrik_zink — Wed, 21 Jun 2006 10:43:13 GMT

Did you change any of the selection criteria in your ABAP query?

/Elvez

Re: Copy ABAP Query

bjorn-henrik_zink — Wed, 21 Jun 2006 11:35:06 GMT

Dear all,

thanks for your contributions, however, I solved the problem myself. Here is what I was looking for:

1) se38

2) select Attributes and press Display

3) Press HR report category

4) Assign the Master data rep. class

Thats it.

/Elvez