Remote cube problem

[raguraman_c]

Hi Experts,

I am using function module, <b>RSOA_VCUBE_READ_REMOTE_DATA</b> in SCM 5.0 it is giving message <b>NO Planning Version Selected</b>. I know we have to pass planning version. but how to do that? Do you have nay sample code for the above mentioned function module. Will be of great help for me please help.<b>Points guaranteed</b>. Its urgent.

--Ragu

[Former Member]

Hello!

In Import parameter I_T_RANGE add the line below:

CHANM = 9AVERSION

SIGN = I

COMPOP = EQ

LOW = <i>your version</i>

I think this will solve your Problem.

[raguraman_c]

Hi Laurant,

Thanks a lot that actually has solved my problem i want to give you more can you please answer this question as well.

For the same it is giving select time characteristic i have given this

g_s_range-chanm = '0CALMONTH'.

• --- including or excluding condition ?

g_s_range-sign = rs_c_range_sign-including.

• --- comparison operator

g_s_range-compop = rs_c_range_opt-between.

• --- low value

g_s_range-low = '199901'.

• --- high value

g_s_range-high = '200606'.

• --- include into list of restriction

but still giving the message, how to include fiscal year, what is the format it is 7 Characters i know, but what is the format.

Please help points guaranteed.

--Ragu

I am not able to reward points, i couldn't find the option buttons. Definitely you deserve points i will reward as soon as it is available.

Message was edited by:

Raguraman C

[Former Member]

Try to add 0CALMONTH in I_TH_SFC. If you do that the message 'select time charac' should desappear.

I_TH_SFC is used to select characterisctics you want to read.

I_T_RANGE is only for filter.

I_TH_SFK is for KF.

E_T_DATA is the table in which you will have the result.

Here is an example:

• 0CALMONTH

CLEAR WS_SFC.

WS_SFC-CHANM = '0CALMONTH'.

WS_SFC-CHAALIAS = '0CALMONTH'.

WS_SFC-ORDERBY = 0.

INSERT WS_SFC INTO TABLE WT_SFC.

• ZK_FCSTAT

CLEAR WS_SFK.

WS_SFK-KYFNM = 'ZK_FCSTAT'.

WS_SFK-KYFALIAS = 'ZK_FCSTAT'.

WS_SFK-AGGR = 'SUM'.

INSERT WS_SFK INTO TABLE WT_SFK.

*9AVERSION (filtre obligatoire)

CLEAR WS_RANGE.

WS_RANGE-CHANM = '9AVERSION'.

WS_RANGE-SIGN = 'I'.

WS_RANGE-COMPOP = 'EQ'.

WS_RANGE-LOW = '000'.

APPEND WS_RANGE TO WT_RANGE.

Here, the FM will return for each month the value of the KF ZK_FCSTAT.

The field CHAALIAS and KYFALIAS is the field of E_T_DATA in which the charac or KF will be 'saved'. Of course you have to define the structure of your table.

Morever, when you will make a querry based on your IC with BEX, if you do not specify a version and if you do not select a time characteristic you will have the same messages.

Message was edited by:

Laurent BOUDART

[digambar_narkhede]

Hi Raghu,

While generating transfer rule click on the charactristic symbol in transfer structure and in edit transfer rule window pass a constant 000 for version .

This will solve your prob.

Thanks ,

Digs