|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
How to do BDC without writing BDC program
Select the work
sheet of the Excel file where the actual data present. In this case it is
Sheet1$ and Click “OK” button.
popup screen would appear with the data. Click “OK” button.
“Next: Write your letter” link.
“Next: Preview your letters” link.
you can see the first record got merged with the word document.
“Next: Complete the merge” link.
“Edit individual letters…” link
new popup will get triggered, there you select “All” radio button and click
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)
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.
Go to the SHDB
transaction and select your recording and click “Change” button.
Now use the
download the TXT file which we saved in Step # 32.
Once you click
the Import button, a popup will come from there you select the file and click
It will transfer
the entire content to the SHDB. Now Save the changes. Click “Back” button.
Now click the
“Session” button, in order to create a new session.
following popup will get triggered, there you enter the new session name and
check the “Keep session” check box and click “Continue” button.
get the “Success Message” that “Batch input session ZTST_GOK was
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.
popup will get triggered, there you select the “Background” radio button and
check the “Extended Log” check box. Click “Process” button.
get the success message “1 session(s) transferred to background processing”.
can also see the status of your session has been changed from “New” to “In
“Log” button, to see the details about the BDC.
taken to the another screen, there you can see status of the BDC.
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.
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
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards