topic Re: browsing data in SAP tables in Application Development and Automation Discussions

browsing data in SAP tables

Former Member — Thu, 21 May 2020 05:11:49 GMT

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

Re: browsing data in SAP tables

matt — Thu, 21 May 2020 05:21:17 GMT

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

Re: browsing data in SAP tables

Former Member — Thu, 21 May 2020 05:37:50 GMT

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

Re: browsing data in SAP tables

Sandra_Rossi — Thu, 21 May 2020 08:29:47 GMT

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?

Re: browsing data in SAP tables

Sandra_Rossi — Thu, 21 May 2020 08:30:03 GMT

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)

Re: browsing data in SAP tables

venkateswaran_k — Thu, 21 May 2020 09:04:13 GMT

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