10-08-2008 4:34 AM
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
10-08-2008 4: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...
10-08-2008 4:41 AM
10-08-2008 4:42 AM
10-08-2008 4:44 AM
About the performance?It depends on the amount of data to be uploaded.
Regards,
Midhun Abraham
10-08-2008 4: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...
10-08-2008 5:04 AM
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 !
10-08-2008 5:13 AM
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....
10-08-2008 4: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...