Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the average size of an ERP database metadata?

user-image
Question ajoutée par Salma Eid , Dietitian/Nutritionist , Muscle Power Sports, Nutrition Centre
Date de publication: 2017/04/12
Mohammad  hanif akhtar
par 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
par 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
par Kiran Chiliveru Chiliveru , Procurement and Logistics Analyst , Procter and Gamble FZE

ABAP tables stored in REPOSRC

Mubashir Ali Aziz
par 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
par 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
par Asim Rahman Khan , Finance Analyst , GE Oil & Gas (Manpower)

It depends upon the company which uses SAP.

Akbar Rattani
par 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
par rahul barad , Microsoft Dynamisc Navision Consultant , Servpro Technologies Pvt Ltd

for Initial stage 8 gb afterwards it can be increase

Manu Radhakrishnan
par 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
par 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
par Hasnat Noor Chowdhury , Head of Business Operations , RANCON

It should be 100 to 200 GB on average.

More Questions Like This