topic Re: VBAP function module/BAPI in Application Development and Automation Discussions

VBAP function module/BAPI

Former Member — Wed, 27 Feb 2008 12:34:23 GMT

Hi all

I wnat to pick up Vbeln, posnr from VBAP.

I dont have the key fields and i want the data for a Material, Plant and storage location.

The select query is taking a lot of time.

Any FM/BAPI to make the data retrieval faster???

<REMOVED BY MODERATOR>

Regards

Ravish

Edited by: Alvaro Tejada Galindo on Feb 27, 2008 3:31 PM

Re: VBAP function module/BAPI

Former Member — Wed, 27 Feb 2008 12:36:34 GMT

Create secondary index for the fields you are using it may improve the performance

Regards

shiva

Re: VBAP function module/BAPI

Former Member — Wed, 27 Feb 2008 12:41:17 GMT

hi,

You can use the following BAPI to get all the material data.

BAPI_MATERIAL_GET_ALL.

You can check it,

I hope it wil give you an idea.

<REMOVED BY MODERATOR>

sekhar

Edited by: Alvaro Tejada Galindo on Feb 27, 2008 3:32 PM

Re: VBAP function module/BAPI

Former Member — Wed, 27 Feb 2008 20:40:13 GMT

Look to table VAPMA.

This table does not exactly meet your needs with the fields provided... but it is intended for Material level selection of sales orders. You could use some INNER JOIN(s) to meet your needs from there.

Re: VBAP function module/BAPI

Former Member — Wed, 27 Feb 2008 20:41:42 GMT

And a secondary index as cited above is certainly an option - your DBAs might have an issue with that, however - since VBAP is a large, line item table.