Skip to Content
0

Datasource FM using BAPI_ALM_ORDER_GET_DETAIL not working

Nov 07, 2017 at 09:53 AM

74

avatar image
Former Member

Hi All

We have developed a datasource using a function module inside which it calls the BAPI '

BAPI_ALM_ORDER_GET_DETAIL' . The datasource works perfectly fine when executed through RSA3 tcode in SAP but when it is extracted through SQL team it is going in endless time and not providing them any records . Is there any issues using this BAPI ? Kindly assist.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Paul Meehan
Nov 09, 2017 at 12:23 PM
0

Hi,

Should not be any problem with this BAPI. Check it independently using SE37 to verify your selection does return data.

-Paul

Share
10 |10000 characters needed characters left characters exceeded
Andras Margitics
Nov 09, 2017 at 08:56 AM
0

Hi Ujj,

This BAPI is connecting to component PM-WOC-MO ( Maintenance Orders ).

You could try to extend the tags with the component, I do not see any impoct from BW side at the moment.

Br, Andras

Share
10 |10000 characters needed characters left characters exceeded
Raymond Giuseppi
Nov 09, 2017 at 09:21 AM
0

Did you check for authorization failure, during your RSA3 test did you extract only small volume of data, etc.

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Raymond , Yes small amount of data is getting fetched so no authorization issue . The SQL people say it extracts only 300-400 records and don't go over that .

0

How do they (SQL) extract the data, for example a BW system will execute multiple requests to extract data package after package until the extractor raise the no_more_data exception. Also you should check execution in source system (Did you free some memory between call of BAPI, damage caused by non sorted big internal table with wrong read statements can kill the performance concept)

" small amount of data is getting fetched so no authorization issue 

Volume of data and authorization check are not really linked... so why 'so'?

1
Former Member

Actaully this an SQL system outside SAP Box. They directly access our datasource created in SAP. I used below FM for refresh of buffers .Is there any FM thourgh which I should free up memory ? Kindly suggest.

CALL FUNCTION 'BUFFER_REFRESH_ALL'.

CALL FUNCTION 'BAPI_ALM_ORDER_GET_DETAIL'
EXPORTING

0

First check on source system for actual problem, those were only assumptions, you have to look first in your system during call. Insure with the guys of the SQL system if they correctly call the extractors.

For memory release you could look at FM like ITOB_BUF_CLEANUP or CO_IH_BUFFER_REFRESH depending on your version of SAP. Or execute the BAPI thru a RFC call so in another LUW (force close with RFC_CONNECTION_CLOSE at end of each package if required)

1

Try FM "IBAPI_PROC_INIT_REQUEST" to clear Buffers before executing the BAPI ...

1