topic Re: BDC in Application Development and Automation Discussions

BDC

Former Member — Mon, 26 Sep 2005 16:51:01 GMT

Hi all,

How we upload data from flat file using call transaction and session method when the fields are in table control.

regards,

vijay.

Re: BDC

Former Member — Mon, 26 Sep 2005 17:00:00 GMT

Do you want to update the data of fields in table control?

In this case you have to create a field name like this:

BDC_FIELD_NAME = <FIELD_SCREEN_NAME>(N).

N is the number of th row of table control you want to update.

You should try to work always on the first row of table control, but you can do it if there's a function to place in a certain position.

LOOP AT T_FILE.

IF SY-TABIX = 1.

BDC-FIELD_NAME = <FIELD_SCREEN_NAME>(1).

BDC-FIELD_VALUE = T_FILE-VALUE.

APPEND BDC.

else.

Here you should simulate to place in the first
position, so you have always the second row to insert
a new data:

.....

BDC-FIELD_NAME = <FIELD_SCREEN_NAME>(2).

BDC-FIELD_VALUE = T_FILE-VALUE.

APPEND BDC.

ENDIF.

ENDLOOP.

Max

Message was edited by: max bianchi

Re: BDC

Former Member — Mon, 26 Sep 2005 17:25:45 GMT

Hi max,

can you explain me taking ME21 or ME22 create/change purchase order as example.

regards,

vijay.

Re: BDC

Former Member — Mon, 26 Sep 2005 17:32:29 GMT

Hi vijay,

welcome to SDN.

below links might help you.

http://help.sap.com/saphelp_erp2004/helpdata/en/fa/097126543b11d1898e0000e8322d00/frameset.htm

http://www.sap-img.com/abap/learning-bdc-programming.htm

http://www.sap-img.com/abap/bdc-example-using-table-control-in-bdc.htm

reward points for helpfull answers by clicking top left side radio buttons and close the thread if your question is solved.

regards,

venu.

Re: BDC

Former Member — Mon, 26 Sep 2005 18:05:33 GMT

In this case:

Insert first row:

LOOP AT T_FILE.

count_posnr = count_posnr + 10.

if sy-tabix = 1.

BDC_FIELD_NAME = 'EKPO-EMATN(01)'.

......

append bdc.

else.

Place in the first row the last position you have

created

BDC_FIELD_NAME = 'RM06E-EBELP'.

BDC_FIELD_VALUE = count_posnr.

Insert ok-code enter /00 (I think)...
Now insert the new position

BDC_FIELD_NAME = 'EKPO-EMATN(02)'.

......

endif.

count_posnr = count_posnr + 10.

In you do in this way you always work on second (except first position), and so you aren't care how many position you have to insert

Max

Re: BDC

Former Member — Mon, 26 Sep 2005 18:33:10 GMT

Create a new recording in transaction SHDB for ME21 or ME22 or whichever tcode you want to do the BDC for.

Later there in an option to create program . You can leverage the code generated in the program or put your logic of reading from file and passing data into this program.

Try putting more that one line items in PO and in the code you will see how it done for a table control.

However you can also use BAPI_PO_CREATE to create the POs without going into the hassle of writing a BDC.

Cheers

Re: BDC

Former Member — Mon, 26 Sep 2005 18:48:42 GMT

Hello Vijaya,

Since you are uploading values froma table control...you have to do it by building the line number dynamically. One way of doing it is by declaring the fields like below which you want to upload.

DATA: BEGIN OF i_epstp,

field1(11) TYPE c VALUE 'RM06E-EPSTP',

field2(1) TYPE c VALUE '(',

field3(3) TYPE n VALUE 000,

field4(1) TYPE c VALUE ')',

END OF i_epstp.

DATA: BEGIN OF i_knttp,

field1(10) TYPE c VALUE 'EKPO-KNTTP',

field2(1) TYPE c VALUE '(',

field3(3) TYPE n VALUE 000,

field4(1) TYPE c VALUE ')',

END OF i_knttp.

................................

PERFORM create_bdc_session.

...................................

FORM create_bdc_session.

PERFORM open_group.

i_xleg[] = i_leg[].

LOOP AT i_leg.

IF i_leg-po_nm = i_xleg-po_nm.

SKIP.

ELSE.

PERFORM read_xref_tables.

*-- First screen

CLEAR w_insert_line.

PERFORM bdc_dynpro USING 'SAPMM06E' '0100'.

PERFORM bdc_field USING 'BDC_CURSOR' 'RM06E-BSART'.

PERFORM bdc_field USING 'BDC_OKCODE' '/00'.

PERFORM bdc_field USING 'EKKO-LIFNR' i_sap-lifnr.

PERFORM bdc_field USING 'RM06E-BSART' c_yb.

PERFORM bdc_field USING 'EKKO-EKORG' p_ekorg.

PERFORM bdc_field USING 'EKKO-EKGRP' i_sap-ekgrp.

PERFORM vendor_address.

IF w_address EQ '3'.

PERFORM bdc_dynpro USING 'SAPMSSY0' '0120'.