topic Re: Select-option values with Concatenate statement in Application Development and Automation Discussions

Select-option values with Concatenate statement

Former Member — Mon, 13 Nov 2006 15:56:37 GMT

Hi,

I am using :-

Concatenate P_FNAME S_RBUKRS S_POPER into v_filepath

separated by '_'.

But I am getting this during testing ...

/sapbatch/TBQ/export/Logs_IEQ3060_IEQ001000

I want to get rid of IEQ from IEQ3060 and I want to get rid of IEQ & ending 3 zero's from IEQ001000.. how do I do that ??

Re: Select-option values with Concatenate statement

Former Member — Mon, 13 Nov 2006 15:59:40 GMT

Hi,

Use LOW field of the select-options.

Concatenate P_FNAME S_RBUKRS-LOW S_POPER-LOW into v_filepath

separated by '_'.

Thanks,

Naren

Re: Select-option values with Concatenate statement

Former Member — Mon, 13 Nov 2006 15:59:47 GMT

Concatenate P_FNAME S_RBUKRS-LOW S_POPER-LOW into v_filepath separated by '_'

Use the LOW field of the SELECT OPTIONS as shown.

Regards,

Ravi

Note : Please mark all the helpful answers

Re: Select-option values with Concatenate statement

Former Member — Mon, 13 Nov 2006 16:00:15 GMT

Hello SB,

U need to give like this

LOOP AT S_RBUKRS.

READ TABLE S_POPER INDEX 1.

Concatenate P_FNAME S_RBUKRS-LOW S_POPER-LOW into v_filepath

separated by '_'.

ENDLOOP.

If useful reward,

Vasanth

Re: Select-option values with Concatenate statement

Former Member — Mon, 13 Nov 2006 16:00:18 GMT

For select options you need to read it as an internal table

read table s_rbukrs index 1.

then use the field s_rbukrs-low to concatenate.

You may geet issues though if that start to enter ranges.

Re: Select-option values with Concatenate statement

Former Member — Mon, 13 Nov 2006 16:10:08 GMT

HI,

follow below logic

Concatenate P_FNAME S_RBUKRS-low S_POPER-low+0(3) into v_filepath

separated by '_'.

Regards

amole