topic Re: BDC session method data is not uploading into database table in Application Development and Automation Discussions

BDC session method data is not uploading into database table

Former Member — Mon, 20 Jul 2009 07:36:45 GMT

Hi ,

My requirement is uplead data to SAP database table using BDC-Sessions method.

I am unable to upload the data into database.

while i am debugging the control is not moving into 'BDC_INSERT Function module.

Can anyone help me in this regard,

Thanks in advance,

Regards,

Rekha

Re: BDC session method data is not uploading into database table

Former Member — Mon, 20 Jul 2009 07:38:38 GMT

Hi,

BDC_INSERT will only create the session and leave it.

You need to process/execute the session in SM35 that is created using the above FM.

Regards

Shiva

Re: BDC session method data is not uploading into database table

Former Member — Mon, 20 Jul 2009 07:39:07 GMT

HI,

For which transaction have you created the BDC?

Can you post your code?

Regards,

Ankur Parab

Re: BDC session method data is not uploading into database table

Former Member — Mon, 20 Jul 2009 08:04:28 GMT

Using Tcode 'QP01' i am uploading data.

The control is not moving into this FM.

Pleasae check the code below..

perform bdc_dynpro using 'SAPLCPDI' '8010'.

perform bdc_field using 'BDC_CURSOR'

'RC271-PLNNR'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'RC27M-MATNR'

w_bdcfinal-matnr.

perform bdc_field using 'RC27M-WERKS'

w_bdcfinal-werks.

perform bdc_field using 'RC271-PLNNR'

w_bdcfinal-plnnr.

perform bdc_field using 'RC271-STTAG'

'07/17/2009'.

perform bdc_dynpro using 'SAPLCPDA' '1200'.

perform bdc_field using 'BDC_OKCODE'

'=BU'.

perform bdc_field using 'PLKOD-PLNAL'

w_final-plnal.

perform bdc_field using 'PLKOD-KTEXT'

w_final-ktext.

perform bdc_field using 'PLKOD-WERKS'

'0002'.

perform bdc_field using 'BDC_CURSOR'

'PLKOD-STATU'.

perform bdc_field using 'PLKOD-VERWE'

'2'.

perform bdc_field using 'PLKOD-STATU'

'1'.

perform bdc_field using 'PLKOD-LOSBS'

'99,999,999'.

perform bdc_field using 'PLKOD-PLNME'

'CS'.

*perform bdc_transaction using 'QP01'.

CALL FUNCTION 'BDC_INSERT'

EXPORTING

tcode = 'QP01'

post_local = 'X'

PRINTING = NOPRINT
SIMUBATCH = ' '
CTUPARAMS = 'X'

TABLES

dynprotab = i_bdcdata

EXCEPTIONS

internal_error = 1

not_open = 2

queue_error = 3

tcode_invalid = 4

printing_invalid = 5

posting_invalid = 6

OTHERS = 7

Re: BDC session method data is not uploading into database table

Former Member — Mon, 20 Jul 2009 08:08:35 GMT

Hi,

Have you opened and closed the session using the FMs 'BDC_OPEN_GROUP' and 'BDC_CLOSE_GROUP'.

Please check if the session has been created in SM35. If so, try processing the session.

Edited by: Nitwick on Jul 20, 2009 1:43 PM

Re: BDC session method data is not uploading into database table

Former Member — Mon, 20 Jul 2009 08:20:23 GMT

Yes.. I've opend and Closed the session.

In SM35 tcode when i am processiong the session i am getting the first screen with data.

When i am clicking on OK code it is going to sesond screen with data in disable mode..

there i am getting some message like 'No batch inputdata for the screen'.

in session overview screen i am getting that ERROR Icon(Red Color)

.Can you please explain where is the Error exactly..

Re: BDC session method data is not uploading into database table

Former Member — Mon, 20 Jul 2009 08:22:43 GMT

your second screen fileds are disable but your passing the values,dont pass the values which are in display mode.

check your recording and process agagin.

Re: BDC session method data is not uploading into database table

Former Member — Mon, 20 Jul 2009 08:28:53 GMT

My prblem is why i am getting the second screen in disable mode..

In recoding the sesond screen also i;ve entered the data..

While i am processiong the session in SM 35 only i am getting this screen in dicable mode

but the data is correct in sccond screen.

Re: BDC session method data is not uploading into database table

Former Member — Mon, 20 Jul 2009 09:11:54 GMT

Hi,

I have tried recording the transaction QP01. I was getting a different second screen when I used the call transaction method. That particular screen was disabled (it was different from the second screen that I got for recording) Just select the row and click on the header icon, you can see your original screen with the data that you had recorded.

Re: BDC session method data is not uploading into database table

Former Member — Mon, 20 Jul 2009 09:49:52 GMT

Hi...

Thank U so much.

My problem is solved..

Can you tell me how to find out the database table for particular Tcode like 'QP01'.

Actually i am new to QM module..

Regadrs,

Rekha

Re: BDC session method data is not uploading into database table

Former Member — Mon, 20 Jul 2009 10:10:50 GMT

Hi,

Check the link

[]