on 10-08-2007 3:24 PM
hi all, urgent
SELECT pernr
usrid_long
FROM pa0105
INTO CORRESPONDING FIELDS OF TABLE it_pa0105
FOR ALL ENTRIES IN <gt_tc_data_all>
WHERE pernr = <gt_tc_data_all>-REC-PARTNER .
<gt_tc_data_all> is the field symbol i am having.
i want to put the query but it is showing the error like.
the specified type has no struycture and there fore no component called
"REC-PARTNER".
please tell me how can i use the where condition here.
pls give me the syntax .
Message was edited by:
Prabhudutta ......
solved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
did you create your table with create data and then made an assign to the <fs> ?
I suppose your field symbol is type any table or something like it.
That's why the structure is unknown so far.
I'm not sure if it works but try this.
<b>data: <my_fs> type any</b>
<b>assign component 'REC-PARTNER' of structure <gt_tc_data_all> to <my_fs>.</b>
and then your select statement:
SELECT pernr
usrid_long
FROM pa0105
INTO CORRESPONDING FIELDS OF TABLE it_pa0105
FOR ALL ENTRIES IN <gt_tc_data_all>
WHERE pernr = <b><my_fs>.</b>
Kind Regards
Henner
<b>Award if helpful</b>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
assuming that your field-symbol is clearly typed (not type any) and the type hold a component named as you specified, then you're code should work.
But, a component named REC-PARTNER is not valid. May be your component is named REC_PARTNER, or maybe a structure is named REC and the component is named PARTNER, or may be you didn't clearly type your field-symbol.
If you didn't find out so far, post some more of your code.
regards
Sven
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
11 | |
10 | |
6 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.