Standard Table on Schema

[#1]

Hi,

Greetings!

I'm very new in SAP HANA and would like yours help on basic question. I've one schema but inside Tables folder I'm not able to see the standard tables like MARA, BSEG, MSEG so on and our ECC is also using same SAP HANA DB. What would the possible reason and how to get that? And for this also we've to use Data provisioning methods?

Regards,

Binay Biswakarma

[Former Member · Accepted solution]

hi,

Looks like you are checking the standard tables under directory/folder created for your USERID.

FInd the folder/Directory where the standard tables are stored:-

May be you can follow the below path:-

Expand<Hana DB Name>

     - Expand Catalog

        -  Expand  <Directory/Folder for your ECC e.g. SAPECC>

            - Expand Tables

               - Search for MARA, BSEG etc

[Former Member]

Thank you guys there is another schema which is related to SAP ECC. One more question do I need authorization to use and read these standard tables in modeling?

Regards,

Binay Biswakarma

[Former Member]

Hi Binay,

It depends on the situation whether the schema created has any authorization provided or not, if yes then you will face auth. error while using this tables.

In order to use remove this use following in SQL editor

GRANT SELECT ON SCHEMA<schema-name> TO <user -name> WITH GRANT OPTION;

thanks

[Former Member]

Thank you Sudatta!!

[Former Member]

Hi Binay,

Since this is your own made schema, you will find only customized tables made by you.For standard ECC tables to be reflected under your schema you need to extract those tables through data provisioning methods, like BODS, SLT etc, each having its own way of extraction method.

The procedures are available in SCN.

Thanks

Sudatta