Data modeling from Sap tables which are in Sql server

[Former Member]

    Any body help me about how to prepare a model from sap tables which are stored in SQL Server.

I don't have any knowledge on SAP.

Please help me out in this.

Thanks,

Vishnu

[giri_ayyagari]

Use CA ERWIN tools or SQL server native diagramming to develop ERD. keep in mind there are 10s of thousands of tables in  SAP. you might look for existing or available one.

-giri

[Former Member]

Thanks for your answer.

     Does SAP tables contain Constraints like primary key and foreign key relationships,

how can i classify dimensions and facts from those tables.

-vishnu