sap query report-selection screen modification

[former_member565100]

Hi

I have created a SAP query report using the logical database KDF ,the selection screen was created automatically.For vendor report open item and Cleared item Push button would be there in FBL1N but here it only displays Open key date,clearing dates.The open key date is mandatory to give though i give clearing dates as i need vendor cleared items.

Is ther way to change the selection screen to get the option open item and cleared item push button as in FBL1N.

This is because i was filtering a vendor only for particular doc type only for clearing items but report takes open item too though i meantioned clearing date rate.How to modify the selection screen in sap query report when Logicaldatabase is selcted.

[former_member565100]

Issue resolved with the help of abaper as suggested.Thanks.

[Former Member]

Hello

SQVI or SQ01 cannot handle this functionality. Get ABAP person's help and develop as radio button.

Regards

Dinabandhu

[Former Member]

Hi,selection screen customizing in program,so you can do it there(if its not standart program). But you can add selection field to dynamic selections for KDF. There is BSIK table,so you can select Open item on selection screen.

[former_member565100]

what is the field name for open item and cleared item.I couldnt find it in BSIK to select them.Please suggest.

[Former Member]

BSIK it's a table wich include ONLY open item!So if you want open item ypu'd to choose from BSIK, if cleared-BSAK.

So for KDF you'd to add creteria for BSIK

[former_member565100]

I need to get only the cleared items.I donot need open items.Then if go for BSIK is it wrong.Should go only for BSAK.

I couldnt find the table BSAK in logical database KDF.

Edited by: mysap query on Mar 18, 2009 3:15 PM

Edited by: mysap query on Mar 18, 2009 3:15 PM

[Former Member]

So try to do it without BSAK. Fo ex you have BSEG and BSIK. Use these both,bcs if you exclude BSIK and select all BSEG you'll req. item.