Skip to Content

Create BDC in SAP thru SHDB.

Start Recording

Select Choose (F2)

Fill amount and save.

Save Recording

And select Export

Save local folder.(Text Format BDC_RECORDING) (this file will be referred as 1st text file)

prepare excel data file and maintain header fields (the file which has to be uploaded)

PLANT

STLO

MAT

QTY

AMT

1011

RM00

RM-100

10

1000

1011

RM00

RM-100

1

1000

1011

RM00

RM-100

3

1000

1011

RM00

RM-100

4

1000

Then open the recorded text file in WORD FORMAT.

  1. Select Mailings à Start Mail Merge à Step by step Mail merge wizard

Click right side step 1 

Select Browse

Select your excel data file (which has to be uploaded)

Click Next: Write your letter.

Complete 4 and 5 steps

Click  6th step Complete the merge


Select your Recorded Field and Insert Merge Field (Ex:Plant).

Change all fields to insert merge fields (Respective headings given in the Excel data upload file)

Click Edit Individual letters

Click OK.

Save as other formats

Select Save ‘Plain Text’ format

Click Ok, then the file will be saved in plain text format.(this file will be referred as 2nd text file)

Go to SAP SHDB Transaction

Click Import & select the plain text format (2nd text file)

Click  Process

Select Processing Mode – N Background Processing

Select Update Mode – S Synchronous

Press Enter

Thanks and Warm Regards

Basavaraaj

To report this post you need to login first.

20 Comments

You must be Logged on to comment or reply to a post.

    1. Deep K

      Hi Mozzam, request to give your input on that and another issue i am facing issue with error message ‘

      Internal error: Fctn DOWNLOAD, RC = 15″   

      can you sujjest me how i can avoid this issue.

      Thanks in advance.

      Deep

      (0) 

Leave a Reply