03-30-2009 6:14 AM
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?
03-30-2009 6:18 AM
Hi,
Which fields are you using from that table...
and for which transaction you want the records from these tables...
Regards,
Siddarth
03-30-2009 6:20 AM
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.
03-30-2009 6:28 AM
Hi,
For purchase order data you may check the tables EKKO EKPO and EKET.
Regards.
03-30-2009 6:31 AM
Hai,
I have used EKPO and EKET to get Purch Requisition and Purchase order data.
But I need table containing GRN Data.
03-30-2009 6:35 AM
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
03-30-2009 6:41 AM
Check table MKPF - EBELN, BLDAT, BUDAT, XBLNR, BKTXT
and MSEG - MBLNR, BWART, LIFNR, MATNR, EBELN
03-30-2009 8:39 AM
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.