topic Re: Doubt in Select statement in Application Development and Automation Discussions

Doubt in Select statement

Former Member — Tue, 14 Aug 2007 05:44:47 GMT

Hi Friends,

I have a small doubt in select statement.

select a~kunnr into table li_kunnr from kna1 as a inner join vbpa as b

on a_{kunnr = b}kunnr where a_{kunnr in fp_kunnr and b}parvw = 'SH'.

I ahve written this select statement even though the value is there in the database no output coming in the select statement.

I think the error because of this line "b~parvw = 'SH' ".

when i tried with value from select option like the output is correct

which is

select a~kunnr into table li_kunnr from kna1 as a inner join vbpa as b

on a_{kunnr = b}kunnr where a_{kunnr in fp_kunnr and b}parvw in fp_parvw.

for the above query output is correct if i give value 'SH' in the selection screen.

please help is there any mistake in the query or any other way to write the query.

Former Member — Tue, 14 Aug 2007 05:49:23 GMT

actually for parvw you have to use conversion exit fn module becuase the internal representation pf SH is WE.

so you can not hard code it

you can use fm CONVERSION_EXIT_PARVW_INPUT and pass SH and use the return value(WE) or

select a~kunnr into table li_kunnr from kna1 as a inner join vbpa as b

on a_{kunnr = b}kunnr where a_{kunnr in fp_kunnr and b}parvw = 'WE'.

regards

shiba dutta

Former Member — Tue, 14 Aug 2007 05:51:03 GMT

HI,

Define a constant of a same type as parvw ,and default it to 'WE'.(Conversion for SH)

Then use that constant in your select query.

Thanks,CSR.

****Reward if helpful

Message was edited by:

CSR