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

OQN6 Catalog & catalog Profile

Former Member

‎2009 Dec 01 9:53 AM

0 Kudos
514

I have the excel sheet with catalog(QATART) & Code(QCODEGRP) fields which contain A,B,C,2, 5 and QCODEGRP contain PM1 along with the catalog and Discription.

I want to upload this Excel with proper programing in BDC

Please help me on this

kalpana N

2 REPLIES 2
Read only

Former Member

‎2009 Dec 01 10:34 AM

0 Kudos
364

use FM GUI_DOWNLOAD to downaload the data from Excel with Tab delimeter. in this FM use FILETYPE = DAT.

after that do your recording and pass the data to BDC..

Read only

dhirendra_pandit
Active Participant

‎2009 Dec 11 11:55 AM

0 Kudos
364

Hi,

Use ALSM_EXCEL_TO_INTERNAL_TABLEfunction module to read the excel sheet data and put it in internal table.

and pass each record to BDC as per your requirement.

Regards

Dhirendra