on 07-13-2005 10:00 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sriram,
It would be relevant for the datasource.
Bye
Dinesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In InfoPack selections only EQ and BT can be used. Less than, greater than, etc. are not supported.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.