Add select option to query with logical database

[maria_merino]

Hi experts,

I have to add 2 select-options to a query. The query uses logical database IFM and the new fields come from CDHDR and KONH tables. The user needs the date and user of purchasing inforecord last modification and KONH-DATBI and KONH-DATAB.

I have modified the inforeset adding DATBI and DATAB as additional fields under EINE:

The work fine.

Then I add CDHDR-USERNAME and CDHDR-UDATE in the same group but when I run the query they don't work as filter. Checking the generated program there is no line like

check SP$00020

for those fields.

Is there anything I'm missing or doing wrong?

thanks in advance!

maría

[maria_merino]

Hi experts,

I have to add 2 select-options to a query. The query uses logical database IFM and the new fields come from CDHDR and KONH tables. The user needs the date and user of purchasing inforecord last modification and KONH-DATBI and KONH-DATAB.

I have modified the inforeset adding DATBI and DATAB as additional fields under EINE:

The work fine.

Then I add CDHDR-USERNAME and CDHDR-UDATE in the same group but when I run the query they don't work as filter. Checking the generated program there is no line like

check SP$00020

for those fields.

Is there anything I'm missing or doing wrong?

thanks in advance!

maría

[Jelena_Perfiljeva]

Adding fields to a group doesn't really do anything.

It's not clear what exactly you're trying to achieve but, in general, if the tables are not included in LDB then you'll need to write additional ABAP code for all the functionality, including using additional fields on selection screen.

Google "custom code SQ01 query site:sap.com" for further information on this.