Data extraction from MARC & MBEW - t code.

[Former Member]

Dear friends,

I required extract data from MARC & MBEW (Material / Plant / valuation class).

I cannot recall the t.code to extract data from multiple table. Kindly help.

Thanks in advance.

Regards,

RAMAN.

[Former Member · Accepted solution]

Hi

SQ01 SAP Query: Maintain queries

SQ02 SAP Query: Maintain InfoSet

SQ03 SAP Query: Maintain user groups

SQVI QuickViewer

Regards

S.Senthil

[former_member433442]

Hi,

You can use T.Code SQVI for query creation.

Regards,

Prabu

[former_member496069]

Hi,

Use SQVI.

Maruthi Reddy

[former_member184655]

Dear Raman,

If your valuation area is equal to your plant then you can get the material,plant and also the valuation

class in the table MBEW itself.

If not then you have to create a query using SQ02 and SQ01 combination or else use SQVI.

Regards

Mangalraj.S

[Former Member]

Dear All,

Thank you verymuch for your expertise.

Problem resolved.

Giving points. Thanks for your support.

Best regards,

RAMAN.

[Former Member]

Hi Raman,

I do not think you can combine 2 tables in se16. The best way is to create a SAP Quickview using SQVI. This has excellent functionality for extracting the data to excel.

Ravi

[Former Member]

Hi,

You can use the report tool Query to do it! Refer to the following blog!

/people/tao.zhang/blog/2009/02/27/magical-function-of-sap-query

Hope can help you!

Good luck

Tao

[former_member212745]

Try using table join of MARC & MBEW in sqvi