Skip to Content
avatar image
Former Member

Upload Materials with z table

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 08, 2017 at 09:05 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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ß

  • Nov 14, 2017 at 07:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Frederic Girod

      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