topic Re: BDC recording in Application Development and Automation Discussions

BDC recording

Former Member — Mon, 06 Aug 2007 05:46:26 GMT

Hi,

what is BDC recording exactly?I have to upload GL master data from legacy system.

Re: BDC recording

Former Member — Mon, 06 Aug 2007 05:48:19 GMT

Hi,

Recording in BDC means that suppose you want to update some values in MM01 transaction and these values are in a flat file , so first start the recording from transaction sm35 an go new recording, here give the transaction name (e.g.-MM01) , and when the recording ends then go to the programme, it will give you the full recotding code , apply for these code in your original programme and then you will update the new values.

For more information go through the following l-----

Data Transfer Methods

You can use the following methods to transfer data:

• Direct input: With direct input, the SAP function modules execute the consistency checks. However with batch input, these consistency checks are executed with the help of the screens. This means that direct input has considerable performance advantages.

• CALL TRANSACTION: Data consistency check with the help of screen logic.

• Batch input with batch input sessions : Data consistency check with the help of screen logic.

Batch Input

Batch input is a standard technique for transferring large sets of data into the R/3 System. Here the transaction flow is simulated and the data is transferred as if it were entered online. The advantage of this is that all relevant checks of the transaction are executed, thereby ensuring that the data is consistent.

The batch input process is divided into two phases:

1. The data transfer program creates a batch input session that contains all the relevant data.

2. The batch input session is processed and the data it contains is transferred into the R/3 System.

The majority of SAP standard data transfer programs use the batch input technique. The data transfer program creates a batch input session which is processed later. Batch input sessions can be processed in various ways:

• In the foreground

• In the background

• During processing, with error display

You should process batch input sessions in the foreground or using the error display if you want to test the data transfer. If you want to execute the data transfer or test its performance, you should process the sessions in the background.

You can find detailed information on batch input in the Basis documentation BC - Basis Programming Interfaces under Transferring Data with Batch Input.

Difference between Batch Input and CALL TRANSACTION

If the direct input cannot be used for your task, this makes creating a data transfer program easier since the underlying transactions ensure that the data consistency checks are executed.

In the case of an error during the data transfer (if data records are inconsistent, for example), you can restart the transfer at the point in the program where the error occurred.

Data Transfer Overview

Batch input methods

With the batch input method, an ABAP program reads the external data that is to be entered in the R/3 System and stores the data in a "batch input session". The session records the actions that are required to transfer data into the system using normal SAP transactions.

When the program has generated the session, you can run the session to execute the SAP transactions in it. You can explicitly start and monitor a session with the batch input management function (by choosing System  Services  Batch input), or have the session run in the background processing system.

CALL TRANSACTION methods

In the second method, your program uses the ABAP statement CALL TRANSACTION USING to run an SAP transaction. External data does not have to be deposited in a session for later processing. Instead, the entire batch input process takes place inline in your program.

The information in Choosing Data Transfer Methods will help you decide which is the best data transfer method

The MODE Parameter

You can use the MODE parameter to specify whether data transfer processing should be displayed as it happens. You can choose between three modes:

A Display all. All screens and the data that goes in them appear when you run your program.

N No display. All screens are processed invisibly, regardless of whether there are errors or not. Control returns to your program as soon as transaction processing is finished.

E Display errors only. The transaction goes into display mode as soon as an error in one of the screens is detected. You can then correct the error.

The display modes are the same as those that are available for processing batch input sessions

The UPDATE Parameter

You use the UPDATE parameter to specify how updates produced by a transaction should be processed. You can select between these modes:

A Asynchronous updating. In this mode, the called transaction does not wait for any updates it produces to be completed. It simply passes the updates to the SAP update service. Asynchronous processing therefore usually results in faster execution of your data transfer program.

Asynchronous processing is NOT recommended for processing any larger amount of data. This is because the called transaction receives no completion message from the update module in asynchronous updating. The calling data transfer program, in turn, cannot determine whether a called transaction ended with a successful update of the database or not.

If you use asynchronous updating, then you will need to use the update management facility (Transaction SM12) to check whether updates have been terminated abnormally during session processing. Error analysis and recovery is less convenient than with synchronous updating.

S Synchronous updating. In this mode, the called transaction waits for any updates that it produces to be completed. Execution is slower than with asynchronous updating because called transactions wait for updating to be completed. However, the called transaction is able to return any update error message that occurs to your program. It is much easier for you to analyze and recover from errors.

L Local updating. If you update data locally, the update of the database will not be processed in a separate process, but in the process of the calling program. (See the ABAP keyword documentation on SET UPDATE TASK LOCAL for more information.)

The MESSAGES Parameter

The MESSAGES specification indicates that all system messages issued during a CALL TRANSACTION USING are written into the internal table <MESSTAB> . The internal table must have the structure BDCMSGCOLL .

