topic Re: where condition problem in Application Development and Automation Discussions

where condition problem

Former Member — Tue, 10 Apr 2007 07:09:04 GMT

Hi everybody

i got struck in problem related to "where condition"

1) i have to select mblnr , mjahr and budat from MKPF into itab (internal table) for user input in the selection screen

+++(Inner join)

and

select zeile,bwart,matnr,werks,lgort,charg,sobkz,erfmg,erfme,kzbew,kzvbr,kzzug,shkzg from MSEG into itab(internal table) for user input in the selection screen

2) now i got confused in "For user input in the selection screen " because at selection screen i have only following fields

matnr , werks , lgort,charg,lifnr,kunnr,bwart,sobkz,usnam,vgart.

and i am using a query like this

select a-mblnr

a-mjahr

a-budat

b-zeile

b-bwart

b-matnr

b-werks

b-lgort

b-charg

b-sobkz

b-erfmg

b-erfme

b-kzbew

b-kzvbr

b-kzzug

b-shkzg into table t_mat_data from mkpf

as a join mseg as b on a-mblnr = b-mblnr

and a-mjahr = b-mjahr

where .....................

so wat should i written in Where condition plz reply

thanks

points will be awarded

Re: where condition problem

Former Member — Tue, 10 Apr 2007 07:11:28 GMT

where a~field name IN ur input

and b~fields name IN ur input

and A~FIELDNAME = UE INOUT .

Re: where condition problem

Former Member — Tue, 10 Apr 2007 07:12:08 GMT

Hi..

select a-mblnr

a-mjahr

a-budat

b-zeile

b-bwart

b-matnr

b-werks

b-lgort

b-charg

b-sobkz

b-erfmg

b-erfme

b-kzbew

b-kzvbr

b-kzzug

b-shkzg into table t_mat_data from mkpf

as a join mseg as b on a-mblnr = b-mblnr

and a-mjahr = b-mjahr

where mseg~matnr in s_matnr and

mseg~werks in s_werks and

mseg~igort in s_igort and

mseg~charg in s_charg and

mseg~kunnr in s_kunnr and

mseg~bwart in s_bwart and

mseg~sobkz in s_sobkz and

mseg~usnam in s_usnam.

Re: where condition problem

Former Member — Tue, 10 Apr 2007 07:15:40 GMT

Hi..,

u need to use the TILT operator here !!! "~"

select a~mblnr

a~mjahr

a~budat

b~zeile

b~bwart

b~matnr

b~werks

b~lgort

b~charg

b~sobkz

b~erfmg

b~erfme

b~kzbew

b~kzvbr

b~kzzug

b~shkzg into table t_mat_data from mkpf

as a join mseg as b on a_{mblnr = b}mblnr

and a_{mjahr = b}mjahr

where mseg_{matnr in s_matnr and **If it is a parameter then u need to use mseg}matnr eq p_matnr.

werks eq p_werks and

lgort eq p_lgort and

charg eq p_charg and

...

not the ' -' u need to use "~".

regards,

sai ramesh

Re: where condition problem

Former Member — Tue, 10 Apr 2007 07:16:05 GMT

Hi Gaurav,

I find the select query absolutely correct.

In the where clause just write what all fields you have on the selection screen.

where matnr = s_matnr

and werks = s_werks

and lgort = s_lgort

and .............so on.

Internally the join will take care of fields as to which table it belongs to.

Thank you.

Reward if useful.

Re: where condition problem

Former Member — Tue, 10 Apr 2007 07:18:16 GMT

Hi,

Always use the Character '~' instead of '-' in joins:

select a-mblnr

a~mjahr

a~budat

b~zeile

b~bwart

b~matnr

b~werks

b~lgort

b~charg

b~sobkz

b~erfmg

b~erfme

b~kzbew

b~kzvbr

b~kzzug

b~shkzg

into table t_mat_data

from mkpf as a join mseg as b

on a_{mblnr = b}mblnr

and a_{mjahr = b}mjahr

where mseg~matnr in s_matnr ...

reward if useful

regards,

Anji

Re: where condition problem

Former Member — Tue, 10 Apr 2007 08:07:53 GMT

hi thanks to all of u for your help.

query is working very fine but data is not found in Internal table . i am getting an error as " data not found"

plz help me

thanks

Re: where condition problem

Former Member — Tue, 10 Apr 2007 08:17:02 GMT

Hi Gaurav,

I hope you are using all the screen fields as SELECT-OPTIONS. If yes without entering anything on the screen, execute the report. It should give some records in the table provided you have entries in table MKPF and then in MSEG. Confirm this using transaction SE16 first.

Thanks.

Re: where condition problem

Former Member — Tue, 10 Apr 2007 10:35:56 GMT

yes u r rite it works well . so wat should i do now when i will execute by filling up the enteries at selection screen . so that table will be full

thanks