cancel
Showing results for 
Search instead for 
Did you mean: 

Copy using Variables with multiple single values in BEX

Former Member
0 Kudos
99

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I've solved similiar issue by exit function.

In my case user defined time interval through 2 variables (from/to) and then I've copied (from-to) times entered data.

Former Member
0 Kudos

for each variable value you want to hand over you need a separate parameter / value pair.

VAR_NAME_1 0 ZFISCPER

VAR_VALUE_1 0 =C20

VAR_NAME_2 1 ZFISCPER_M

VAR_VALUE_2 1 =C21

VAR_NAME_3 1 ZFISCPER_M

VAR_VALUE_3 1 =C22

VAR_NAME_4 1 ZFISCPER_M

VAR_VALUE_4 1 =C23

VAR_NAME_5 1 ZFISCPER_M

VAR_VALUE_5 1 =C24

Regards Matthias

Former Member
0 Kudos

Thanks for the response.

I shall try doing it and update. Meanwhile, another doubt that I have is, if the Target value is a 'Range' of values instead of multiple single values, how to reference it accordingly.

Rgds

Shyam

Former Member
0 Kudos

Hi,

I have tried to enter multiple single values as below:

VAR_VALUE_1 0 000 - Source

VAR_VALUE_1 1 003 - Target

VAR_VALUE_2 1 010

VAR_VALUE_3 1 080

VAR_VALUE_4 1 099

When I tried to execute the planning function, the system copies the data from version 000 to ALL versions irrespective of values entered above.ie:

1

2

3

10

80

99

100

110

#.

Rgds

Shyam