You can record the messages issued by Transaction TFCA in table MESSTAB with the following coding:

(This example uses a flight connection that does not exist to trigger an error in the transaction.)

DATA: BEGIN OF BDCDATA OCCURS 100.

INCLUDE STRUCTURE BDCDATA.

DATA: END OF BDCDATA.

DATA: BEGIN OF MESSTAB OCCURS 10.

INCLUDE STRUCTURE BDCMSGCOLL.

DATA: END OF MESSTAB.

BDCDATA-PROGRAM = 'SAPMTFCA'.

BDCDATA-DYNPRO = '0100'.

BDCDATA-DYNBEGIN = 'X'.

APPEND BDCDATA.

CLEAR BDCDATA.

BDCDATA-FNAM = 'SFLIGHT-CARRID'.

BDCDATA-FVAL = 'XX'.

APPEND BDCDATA.

BDCDATA-FNAM = 'SFLIGHT-CONNID'.

BDCDATA-FVAL = '0400'.

APPEND BDCDATA.

CALL TRANSACTION 'TFCA' USING BDCDATA MODE 'N'

MESSAGES INTO MESSTAB.

LOOP AT MESSTAB.

WRITE: / MESSTAB-TCODE,

MESSTAB-DYNAME,

MESSTAB-DYNUMB,

MESSTAB-MSGTYP,

MESSTAB-MSGSPRA,

MESSTAB-MSGID,

MESSTAB-MSGNR.

ENDLOOP.

The following figures show the return codes from CALL TRANSACTION USING and the system fields that contain message information from the called transaction. As the return code chart shows, return codes above 1000 are reserved for data transfer. If you use the MESSAGES INTO <table> option, then you do not need to query the system fields shown below; their contents are automatically written into the message table. You can loop over the message table to write out any messages that

Reward if it helps..

Regards,

Omakr.

Re: BDC recording

Former Member — Mon, 06 Aug 2007 05:48:36 GMT

Hi,

For uploading data into the SAP system u perform a BDC recording using transaction 'SHDB'. Here u create a recording for the transaction u need to upload.

and use that program for uploading data.

regards,

Navneeth K.

Re: BDC recording

Former Member — Mon, 06 Aug 2007 05:49:59 GMT

Hi,

If you want to record for two transations then you will use same method as one transation.For example if you want to execute two transations like VA01(sales order) and VL01N(delivery).Here first you can record for both transactions seperately and in the function module calling you will call BDC_INSERT two times

First function module contains Tcode as VA01 and Bdcdata table as data for the va01 transaction and second table contains tcode as VL01N and Bdcdata table conatins data which contains the record data of the delivery recorded data.

PERFORM open_batch_session USING p_sessa.

LOOP AT ltcap_int

WHERE NOT tot_inc IS initial.

ltcap_int-adj = ltcap_int-adj * -1.

CONCATENATE ltcap_int-fund '/' ltcap_int-cfc INTO zuonr.

PERFORM fill_bdc_header.

PERFORM fill_bdc_lines.

PERFORM post_entries.

PERFORM insert_batch_session USING 'FB01'.

ltcap_int-adj = ltcap_int-adj * -1.

ENDLOOP.

PERFORM close_batch_session.

perform start_batch_session using p_sessa.

Budgets

WRITE p_fy TO c_fy.

PERFORM open_batch_session USING p_sessb.

LOOP AT ltcap_int

WHERE NOT tot_inc IS initial.

PERFORM rollup_header.

PERFORM rollup_line.

PERFORM rollup_save.

PERFORM insert_batch_session USING 'FR21'.

IF NOT ltcap_int-gsef_amt IS INITIAL.

PERFORM rollup_header_gsef.

PERFORM rollup_line_gsef.

PERFORM rollup_save.

PERFORM insert_batch_session USING 'FR21'.

ENDIF.

ENDLOOP.

PERFORM close_batch_session.

perform start_batch_session using p_sessb.

We can process more than 1 transactions in session method.

For this we will create the internal tables equilant to transactions and

Between BDC_open_group and BDC_close_group we will call the BDC_Insert the no.of transactions times and populate the internal tables which contains the data pertaining to diffrent transactions.

Re: BDC recording

Former Member — Mon, 06 Aug 2007 05:50:15 GMT

Hi,

This recoding allows a user to record keystrokes and other keyboard actions so that they may be incorporated into a BDC session. While any session may be recorded, it does not mean that the recording can be used to create a session. Within a recording individual screens may not be allowed.

Look at the below link

http://goldenink.com/abap/shdb.html

Regards

Sudheer

Re: BDC recording

Former Member — Mon, 06 Aug 2007 05:54:04 GMT