topic Re: Give one example error for bdc? in Application Development and Automation Discussions

Give one example error for bdc?

Former Member — Wed, 01 Aug 2007 05:00:46 GMT

Hi ,

what are errors in bdc? Give one example error ? how to solve it ?

regards

eswar

Re: Give one example error for bdc?

anversha_s — Wed, 01 Aug 2007 05:08:20 GMT

Hi,

Kindly go thru this links. Ur query is answered there.

check this link.

https://forums.sdn.sap.com/click.jspa?searchID=4238251&messageID=2979983

https://forums.sdn.sap.com/click.jspa?searchID=4238251&messageID=2979982

https://forums.sdn.sap.com/click.jspa?searchID=4238251&messageID=745186

https://forums.sdn.sap.com/click.jspa?searchID=4238251&messageID=3523632

Rgds

Anversha

Re: Give one example error for bdc?

Former Member — Wed, 01 Aug 2007 05:43:07 GMT

hi,

REPORT zsdr_price_upload MESSAGE-ID zsdr_bdc_vk11 LINE-SIZE 150

LINE-COUNT 75 .

******Internal Table for Header Data.

TYPES : BEGIN OF type_header,

kschl LIKE konv-kschl,

vkorg LIKE vbak-vkorg,

vtweg LIKE komg-spart,

matnr LIKE mvke-matnr,

kbetr(11) TYPE c,

datab(10) TYPE c,

datbi(10) TYPE c,

END OF type_header.

****Internal Table for Item Level.

TYPES : BEGIN OF type_item,

kschl LIKE konv-kschl,

vkorg LIKE vbak-vkorg,

vtweg LIKE komg-spart,

matnr LIKE mvke-matnr,

kbetr(11) TYPE c,

datab(10) TYPE c,

datbi(10) TYPE c,

END OF type_item.

******Error Table For not found in MVKE.

TYPES : BEGIN OF type_error ,

kschl LIKE konv-kschl,

vkorg LIKE vbak-vkorg,

vtweg LIKE komg-spart,

matnr LIKE mvke-matnr,

kbetr LIKE konp-kbetr,

datab(10) TYPE c,

datbi(10) TYPE c,

text(100) TYPE c,

END OF type_error.

****For error Messages

TYPES : BEGIN OF type_mtab,

matnr LIKE mara-matnr,

msgtyp LIKE bdcmsgcoll-msgtyp,

msgid LIKE bdcmsgcoll-msgid,

msgnr LIKE bdcmsgcoll-msgnr,

text(100) TYPE c,

END OF type_mtab.

****Internal Table

TYPES: BEGIN OF type_mvke,

matnr LIKE mvke-matnr,

vkorg LIKE mvke-vkorg,

vtweg LIKE mvke-vtweg,

END OF type_mvke.

****Internal Table

TYPES : BEGIN OF type_tvkov,

vkorg LIKE tvkov-vkorg,

vtweg LIKE tvkov-vtweg,

END OF type_tvkov.

Declaring Internal Tables

DATA : t_header TYPE STANDARD TABLE OF type_header,

t_item TYPE STANDARD TABLE OF type_item,

t_mvke TYPE STANDARD TABLE OF type_mvke,

t_tvkov TYPE STANDARD TABLE OF type_tvkov,

t_error TYPE STANDARD TABLE OF type_error,

t_mtab TYPE STANDARD TABLE OF type_mtab.

Work Area Declaration.

DATA : wa_header LIKE LINE OF t_header,

wa_item LIKE LINE OF t_item,

wa_error LIKE LINE OF t_error,

wa_mtab LIKE LINE OF t_mtab,

wa_tvkov LIKE LINE OF t_tvkov,

wa_mvke LIKE LINE OF t_mvke.

*Rows for Table with Excel Data*******

DATA: t_xls_file LIKE alsmex_tabline OCCURS 0 WITH HEADER LINE.

***Constant.

DATA : c_params LIKE ctu_params.

DATA : c_ans(1) TYPE c.

DATA : v_count(4) TYPE c. " To show No.of records

DATA : bdctab LIKE bdcdata OCCURS 10 WITH HEADER LINE. " BDCDATA

DATA : tmess_mtab LIKE bdcmsgcoll OCCURS 10 WITH HEADER LINE.

************************************************************************

SELECTION SCREEN

************************************************************************

SELECTION-SCREEN : BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

PARAMETERS : p_fname LIKE rlgrap-filename OBLIGATORY.

SELECTION-SCREEN : END OF BLOCK b1.

**********************************************************************

END OF SELECTION SCREEN.

**********************************************************************

DATA : repid LIKE sy-repid.

DATA : v_matnr(50) TYPE c, "used for line items

