How to do BDC without writing BDC program


23.    Select the work sheet of the Excel file where the actual data present. In this case it is Sheet1$ and Click “OK” button.

24.     A new popup screen would appear with the data. Click “OK” button.

25.     Now click “Next: Write your letter” link.

26.     Click “Next: Preview your letters” link.

27.      Now you can see the first record got merged with the word document.

28.     Click “Next: Complete the merge” link.

29.     Click the “Edit individual letters…” link

30.      A new popup will get triggered, there you select “All” radio button and click “OK” button.

31.     Now you can see the merge has been done in the word document and it will create the BDC program for all the records in the Excel sheet. (In this case we had 10 records in excel sheet, hence the merge has created 10 pages in the word document. One page for each record)

32.     Now Select the entire content in the word document (i.e. all the 10 pages) and copy it in a notepad and save as separate “TXT” file.

33.    Go to the SHDB transaction and select your recording and click “Change” button.


34.    Now use the “Import” button   to download the TXT file which we saved in Step # 32.

35.    Once you click the Import button, a popup will come from there you select the file and click “Transfer” button.

36.    It will transfer the entire content to the SHDB. Now Save the changes. Click “Back” button.

37.    Now click the “Session” button, in order to create a new session.

38.     The following popup will get triggered, there you enter the new session name and check the “Keep session” check box and click “Continue” button.

39.     You will get the “Success Message” that “Batch input session ZTST_GOK was created”.

40.     Now go to the Transaction SM35 (Batch Input: Session Overview), there you select your “Session” which you have created in Step # 38 (You can the status of your session will be New) and click “Process” button.

41.     A small popup will get triggered, there you select the “Background” radio button and check the “Extended Log” check box. Click “Process” button.

42.     You will get the success message “1 session(s) transferred to background processing”.

43.     And you can also see the status of your session has been changed from “New” to “In background”.

44.     Click “Log” button, to see the details about the BDC.

45.     You will taken to the another screen, there you can see status of the BDC.

46.     In our case, the status is “Errors”, to know the details further. Select the entry and click “Analyze session”. It will display the status of all the records.

47.     In the above screen shot you can see the first two records were failed and others were processed. The reason for the same is: For the first time when we used SHDB we created the first condition record. Since this record is already there it failed in the second time. The same thing applies to the second failure case.

Please send us your feedback/suggestions at webmaster@SAPTechnical.COM 

HomeContribute About Us Privacy Terms Of Use • Disclaimer • SafeCompanies: Advertise on SAPTechnical.COM | Post JobContact Us  

Graphic Design by Round the Bend Wizards

footer image footer image