cancel
Showing results for 
Search instead for 
Did you mean: 

Modify or inserting the data from node data into standarad db table.

former_member199125
Active Contributor
0 Kudos

Hi ...

I want to modify the standard db table( say some hr table pa0002) ..with the values available in node.

But node consist of only 4 fields from pa0002.

modify statement example: modify itab1 from wa1.

here wa1 should be same structure of itab1 then only above statement works.

but in my scenario node have only 4 fields , so how can i modify or insert the node values into Database table?

Please help me in this.

Regards

Srinivas

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member199125
Active Contributor
0 Kudos

solved by own

Former Member
0 Kudos

Hi,

Define your internal table with 4 fields and use modify statement.

But it is not recommandable, you have to insert/update data using BAPI/FM or BDC. Serach for that.

Cheers,

Kris.

former_member199125
Active Contributor
0 Kudos

hi kris,

even with internal table also we cannot modify directly. becuase the structures are different. we cannot use simply modify.

And... will there be any kind of FM to modify the pa0021 ?

Regards

Srinivas

former_member199125
Active Contributor
0 Kudos

And may i know the reason? i mean why u said its not recommended to use Modify

Regards

Srinivas

Former Member
0 Kudos

Hi,

HR_MAINTAIN_MASTERDATA i dont know this is working for you or not. try once. and you serach any other fm/bapi available.

Please go thorugh this...

Cheers,

Kris.

Edited by: kissnas on Jun 13, 2011 11:05 AM

former_member199125
Active Contributor
0 Kudos

Kris,

If we transfer the bulk data, then it is better to use.. bapi / RFC ....

But i am updating only one or 2 records..

Here my scenarioo... i have an simple application...in which enduser can update his family details . Once he click on save button, it should reflect in database.

So thats y i am going for modify statement. Correct me if my idea is wrong.

Regards

Srinivas

Former Member
0 Kudos

Hi,

For example you update database table, that doesn't mean that you updated 0002 infotype right, i think by updating directly

database table wont appear at ecc. I faced same problem in SD, so i used BAPI.

Cheers,

former_member199125
Active Contributor
0 Kudos

Kris,

am able to update the database directly...(pa0002 not p0002). Thats why i am going for update method.

Anyhow thanks for ur inputs. my prblmsoloved.

Regards

Srinivas