v_kbetr(50) TYPE c, "used for line items

v_dat1(50) TYPE c, "used for line items

v_dat(50) TYPE c. "used for line items

DATA : v_lindx(5) TYPE n ,"index counter for first 14 records.

v_lindx1(5) TYPE n VALUE '01', "index counter for 13 records.

v_item(5) TYPE c, "To increment the line index

v_pgedwn2 TYPE i . "For Pagedown Counter

DATA: v_currentrow TYPE i. "For Current Row

DATA v_bdc(50) TYPE c." Text to apper in Confrim POPUP Window.

************AT SELECTION-SCREEN

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_fname.

PERFORM get_filename USING p_fname.

*************START-OF-SELECTION

START-OF-SELECTION.

******Values for Ctu_params to Transaction

c_params-defsize = 'X'.

c_params-dismode = 'N'.

c_params-updmode = 'S'.

******Refresh

PERFORM f_refresh.

*********To upload File.

PERFORM upload_file.

****User Confrimation only BDC will Process

IF c_ans = '1'.

*** BDC Process.

PERFORM read_data.

ELSE.

FORMAT COLOR 3 INTENSIFIED .

WRITE:/ 'Selected not to Process the Upload'.

EXIT.

ENDIF.

******On completion of Process Refresh the Internal Table

REFRESH : t_xls_file,

t_header,

t_item,

t_mvke,

t_tvkov.

CLEAR : t_xls_file,

wa_header,

wa_item,

wa_mvke,

wa_tvkov.

***************************************

***********Display Messages

WRITE : /01 'Status',19 'Status Text'.

WRITE AT 0(150) sy-uline.

LOOP AT t_mtab INTO wa_mtab.

WRITE :/01 wa_mtab-msgtyp,19 wa_mtab-text.

ENDLOOP.

SKIP 2.

SORT t_error BY matnr.

WRITE AT 0(150) sy-uline.

WRITE 'ERROR MESSAGES'.

WRITE AT 0(150) sy-uline.

WRITE :/01 'Material.No',20 'Status Text'.

WRITE AT 0(150) sy-uline.

LOOP AT t_error INTO wa_error WHERE matnr NE ' '.

WRITE:/01 wa_error-matnr,20 wa_error-text.

ENDLOOP.

----

*& Form get_filename

&----

text

----

-->P_FILENAME text

----

FORM get_filename USING p_fname.

*****To read the file from Presentation Server

CALL FUNCTION 'KD_GET_FILENAME_ON_F4'

EXPORTING

program_name = repid

dynpro_number ! ; = syst-dynnr

field_name = p_fname

STATIC = ' '

mask = '*.XLS'

CHANGING

file_name = p_fname

EXCEPTIONS

mask_too_long = 1

OTHERS = 2

IF sy-subrc <> 0.

* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

ENDFORM. " get_filename

&----

*& Form upload_file

&----

text

----

--> p1 text
<-- p2 text

----

FORM upload_file.

DATA : frow VALUE 2 TYPE i,

fcol VALUE 1 TYPE i,

erow VALUE 10000 TYPE i,

ecol VALUE 7 TYPE i,

ecol1 VALUE 1 TYPE i,

c_col1 TYPE i VALUE '0001',

c_col2 TYPE i VALUE '0002',

c_col3 TYPE i VALUE '0003',

&nb! sp; c_col4 TYPE i VALUE '0004',

c_col5 TYPE i VALUE '0005',

c_col6 TYPE i VALUE '0006',

c_col7 TYPE i VALUE '0007'.

***FM used to UPLOAD data from Flat file

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = p_fname

i_begin_col = fcol

i_begin_row = frow

i_end_col = ecol

i_end_row = erow

TABLES

intern = t_xls_file

EXCEPTIONS

inconsistent_parameters = 1

upload_ole = 2

OTHERS = 3.

IF sy-subrc <> 0.

MESSAGE e000.

ENDIF.

****T_XLS_FILE is initial, stop the process & throw message

IF t_xls_file[] IS INITIAL.

FORMAT COLOR 6 ON INTENSIFIED ON.

WRITE:/ 'No Data Exists '.

FORMAT COLOR OFF INTENSIFIED OFF.

STOP.

ELSE.

Sort table by rows and colums

SORT t_xls_file BY row col.

Get first row retrieved

READ TABLE t_xls_file INDEX 1.

Set first row retrieved to current row

v_currentrow = t_xls_file-row.

**Loop to move data in internal Table

LOOP AT t_xls_file .

Reset values for next row

IF t_xls_file-row NE v_currentrow.

APPEND wa_header TO t_header.

CLEAR wa_header.

