topic issue while fetching data from rbkp table in Application Development and Automation Discussions

issue while fetching data from rbkp table

Former Member — Tue, 03 Mar 2015 20:47:21 GMT

Hi Experts ,

i have an strange situation, when i am trying to fetch data from rbkp table passing company code and posting date , i am not getting any records, according to my knowledge , select statement is correct.,while i checked in se11 with same inputs, it is showing records.

where am i going wrong,

i am attaching the both screen shots.please check.help required.

Re: issue while fetching data from rbkp table

Former Member — Tue, 03 Mar 2015 21:18:14 GMT

No - the selection conditions are not the same in both cases. In your program, you using P_LIFNR, but not in the data browser. I suspect that P_LIFNR is blank in the program and that is why you do not get any records.

Or if P_LIFNR is a SELECT-OPTION, you cannot use "=".

Rob

Message was edited by: Rob Burbank

Re: issue while fetching data from rbkp table

philipdavy — Tue, 03 Mar 2015 21:55:48 GMT

Conversion Exit issue for the field LIFNR ?
Did you try CONVERSION_EXIT_ALPHA_INPUT ?

Regards,

Philip.

Re: issue while fetching data from rbkp table

perfectoromero — Tue, 03 Mar 2015 23:13:45 GMT

Validate if the P_LIFNR is empty, because if that is true, your parameter set the value in P_LIFNR = '' and search this in the database.

Option 1: Set P_LIFNR as an obligatory parameter

p_lifnr type bsik-lifnr obligatory

Option 2: Validate P_LIFNR is empty

if p_lifnr is initial.

select ...

where ...

else.

select ...

where LIFNR = P_LIFNR.

Option 3: Convert the P_LIFNR as a Select-Option, you need to change the "=" to "IN" instruction in Where.

Best Regards,

Francisco Romero

Re: issue while fetching data from rbkp table

atul_mohanty — Wed, 04 Mar 2015 05:23:08 GMT

Hi -

In your code, you have P_BELNR, P_BUKRS, P_LIFNR is mentioned. If P_BUKRS or P_LIFNR are parameters it will cause the issue. You need make these fields mandatory for your case.