Table containing GRN Data

[Former Member]

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]

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]

Hi,

Which fields are you using from that table...

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

Regards,

Siddarth

[Former Member]

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]

Hi,

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

Regards.

[Former Member]

Hai,

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

But I need table containing GRN Data.

[Former Member]

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]

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

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

[Former Member]

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.