ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What is the average size of an ERP database metadata?

user-image
تم إضافة السؤال من قبل Salma Eid , Dietitian/Nutritionist , Muscle Power Sports, Nutrition Centre
تاريخ النشر: 2017/04/12
Mohammad  hanif akhtar
من قبل 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
من قبل 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
من قبل Kiran Chiliveru Chiliveru , Procurement and Logistics Analyst , Procter and Gamble FZE

ABAP tables stored in REPOSRC

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

It depends upon the company which uses SAP.

Akbar Rattani
من قبل 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
من قبل rahul barad , Microsoft Dynamisc Navision Consultant , Servpro Technologies Pvt Ltd

for Initial stage 8 gb afterwards it can be increase

Manu Radhakrishnan
من قبل 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
من قبل 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
من قبل Hasnat Noor Chowdhury , Head of Business Operations , RANCON

It should be 100 to 200 GB on average.

المزيد من الأسئلة المماثلة