ASAp:Function module

[Former Member]

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?

[former_member189059]

try using a select statement

[Former Member]

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

[former_member189059]

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

[Former Member]

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

[former_member189059]

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

[Former Member]

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.

[former_member189059]

yes.. your approach seems fine

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

[Former Member]

Is there any FM or BAPI?