|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
By Vikram Chellappa, Mouri Tech Solutions
In this example, I have used the transaction VV31
(Create Output – Condition Records - Billing) to do the BDC.
Go to Transaction SHDB and click “New Recording” button.
The following popup screen gets populated, there you enter
the Recording name and transaction for which you wish to do the BDC (In
this example it is VV31). Click “Start recording” button.
In the Transaction, enter the mandatory field. In this case
it is Output type (AUS1).
Hit enter key.
The following screen appears for more entry. Enter all the
mandatory fields and click on save.
SAP will give the Recorded program as shown in the following
Click the Export button
save the file as word document file into the system.
Now open the newly created word document file.
Select/Highlight the first field in the word document for
which for which BDC needs to done. (In this case it is output type i.e. AUS1)
and go to the menu path Insert à
A new screen will get populated and there you select the
“Merge Field” option from the list box and enter the Column Name (In this
case the 1st column is output_type).
Now you can see
in the word document that the highlighted field will get replaced with the
highlight the other fields for which we need to create the BDC and give the
unique column names for those fields.
Now you can see that all the required fields have been mapped
with unique column names.
Now go the menu
path Tools à
Letters and Mailings à
Mail Merge Wizard.
A mail merge
wizard will gets opened in the right hand side.
Now open the
excel file where which you have the data to do the BDC for transaction VV31.
Check that the column name in the word document is matching with the column name
in the Excel file.
Close the Excel
Switch to world
document and Now Click “Next: Start document” link in the bottom of Mail
Now click on “Next: Select recipients” link
Now click on “Browse” link
It will open the
popup for selecting the file (which is having data for BDC).
A new popup will
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