Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the average size of an ERP database metadata?

user-image
Question added by Salma Eid , Dietitian/Nutritionist , Muscle Power Sports, Nutrition Centre
Date Posted: 2017/04/12
Mohammad  hanif akhtar
by Mohammad hanif akhtar , plant operations head , Austin Nutri Food Industries LLC

 we can ballpark the space needed for metadata to be something between 50 to 150 GB.

Fahad Baguindali
by Fahad Baguindali , Executive Assistant , SETRA Co.

SAP Does not use a separate file or a different database to store its meta-data like table definitions, data elements or even the ABAP code.

 

Instead, SAP uses the same database space to store its metadata too. Eg.

DD02L - Table that stores all available SAP TablesDD03L - Stores Table fields,DD04L - Stores Data Elements,

 

Not only this, whenever you keep a breakpoint in anyprogram, even that data is captured in database tables (ABDBG_BPS & ABDBG_INFO).

 

SAP ECC 6.0 Installation package along with Oracle database occupies around 50 GB including its Kernel and atleast 250 GB of hard disk space is needed to get this software up and running.

Kiran Chiliveru Chiliveru
by Kiran Chiliveru Chiliveru , Procurement and Logistics Analyst , Procter and Gamble FZE

ABAP tables stored in REPOSRC

Mubashir Ali Aziz
by Mubashir Ali Aziz , Stores & Assets Administrator , Batco, Lavajet

SAP Does not use a separate file or a different database to store its meta-data.

Zafar Jamal
by Zafar Jamal , Senior Accounts Officer , IKAN Engineering Services (Pvt) Ltd

SAP Does not use a separate file or a different database to store its meta-data like table definitions, data elements or even the ABAP code.

Asim Rahman Khan
by Asim Rahman Khan , Finance Analyst , GE Oil & Gas (Manpower)

It depends upon the company which uses SAP.

Akbar Rattani
by Akbar Rattani , CIO - Head of IT , MenaBev - Pepsi Bottler

Well there is no certain answer for this question. Nevertheless, if ERP is based on SAP then there is no separate space for metadata except in HANA where temporary memory / on client storage act as metadata for sorting and table space.

If Oracle EBS system is implemented than again metadata will vary based on modules implemented for the sake of answer it varies between 40 MB to  Tera bit (in this case it's recommended to have cloud solution) :)

 

Regards,

Akbar 

rahul barad
by rahul barad , Microsoft Dynamisc Navision Consultant , Servpro Technologies Pvt Ltd

for Initial stage 8 gb afterwards it can be increase

Manu Radhakrishnan
by Manu Radhakrishnan , Data Science Trainee , Beach Theory

An SAP DB typically depends upon the size of the company it is imlemented in. After Go-Live the size can be anywhere between 300-1000GB

Mohd Kamil
by Mohd Kamil , SAP SD functional consultant , unisoft infotech pvt ltd

SAP Does not use a separate file or a different database to store its meta-data like table definitions, data elements or even the ABAP code.Instead, SAP uses the same database space to store its metadata too. Eg. DD02L - Table that stores all available SAP TablesDD03L - Stores Table fields,DD04L - Stores Data Elements,The source code of all ABAP programs are stored in as compressed RAW string in REPOSRC table.

Hasnat Noor Chowdhury
by Hasnat Noor Chowdhury , Head of Business Operations , RANCON

It should be 100 to 200 GB on average.

More Questions Like This