Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

cg3z t-code

Hi SDNers,

I want to upload an excel file from presentation server to application server using cg3z.

I need step-by-step procedure and i have the following doubts. Please clarify it.

a. Shall i want to do the column width in excel file for the fields which i am going to use in my report.

b. Shall i want to remove the header line (First line) in the excel sheet.

c. In which file format wether ASC/BIN should i want to choose. And also which file will support ASC and which one will support BIN.

d. Where (in which t-code) will i check the uploaded data.

Thanks in advance.

Reward sure for helpful answers.

Senthil kumar

Tags:
Former Member
Former Member replied

Hi Senthil,

I sugest u to upload the file in CSV format.

Open ur excel=>File=>Save as CSV file.

Now in CG3Z give presentation and application server file names, Transfer format as ASC and click on enter. Give the application server file extension as .dat for .txt or .csv.

Now if u want to read the data then use open data set and read data set and close data set statements in ur program.

a. Shall i want to do the column width in excel file for the fields which i am going to use in my report.
"Not required

b. Shall i want to remove the header line (First line) in the excel sheet.
"If u remove the header then u can directly use the internal 
"table after read dataset. If u upload with header then u have to 
"delete the first record which is ur header.

c. In which file format wether ASC/BIN should i want to choose. And also which file will support ASC and which one will support BIN.
"U can use BIN or ASC. Both will work. While downloading 
"ASC works for 1500 characters line length. so better use BIN

d. Where (in which t-code) will i check the uploaded data.
"Go to CG3Y, Give both file names, download to .txt or .csv file.
"U can see the uploaded data.

"If the line length is less than 255 characters u can directly 
"view the data in transaction AL11

Thanks,

Vinod.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question