issue with query output display

[Former Member]

Hi ,

I have a custom  SAP query created for tables MARAV , MARM , MBEWV, MARCV, PROPF, MARD, MCHB, MKOL, MLGN , MLGT.

This basically uses logical database MSM , the issue I am facing is when I add some fields to the field group and change the O/P fields to be displayed .

For suppoose I had added fields A, B, C, D to be displayed at the output  by default it is taking Fields A, C, D at the O/P to be displayed, please suggest what is wromng with this query , It is basically using global area.

I am nbot sure on the strange behaviour , Please suggest .

Thanks,

RG

[Former Member]

Hi ,

I have a custom  SAP query created for tables MARAV , MARM , MBEWV, MARCV, PROPF, MARD, MCHB, MKOL, MLGN , MLGT.

This basically uses logical database MSM , the issue I am facing is when I add some fields to the field group and change the O/P fields to be displayed .

For suppoose I had added fields A, B, C, D to be displayed at the output  by default it is taking Fields A, C, D at the O/P to be displayed, please suggest what is wromng with this query , It is basically using global area.

I am nbot sure on the strange behaviour , Please suggest .

Thanks,

RG

[Former Member]

Hi Ramya,

Can you please include your code snippet here..so that we can understand what the issue..

Anyway Field Group is there older version.Now a days no one uses the field Group.

Thanks & Regards

@Surendra@

[Former Member]

[Former Member]

[Former Member]

[Former Member]

[Former Member]

Hi Surendra,

Thanks for your reply.

Could you  please tell me what will they use for creating queries instead of creation of field groups.

Thanks,

RG

[Sandra_Rossi]

Could you tell us which fields are A, B, C and D? Could you show the output where field "C" is missing?

[Former Member]

Hi Sandra,

Let me explain you more detail for suppose if we take field division , for division there is a column which displays the division value and other division which displays text ( text division ) , Now the problem I am having is even though I ticked division value to be displayed at the o/p. Its displaying text for division and similarly for other fields , see attched.

I know that there are two divisions but both of them are having some values for division and not the text division.

Thanks,

RG

[Sandra_Rossi]

By default, I think you have the option only to select the code or the text (menu Edit -> Settings). If you want both of them, you need to go to the classic Query maintenance dialog (button Change instead of Infoset Query) and tick the text fields (List fields)

[Former Member]

Hi Sandra,

For my query where are the O/P fields selected as per my knowledge , the O/P fileds can be selected at the query level , click on infoset query and select the selection screen and O/P fields .

Or we can also select at the infoset level if the prog uses join , but my prog uses LDBs , by default will the LDBs display all the fields.

If yes , I am not able to see all the fields

If No , where can I select the O/P fields.

Thanks,

RG

[Sandra_Rossi]

In my test above, I was using the same MSM logical database as yours. In SQ01, using only the button "Infoset Query" to maintain the query, didn't allow me displaying both value and text of division. But by using the button "Change", I could also select the text. No problem after that to still continue using button "Infoset Query" to maintain the query (the only thing is that we never see the text fields).

One thing I didn't understand in your last screen capture, was the group "Additional fields". I don't have it (and I don't need it) when I use the "Infoset Query" button. I have additional fields only via the "Change" button.

I'm using 7.40 SP 11.

[Former Member]

Hi Sandra,

Yes you are correct you do not require additional fields in your query ..

Could you please suggest how to control the O/P fields are controlled, when the query uses LDB MSM.  basically I know that infoset query (button) is not the only option available , there should be other option avaialable to control the O/P fields.

Or is it field groups fields would be avaialable by default at the O/P or all the  fields used in LDB are displayed.

Thanks,

RG

[Former Member]

Hi Sandra,

Thanks for your reply , it helped me a  lot, we need to go to QUERY CHANGE MODE, click on next screen and path GO TO --> BASIC LIST --> STRUCTURE maintain our required fileds.

Thanks,

RG

[Jelena_Perfiljeva]

The Infoset Query is a subset of SAP Queries. Unfortunately, there are many SCN posts that call all the SAP Queries "infoset queries" (as opposed to QuickView queries in SQVI). It's very unfortunate verbiage choice by SAP IMHO - as if regular SQ01 queries are not based on the infosets.

There is SAP Help article on the Infoset Queries, I'd refer to it if a clarification is needed.

Unless the requirement is specifically to create the Infoset Query, I would suggest to not touch that button and instead just create a regular query (Create/Change buttons). In the regular queries, if you hit Basic List, you'll see all the fields available, with the automatically added text fields in "Additional fields" section, just like on the Sandra's screenshot.

There is a good collection of the query-related SCN blogs/documents, see here:

Although, as I've mentioned, the "Infoset Queries" term is used incorrectly all over the place.

EDIT - found the option in the Infoset Query by random clicking: the fields marked with [T] have additional text available. Check the checkbox for output, this will add the column in the preview window below. Then right-click on the column (so that it's highlighted) and the menu will show options for text, value or both:

But still - don't use infoset queries, just go with the regular ones.

Message was edited by: Jelena Perfiljeva