on 02-21-2008 7:32 AM
can any one explain me how to create a BDC from the scratch with an example?
Hi
Step-by-Step Process
Task 1: Recording
1. Give transaction SHDB ( Transaction Recorder ), this is used to record our transaction
Press New Recording, Give Recording name, Give Transaction, And Press Start Recording.
BDC Step-by-Step SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com © 2007 SAP AG 4
2. You will get the following screen, Give the selection screen inputs as below, finally
Save.
BDC Step-by-Step SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com © 2007 SAP AG 5
3. The following screen comes when you save, this shows table name and filed name
Which stores the data given in respected selection screen of transaction. Next Press
F3 to come back.
BDC Step-by-Step SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com © 2007 SAP AG 6
Task 2: Creating ABAP Report based on recording done
Now select your Recording and press Create program icon.
You will be asked to fill the following selection screens
��Using SE11 get the Length of the fields. It must be supplied in MS-Excel
Now we are going to Upload the following fields in
First Screen
Vendor No, Company Code, Account Group
Second Screen
Name, Search Parameter, Street, House No, City, Country Code, Region, PO Box
Language, Telephone
Final Screen
Recon Account, Cash Mgmt Group
Task 3: Writing ABAP report to do data transfer
Now Four Steps in ABAP Editor: BDC Step-by-Step SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com © 2007 SAP AG 11
1. Create an internal table for above fields in the report after Include bdcrecx1.
2. Next call upload function after start-of-selection
3. Put Loop after perform open group
Close loop using Endloop.
4. Now replace the constants in perform statement within loop by internal table name
With field name. Make the values used in recording in . Then Save, Activate
This is your data in MS-Excel. This order must be in the Internal table of ABAP report.
Unformatted Excel
Now Give respected Length for each fields. By placing Cursor in each column, Right Click, Select Column Width.
SelectText
Since LIFNR are 16 give that width.
After that save the excel file. And save a copy as Formatted text space delimited
Give OK, Yes, Then Close Excel by giving No.
Now come to ABAP editor and run the report, you will get the screen.
Select Call transaction Radio Button, and run in a mode. Press F8
Now in next screen Give the .prn file you saved previously. ( .prn must be selected )
Then press Transfer.
You will get following screen, Just Check for correct order of data, if yes, Press Enter
Next Screen comes, Press Enter.
The vendor created. And system shows log. If small errors you can select that from F4 help and run the report.
Hope this will make some sense to you
Thanks
Krushna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try this link may be it will help u...
http://abap-gallery.blogspot.com/2007/08/bdc-batch-data-communication-tutorial.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
BDC:
Batch Data Communication (BDC) is the process of transferring data from one SAP System to another SAP system or from a non-SAP system to SAP System.
Features :
BDC is an automatic procedure.
This method is used to transfer large amount of data that is available in electronic medium.
BDC can be used primarily when installing the SAP system and when transferring data from a legacy system (external system).
BDC uses normal transaction codes to transfer data.
Types of BDC :
CLASSICAL BATCH INPUT (Session Method)
CALL TRANSACTION
BATCH INPUT METHOD:
This method is also called as CLASSICAL METHOD.
Features:
Asynchronous processing.
Synchronous Processing in database update.
Transfer data for more than one transaction.
Batch input processing log will be generated.
During processing, no transaction is started until the previous transaction has been written to the database.
CALL TRANSACTION METHOD :
This is another method to transfer data from the legacy system.
Features:
Synchronous processing. The system performs a database commit immediately before and after the CALL TRANSACTION USING statement.
Updating the database can be either synchronous or asynchronous. The program specifies the update type.
Transfer data for a single transaction.
Transfers data for a sequence of dialog screens.
No batch input processing log is generated.
Differences between Call Transaction and Sessions Method:
Session method.
1) synchronous processing.
2) can tranfer large amount of data.
3) processing is slower.
4) error log is created
5) data is not updated until session is processed.
6) generally used for back ground jobs.
7) at atime we can update to more than one screens.
Call transaction.
1) asynchronous processing
2) can transfer small amount of data
3) processing is faster.
4) errors need to be handled explicitly
5) data is updated automatically
6) for background n fore ground jobs.
7) at atime we can update to a single screen.
For BDC:
http://myweb.dal.ca/hchinni/sap/bdc_home.htm
https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/bdc&;
http://www.sap-img.com/abap/learning-bdc-programming.htm
http://www.sapdevelopment.co.uk/bdc/bdchome.htm
http://www.sap-img.com/abap/difference-between-batch-input-and-call-transaction-in-bdc.htm
http://help.sap.com/saphelp_47x200/helpdata/en/69/c250684ba111d189750000e8322d00/frameset.htm
http://www.sapbrain.com/TUTORIALS/TECHNICAL/BDC_tutorial.html
Check these link:
http://www.sap-img.com/abap/difference-between-batch-input-and-call-transaction-in-bdc.htm
http://www.sap-img.com/abap/question-about-bdc-program.htm
http://www.itcserver.com/blog/2006/06/30/batch-input-vs-call-transaction/
http://www.planetsap.com/bdc_main_page.htm
Follow the links for BDC tutorials.
http://www.sapbrainsonline.com/TUTORIALS/TECHNICAL/BDC_tutorial.html
http://aspalliance.com/1130_Batch_Data_Communication_BDC_in_SAP_R3
http://abap-gallery.blogspot.com/2007/08/bdc-batch-data-communication-tutorial.html
Follow this link for a easy tutorial on BDC for t-code MM01.
https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/bdc%2btutorial
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.