cancel
Showing results for 
Search instead for 
Did you mean: 

Error in user-exit RSAP0001

Former Member
0 Kudos

I am getting an error when I try to activate the user exit for enhancing a datasource. It's giving me the message, "The work area L_S_(Extract structure name) is not long enough".

The select statement I used is like this.

select * from (table_name) into l_s_(Extract structure name) where field_name = l_s_(extract structure name)_(field_name).

Can anyone tell me why this is happening?

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

hi Pooja,

can you post the code here ?

i think you can't select table_name into l_s_[extract structure name] since they may not have the same structure.

if you need just some fields from (table_name), you can use e.g

select field1, field2 into l_field1 l_field2 from xyz

where ....

Former Member
0 Kudos

This is the code that I'm using.

data: l_s_ZFIAA_IS001 like ZFIAA_IS001,

l_tabix like sy-tabix.

CASE i_datasource.

WHEN 'ZFI_AA_001'.

loop at c_t_data into l_s_ZFIAA_IS001.

l_tabix = sy-tabix.

select * from ANLA into l_s_ZFIAA_IS001 where TXT50 = l_s_ZFIAA_IS001-TXT50.

if sy-subrc = 0

l_s_ZFIAA_IS001_TXT50 = ANLA_TXT50.

modify c_t_data from l_s_ZFIAA_IS001 index l_tabix.

endif.

endloop.

0 Kudos

hi Pooja,

you should use - instead of _ for table-field name.

datasource name is ZFI_AA_001 ?

try following code. hope this helps.

data: l_s_ZFIAA_IS001 like ZFIAA_IS001,

lv_TXT50 like ANLA-TXT50.

l_tabix like sy-tabix.

CASE i_datasource.

WHEN 'ZFI_AA_001'.

loop at c_t_data into l_s_ZFIAA_IS001.

l_tabix = sy-tabix.

clear lv_TXT50.

select TXT50 into lv_TXT50 from ANLA where TXT50 = l_s_ZFIAA_IS001-TXT50.

if sy-subrc = 0

l_s_ZFIAA_IS001_TXT50 = lv_TXT50.

modify c_t_data from l_s_ZFIAA_IS001 index l_tabix.

endif.

endloop.

Former Member
0 Kudos

Great!!

I was able to activate it with your code.

Thanks. Full points to you!!!

I tried to do the checking in RSA3.

I put the datasouce in and selected the debug mode and executed. Now, I wasn't really able to understand the screen after that. Then I selected the pushbutton, continue. On the status bar, it was showing something like, 'ZBW_ARBW_BIW_GET_DATA_IS' and the number of records selected. What is this?

Also, in the extractor checker, in the selections screen, I'm not able to find my new field, TXT50. Why is this? How do I make sure that the user exit is populating this field?

Former Member
0 Kudos

Hi pooja,

in RSA3, go with execute. then go with output list. then you could see list. from there you need to select the coloumns. this way you can make sure that whether the new field is getting correct values are not.

Regards,

Nagesh.

Former Member
0 Kudos

When I checked the datasource, this field is greyed out for selection option. I'm in change mode and I can select all other fields and save the datasource, but due to some reason, TXT50, which is the newly added field is greyed out. I'm not able to select it. I guess that's why it's not showing in RSA3. Any way I could select this field??

Former Member
0 Kudos

Nagesh,

While I execute, don't I need to select debug mode?

After I executed, I selected display list. Is this the output list that you're mentioning about?

0 Kudos

hi Pooja,

'ZBW_ARBW_BIW_GET_DATA_IS' is the extraction module used.

you can have txt50 for selection by removing first the checkmark for 'hidden' column for that field, edit datasource.

to display the contents extracted, you can click 'display' in rsa3 after running, double click the line, you may need change the layout (there is button) to add fields to be displayed.

hope this helps.

Former Member
0 Kudos

Hi Pooja,

RSA3--> provide DS > execute(after this one pop up will come it will show u the number of records)> display output list --> then you could see Data Packet Number and Records per packet --> double click on records --> then you could see the fileds --> some times all the fields won't be visible --> we need to select from the out put list in the menu options -->

settings>? layout> current.

hope it helps..

regards,

Nagesh.

Former Member
0 Kudos

Thanks A.H.P.

Yes, now I'm able to select TXT50.

Answers (1)

Answers (1)

0 Kudos

hi Pooja,

what's exactly the extract structure name you are using ?

could it be l_s_(extract structure name)<b>-</b>(field_name), instead of underscore ?

you can use variable e.g. l_s_02_itm.

hope this helps.

Former Member
0 Kudos

Thanks A.H.P.

Yes, I changed the underscore as hyphen.

I'm still having the same error.