Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

VBAP function module/BAPI

Former Member

‎02-27-2008 12:34 PM

0 Kudos

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

4 REPLIES 4

Former Member

‎02-27-2008 12:36 PM

0 Kudos

Hi

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

Regards

shiva

Former Member

‎02-27-2008 12:41 PM

0 Kudos

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

Former Member

‎02-27-2008 8:40 PM

0 Kudos

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.

Former Member

‎02-27-2008 8:41 PM

0 Kudos

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.