topic Re: Table containing GRN Data in Application Development and Automation Discussions

Table containing GRN Data

Former Member — Mon, 30 Mar 2009 05:14:45 GMT

Hai All,

I have used Tables EKBE and MSEG to get the GRN number, GRN quantity, GRN Date,

but I am not able to display the perfect data.

Have I used the wrong tables? If so, which table I have to use?

Former Member — Mon, 30 Mar 2009 05:18:23 GMT

Hi,

Which fields are you using from that table...

and for which transaction you want the records from these tables...

Regards,

Siddarth

Former Member — Mon, 30 Mar 2009 05:20:54 GMT

Hai,

I need GRN Number, GRN quantity, GRN date.

I have tried BELNR, LSMNG, BUDAT fields from EKBE table

and MBLNR, ERFMG, BUDAT from Mseg table.

I need this data to display the Purchase order data.

Former Member — Mon, 30 Mar 2009 05:28:30 GMT

Hi,

For purchase order data you may check the tables EKKO EKPO and EKET.

Regards.

Former Member — Mon, 30 Mar 2009 05:31:10 GMT

Hai,

I have used EKPO and EKET to get Purch Requisition and Purchase order data.

But I need table containing GRN Data.

Former Member — Mon, 30 Mar 2009 05:35:58 GMT

Hi,

Is there any transaction which displays these items... if so then try SQL trace you will get the details of all the tables it uses...

Regards,

Siddarth

Former Member — Mon, 30 Mar 2009 05:41:28 GMT

Check table MKPF - EBELN, BLDAT, BUDAT, XBLNR, BKTXT

and MSEG - MBLNR, BWART, LIFNR, MATNR, EBELN

Former Member — Mon, 30 Mar 2009 07:39:13 GMT

Hai,

Thanks.... I have used the same tables and have got all data except GRN Quantity.

Many fields are therefor quantity in table MSEG like.... 'MENGE' , 'LSFMG' , 'BAMNG' , 'ERFMG' etc.

But no field is giving the perfect data.

Pls help me if u have any idea on this.