cancel
Showing results for 
Search instead for 
Did you mean: 

Abap routing in infopackage data selection

Former Member
0 Kudos
161

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (10)

Answers (10)

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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

Message was edited by: Pascal Gabin

Former Member
0 Kudos

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
0 Kudos

Hi Sriram,

It would be relevant for the datasource.

Bye

Dinesh

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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