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
Showing results for 
Search instead for 
Did you mean: 

material document ,quantity and stock location for a given material

former_member185116
Active Participant
0 Kudos

hello all,

i have a requirement like this.

in the selection screen i have,

material.....

plant....

posting document date.....

i need to get material document number,quantity,units and stock location for the above mentioned selection criteria...

what tables do i need to use..

do i need to use any BAPI or Function module..

thanks in advance...

1 ACCEPTED SOLUTION

yogendra_bhaskar
Contributor
0 Kudos

Hi Vinay ,

Look into table MKPF & MSEG for material document

anf for quantity in MARD

Regards

Yogendra Bhaskar

7 REPLIES 7

kiran_k8
Active Contributor
0 Kudos


Vinay,

I think MMBE and MB5B will get you all these details.

K.Kiran.

0 Kudos

hi kiran,

we are developing a custom smartform for report transaction MB5B,

karun_prabhu
Active Contributor
0 Kudos

Hello Vinay Reddy.

     Use MSEG table.

     For production order goods movements, use AUFM table.

Regards.

0 Kudos

hi arun,

there is a standard report MB5B,

for the same we are developing a smartform,

that is why i want know exactly which tables are used..

0 Kudos

To find the stock of material, use the FMs:

BF_READ_STOCK - Free stock

BF_READ_STOCK_Q - Project stock

BF_READ_STOCK_E - Sale order stock

yogendra_bhaskar
Contributor
0 Kudos

Hi Vinay ,

Look into table MKPF & MSEG for material document

anf for quantity in MARD

Regards

Yogendra Bhaskar

VenkatRamesh_V
Active Contributor
0 Kudos

Hi Vinay,

Use MSEG Table, try to create  Secondary Index for the Select-options Fields.

Regards,

Venkat.