topic Type of Program in Application Development and Automation Discussions

Type of Program

Former Member — Wed, 08 Oct 2008 03:34:38 GMT

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.

Re: Type of Program

Former Member — Wed, 08 Oct 2008 03:41:45 GMT

Hey,

Try goin with the first one.

Regards,

Midhun Abraham

Re: Type of Program

Former Member — Wed, 08 Oct 2008 03:42:31 GMT

How abt the perfermance?

Re: Type of Program

Former Member — Wed, 08 Oct 2008 03:44:36 GMT

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

Regards,

Midhun Abraham

Re: Type of Program

madan_ullasa — Wed, 08 Oct 2008 03:48:38 GMT

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

Re: Type of Program

Former Member — Wed, 08 Oct 2008 03:59:52 GMT

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

Re: Type of Program

Former Member — Wed, 08 Oct 2008 04:04:52 GMT

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 !

Re: Type of Program

madan_ullasa — Wed, 08 Oct 2008 04:13:25 GMT

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