Use This Tool to Create or Update Mass Data Through BDC

  • by Sandeep Kumar, Lead Consultant, Infosys
  • January 8, 2014
Sandeep Kumar introduces a tool that allows you to run Batch Data Communication (BDC) through the SAP GUI. BDC can be used for a mass data update whenever a sample record is created using a standard SAP transaction. To create a BDC and run it, you need to perform a large number of manual activities. This BDC tool minimizes, to a large extent, the required manual activities.
Learning Objectives

Reading this article you will learn how to:

  • Prepare a data file to be used in BDC
  • Create a BDC in an SAP system using data files
  • Execute BDC in an SAP system
Key Concept

Batch Data Communication (BDC) is a batch interface technique developed by SAP that can be used when you need to create or update mass data in an SAP system. BDC has three steps:

  1. Record a transaction.
  2. Prepare the BDC file using the BDC creation tool.
  3. Run BDC to update data.

A successful execution of BDC at this point shows that BDC was correctly created and can now be used for the reason it was created.

In the course of normal business, you frequently need to create or update mass data in your SAP system. This can be done using an SAP program, a Legacy System Migration Workbench (LSMW) script, a third-party tool, if available, or Batch Data Communication (BDC). If there are different requirements every time you need to create or update mass data and you do not have access to an SAP program, an LSMW script, or third-party tools, then BDC can be a great help. It is the best choice when correcting the data of a single field. For example, in purchase orders (POs) or sales orders (SOs), when the field you need to correct varies each time, you have to perform the correction each time.

Transaction code SHDB is an SAP transaction that records the steps you take within another transaction up to and including when you save your entries. This recording then turns to BDC and is repeatedly used with different inputs from the file the BDC creation tool prepares. This is particularly useful if you have a large number of records to create or update. For example, if you need to create thousands of IDocs for testing purposes, you can use transaction code SHDB to create one sample IDoc and then create a cloning script by recording. The IDoc creation recording (transaction code WE19) is created using transaction code SHDB in any core SAP system. The IDoc test tool is an SAP functionality that is used to create new IDocs by cloning existing IDocs. However, transaction code SHDB can only create one IDoc at a time. In order to create multiple IDocs, you need to use this BDC creation tool. This article explains how to create and use this tool.

Sandeep Kumar

Sandeep Kumar is a lead consultant with Infosys with more than 17 years of experience working in the automotive, aeronautical, and hi-tech manufacturing industries. He specializes in implementing SAP in the manufacturing industry domain. He holds a master's degree in financial management and a bachelor’s degree in production and industrial engineering.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.