Abap routing in infopackage data selection

[Former Member]

Hi guys

I'm using an ABAP routin for the Data selection in my infopackage. I want to fetch all the records which is having value Less than 'IN14' for company code.I have modifuied the l_t_range as shown

l_t_range-sign = 'I'.

l_t_range-option = 'LT'.

l_t_range-low = 'IN14'.

modify l_t_range index l_idx.

But while executing, its giving the followinf error message.

"For sel. field 'COMP_CODE', no selection with SIGN = 'I'; OPTION 'LT' allowed"

Does anybody knows what should be done for this?

Regards

Sriram

[Former Member · Accepted solution]

Hi Sriram,

You have to use append l_t_range and clear l_t_range after l_t_range-low = 'IN14'..

Try that.It should work.

Bye

Dinesh

[Former Member]

hi,

try to do following:

l_t_range-sign = 'I'.

l_t_range-option = 'BT'.

l_t_range-low = 'A'.

l_t_range-high = 'IN13'.

maybe this work...

Regards,

Andrzej

Message was edited by: Andrzej Krysiuk

[Former Member]

Hi Sriram,

As you found from the ROOSFIELD table you would be able to use only EQ, BT, CP. In such a case even if you use OLAP variable it won't work for LT. If your company codes are few and you know them then enter hard code values in the data selections of the infopackage. Thats one option though not the best.

If I find anything else I shall post it here.

Bye

Dinesh

[Former Member]

I opened a new post under 'data selection'. cheers.

Message was edited by: Pascal Gabin

[Former Member]

Hi

I checked against the datasource and against the comp_code field and the SELOPTS value is 7 i.e Selection EQ, BT, CP Permitted. So further what can be done?

Regards

Sriram

[Former Member]

Hi Sriram,

It would be relevant for the datasource.

Bye

Dinesh

[Former Member]

Hi again,

i'm seeing the ROOSFIELD entries in the source system. But for what entry i need to check the field SELOPTS? is it for the infoobject or source system or hows that?

Regards

Sriram

[Former Member]

Hi Sriram,

First check what are the selection options supported by your data source in the table <b>ROOSFIELD</b> in your source system. You need to check the field SELOPTS in the table.

Hope it helps.

Bye

Dinesh

[Former Member]

Hi dinesh,

I'm not very sure abt how OLAP variables will work. It will be helpfull if you suggest me some documents or post it here.

Thanx

Sriram

[Former Member]

Hi Sriram,

Instead use an OLAP variable to achieve the results you want.

But first check what are the selection oprions supported by your data source in the table <b>ROOSFIELD</b> in your source system.

Bye

Dinesh

Message was edited by: Dinesh Lalchand

Message was edited by: Dinesh Lalchand

[Former Member]

Thanx for your replies guys,

Aneesh, can i find any documents regarding the same? I wanted to fetch all the records with blank company code. So just i thought will give the selection as

LT the lowest value

Can I give something like

Option = 'EQ'.

and Low = ''. ??

Thanx for your post again, have assigned some points

Regards

Sriram

[Former Member]

In InfoPack selections only EQ and BT can be used. Less than, greater than, etc. are not supported.