Skip to Content
avatar image
Former Member

Adding data to Z table from a file

Hi All,

Is there some way I can import data from a file into Z table without creating BDC for SM30 transaction. Is there some facility in SM30 itself which will allow me to do mass data imports?

Thanks for reading

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Apr 14, 2006 at 08:16 PM

    I meant an excel file

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      If you have LSMW , You can upload data using LSMW. But if you dont have much validations i suggest upload via BDC only.

      Hope this helps.

      Thanks,

      Vamshi

  • avatar image
    Former Member
    Apr 14, 2006 at 09:35 PM

    I wish there can be upload utility ..But BDC is only a good option OR you can write a program which reads your file INSERT in DB .

    After that You can compare the view using tr.SCMP and adjust in other clients OR Transport the entries ..

    Hope this’ll give u some help!!

    Don’t forget to award the points !!

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 16, 2006 at 09:42 PM

    Think you are much better off writing a simple program using Insert. If you are going to use program frequently then Insert DB statement is definately better in performance then BDC.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 16, 2006 at 11:27 PM

    Hi Srikrishna,

    Check the link below, its a utility tool available on SDN itself and you can use this tool to upload data to any z table.

    Ofcourse the best way is to write a simple piece of code but at time we need to work smarter ;-).

    <a href="/people/alvaro.tejadagalindo/blog/2006/03/16/taking-good-care-of-z-data & Download data from any Z table</a>

    Hope this helps.

    Cheers

    VJ

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 17, 2006 at 04:14 AM

    Hi Srikrishna,

    1. Does this Z Table have an associated

    Program (MOdule Pool)

    for data entry purpose ?

    2. If yes, then its always better

    to put data in Z Table via BDC.

    <b>3. Other wise its not necessary at all !</b>

    4. After uploading data in internal table,

    Loop at ITAB.

    MODIFY dbtab FROM itab.

    Endloop.

    regards,

    amit m.

    Add comment
    10|10000 characters needed characters exceeded