Skip to Content
author's profile photo Former Member
Former Member

Regarding modify transparent table

Hi Experts,

I have table pa0008 there is wagetype fields and amount corrosponding wage types like LGA01 to LGA40 the amount corrosponding every vage type is BET01 to BET40, now my requirement is i want to modify pa0008 table and amount i have to put 50%.

Thanks in Advance.

Regards

Ajay Pandey

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 31, 2007 at 06:41 AM

    hello Ajay

    providing you with a sample code to modify ure betrg values.

    data : lgart type lgart,

    betrg type betrg

    DO 40 TIMES VARYING lgart FROM wa_pa0008-lga01 NEXT wa_pa0008-lga02

    VARYING betrg FROM wa_pa0008-bet01 NEXT wa_pa0008-bet02.

                                    • ur coding logic

                                    betrg = betrg /2 . " to reduce to 50%

                                    betrg = betrg + betrg/2 " to add 50%

                                    **********************

                                    ENDDO.

                                    NOTE this is at work area level to modify whote table write the above code inside loop of your internal table and before endloop modify it from wa.

                                    reward points if helpful

                                    Add a comment
                                    10|10000 characters needed characters exceeded

                                  • author's profile photo Former Member
                                    Former Member
                                    Posted on May 31, 2007 at 06:34 AM

                                    Hi Ajay ,

                                    you have to do the change of the Basic pay of the employees in the infotype 008 .... For that

                                    goto -> T.code ->PA30 put the infotype 0008 ..... using the Change option there you can change the Amount of the corresponding Wage types .... and save it ... with the Change date's .... so that it will have the old amounts and new amounts with respect to Dates ....

                                    if you want to change all the Amounts present in the PA0008 ...... then Get permission from you Project Manager for changing of the data ... because it an master data for an Employee in an Organisation ..... and it will get stored with the (changed or. delete) with date & User name. so becarefulll and takethe risk ....

                                    then the easy way is .... write a prgram for it for direct table modification or Update ...

                                    tables  :  pa0008 .
                                    
                                    
                                    select-options :  s_pernr  for  pa0008-pernr ,
                                                           s_BEGDA   for   pa0008-BEGDA ,
                                                            s_ENDDA  for pa0008-ENDDA .
                                    
                                    
                                    DATA pa0008_tab TYPE TABLE OF pa0008. 
                                    FIELD-SYMBOLS <pa0008> TYPE pa0008. 
                                    
                                    
                                    SELECT * 
                                           FROM pa0008 
                                           INTO TABLE pa0008_tab 
                                           WHERE pernr  in s_pernr  AND 
                                                 begda in s_BEGDA and  
                                                 endda  in  s_ENDDA 
                                    IF sy-subrc = 0. 
                                      LOOP AT pa0008_tab ASSIGNING <pa0008>. 
                                    pleas   get the   amount  of  what you want to  do  .....   like   you have mentioned  as 50 % .... so   do it here ...
                                    pa0008-BET01   =    pa0008-BET01  /2 .
                                    pa0008-BET02   =    pa0008-BET02  /2 .
                                    pa0008-BET03   =    pa0008-BET03  /2 .
                                    .....
                                    ......
                                    ......
                                    pa0008-BET40   =    pa0008-BET40 / 2 .  
                                    
                                     ENDLOOP. 
                                    ENDIF. 
                                    
                                    UPDATE pa0008 FROM TABLE pa0008_tab.

                                    I think this will solve your problem...... there are still so many ways to update or change the data .... but get the approval from the Boss is must for this things .... fine if it is testing then it is ok ... you can do it ...

                                    reward points if it is usefull ....

                                    Girish

                                    Add a comment
                                    10|10000 characters needed characters exceeded

                                  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.