10-17-2007 6:27 PM
I want all the Goods Receipts Qty to be accumulated in weekly buckets. The ztable consists of following fields
Vendor No.
Material
Year (Eg. 2007)
Week01 (Eg. Total Receipt Qty for 1st week of 2007)
Week02 (Eg. Total Receipt Qty for 2nd week of 2007)
.
.
Week052
Which table I can find the values for above goods receipt information? Kindly help me.
Thanks
10-17-2007 6:31 PM
Hi
Use the tables<b> MSEG and MKPF</b> for the Goods receipt and GOODS issue data
Reward if useful
Anji
10-17-2007 6:31 PM
Hi
Use the tables<b> MSEG and MKPF</b> for the Goods receipt and GOODS issue data
Reward if useful
Anji
10-17-2007 6:32 PM
You will have to write extract program which will update this table regularly.
EKBE is the table which stores PO History where you can get Goods Receipts data.
MKPF and MSEG are material document header and item details. MSEG is a huge table and it takes long execution time if used in programs.
This should give you some idea to start with.
ashish
10-17-2007 7:15 PM
I understand MSEG is a Huge table but there is no vendor number in EKBE. Is there any table where I can find vendor number other than MSEG table?
10-17-2007 7:18 PM
Instead of touching MSEG, i wil lprefer to use EKKO table. EKBE will provide you the PO No, using this you can always get Vendor from EKKO.
10-17-2007 7:25 PM
Ashish
Thanks a lot. I think it will work. I will try to use both these tables.
Thanks
04-28-2009 7:27 PM
10-17-2007 7:22 PM