Update Sap Table

[Former Member]

Hello All,

I have to update a field 'RFAREA' in SAP table 'GLPCT' for all entries based on the profit center field 'RPRCTR'. I have a list of profit centers and corresponding functional areas in an excel sheet.

Can you please tell me how to do this? And what are the things I need to consider for modifying this table?

Thanks in Advance,

Anitha

[Former Member]

Hello Anitha,

I believe you can use a special tool for data upload to SAP. It can be used either for GLPCT table and any else. The tool - "Sloka Input Automation for SAP" is using a standard SAP applications, therefore the data upload by this tool will insure 100% data integrity, security policy etc. important things.

I'm advising the product of my company. However I believe it's not just a promotion, but a premium product that can be a real solution for you. Here is the link where you can find more info: http://www.slokasoftware.com/index.php?p=3

Sincerely

Vyacheslav Lifits

[dirk_feeken]

I'm afraid that it is not possible to have a tool that can alter any table content AND guarantees 100% data integrity. There always can be data which semantically relies on data in other tables not necessarily connected by foreign keys. No tool can guess the meaning of the data on the database level.

Dirk

[Peter_Inotai]

Anitha,

It's not recommended to update a SAP table directly, since in this case data consistency is not guaranteed.

Use SAP data transfer tools for this.

Eg BAPI, Batch Input, CALL TRANSACTION, LSMW....

Incho