topic Re: List of checked (marked) fields in basic list querries in Application Development and Automation Discussions

List of checked (marked) fields in basic list querries

Former Member — Tue, 17 Dec 2019 06:54:01 GMT

Is it possible to get list of all marked list fields and selection in all queries (maybe some table) ??

Just all selected below

Re: List of checked (marked) fields in basic list querries

Abinathsiva — Tue, 17 Dec 2019 07:09:18 GMT

Hi Adrian,

Mention exact requirement in question for better understanding.

Re: List of checked (marked) fields in basic list querries

FredericGirod — Tue, 17 Dec 2019 07:34:57 GMT

All the query tables start with AQL

the table your are looking for seams to be AQLDB and is a cluster, you need a code like the standard:

    import headqu clogqu
           dbop dbsn dbfr dblf dblc dbld dbse dbsq
           dbgr dbli dbff dbfm
           dbvh dbvs dbrh dbrl
           dbpt dbct
           maxqu_tindx qutext
           from database aqldb(aq) id l_qukey
           IGNORING CONVERSION ERRORS.

Re: List of checked (marked) fields in basic list querries

Sandra_Rossi — Tue, 17 Dec 2019 08:52:16 GMT

Or at a more abstract layer, use a function module like RSAQ_IMPORT_QUERY...(just one level above IMPORT)

Re: List of checked (marked) fields in basic list querries

Sandra_Rossi — Tue, 17 Dec 2019 09:05:30 GMT

Wasn't RSAQ_IMPORT_QUERY your very first idea? If so, just add it to your answer (NB: the first statement of RSAQ_IMPORT_QUERY is PERFORM import_query, and almost the first statement of import_query is the IMPORT you mention)

By the way, there's also RSAQ_IMPORT_QUERY_AND_INFOSET, and maybe other function modules...

Re: List of checked (marked) fields in basic list querries

Sandra_Rossi — Tue, 17 Dec 2019 09:27:29 GMT

Use a function module like RSAQ_IMPORT_QUERY or RSAQ_IMPORT_QUERY_AND_INFOSET.

Re: List of checked (marked) fields in basic list querries

Former Member — Wed, 18 Dec 2019 08:16:39 GMT

Hello, thanks for your response...

I have about 100 querries and need to extract list of "ticked" checkboxes in columns List Fields and Selection.

Regarding to attached picture:

List fields: Article number, Merchandise Category and Base Unit...

Selection: Article Number, Name of Person etc.

Is this information stored in some table?

Re: List of checked (marked) fields in basic list querries

Former Member — Wed, 18 Dec 2019 08:17:24 GMT

Hi Frederic

Thanks for your answer

Unfortunetly i have blocked ABAP programming in a SAP, is it possible to get it in another way?

Re: List of checked (marked) fields in basic list querries

Sandra_Rossi — Wed, 18 Dec 2019 08:33:45 GMT

It's stored in a table that you can only read with ABAP (ABAP storage).

Re: List of checked (marked) fields in basic list querries

FredericGirod — Wed, 18 Dec 2019 09:12:40 GMT

you will need to program something somewhere, it is not accessing directly by SELECT statement (query)