Data size based on Company code

[Former Member]

Hi Folks,

As a part of separation, there is an ask to transfer financial data from our ERP system, the data is based on company codes.

I have an ask to suggest what will be the size of the data in terms of storage which we will have to transfer out. Can anyone suggest which tables I should be looking at, I can pull out data based on a query and then calculate what will it occupy but can someone suggest tables I should be querying as SAP or DB level.

we have SQL Server.

Yogesh

[yakcinar]

Hello Yogesh,

I am not sure about all tables related to company code.

But if i were you I would look at the largest 50 tables (number can change according your DB size, selection etc). Mostly these 50 largest tables occupy 70-80% of the DB size.

For the rest of the tables you can use the same calculated % ratio.

And run table analysis for all tables using TAANA transaction in order to find the related company code's number of records. Then you can take the size rartios of the tables using this # of records.

Regards,

Yuksel AKCINAR