Type of Program

[Former Member]

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

[Former Member]

Hey,

Try goin with the first one.

Regards,

Midhun Abraham

[Former Member]

How abt the perfermance?

[Former Member]

About the performance?It depends on the amount of data to be uploaded.

Regards,

Midhun Abraham

[madan_ullasa]

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...

[Former Member]

In case of BDC, Which Transaction

should I have to record ?

My Z Table is similar/equal in Structure

to TCURR. WE need to put data into this Z Table !

[madan_ullasa]

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....

[Former Member]

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...