Skip to Content
avatar image
Former Member

Update Sap Table

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Nov 28, 2003 at 05:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 25, 2004 at 02:48 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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