topic Re: ASAp:Function module in Application Development and Automation Discussions

ASAp:Function module

Former Member — Fri, 20 Jun 2008 04:07:52 GMT

Is there any functional module or BAPI to fetch the idoc number from edidc table based on the idoc creation date,idoc type and partner number?

Re: ASAp:Function module

former_member189059 — Fri, 20 Jun 2008 04:25:14 GMT

try using a select statement

Re: ASAp:Function module

Former Member — Fri, 20 Jun 2008 04:29:35 GMT

ya i have written using select statement only but performance issues is arising thats the reason to go to FM or BAPI

Re: ASAp:Function module

former_member189059 — Fri, 20 Jun 2008 04:34:24 GMT

Hello,

Even if there was a FM or BAPI, it wouldn't make a performance difference since it would in turn execute a similar select statement

Using 'select single' is a better option that select if you need a single record

Re: ASAp:Function module

Former Member — Fri, 20 Jun 2008 04:38:41 GMT

I cant use select single coz have to fetch lot of values from the table so its better to use FM or BAPI.Please help

Re: ASAp:Function module

former_member189059 — Fri, 20 Jun 2008 04:41:58 GMT

ok.. i'm not sure of your exact scenario, but you can try using 'select.. for all entries' in order to get all the required entries in an internal table

then use 'read table.. with key' to get a single record from the internal table

this approach would need just one db call

Re: ASAp:Function module

Former Member — Fri, 20 Jun 2008 04:48:03 GMT

Have written the select query as

SELECT docnum FROM edidc INTO TABLE gi_edidc

WHERE credat IN s_credat AND idoctp = gc_idoctype

AND rcvprn IN s_lifnr .

This is taking much time since the problem.

Re: ASAp:Function module

former_member189059 — Fri, 20 Jun 2008 05:18:38 GMT

yes.. your approach seems fine

I don't think any FM would be able to improve it

Re: ASAp:Function module

Former Member — Fri, 20 Jun 2008 05:24:58 GMT

Is there any FM or BAPI?