v_currentrow = t_xls_file-row.

ENDIF.

CASE t_xls_file-col.

WHEN c_col1. "Kschl

wa_header-kschl = t_xls_file-value.

WHEN c_col2. "Vkorg

wa_header-vkorg = t_xls_file-value.

WHEN c_col3. "vtweg

wa_header-vtweg = t_xls_file-value.

WHEN c_col4. "Matnr

wa_header-matnr = t_xls_file-value.

WHEN c_col5. "Kbetr

wa_header-kbetr = t_xls_file-value.

WHEN c_col6. "FROm

wa_header-datab = t_xls_file-value.

WHEN c_col7. "TO

wa_header-datbi = t_xls_file-value.

ENDCASE.

ENDLOOP.

APPEND wa_header TO t_header.

CLEAR wa_header.

ENDIF.

****To process the data

PERFORM f_process.

ENDFORM. " upload_file

&----

*& Form READ_DATA

&----

text

----

--> p1 text
<-- p2 text

----

FORM read_data.

****To make Uniq Records in Header Level

SORT t_header BY kschl vkorg vtweg.

DELETE ADJACENT DUPLICATES FROM t_header COMPARING

kschl vkorg vtweg .

SORT t_item BY vkorg vtweg matnr.

DATA : wa1_item TYPE type_item.

DATA : l_cnt TYPE i.

DATA : flag(1) TYPE c. "to process the Line item.

***Looping Header Table.

LOOP AT t_header INTO wa_header.

***************************************

PERFORM bdc_dynpro US! ING 'SAPMV13A' '0100'.

PERFORM bdc_field USING 'BDC_CURSOR'

'RV13A-KSCHL'.

PERFORM bdc_field USING 'BDC_OKCODE'

'=ANTA'.

PERFORM bdc_field USING 'RV13A-KSCHL'

wa_header-kschl.

PERFORM bdc_dynpro USING 'SAPLV14A' '0100'.

PERFORM bdc_field USING 'BDC_CURSOR'

'RV130-SELKZ(03)'.

PERFORM bdc_field USING 'BDC_OKCODE'

'=WEIT'.

PERFORM bdc_field USING 'RV130-SELKZ(03)'

'X'.

PERFORM bdc_dynpro USING 'SAPMV13A' '1004'.

PERFORM bdc_field USING 'BDC_CURSOR'

'KOMG-VKORG'.

PERFORM bdc_field USING 'KOMG-VKORG'

wa_header-vkorg.

PERFORM bdc_field USING 'KOMG-VTWEG'

wa_header-vtweg.

****To handle Line Items.

LOOP AT t_item INTO wa1_item WHERE vkorg = wa_header-vkorg AND

vtweg = wa_header-vtweg.

wa_item = wa1_item.

******Flag Set only After processing first 14 records .

IF flag = ' '.

v_lindx = v_lindx + 01.

SHIFT v_lindx LEFT DELETING LEADING '0'.

v_item = v_lindx .

CONCATENATE 'KOMG-MATNR(' v_item ')' INTO v_matnr.

PERFORM bdc_field USING v_matnr

wa_item-matnr.

CONCATENATE 'KONP-KBETR(' v_item ')' INTO v_kbetr.

PERFORM bdc_field USING v_kbetr

wa_item-kbetr.

CONCATENATE 'RV13A-DATAB(' v_item ')' INTO v_dat.

PERFORM bdc_field USING v_dat

wa_item-datab.

CONCATENATE 'RV13A-DATBI(' v_item ')' INTO v_dat1.

PERFORM bdc_field USING v_dat1

wa_item-datbi.

IF v_item = 14.

flag = 'X'.

PERFORM bdc_field USING 'BDC_OKCODE'

'/00'.

PERFORM bdc_field USING 'BDC_OKCODE'

'=P+'.

PERFORM bdc_dynpro USING 'SAPMV13A' '1004'.

CLEAR v_lindx.

CLEAR v_item.

CONTINUE.

ENDIF.

***Flag is Set after Processing of 14 records.

TO process rest of Records

IF flag = 'X'.

v_pgedwn2 = v_pgedwn2 + 1.

v_lindx1 = v_lindx1 + 01.

SHIFT v_lindx1 LEFT DE! LETING LEADING '0'.

v_item = v_lindx1 .

CONCATENATE 'KOMG-MATNR(' v_it! em ')' INTO v_matnr.

PERFORM bdc_field USING v_matnr

wa_item-matnr.

CONCATENATE 'KONP-KBETR(' v_item ')' INTO v_kbetr.

PERFORM bdc_field USING v_kbetr

wa_item-kbetr.

CONCATENATE 'RV13A-DATAB(' v_item ')' INTO v_dat.

