Skip to Content
Author's profile photo basavaraj evani

Data Upload without Programming Using MS-Word Mail Merge

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

Assigned tags

      20 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Srinu S
      Srinu S

      Hi,

      Very nice effort.

      regards,

      Srinu.

      Author's profile photo Deep K
      Deep K

      Very simple and nice explanation..

      Author's profile photo venu gopal
      venu gopal

      Hai nice document

      thanks a lot for sharing this

      Author's profile photo Jürgen L
      Jürgen L

      Interesting route. There are more ways of killing a dog than by hanging

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Nice document but you could add more screenshots for understanding every step.

      Author's profile photo Deep K
      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

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Talk to your BASIS guy as it looks like you have some authorization issue or may be parameters issue. BASIS guy can understand this.

      Author's profile photo Suman Sardar
      Suman Sardar

      Nice presentation but agree with ' MoazzaM you can add some more screens.

      Author's profile photo Former Member
      Former Member

      Good Job and Really helpful. Keep on sharing.Thanks again. 🙂

      Regards Anirban

      Author's profile photo Sanil Bhandari
      Sanil Bhandari

      Very useful

      Regards

      Sanil Bhandari

      Author's profile photo Former Member
      Former Member

      Nice document...

      thanks for sharing..:)

      Author's profile photo Kenneth Moore
      Kenneth Moore

      Windows XP?  You really need to upgrade!  LOL!

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      😀

      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      🙂 helpful.........

      Author's profile photo Former Member
      Former Member

      Hi Basavaraj,

      Nice & useful document keep sharing. Thanks

      Author's profile photo Former Member
      Former Member

      Dear Basavaraj,

      Very useful Document and Continue the good work 🙂

      Thanks.

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli

      Nice document ....... 😎

      Author's profile photo pramod balanagendra
      pramod balanagendra

      excellent work 🙂

      Author's profile photo Kishore Reddy
      Kishore Reddy

      Nice Document....thanks for sharing..:)

      Author's profile photo Former Member
      Former Member

      Superb !!! It saved lot of time....