topic Re: Query Layout in Application Development and Automation Discussions

Query Layout

Former Member — Wed, 26 Oct 2005 10:11:43 GMT

Hello All,

How can we display the List layout of an ABAP Query.

Currently this functionality exists in the standard SQ00.

TA Code SQ00 --> Select the Group

It displays all the Queries under that Group.

select any of the Query and click the 'Layout display' button on the Application tool bar.

Is there an SAP FM which can deliver the same. I need to recreate the same in a ZObject. I am currently on the 4.5 Ver.

Thank you.

-PSK

Re: Query Layout

Former Member — Wed, 26 Oct 2005 11:00:03 GMT

hi,

i don't know about 4.5 version, but u try with this

copy the existing one into new Zquery. then the query will generate one ABAP program you can find out the name of program name by

menu -> query - > More functions - > Display report name

cheers,

sasi

Re: Query Layout

Former Member — Wed, 26 Oct 2005 11:12:00 GMT

Hello Sasi,

Thank you for your posting.

But currently i am looking out for the Query's Layout (This will have only the Header fields of the Output that have been used in the Query, there will be no data displayed in this.)

This functionality gives the end users to First have a look at the Out put fields and if it matches there requirment then they can select the query to execute.

Thank you.

- PSK

Re: Query Layout

andreas_mann3 — Wed, 26 Oct 2005 11:33:15 GMT

hi,

look report rsaqlout - but you've to export some parameters before submitting it - so analyse report

regards Andreas

Re: Query Layout

Former Member — Wed, 26 Oct 2005 11:39:08 GMT

Hi Andreas,

Thank you for your posting.

I included

WHEN 'LOUT'.

DATA: QNAME TYPE QUNAME.

EXPORT HEADQU

DBOP DBSN DBFR DBLF DBSE

DBGR DBLI DBFF DBFM

DBVH DBVS DBRH DBRL

DBPT DBCT

MAXQU_TINDX QUTEXT

HEADSG

DBSA DBSF DBSG DBJT DBJC DBZT DBZC DBZL DBPA DBWR DBFT

MAXSG_TINDX SGTEXT

QNAME

TO MEMORY ID 'AQQDATA'.

SUBMIT RSAQLOUT AND RETURN.

the same into my ZObject and when i start debugging the object i can see the data been picked up. But the Object is failing at

008280 ENDIF.

008290 I = BLDESC-LPOS - 1.

> ASSIGN COL1+I(BLDESC-LENG) TO <F1>.

008310 ASSIGN COL2+I(BLDESC-LENG) TO <F2>.

008320 READ TABLE DBOP WITH KEY SGNA = BLDESC-SGNA

With the info that

Program error: ASSIGN with length 0 in program "RSAQLOUT ".

As Field Symbols have been used i could not see what value is been passed.

Thank you.

- PSK