topic Re: data uploading problem via FM in Application Development and Automation Discussions

data uploading problem via FM

Former Member — Thu, 05 Feb 2009 11:56:39 GMT

I have cleared the data from SDBAP and SDBAR.

I want to upload a data from internal table and i already have uploaded the data in Internal table I_FINAL.

after doin this, am callin FM :

CALL FUNCTION 'ADD_DBA_PLANNING_ALL'

EXPORTING

PLANNING_DESC = PLANNING_DESC

PLANNING_STRUCT = PLANNING_STRUCT

START_IMMED = START_IMMED

*TASK_STR =

*TASK_NAME =

*IMPORTING

*PLANNING_RC =

TABLES

RESOURCE_TABLE = I_FINAL

EXCEPTIONS

PROBLEMS = 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.

but the database is still empty.

Please help me out.

Is this FM is right?

Re: data uploading problem via FM

Former Member — Thu, 05 Feb 2009 12:02:31 GMT

HI Jatin,

I checked in that FM it was not using any commit statment

try below

if PLANNING_RC = 0 " exportting parameter of that FM
COMMIT.
ENDIF.

hope it helps.

Re: data uploading problem via FM

Former Member — Thu, 05 Feb 2009 12:09:22 GMT

Hi,

Use this Fm ALSM_EXCEL_TO_INTERNAL_TABLE

Let me know if you still have a problem will provide u the necessary code.

Thanks

Kalyan.

Re: data uploading problem via FM

Former Member — Thu, 05 Feb 2009 12:23:25 GMT

IS THIS FM 'ADD_DBA_PLANNING_ALL'

UPLOADS THE DATA OF MY INTERNAL TABLE TO DB13 T-CODE TABLES?

Re: data uploading problem via FM

Former Member — Thu, 05 Feb 2009 12:32:04 GMT

Hi,

If i am not wrong you have all the data in your internal table,and want to upload this data from the internal table to the DB table right!

I think you can do this in two ways

1.Upload the data throught he bdc

2.In loop-endloop on internal table simply update the records form the internal table to db table along with commit after every update command.

Hope this solve your problem.

Pooja