cancel
Showing results for 
Search instead for 
Did you mean: 

Upload Materials with z table

Former Member
0 Kudos

Hi everyone.

This is the first time I upload a question because some consultants tell me that is not possible anything that I proposed. So I decided to upload a question to know if my thoughts are wrong or maybe correct.

We have a lot of materials to upload to the system (500k) and we need to extend at least 100 centers. Every consultant tells me that we need to create a file with this information required by SAP but my file size is 8 Gb. So I thought that if we create a z table and I access the database directly to upload all records and run a custom program that reads the z table I will win a lot of time. Is this possible?

Thanks.

Oskar

Accepted Solutions (0)

Answers (2)

Answers (2)

FredericGirod
Active Contributor
0 Kudos

Hi Oscar,

500 000 entries are a big quantities of data, in your source system, could you make some code ? could you send IDOC (EDI) ?

regards

Fred

Former Member
0 Kudos

Thanks Frederic.

Yes, I could create an IDOC and send it.

I am using Pentaho Data Integration (PDI) to move my info and can create anything.

Do you think that this way will be much more efficiently?

Oskar

FredericGirod
Active Contributor

I don't know your level in SAP, maybe you already know that but ..

There is 3 ways to integrate data into SAP :

- Batch-Input: like a macro, full control, very slow, error could be reprocessed

- Direct-Input: like an insert in the table, low control, very quick , no reprocess

- BAPI: high control, slow, no reprocess

All this techno needs files and will be a problem with 500 000 entries

Idoc used one of this techno, but could be reprocessed, could be split in block (you could say to SAP to commit all the 1000 entries), could be process in parallels, ...

If I were you, I will try to used Idoc

But, please, inform the Basis team about this amount of data, that will have an impact on the database size ... You must make some test before sending the full entries.

regards

Fred

Former Member
0 Kudos

Thanks Fred.

This week we will try with my interface tables (z tables) into the SAP database and in the next weeks we will try use idocs.

Thanks Oskar

d024348
Employee
Employee
0 Kudos

Sure it's possible; you can create your Z table, load the data into it and then write a program that accesses this table and calls BAPI_MATERIAL_SAVEREPLICA to create the materials.

Question is whether this is feasible; you'd need to code error handling, mark which Z table records are alreaday processed, make it restartable, provide a simulation mode, maybe even parallelization, ...

Loading materials via LSMW provides more support; you can maybe split your file in smaller chunks.

Former Member
0 Kudos

Thaks for your answer Ingo.

I will try to explain what I have now.

We create a DataBase on another server because support system tells us that SAP never ever allows inserting info directly into a "z table", they tell us that the best way is creating another database.

So I create 6 tables: MARA, MARC, MLGN, MVKE, EANS, CHARACTERISTICS. Then we did create an ABAP program that connects to the new database and read all materials that have a flag of "pending". When everything goes perfect returns to the database and change the flag to "done" and if the material had an error then change the flag to "error".

The problem is because to upload 5,000 materials into SAP I will need to create different rows in each table, and take days uploading data.

MARA: 5,000 rows

MARC: 350,000 rows

MLGN: 5,000 rows

MVKE: 5,600,000 rows (because we have 16 distribution channels by center)

EANS: 20,000 rows (approx)

CHARACTERISTICS: 10,000 rows.

So I want to change my architecture and create this tables into SAP Database, access it by a database user and insert all rows that I have to upload. Then the ABAP program will not need to open connection to another database, read the first material, mark status and close conection. I expect to increase my performance. Ingo if you think that I'm crazy no problem, but I feel so frustrated because I do not know very well SAP. Can this actions help me to encrease the performace?

Another question is: Can SAP upload the material entirely?? what I mean is join the 6 tables and upload it by one "select".

Really thanks Ingo.

d024348
Employee
Employee

Hi, never directly write to SAP tables (MARA, MARC, ...)

Z tables can be created everywhere, need not be on an own server.

You can write into your own Z tables any way you like.

That's about what I can add to this topic, regards, Ingo Bruß