Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Type of Program

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

madan_ullasa
Contributor
0 Kudos

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

7 REPLIES 7

Former Member
0 Kudos

Hey,

Try goin with the first one.

Regards,

Midhun Abraham

0 Kudos

How abt the perfermance?

0 Kudos

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

Regards,

Midhun Abraham

madan_ullasa
Contributor
0 Kudos

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

0 Kudos

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 !

0 Kudos

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
0 Kudos

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