topic Re: select statement issue in Application Development and Automation Discussions

select statement issue

Former Member — Wed, 22 Jan 2014 06:22:19 GMT

Dear Experts,

I have parameters and select-options like below..

data: d_date type vbrp-erdat.

parameters: p_bukrs type t001k-bukrs,

p_matnr type mara-matnr,

s_date for d_date.

I want to pass matnr and erdat to table vbrp and fetch data like vbeln,fkimg,erdat,werks,matnr,arktx from table vbrp for that inputed matnr.

So I created the types for vbrp table for these declared fields and also created the itab and wa.

when I wrote the select statement to fetch data from vbrp table and put the where condition as where matnr = p_matnr and erdat in s_date,no data has populated to itan it_vbrp. So in that case how I ll fetch data from vbrp table. Also if i remove the where conditions it fetched the wrong data from the table.

Please guide me how to write the select statement to fetch data based on above conditions..

Kind Regards,

Ajit

Re: select statement issue

former_member187748 — Wed, 22 Jan 2014 06:24:42 GMT

Hi Ajit,

parameters are defined as shown below

PARAMETERS : P_VKBUR TYPE VBAK-VKBUR OBLIGATORY.

Then you can use it as shown below.

vkbur EQ p_vkbur

Re: select statement issue

Former Member — Wed, 22 Jan 2014 06:25:38 GMT

Hi,

parameters: p_bukrs type t001k-bukrs,

p_matnr type mara-matnr,

s_date for d_date.

is wrong. for using select....from...where erdat in s_date you should define s_date as select option.

tables : vbrp.

parameters: p_bukrs type t001k-bukrs,

p_matnr type mara-matnr.

select-options : s_date for vbrp-erdat..

thanks

akshay

Re: select statement issue

former_member210857 — Wed, 22 Jan 2014 06:28:26 GMT

Hi Ajit,

I think you are trying to create a select options for s_date and you have declared it in parameters.u

if you want to use IN in select query .you should use select options.

data: d_date type erdat

parameters: p_bukrs type bukrs,

p_matnr type matnr.

SELECT-OPTIONS : s_date for d_date.

Kindly check.

Regards,

Subeesh Kannottil

Re: select statement issue

former_member212148 — Wed, 22 Jan 2014 06:31:35 GMT

Hi Ajit,

Akshay is right. IN operator used in select-options defined parameter.

select <fieldname> into table <internaltable> where matnr = p_matnr and erdat in s_date.

Thanks,

Ranjit K.

Re: select statement issue

Former Member — Wed, 22 Jan 2014 06:34:58 GMT

Dear Akshay,

I declared select-option.

If I declared select-option : s_date for vbrp-erdat,its showing vbrp table is unknown.

@sanjiv....

if i pass as per your suggstion,its not fetching any data to itab it_vbrp.

Regards,

Ajit

Re: select statement issue

former_member187748 — Wed, 22 Jan 2014 06:37:51 GMT

Hi Ajit,

please change your code logic as shown below

parameters: p_bukrs TYPE t001k-bukrs,

p_matnr TYPE mara-matnr,

s_date TYPE vbrp-erdat.

Now you can write your code logic and put EQ for your parameters.

Re: select statement issue

sivaprasad_paruchuri — Wed, 22 Jan 2014 06:39:09 GMT

hi ,

u can declare as follows there wont be any issue

tables : vbrp

parameters: p_bukrs type t001k-bukrs,

p_matnr type mara-matnr.

slect-options s_date for vbrp-erdat.

select .... from vbrp into table itab where matnr = p_matnr and erdat in s_erdat.

regards

Siva

Re: select statement issue

former_member187748 — Wed, 22 Jan 2014 06:39:57 GMT

Hello Ajit,

please see i have edited my post, sorry i didn't not seen that you have used

parameters and declared as SELECT-OPTIONS.

Please see my edited post.

Re: select statement issue

Former Member — Wed, 22 Jan 2014 06:43:44 GMT

tHANK YOU VERY MUCH ALL FOR YOUR VALUABLE ANSWERS..

I DECLARED THE INPUT FIELDS AAS SELECT-OPTIONS AND SOLVE MY PROBLEM AS NEERAJ SAID.

tHANK YOU ALL..

Re: select statement issue

Former Member — Wed, 22 Jan 2014 06:51:06 GMT

Dear Ajit.

Please Check Bellow Source code.

DATA: D_DATE TYPE VBRP-ERDAT.

DATA : BEGIN OF IT_VBRP OCCURS 0,
           VBELN TYPE VBRP-VBELN,
           FKIMG TYPE VBRP-FKIMG,
           ERDAT TYPE VBRP-ERDAT,
           WERKS TYPE VBRP-WERKS,
           MATNR TYPE VBRP-MATNR,
           ARKTX TYPE VBRP-ARKTX,
        END OF IT_VBRP.

PARAMETERS: P_BUKRS TYPE T001K-BUKRS,

                   P_MATNR TYPE MARA-MATNR.

SELECT-OPTIONS: S_DATE FOR D_DATE.

SELECT VBELN FKIMG ERDAT WERKS MATNR ARKTX
   FROM VBRP
   INTO TABLE IT_VBRP
   WHERE MATNR = P_MATNR
   AND ERDAT IN S_DATE.

your requirement is may fulfill and Replay me Your Friend and kind of problem please tell me.

Re: select statement issue

Former Member — Wed, 22 Jan 2014 06:57:22 GMT

THANK YOU @RAJ