topic Re: data entry in ztable in Application Development and Automation Discussions

data entry in ztable

Former Member — Thu, 01 Feb 2007 08:51:42 GMT

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.

Re: data entry in ztable

Former Member — Thu, 01 Feb 2007 08:54:47 GMT

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

Re: data entry in ztable

Former Member — Thu, 01 Feb 2007 08:55:54 GMT

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.

Re: data entry in ztable

Simha_ — Thu, 01 Feb 2007 08:56:16 GMT

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,

Re: data entry in ztable

Former Member — Thu, 01 Feb 2007 08:56:23 GMT

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.

Re: data entry in ztable

Former Member — Thu, 01 Feb 2007 09:00:16 GMT

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.

Re: data entry in ztable

Former Member — Thu, 01 Feb 2007 09:08:06 GMT

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.

Re: data entry in ztable

Former Member — Thu, 01 Feb 2007 09:09:27 GMT

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