PERFORM bdc_field USING v_dat

wa_item-datab.

CONCATENATE 'RV13A-DATBI(' v_item ')' INTO v_dat1.

PERFORM bdc_field USING v_dat1

wa_item-datbi.

IF v_pgedwn2 = 13.

PERFORM bdc_field USING 'BDC_OKCODE'

'/00'.

PERFORM bdc_field USING 'BDC_OKCODE'

'=P+'.

PERFORM bdc_dynpro USING 'SAPMV13A' '1004'.

v_pgedwn2 = 0.

v_lindx1 = 1.

CLEAR v_item.

CONTINUE.

ENDIF.

ENDLOOP.

PERFORM bdc_field USING 'BDC_OKCODE'

'=SICH'.

Calling Transaction after Processing All items.

CALL TRANSACTION 'VK11' USING bdctab

OPTIONS FROM c_params MESSAGES INTO tmess_mtab.

REFRESH bdctab.

CLEAR : bdctab.

CLEAR : wa_item.

CLEAR : wa1_item.

CLEAR : wa_header.

CLEAR : l_cnt.

CLEAR : v_lindx1.

CLEAR: v_pgedwn2,v_lindx.

LOOP AT tmess_mtab .

l_cnt = l_cnt + 1.

READ TABLE t_item INTO wa_item INDEX l_cnt .

CALL FUNCTION 'MASS_MESSAGE_GET' "To get the Message Text

EXPORTING

arbgb = tmess_mtab-msgid

msgnr = tmess_mtab-msgnr

msgv1 = tmess_mtab-msgv1

msgv2 = tmess_mtab-msgv2

msgv3 = tmess_mtab-msgv3

msgv4 ! = tmess_mtab-msgv4

IMPORTING

msgtext = wa_mtab-text

EXCEPTIONS

message_not_found = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

wa_mtab-matnr = wa_item-matnr.

wa_mtab-msgtyp = tmess_mtab-msgtyp.

wa_mtab-msgid = tmess_mtab-msgid.

wa_mtab-msgn! r = tmess_mtab-msgnr.

APPEND wa_mtab TO t_mtab.

CLEAR wa_mtab-text.

CLEAR wa_item.

ENDLOOP.

ENDFORM. " READ_DATA

&----

*& Form BDC_DYNPRO

&----

text

----

-->P_0300 text
-->P_0301 text

----

Start new screen *

----

FORM bdc_dynpro USING program dynpro.

CLEAR bdctab.

bdctab-program = program.

bdctab-dynpro = dynpro.

bdctab-dynbegin = 'X'.

APPEND bdctab.

ENDFORM. " BDC_DYNPRO

&----

*& Form BDC_FIELD

&----

text

----

-->P_0305 text
-->P_WA_HEADER_KSCHL text

----

Insert field *

----

FORM bdc_field USING fnam fval.

CLEAR bdctab.

bdctab-fnam = fnam.

bdctab-fval = fval.

APPEND bdctab.

ENDFORM. " BDC_FIELD

&----

*& Form bdc_trc_ansaction

&----

text

----

-->P_0527 text

*----

&----

*& Form f_Process

&----

text

----

--> p1 text
<-- p2 text

----

FORM f_process.

DATA : l_todate(12) TYPE c,

l_frdate(12) TYPE c.

***Select for all entries of material in Header "Flat File Materials".

IF NOT t_header[] IS INITIAL.

SELECT matnr vkorg vtweg FROM mvke INTO TABLE t_mvke FOR ALL ENTRIES

IN t_header WHERE matnr = t_header-matnr AND

vkorg = t_header-vkorg AND

vtweg = t_header-vtweg.

ENDIF.

*********select Sales.org & Dist.channel.

IF NOT t_header[] IS INITIAL.

SELECT vkorg vtweg FROM tvkov INTO TABLE t_tvkov FOR ALL ENTRIES IN

t_header WHERE vkorg = t_header-vkorg

AND vtweg = t_header-vtweg.

ENDIF.

***Checking for material in Sales Master Table

SORT t_mvke BY matnr vkorg vtweg.

SORT t_tvkov BY vkorg vtweg.

LOOP AT t_header INTO wa_header.

READ TABLE t_mvke INTO wa_mvke WITH KEY matnr = wa_header-matnr

vkorg = wa_header-vkorg

! ; vtweg = wa_header-vtweg BINARY SEARCH.

IF sy-subrc <> 0.

wa_error = wa_header.

&nb! sp; MOVE text-011 TO wa_error-text.

APPEND wa_error TO t_error.

DELETE TABLE t_header FROM wa_header.

ELSE.

********Date Validations

