Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Transactions per Material

Bhushan_hs
Participant

‎2010 Mar 12 11:34 AM

0 Likes
503

Dear Experts,

I have a requirement where in for a particular material & particular company code what and all transactions has happened suppose for example PO,SO etc.

All details I want any table will solve my purpose

Any help will be highly appreciated.

Edited by: Bhushan on Mar 12, 2010 5:04 PM

Dear Experts,

I have a requirement where in for a particular material & particular company code what and all transactions has happened suppose for example PO,SO etc.

All details I want any table will solve my purpose

Any help will be highly appreciated.

Edited by: Bhushan on Mar 12, 2010 5:04 PM

Reply
1 REPLY 1
Read only

vadimklimov
Active Contributor

‎2010 Mar 12 12:16 PM

0 Likes
435

Dear Bhushan,

You can have a look into tables MKPF and MSEG containing material documents info (MKPF - document header level, MSEG - document item level). Here you can evaluate transactions based on transaction type (MKPF-VGART), document type (MKPF-BLART), movement type (MSEG-BWART), plant (MSEG-WERKS), etc. E.g. transaction type and movement type can be used to identify the original business transaction, which caused the transaction with the material.

In order to find out plants assigned to the given company code (so that company code could be among selection criteria, but respective plants could be submitted for selection from material documents' tables), view V_T001K_ASSIGN can be used.

My regards,

Vadim