Skip to Content

Updating PA0000 via SQL

Hi -

New to SAP (1709 S4/HANA), green field implementation, migrated from Oracle-based legacy system. We have changed the configuration of the employee status fields in PA0000 (MASSN+STAT2). Previously, when MASSN='Z5', STAT2='1'. This is now setup so that 'Z5' maps STAT2 to '3'. For new entries, all is good. For existing entries, we need to update STAT2 to '3'. The functional team wants to create an LSMW object to, essentially, recreate all of the existing Z5 records so that STAT2 gets set correctly during normal processing. Coming from an Oracle background, couldn't we simply create an ABAP program that does this:

update pa0000

set stat2 = '3'

where massn = 'Z5'.

I find it hard to believe that a simple update like this needs to be made so complicated.

Thanks,

Mark C.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.