IF ( wa_header-datab NE ' ! ; ' AND wa_header-datbi NE ' ' ) .

l_todate = wa_header-datab.

l_frdate = wa_header-datbi.

REPLACE '.' INTO l_toda! te WITH ''.

REPLACE '.' INTO l_todate WITH ''.

CONDENSE l_todate NO-GAPS.

REPLACE '.' INTO l_frdate WITH ''.

CONDENSE l_frdate NO-GAPS.

IF l_frdate < l_todate.

wa_error = wa_header .

MOVE text-012 TO wa_error-text.

APPEND wa_error TO t_error.

DELETE TABLE t_header FROM wa_header.

ENDIF.

ELSE.

wa_error = wa_header .

MOVE text-016 TO wa_error-text.

APPEND wa_error TO t_error.

DELETE TABLE t_header FROM wa_header.

ENDIF.

********Rate Validation.

IF wa_header-kbetr = ' '.

wa_error = wa_header .

MOVE text-017 TO wa_error-text.

APPEND wa_error TO t_error.

DELETE TABLE t_header FROM wa_header.

ENDIF.

************************************************************************

READ TABLE t_tvkov INTO wa_tvkov WITH KEY vkorg = wa_header-vkorg

BINARY SEARCH.

IF sy-subrc = 0.

READ TABLE t_tvkov INTO wa_tvkov WITH KEY vtweg = wa_header-vtweg

BINARY SEARCH.

IF sy-subrc <> 0.

wa_error = wa_header.

MOVE text-015 TO wa_error-text.

WRITE wa_header-vtweg TO wa_error-text+13(4).

APPEND wa_error TO t_error.

ENDIF.

ELSE.

wa_error = wa_header.

MOVE text-013 TO wa_error-text.

WRITE wa_header-vkorg TO wa_error-text+9(4).

APPEND wa_error TO t_error.

ENDIF.

CLEAR wa_header.

ENDLOOP.

*****Deleting Duplicate Material Form Header "Flat File Data".

SORT t_header BY kschl vkorg vtweg matnr.

DELETE ADJACENT DUPLICATES FROM t_header COMPARING

kschl! vkorg vtweg matnr .

****Data Moving from Header to Item Level.

t_item[] = t_header[].

*To count No.of records in Item Table.

DESCRIBE TABLE t_item LINES v_count.

CONCATENATE text-014 ' ' v_count INTO v_bdc.

****Popup to get Confirmation from user to process BDC

CALL FUNCTION 'POPUP_TO_CONFIRM'

EXPORTING

titlebar = 'Confirmation of File Data'

text_question = v_bdc

text_button_1 = 'Confirm'

text_button_2 = 'Cancel Run'

default_button = '1'

IMPORTING

answer = c_ans.

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-! MSGV3 SY-MSGV4.

ENDIF.

ENDFORM. " f_Process

&----

*& Form f_Refresh

&----

text

----

--> p1 text
<-- p2 text

----

FORM f_refresh.

REFRESH : t_xls_file,

t_header,

t_item,

t_mvke,

t_tvkov,

t_error,

t_mtab.

CLEAR : t_xls_file,

wa_header,

wa_item,

wa_mvke,

wa_tvkov,

wa_error,

wa_mtab.

ENDFORM. " f_Refresh

Regards

Re: Give one example error for bdc?

Former Member — Wed, 01 Aug 2007 05:53:36 GMT

Hi Eswar,

Regarding the error handling in call transaction.

The BDCMSGCOLL does not have the messages text. It has only the message type, number and message parameters.

You have to read the message text. (recall that the database table T100 stores all the messages.)

There are more than one method of doing this.

Following is the psuedocode for one of the methods.

LOOP for the internal table IT1 which has data value from flat file.

call transcation using....

if SY-SUBRC <> 0.

Read the dictionary table T100 FOR ALL ENTRIES in BDCMSGCOLL.

