topic Re: Variable in Application Development and Automation Discussions

Variable

Former Member — Mon, 09 Apr 2007 06:16:52 GMT

Hi Expert,

I have a problem when I try to use a variable with LIKE command at SQL command.

The ABAP source code as below.

FORM get_sales_forecast.

DATA: yyyymm(6) TYPE C.

yyyymm = sy-datum+0(6).

SELECT pbim_{werks pbim}matnr pbim_{bedae pbim}versb pbim~pbdnr

pbim_{bdzei pbed}pdatu pbed_{plnmg pbed}meins

INTO TABLE t_pbim_ed

FROM pbim INNER JOIN pbed ON

pbim_{bdzei = pbed}bdzei

FOR ALL ENTRIES IN t_marc

WHERE pbim~matnr = t_marc-matnr

AND pbim~werks = p_werks

AND pbim~loevr = SPACE

AND pbed~loevr = SPACE

AND pbed~pdatu LIKE 'yyyymm%'.

ENDFORM.

When I use a Variable

pbed~pdatu LIKE 'yyyymm%'. give me zero record

Try to use a Literal

pbed~pdatu LIKE '200704%'. give me some records

Could anyone please tell me how to use a variable in LIKE command?

Regards

Tiwa Noitawee.

Re: Variable

Former Member — Mon, 09 Apr 2007 06:20:28 GMT

TRY LIKE THIS..

DATA : MONYR(6) TYPE C,

PAT(7).

MONYR = SY-DATUM+0(6).

CONCATENATE MONYR '%' INTO PAT.

SELECT pbim_{werks pbim}matnr pbim_{bedae pbim}versb pbim~pbdnr

pbim_{bdzei pbed}pdatu pbed_{plnmg pbed}meins

INTO TABLE t_pbim_ed

FROM pbim INNER JOIN pbed ON

pbim_{bdzei = pbed}bdzei

FOR ALL ENTRIES IN t_marc

WHERE pbim~matnr = t_marc-matnr

AND pbim~werks = p_werks

AND pbim~loevr = SPACE

AND pbed~loevr = SPACE

AND <b>pbed~pdatu LIKE PAT</b>.

REGARDS

SHIBA DUTTA

Re: Variable

Former Member — Mon, 09 Apr 2007 06:21:31 GMT

YYYYMM% it has no meaning ,

so u have

concatenate YYYYMM with % into X.

then call

no sytax checks please.

Regards

Prabhu

Re: Variable

Former Member — Mon, 09 Apr 2007 06:21:34 GMT

You can do as below.

data: yyyymm(7) TYPE C.

concatenate sy-datum+0(6) '%' into yyyymm.

SELECT pbim_{werks pbim}matnr pbim_{bedae pbim}versb pbim~pbdnr

pbim_{bdzei pbed}pdatu pbed_{plnmg pbed}meins

INTO TABLE t_pbim_ed

FROM pbim INNER JOIN pbed ON

pbim_{bdzei = pbed}bdzei

FOR ALL ENTRIES IN t_marc

WHERE pbim~matnr = t_marc-matnr

AND pbim~werks = p_werks

AND pbim~loevr = SPACE

AND pbed~loevr = SPACE

AND pbed~pdatu LIKE yyyymm.

Re: Variable

Former Member — Mon, 09 Apr 2007 06:23:29 GMT

Hi,

The statement LIKE 'XXXX%' will give you only the matching records thats been mentioned. i.e. for example if you give the condition LIKE 'QM%' it gives you all the records which starts with QM. In your case if you have given it as LIKE 'yyyymm%' and it will search to get the records which starts with yyyymm. SO you are not getting any output.

Hope its clear how to use the LIKE statement.

Regards,

Ram

Pls reward points if helpful.

Re: Variable

Former Member — Mon, 09 Apr 2007 07:04:07 GMT

The problem has already resolved.

Thanks everyone.

Regards,

Tiwa Noitawee