Thanks for the response guys actually here is what i am trying to do.
My business guys wants to know what all plants are using a specific Output type (ZFAX).
Through Conditions i could get the Pur Org, Pur Grp and Vendor associated with that Out put but i dont understand how to pull the plant details.
Any suggestions please...
for this you need to go to table NAST and put your ZFAX in the message type field, then execute you will get all the entries with object key (OBJKY) after this copy all these OBJKY and put this into EKKO to get your PUR grp and where EKKO-EBELN = OBJKY (here object ky is the P.O number) and input the OBJKY in EKPO to get plant.
for this you need to develop a Z report with the above logic
hope this helps
Thats a good way to do but we have like 400,000 PO's in the system with same Output type ZFAX. I cannot even download it to excel. Is there any other way to get the plant data?
I could find one table B912 which has Output type, Pur Grp Pur Org, Vendor, and Inforecord.
Is there any table to link with B912, create a query and get the plant dat as well?
I dont think that you have a message type at EBAN level.
B912 is a condition table, that is specific to the access sequence. that is used to determine an output table. However ZFAX can be used in several other condition tables, too.
You can do an download to a text file.
The text file can then be imported to MS ACCESS Database and be analyzed there.