Skip to Content
avatar image
Former Member

Type of Program

Dear All

WE have a Z Table with 3 primary keys.

The data for this table comes from a Legancy System

in a File.

We need to upload the Data from this File into the Z

Table.

We are planning to design Z program to does the data

upload that will run in both DIRECT and BATCH mode. What type of Data Upoloading will be best:

1. Direct DB MODIFY(using Stmt MODIFY Ztable FROM itab)

2. BDC necessary ?

or anyother.

Please advice.

RJ

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 08, 2008 at 03:48 AM

    Hi,

    Use BDC, if the fields in your Z table has check table or if there are other validations... if it is a simple upload to the Z table then you use 'modifiy'... 'Insert' will be faster i believe...

    regards,

    Madan...

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      You would have to go this way for BDC.. Generate the table maintenance....then give a 'Z' tcode for that...You can then use this Tcode in your 'Call transaction' or in session method.. lenghty process if your are just looking for a simple upload...

      I suggest you go for 'modify' or 'insert'... only if you have validations... like, say the fields had F4 help, then you can go for BDC... You can capture the errors in BDC... where as in direct update you can only capture the 'sy-subrc' values....

      Regards,

      Madan....

  • avatar image
    Former Member
    Oct 08, 2008 at 03:59 AM

    Hi,

    Since this is a Z table with simple business logic, I would recommend you to go with the first option: Modify Z table directly, as it's better from the performance point of view, and easier to do.

    This option is better because:

    1. You don't have to create a dialog program to do it

    2. You can use mass insert/update (MODIFY Ztable FROM itab)

    If you want to do BDC, then you will have to:

    1. You have to create a dialog program

    2. You have to create BDC program to batch data

    And in terms of performance it's slower than the first option.

    Regards,

    Lim...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2008 at 03:41 AM

    Hey,

    Try goin with the first one.

    Regards,

    Midhun Abraham

    Add comment
    10|10000 characters needed characters exceeded