topic steps for creating the table and code for loading text file into table in Application Development and Automation Discussions

steps for creating the table and code for loading text file into table

Former Member — Mon, 12 Jan 2009 17:24:19 GMT

Im SAP-BW Consultant . I have a text file with data .

I want to create a table and then load the data into this Z-table.

1) Please give the steps for creating the custom Z-Table .

2) How to load the text file data into the Z-Table .

Please give me the steps for creating the Z-Table and sample code for uploading the text file into that

Z-Table .

Thanks Alot

Regards

Mohammed

Former Member — Mon, 12 Jan 2009 17:26:58 GMT

trancode SE11 will let you create the table.

To upload it, you didn't define if it was coming from the local PC (Presentation Server) or

from the Network (Application Server)

Both methods are different. Additionally, you didn't mention what format the input file would be.

Tab delimited? Comma delimited? Fixed length record?

To many optoins to give you a straight answer to your question.

Edited by: Paul Chapman on Jan 12, 2009 12:27 PM

Former Member — Mon, 12 Jan 2009 17:29:05 GMT

Hi Mohammed,

Link Table Creation

To upload the data ..

Need to create the Zprogram ..

1. Upload the data from presentation server/ Application server into internal table.

2. using UPDATE statement upload the data from internal table to DB table.

It's the basic question Please seach the SCN before posting it..

Former Member — Thu, 13 Aug 2009 20:09:59 GMT

Thanks Alot

Mohammed