Copy using Variables with multiple single values in BEX

43 Views

Hi,

I have a requirement wherein on executing the planning function, the system should take the FROM and TO values of 0FISCPER and copy the data accordingly.

Source variable is 'Single Value'.

Target variable is 'Multiple Single Value'.

I tried to give the Command Range as below:

$A$30:$C$31.

The button sequence is as below:

VAR_NAME_1 0 ZFISCPER

VAR_VALUE_1 0

VAR_NAME_2 1 ZFISCPER_M

VAR_VALUE_2 1

In the Analyzer, I entered the values as

In A30, VAR_NAME_1 0 =C20

In A31, VAR_NAME_2 1 =C21:C24

The values that I entered are as below:

C20 = 2007001 - Source value

C21 = 2007002 - Target values

C22 = 2007003

C23 = 2007004

C24 = 2007005.

The problem that Im facing is the system is unable to identify the multiple values that I enter for Target Fiscper and it displays as :#VALUE!

How to enter multiple single values and reference them accordingly?

Rgds,

Shyam