Goods Receipt table

[Former Member]

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]

Hi

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

Reward if useful

Anji

[Former Member]

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]

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]

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.

[Former Member]

Ashish

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

Thanks

[Former Member]

resolved

[ferry_lianto]

Hi,

Please try database view EKBI.

Regards,

Ferry Lianto