browsing data in SAP tables

[Former Member]

Dear experts

I am pretty much newbie in sap. I need to know how can i query SAP tables. I have configured SAP HANA studio and RAzorSQL tool with System user.

now i am accessing different schema for data but i cant found any single table related to the business, But i found mostly system admin tables with data .

Now i need to know do i need any other user to access application data??

do i need any other tool ??

Is there any schema designed in SAP to keep application modules data ,like MM data in MM folder , OM data in Another folder..
If someone help me to do query in MVKE – Sales Org, distribution channel table and browse data , it would be great help

regards

Anwer Ali

[matt]

Sounds like your backend is not an ERP system, rather just the ABAP stack. It doesn't contain the material master module.

[Former Member]

Dear Matthew

i am sharing on screen shot for your review, Please suggest if you understand. according to image my left side is schema where i assume that in these schema somewhere application data should be recorded.

sap.jpg

[Sandra_Rossi]

Please use the COMMENT button for comments, questions, adding details, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area.

If you do a comment under a question/answer and you want to target someone else than the question/answer' author, the only solution is to copy/paste their hyperlinked name so that the person receives a warning (NB: @ doesn't work/but typing this character will suggest hyperlinked names)

[Sandra_Rossi]

What is the scheme name of SAP ERP in your database? (log in via SAP GUI > menu System > Status > Database info)

Are you in the right tenant?

[venkateswaran_k]

Dear Anwar,

You need to identify the Schema name from your Admin. In that the SAP tables are stored as below.

Assuming your Schema name is MMSCHEMA then you can write a query as below

SELECT * FROM "MMSCHEMA".MVKE

Regards,

Venkat