topic Re: data upload into 'Z' table in Application Development and Automation Discussions

data upload into 'Z' table

Former Member — Thu, 16 Dec 2004 04:26:06 GMT

Hi All,

I want to upload legacy data into Z table for further use. for that following logic i am using.

Loop at itab.

insert into (DB table) values (Internal Table)

Endloop.

But, in above no validation check. so any other way can i upload? can i create screen similar to DB table using any SAP transaction?

Thanks in advance,

Parag

Former Member — Thu, 16 Dec 2004 05:33:27 GMT

Hi Parag,

If you want to provide any validation before uploading the datas into 'Z' table , do the following

1.Create a Table Maintanance using the Table Maintanance Generator from SE11 or SM30

2.Provide the validation in the Maintanance Screens (Use SE80 or SE51) - Its just the dialog program concepts to be used

3.Now write a BDC to upload in this Table using Transaction SM30

1.Do all your validation in your program and then just insert into the table --- Faster Method but not reliable

Hope these suggestions helps you.

BR,

Raj

Former Member — Thu, 16 Dec 2004 06:15:04 GMT

Hi raja,

Thanks for immediate help. i got the point.

Regards,

Parag