topic Re: Goods Receipt table in Application Development and Automation Discussions

Goods Receipt table

Former Member — Wed, 17 Oct 2007 17:27:12 GMT

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 1’st 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

Former Member — Wed, 17 Oct 2007 17:31:34 GMT

Use the tables<b> MSEG and MKPF</b> for the Goods receipt and GOODS issue data

Reward if useful

Anji

Former Member — Wed, 17 Oct 2007 17:32:23 GMT

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

Former Member — Wed, 17 Oct 2007 18:15:11 GMT

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?

Former Member — Wed, 17 Oct 2007 18:18:37 GMT

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.

ferry_lianto — Wed, 17 Oct 2007 18:22:31 GMT

Hi,

Please try database view EKBI.

Regards,

Ferry Lianto

Former Member — Wed, 17 Oct 2007 18:25:41 GMT

Ashish

Thanks a lot. I think it will work. I will try to use both these tables.

Thanks

Former Member — Tue, 28 Apr 2009 18:27:13 GMT

resolved