topic Re: Select goods receipt in Application Development and Automation Discussions

Select goods receipt

Former Member — Mon, 18 Jun 2007 10:09:40 GMT

Dear All,

Could you please let me know what other selection scriteia to be considered for selecting goods received(MENGE) from MSEG table provided we have material doc (MBLNR) , year (MJAHR) and purchase doc (EBELN).

What other points to be considered in the below select query to obtain correct GR.

select mblnr

mjahr

zeile

Menge

into table lt_mseg

from MSEG

for all entries in lt_mkpf

where mblnr EQ lt_mkpf-belnr

and mjahr EQ lt_mkpf-gjahr

and zeile NE space

and matnr EQ gs_item-matnr

and ebeln EQ gs_item-ebeln

and ebelp EQ gs_item-ebelp

and j_3asiz EQ gs_item-grid.

Re: Select goods receipt

Former Member — Mon, 18 Jun 2007 10:20:02 GMT

check EKBE table .

EKBE - VGABE = 1.

<b>Hello ,

For GR u have to take Movement types 101/102 as a standard process .

If u want data based on the PO then better to use EKBE table to get performace.</b>

Regards

Peram

Re: Select goods receipt

Former Member — Mon, 18 Jun 2007 10:28:15 GMT

Thank you for your reply..

I mean what other field of MSEG table has to be considered inorder to get correct quantity MSEG-MENGE.

regards

Re: Select goods receipt

Former Member — Mon, 18 Jun 2007 10:29:11 GMT

Consider the MOVEMENT TYPE field BWART of table MSEG in the where condition

because based on the Movement type GR/GI and other goods movements are distinguished clearly

Reward points for useful Answers

Regards

Anji

Re: Select goods receipt

Former Member — Mon, 18 Jun 2007 10:36:35 GMT

BWART in MSEG table

Regards

Re: Select goods receipt

Former Member — Mon, 18 Jun 2007 13:00:24 GMT

Got the answer