Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

BDC

Go to solution
Former Member

‎2007 Dec 24 9:17 AM

0 Likes
256

Friends,

I need the process to upload data from an EXCEL file located in the APPLICATION server to the internal table. I need your valuable inputs on this front.

Thanks in advance,

Ram.

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2007 Dec 24 10:42 AM

0 Likes
239

Hi

Sample code:

DATA: V_RECORD(200).

OPEN DATASET P_FILE FOR INPUT IN TEXT MODE ENCODING DEFAULT.

IF SY-SUBRC 0.

EXIT.

ENDIF.

DO.

READ DATASET P_FILE INTO V_RECORD.

IF SY-SUBRC NE 0.

EXIT.

ENDIF.

SPLIT V_Record at CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB "Tab delimeter

INTO WA-FIELD1 WA-FIELD2.

APPEND WA TO ITAB.

ENDDO.

Reward if Helpful.

Thanks

Siva kumar

1 REPLY 1
Read only

Go to solution
Former Member

‎2007 Dec 24 10:42 AM

0 Likes
240

Hi

Sample code:

DATA: V_RECORD(200).

OPEN DATASET P_FILE FOR INPUT IN TEXT MODE ENCODING DEFAULT.

IF SY-SUBRC 0.

EXIT.

ENDIF.

DO.

READ DATASET P_FILE INTO V_RECORD.

IF SY-SUBRC NE 0.

EXIT.

ENDIF.

SPLIT V_Record at CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB "Tab delimeter

INTO WA-FIELD1 WA-FIELD2.

APPEND WA TO ITAB.

ENDDO.

Reward if Helpful.

Thanks

Siva kumar