(also use the condition T100-SPRAS = SY-LANGU (the log on language. This is because you need only the message texts in English if the user is logged in English language)

IF message type is E , then, transfer the contents of this particular error record to file x. (TRANSFER......)

( Ignore all other messages. Only consider type 'E' messages. Ignore other types of messages.)

(You can also store the message text from T100 and the error record in another internal table IT2)

.....

....

ENDLOOP.

Please note that the client might ask you for a file of records which could not be uploaded.

Give him the file created in the above psuedocode. (most often you will have to do this).

Otherwise just display the error messages and the error records in the internal table IT2 in the form of a list.

Thats it.

Alternatively,

Instead of

" Read the dictionary table T100 FOR ALL ENTRIES in BDCMSGCOLL."

you can use the function module

WRITE_MESSAGES to read the messages.

Please refer to the function module for the list of parameters.

Also refer FORMAT_MESSAGES function module.

As, I said, there are more than one method of doing this.

.Reward points if useful

Cheers!!!!

Twinkle

Re: Give one example error for bdc?

Former Member — Wed, 01 Aug 2007 06:04:44 GMT

Hi,

In BDC genreal errors are due to if you have not record the screens flow propely the most of erros will come.

second if the data populated to the BDC screens are not valid data then erros will come.

If you are using the call transaction method then you will check the sy-subrc if it is 0 then success if it 1000 or 1001 then it is error.

If you are using the session method then function module will give the exceptions.

Thanks and regards,

shyla

Re: Give one example error for bdc?

Former Member — Wed, 01 Aug 2007 06:26:40 GMT

hi,

ERRORS In BDC:

In the SESSION method we can check errors at sm35->log(ERROR LOG)

u can reprocess the session for error records.

where as in call transaction we have to take care using the structure BDCMSGCOLL and the FM FORMAT_MESSAGES and we can open session for error records(if sy-subrc <>) 0), we can amke changes andreprocess the session for error records.

ex:

REPORT zgopi_report

NO STANDARD PAGE HEADING

LINE-SIZE 255

MESSAGE-ID ZRASH.

************************************************************************

Internal Table Declarations *

************************************************************************

*--Internal Table for Data Uploading.

DATA : BEGIN OF IT_FFCUST OCCURS 0,

KUNNR(10),

BUKRS(4),

KTOKD(4),

ANRED(15),

NAME1(35),

SORTL(10),

STRAS(35),

ORT01(35),

PSTLZ(10),

LAND1(3),

SPRAS(2),

AKONT(10),

END OF IT_FFCUST.

*--Internal Table to Store Error Records.

DATA : BEGIN OF IT_ERRCUST OCCURS 0,

KUNNR(10),

EMSG(255),

END OF IT_ERRCUST.

*--Internal Table to Store Successful Records.

DATA : BEGIN OF IT_SUCCUST OCCURS 0,

KUNNR(10),

SMSG(255),

END OF IT_SUCCUST.

*--Internal Table for Storing the BDC data.

DATA : IT_CUSTBDC LIKE BDCDATA OCCURS 0 WITH HEADER LINE.

*--Internal Table for storing the messages.

DATA : IT_CUSTMSG LIKE BDCMSGCOLL OCCURS 0 WITH HEADER LINE.

DATA : V_FLAG1(1) VALUE ' ',

"Flag used for opening session.

V_TLINES LIKE SY-TABIX,

"For storing total records processed.

V_ELINES LIKE SY-TABIX,

"For storing the no of error records.

V_SLINES LIKE SY-TABIX.

"For storing the no of success records.

************************************************************************

Selection screen *

************************************************************************

SELECTION-SCREEN BEGIN OF BLOCK B1.

PARAMETERS : V_FNAME LIKE RLGRAP-FILENAME,

V_SESNAM LIKE RLGRAP-FILENAME.

SELECTION-SCREEN END OF BLOCK B1.

************************************************************************

Start-of-selection *

************************************************************************

START-OF-SELECTION.

*-- Form to upload flatfile data into the internal table.

PERFORM FORM_UPLOADFF.

************************************************************************

TOP-OF-PAGE *

************************************************************************

TOP-OF-PAGE.

WRITE:/ 'Details of the error and success records for the transaction'

ULINE.

SKIP.

************************************************************************

End of Selection *

************************************************************************

END-OF-SELECTION.

*-- Form to Generate a BDC from the Uploaded Internal table

PERFORM FORM_BDCGENERATE.

*--To write the totals and the session name.

PERFORM FORM_WRITEOP.

&----

*& Form form_uploadff

&----

Form to upload flatfile data into the internal table.

----

FORM FORM_UPLOADFF .

*--Variable to change the type of the parameter file name.

DATA : LV_FILE TYPE STRING.

LV_FILE = V_FNAME.

*--Function to upload the flat file to the internal table.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = LV_FILE

FILETYPE = 'ASC'

HAS_FIELD_SEPARATOR = 'X'

HEADER_LENGTH = 0
READ_BY_LINE = 'X'
DAT_MODE = ' '
IMPORTING
FILELENGTH =
HEADER =

TABLES

DATA_TAB = IT_FFCUST

EXCEPTIONS

FILE_OPEN_ERROR = 1

FILE_READ_ERROR = 2

NO_BATCH = 3

GUI_REFUSE_FILETRANSFER = 4

INVALID_TYPE = 5

NO_AUTHORITY = 6

UNKNOWN_ERROR = 7

