BDC

[Former Member]

hi abaper's

i want to know one IQ about BDC, suppose in our vendor master contrycode is UK that is already in sap database but now i need to update my all vendor master data country code with New Information (suppose INDIA) so pls tell me how can we do this task.

points will be rewarded.

thanks

[Former Member]

Hi,

The vendor data stored in various tables. If u want to change the one particular thing (In u r case Country code).The changes need to effect the all the tables. So for that reason u can go to the tcode (XK02) for changing the vendor information.

If some thousands of vendors are need to change the country code. In that u need to do for recording for

one vendor using SHDB tcode.

In report porgram write BDC code to vhange all vendors country codes.

Some of the IQS about BDC:

1 What should be the approach for writing a BDC program?

Ans.: 1. Analysis the Data. 2. Generate SAP structure. 3. Develop transfer program 4. Create sequential file. 5. Create batch input program. 6. Process batch input data

2) What are the steps in a BDC session ?

The first step in a BDC session is to identify the screens of the transaction that the program will process. Next step is to write a program to build the BDC table that will be used to submit the data to SAP. The final step is to submit the BDC table to the system in the batch mode or as a single transaction by the CALL TRANSACTION command.

3)What are the function modules associated with batch input?

Ans :- BDC_OPEN_GROUP , BDC_CLOSE_GROUP , BDC_INSERT.

4)How do you find the transaction number, program number and field names?

Ans :-

Transaction no.,program no. – System -> status

Field names - F1, Technical help

5)What are the available OK Codes that can be utilized during batch input processing?

Ans :-

/n – terminates current batch input transaction and marks as incorrect.

/bdel – delete current batch input transaction from session.

/bend – terminate batch input processing and mark session as incorrect.

/bda – change display mode to process the session on screen instead of displaying only errors.

/bde – change display mode to display only errors instead of processing the session on the screen.

6)What is the effect of the BDC_CURSOR field name in the BDC table?

Ans :- You can set the cursor and enter as a corresponding field value the name of the field on which the cursor is to be positioned .

7)Why you choose Call transaction and/or session method?

Call transaction is mainly used when you want to update the database using a single transaction , you can also update the database in asynchronous mode, where as session is used to perform huge database updations using more than one transaction and which will last for a long time.

8)How you trap errors in call Transaction

Errors while updating the database using call transaction technique are trapped using a structure bdcmsgcall, whose field msgtyp become ‘e’ when an error record is encountered. Those records are formatted using format_message function call in the desired format and stored in an internal table for listing of all error records in one shot.

9)What are the differences between CALL TRANSACTION and BATCH INPUT SESSION ?

- The most important aspects of the batch session interface are:

- Asynchronous processing

- Transfers data for multiple transactions

- Synchronous database update

During processing, no transaction is started until the previous transaction has been written to the database.

- A batch input processing log is generated for each session

- Sessions cannot be generated in parallel

The most important aspects of the CALL TRANSACTION USING interface are:

- Synchronous processing

- Transfers data for a single transaction

- Synchronous and asynchronous database updating both possible

The program specifies which kind of updating is desired.

- Separate LUW for the transaction

The system performs a database commit immediately before and after the CALL TRANSACTION USING statement.

No batch input processing log is generated

10)What is BDC_OKCODE ?

The command field is identified by a special name in batch input called BDC_OKCODE. This name is constant and always identifies the command field.

11)How can we execute a function in a BDC session ?

We can execute a function in a transaction by entering the function code or function key number in the command field of an SAP session. A function key number must be prefixed with the / (slash) character. A function code must be prefixed with the = character.

Example:

BDCDATA-FNAM = 'BDC_OKCODE'

BDCDATA-FVAL = '=UPDA'

12)Who are Dialog users and who are Background users ?

Dialog users are normal interactive users in the SAP system. Background users are user master records that are specially defined for providing authorizations for background processing jobs.

If it is helpful rewards points

Regards

Pratap.M