How to using BDC or LSMM for uploading data.

[Former Member]

Please help me how to write BDC program for the tranfer information from time machine or data of Excel file (include informations about In/Out record time ) to data SAP system.

I know that using BDC or LSMW for uploading data but

I don't know how to do it and I haven't any documents for that.

please help me steps by steps or if you have the doccuments about it, share it to me.

Thanks for your supports.

Regards,

Huyen Nguyen

[sikindar_a · Accepted solution]

https://forums.sdn.sap.com/click.jspa?searchID=18173789&messageID=6400122

check this thread for LSMW

u can follow the BAPI also

[Former Member]

I sugguest you transfer time records from time machine to sap using BAPI not BDC, for reason of performance. Code snippet as below:

CALL FUNCTION 'BAPI_CC1_UPLOAD_TIMEEVENT'

TABLES

TIMEEVENTS = TIMEEVENTS

RETURN = RETURN

EXCEPTIONS

OTHERS = 01.

CASE SY-SUBRC.

WHEN 0. " OK

CALL FUNCTION 'POPUP_TO_CONFIRM'

EXPORTING

TEXT_QUESTION = 'No error occured,posting time events now?'

DEFAULT_BUTTON = '1'

DISPLAY_CANCEL_BUTTON = SPACE

IMPORTING

ANSWER = POPUP_RET.

IF POPUP_RET = '1'.

CALL TRANSACTION 'PT45'.

ENDIF.

WHEN OTHERS. " to be implemented

LOOP AT RETURN .

WRITE: / RETURN-NUMBER,'---',RETURN-MESSAGE.

ENDLOOP.

ENDCASE.