BAD_DATA_FORMAT = 8

HEADER_NOT_ALLOWED = 9

SEPARATOR_NOT_ALLOWED = 10

HEADER_TOO_LONG = 11

UNKNOWN_DP_ERROR = 12

ACCESS_DENIED = 13

DP_OUT_OF_MEMORY = 14

DISK_FULL = 15

DP_TIMEOUT = 16

OTHERS = 17

IF SY-SUBRC = 0.

*--Deleting the headings from the internal table.

DELETE IT_FFCUST INDEX 1.

*--Getting the total number of records uploaded.

DESCRIBE TABLE IT_FFCUST LINES V_TLINES.

ENDIF.

ENDFORM. " form_uploadff

&----

*& Form Form_bdcgenerate

&----

Form to Generate a BDC from the Uploaded Internal table

----

FORM FORM_BDCGENERATE .

*--Generating the BDC table for the fields of the internal table.

LOOP AT IT_FFCUST.

PERFORM POPULATEBDC USING :

'X' 'SAPMF02D' '0105',

' ' 'BDC_OKCODE' '/00' ,

' ' 'RF02D-KUNNR' IT_FFCUST-KUNNR,

' ' 'RF02D-BUKRS' IT_FFCUST-BUKRS,

' ' 'RF02D-KTOKD' IT_FFCUST-KTOKD,

'X' 'SAPMF02D' '0110' ,

' ' 'BDC_OKCODE' '/00',

' ' 'KNA1-ANRED' IT_FFCUST-ANRED,

' ' 'KNA1-NAME1' IT_FFCUST-NAME1,

' ' 'KNA1-SORTL' IT_FFCUST-SORTL,

' ' 'KNA1-STRAS' IT_FFCUST-STRAS,

' ' 'KNA1-ORT01' IT_FFCUST-ORT01,

' ' 'KNA1-PSTLZ' IT_FFCUST-PSTLZ,

' ' 'KNA1-LAND1' IT_FFCUST-LAND1,

' ' 'KNA1-SPRAS' IT_FFCUST-SPRAS,

'X' 'SAPMFO2D' '0120',

' ' 'BDC_OKCODE' '/00',

'X' 'SAPMF02D' '0125',

' ' 'BDC_OKCODE' '/00',

'X' 'SAPMF02D' '0130',

' ' 'BDC_OKCODE' '=ENTR',

'X' 'SAPMF02D' '0340',

' ' 'BDC_OKCODE' '=ENTR',

'X' 'SAPMF02D' '0360',

' ' 'BDC_OKCODE' '=ENTR',

'X' 'SAPMF02D' '0210',

' ' 'KNB1-AKONT' IT_FFCUST-AKONT,

' ' 'BDC_OKCODE' '/00',

'X' 'SAPMF02D' '0215',

' ' 'BDC_OKCODE' '/00',

'X' 'SAPMF02D' '0220',

' ' 'BDC_OKCODE' '/00',

'X' 'SAPMF02D' '0230',

' ' 'BDC_OKCODE' '=UPDA'.

*--Calling the transaction 'fd01'.

CALL TRANSACTION 'FD01' USING IT_CUSTBDC MODE 'N' UPDATE 'S'

MESSAGES INTO IT_CUSTMSG.

IF SY-SUBRC <> 0.

*--Populating the error records internal table.

IT_ERRCUST-KUNNR = IT_FFCUST-KUNNR.

APPEND IT_ERRCUST.

CLEAR IT_ERRCUST.

*--Opening a session if there is an error record.

IF V_FLAG1 = ' '.

PERFORM FORM_OPENSESSION.

V_FLAG1 = 'X'.

ENDIF.

*--Inserting the error records into already open session.

IF V_FLAG1 = 'X'.

PERFORM FORM_INSERT.

ENDIF.

*--Populating the Success records internal table.

ELSE.

IT_SUCCUST-KUNNR = IT_FFCUST-KUNNR.

APPEND IT_SUCCUST.

CLEAR IT_SUCCUST.

ENDIF.

*--Displaying the messages.

IF NOT IT_CUSTMSG[] IS INITIAL.

PERFORM FORM_FORMATMSG.

ENDIF.

*--Clearing the message and bdc tables.

CLEAR : IT_CUSTBDC[],IT_CUSTMSG[].

ENDLOOP.

*--Getting the total no of error records.

DESCRIBE TABLE IT_ERRCUST LINES V_ELINES.

*--Getting the total no of successful records.

DESCRIBE TABLE IT_SUCCUST LINES V_SLINES.

*--Closing the session only if it is open.

IF V_FLAG1 = 'X'.

PERFORM FORM_CLOSESESS.

ENDIF.

