data entry in ztable

[Former Member]

Hi,

I've generated a Z table and created table maintenance generator for it.

now without manually entering values into this table,can i enter data from an excel/word file directly?

if,yes please tell me the process.it's urgent!

points will be awarded,

regards,

ravi.

[Former Member]

Hi

U need to create a little program reads your file and insert the data into your table.

U can use fm as GUI_UPLOAD to read the file.

Max

[Former Member]

it is not possible to enter the records directly from excel. You have to write ABAP program to read file from excel and insert the records into ztable.

[Former Member]

You can use function module 'ALSM_EXCEL_TO_INTERNAL_TABLE' to upload data in an Excel file to an internal table. Give the Import

Once the data is in the internal table, you can use either Insert, Update or Modify statements, according to your requirement, to populate the database table.

Hope this helps.

[Simha_]

Hi,

U need to write the BDC for that ...

or u can take the internal table of ur ztable structure and use the GUI_UPLOAD F.M to upload the data in to the internal table and then insert the entries in to your Ztable...

Cheers,

Simha,

[Former Member]

Hi,

Create a transaction code for ur table. Using SHDB tcode do the recording for your transaction. Using BDC session method or call transaction method u can enter data. To enter value from an excel file u have to use the Function Module ALSM_EXCEL_TO_INTERNAL_TABLE to upload data. If u need further infn u can ask me.

Regards,

U. Uma.

[Former Member]

Ravi,

1. Upload the excel data by using the function module GUI_UPLOAD .

If file is in presentation server and move the data into internal table.After that

update the data into Ztable.

2. If file is in application server Use OPEN DATASETS extract the file and move

data into internal table .Up[date the data into database table.

Pls. mark if useful.

[Former Member]

Hi

You can upload the data into table.

Check the compability of the data if not convert it into SAP standard

Upload the data into ITAB and insert the same into Ztable

Thanks

Shiva