Infoset Query Modification Suggestion

[Former Member]

I'm new to ABAP Infoset and logical database, and need your help.

I have a query running based on Infoset Z_FI_CHILE_XX(same copy from /SAPQUERY/FI_CHILE_PERU) and logical database SDF. Now I'm trying to modify the selection screen, for example: get rid of 'Fiscal year' and 'Period', and adding 'Posting data' criteria.

As I can see so far, 'Fiscal year' critieria is from logical database SDF, and 'Period' was adding in Infoset. Please give me some suggestion, should we modified logical database, or you have better solution?

Also do you have better documentation on how to modify the selection criteria in infoset rather than SAP library?

Thanks a lot!

[suresh_datti]

Hi Xing,

there is no need to change the LDB.. you should be able to modify the selection criteria of the query..

Suresh Datti

[Former Member]

Since you can se the fiscal year i hope you can find the Period. LDB is not required to be changed.

[sergey_korolev]

In your case you can get rid of selection screen parameter only via selection screen variant. I strongly recommend not to modify standard selection screen of LDB.

[Former Member]

Thanks for all your applies. From your answer modified LDB is not a good way to do.

I would like to first try to get rid of selection screen parameter via selection screen variant.

Now I'm in the 'change infoset' screen, and there is a button('Selections' Shift+F7) bring me to list of selections. When I click Selection 'Fiscal Year'(intend to delete it), give me error say 'Logical database selections cannot be changed'.

Is that I'm in the right track? It's very possible I didn't get the right idea. Please advise.

Appreciated!

[suresh_datti]

Hi Xing,

yes , you are on the right track.. since you cannot delete it from the list.. you can try it via coding..

select the 'code' option 'AT SELECTION-SCREEN OUTPUT' , modify the screen element fiscal year ie make the property 'invisible' = 1 for fiscal year in loop at screen ..endloop

Good Luck,

Suresh Datti

[Former Member]

Hi Xing,

What you should do is try to select the data from de logical database, and put the data into a new internal table, that should help ypu to get data you need.

Hope this helps!!!

Gabriel P.

[Former Member]

Thanks for all help from you.

I realised that my problem actually can not be just simply solved by modify the selection screen, since I need selection some periods from one fiscal year, then get some periods from another fiscal year, which two part of periods are not the same. Also I need the sum the total from all the periods that I selected, instead of list them in report.

My solution is modified the code behind the infoset to control selection in different periods for different fiscal year, then adding the subtotal total section in infoset Query, finally use a menu function(total drilldown) to leave only subtotal sections in report.

Thanks anyway, if you think there has better solution, please feel free to let me know. I would like to learn from you.