ENDFORM. " Form_bdcgenerate

&----

*& Form populatebdc

&----

FOrm to Populate the BDC table.

----

FORM POPULATEBDC USING VALUE(P_0178)

VALUE(P_0179)

VALUE(P_0180).

IF P_0178 = 'X'.

IT_CUSTBDC-PROGRAM = P_0179.

IT_CUSTBDC-DYNPRO = P_0180.

IT_CUSTBDC-DYNBEGIN = 'X'.

ELSE.

IT_CUSTBDC-FNAM = P_0179.

IT_CUSTBDC-FVAL = P_0180.

ENDIF.

APPEND IT_CUSTBDC.

CLEAR IT_CUSTBDC.

ENDFORM. " populatebdc

&----

*& Form FORM_OPENSESSION

&----

Form to Open a session.

----

FORM FORM_OPENSESSION .

*--Variable to convert the given session name into reqd type.

DATA : LV_SESNAM(12).

LV_SESNAM = V_SESNAM.

*--Opening a session.

CALL FUNCTION 'BDC_OPEN_GROUP'

EXPORTING

CLIENT = SY-MANDT

GROUP = LV_SESNAM

HOLDDATE = '20040805'

KEEP = 'X'

USER = SY-UNAME

PROG = SY-CPROG

IMPORTING
QID =

EXCEPTIONS

CLIENT_INVALID = 1

DESTINATION_INVALID = 2

GROUP_INVALID = 3

GROUP_IS_LOCKED = 4

HOLDDATE_INVALID = 5

INTERNAL_ERROR = 6

QUEUE_ERROR = 7

RUNNING = 8

SYSTEM_LOCK_ERROR = 9

USER_INVALID = 10

OTHERS = 11

IF SY-SUBRC <> 0.

WRITE 😕 'Session not open'.

ENDIF.

ENDFORM. " FORM_OPENSESSION

&----

*& Form FORM_INSERT

&----

fORM TO INSERT ERROR RECOED INTO A SESSION.

----

FORM FORM_INSERT .

*--Inserting the record into session.

CALL FUNCTION 'BDC_INSERT'

EXPORTING

TCODE = 'FD01'

POST_LOCAL = NOVBLOCAL
PRINTING = NOPRINT
SIMUBATCH = ' '
CTUPARAMS = ' '

TABLES

DYNPROTAB = IT_CUSTBDC

EXCEPTIONS

INTERNAL_ERROR = 1

NOT_OPEN = 2

QUEUE_ERROR = 3

TCODE_INVALID = 4

PRINTING_INVALID = 5

POSTING_INVALID = 6

OTHERS = 7

IF SY-SUBRC <> 0.

WRITE 😕 'Unable to insert the record'.

ENDIF.

ENDFORM. " FORM_INSERT

&----

*& Form FORM_CLOSESESS

&----

Form to Close the Open Session.

----

FORM FORM_CLOSESESS .

CALL FUNCTION 'BDC_CLOSE_GROUP'

EXCEPTIONS

NOT_OPEN = 1

QUEUE_ERROR = 2

OTHERS = 3.

IF SY-SUBRC <> 0.

ENDIF.

ENDFORM. " FORM_CLOSESESS

&----

*& Form FORM_FORMATMSG

&----

Form to format messages.

----

FORM FORM_FORMATMSG .

*--Var to store the formatted msg.

DATA : LV_MSG(255).

CALL FUNCTION 'FORMAT_MESSAGE'

EXPORTING

ID = SY-MSGID

LANG = SY-LANGU

NO = SY-MSGNO

V1 = SY-MSGV1

V2 = SY-MSGV2

V3 = SY-MSGV3

V4 = SY-MSGV4

IMPORTING

MSG = LV_MSG

EXCEPTIONS

NOT_FOUND = 1

OTHERS = 2.

IF SY-SUBRC = 0.

WRITE 😕 LV_MSG.

ENDIF.

ULINE.

ENDFORM. " FORM_FORMATMSG

&----

*& Form form_writeop

&----

To write the totals and the session name.

----

FORM FORM_WRITEOP .

WRITE 😕 'Total Records Uploaded :',V_TLINES,

/ 'No of Error Records :',V_ELINES,

/ 'No of Success Records :',V_SLINES,

/ 'Name of the Session :',V_SESNAM.

ULINE.

Re: Give one example error for bdc?

Former Member — Wed, 01 Aug 2007 08:29:11 GMT

hi if u are using CALL TRANSACTION then we generally have those errors in BDCMSGCOLL structure.

check the link below which discusses about this in detail, award points if found helpful

https://forums.sdn.sap.com/click.jspa?searchID=907612&messageID=745186