topic Re: Problem with Parameters or Query in Application Development and Automation Discussions

Problem with Parameters or Query

Former Member — Tue, 20 Dec 2011 06:46:54 GMT

Dear Friends

i am not able to rectify the issue with following code.

SELECTION-SCREEN BEGIN OF BLOCK BK1 WITH FRAME TITLE TEXT-001.

SELECT-OPTIONS BUKRS FOR BSEG-BUKRS OBLIGATORY.

SELECT-OPTIONS GJAHR FOR BSEG-GJAHR OBLIGATORY.

SELECT-OPTIONS SAKNR FOR BSEG-SAKNR.

SELECTION-SCREEN END OF BLOCK BK1.

SELECT BUKRS BELNR GJAHR AUGDT AUGCP AUGBL BSCHL KOART SHKZG DMBTR ZUONR SGTXT

HKONT KUNNR LIFNR FROM BSEG INTO corresponding fields of table IT_BSEG

WHERE BUKRS in BUKRS

AND SAKNR IN SAKNR

AND GJAHR in GJAHR.

if i entered bukrs , gjahr and saknr then

there is no any value inside internal table

but if i entered bukrs and gjahr then there are list of values inside internal table including saknr .

i came to know that there is some issue with saknr ??

- Avirat

Re: Problem with Parameters or Query

Former Member — Tue, 20 Dec 2011 06:53:13 GMT

Hi,

Try giving hkont instead of saknr as both fields are same.If there are no values for saknr you woill not get you can use hkont also

Regards,

Ram.

Re: Problem with Parameters or Query

Former Member — Tue, 20 Dec 2011 06:59:51 GMT

Hi,

Before processing query check the value in your database table through SE16N.

Pass the 3 fields and check the whether the values are displaying or not .

Pass 2 fields and check whether it is dispalying or not .

You are passing two fields bukrs and gjahr for that no saknr value is not there thats why the data is not fetching.

You this is helpful.

Regards,

G.Aditya

Re: Problem with Parameters or Query

Former Member — Tue, 20 Dec 2011 07:02:49 GMT

Hi ,

Try adding SAKNR feild in the select query selection fields.

Regards,

Ganesh.

Re: Problem with Parameters or Query

GauthamV — Tue, 20 Dec 2011 07:08:56 GMT

There is a conversion exit for field SAKNR.

Use below function modules accordingly.

CONVERSION_EXIT_ALPHA_INPUT

CONVERSION_EXIT_ALPHA_OUTPUT

Re: Problem with Parameters or Query

Former Member — Tue, 20 Dec 2011 07:55:03 GMT

H Corrtech,

Please use the function module 'CONVERSION_EXIT_ALPHA_INPUT' before the select to modify the range table SAKNR as the field type is char and convers.routine (ALPHA) is attached.

conversation exit fun is used to add the preceding zero

Exp:'1234 ' --> '00001234'

Thanks

Prabhakaran

Re: Problem with Parameters or Query

Former Member — Tue, 20 Dec 2011 08:44:55 GMT

dear Sriram.S

thanks.. for the answer..

would you please give me a brief between hkont and saknr.

Regards

Avirat Patel