Skip to Content
Author's profile photo Former Member

Enhancement of GL master (Addition of new fields in FS00)

New field addition for FS00 transaction-

For example How to add new field “planning account” in FS00 .

There is no screen exit / Badi available to add the new fields / new tab in GL master screen But there is one way through customization which will add new layout and eventually new tab with required fields on it.

Steps :

Add the required field in SKB1 table using
append structure as well add field in structure GLACCOUNT_CCODE_DATA using
append.

  1. Create new layout  in SPRO
  2. Add entries of layout in tables like TAMLAY0, TAMLAY0T,
    TAMLAY1, TAMLAY1T, TAMLAY2, TAMLAYA, TAMLAYAT.
  3. Create Z function group , add new screen with
    required fields in it.
  4. Write the logic in Function Group screen PAI and
    PB0 modules for data transfer.

Detail steps are mentioned below-

1.  Add new field “ ZZPLANACT” in Table ‘SKB1’ with append structure .

2.  Also add new field in structure ‘GLACCOUNT_CCODE_DATA’  using append structure

     That is required for data transfer purpose from screen to database and vice versa.

3.  Goto SPRO-> Financial Accounting-> General
     Ledger Accounting-> G/L Accounts-> Master Data->Preparations->Additional
     Activities->Layouts for Individual Processing->Define Layout

     Path is in screen shot.

      /wp-content/uploads/2015/02/screen1_638957.png

4.   Create new layout “ZBMG” by coping the existing layout-> select the new layout and click “tab page titles” ,

      add new entry for new tab with next number and related description.

      For ex  Here new added entry is with tab 7(Additional fields)

       /wp-content/uploads/2015/02/scree2_638958.png

5. Now add the new entry in table TAMLAY0 with application = “GL_MASTER “and tab layout = “ZBMG “.

    (new one created ). Entry is as below.

    /wp-content/uploads/2015/02/scree3_638959.png

6.  Add the new entry in table TAMLAY1 with application = ‘GL_MASTER” , Layout = ‘ZBMG’  and tab page = ‘7’ .

     Entry is as below.

     /wp-content/uploads/2015/02/screen4_638963.png

7. Add the new entry in table TAMLAY2 with application = ‘GL_MASTER’ , layout = ‘ZBMG’, tab page = 7, position = 1

    and group box = ‘V0100’ . For custom screen, Group box value is combination of ‘V’ + screen number

    that you are going to create in function group.

    /wp-content/uploads/2015/02/screen5_638964.png

8. Select new entry “additional fields” and click on “position of groups on the tab pages”

     Now add new entry with position 1 and group box = ‘V0100’ (which we have already created in above step)

9. Now create new Function Group “ZFIELD” in se 80, create new screen 0100 with Required field “Planning account”

        9.1  At run time structure ‘GLACCOUNT_CCODE_DATA’ will get filled. So access this structure

               GLACCOUNT_CCODE_DATA in your field Group logic using field symbol and pass data from this structure

               to screen field in PBO  as shown below.

         ASSIGN (‘(SAPLGL_ACCOUNT_MASTER_MAINTAIN)ac_new-CCODE_DATA-ZZPLANACT’)TO <fs>.

         *from databaseto screen

          skb1-zzplanact = <fs>.

        9.2  And In the PAI of screen pass data from screen field to this structure GLACCOUNT_CCODE_DATA.

               <fs> = skb1-zzplanact.

10. Add new entry in table ‘TAMLAYA’ with application = ‘GL_MASTER’ and function group = ‘ZFIELD’

      the one which we have created in step 9)

      /wp-content/uploads/2015/02/screen7_638965.png

11. Now attach this layout to specific chart of account as shown below in the path

12. Goto SPRO-> Financial Accounting-> General Ledger Accounting-> G/L Accounts-> Master Data->Preparations->

      Additional Activities->Layouts for Individual Processing->Assign Layout to chart of account.

     /wp-content/uploads/2015/02/screen8_638978.png

    Now select particular chart of account and assign the newly created layout as below.

  /wp-content/uploads/2015/02/screen9_638979.png

13. After all these steps , you can see the new tab in FS00 with new field “Planning account”

       screen10.JPG

Assigned Tags

      20 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo P. Leopard
      P. Leopard

      Hi,

      Thanks for the document and it is right through explained clearly. I am stuck with the field value passed to the data table. I am using the GL master for COA and the additional tab is fine to have the new field int able SKA1 and Structure GLACCOUNT_COA_DATA. It is the PAI and PBO where the value are not been passed. Please could you help.

      Regards, Uma.

      Author's profile photo P. Leopard
      P. Leopard

      No worries - I managed to get that working.

      Author's profile photo Monica Singhal
      Monica Singhal

      Please update what issues you are facing and how it got ressolved.

      Author's profile photo Former Member
      Former Member

      Hi Leopard,

      How did you achive the transfer of data from screen to SKB1.

      Thanks,
      Mukesh

      Author's profile photo Monica Singhal
      Monica Singhal

      Hi Mukesh,

      To Transfer the Data from Screen to SKb1 I have Used below FM:


      CALL FUNCTION 'DYNP_VALUES_UPDATE'

      This is working for me as expected.

      But the issue is only that the Newly added field in Display Mode is also Editable.
      If in case you found the solution to my issue,Please Update.

      Thanks,
      Monica

      Author's profile photo Former Member
      Former Member

      HI,

       

      I am having the issue of reading values in the subscreen.. can you explain how  DYNP_VALUES_UPDATE to use

      Author's profile photo Monica Singhal
      Monica Singhal

      Thanks for giving informative Document.I have followed all the steps mentioned but the table entry in new zfield is not saved in Table SKB1.

      Please help.

      Thanks in advance.

      Author's profile photo Monica Singhal
      Monica Singhal

      How can we make newly added field non- Editable in Display mode?

      Please Reply.

      Thanks.

      Author's profile photo Former Member
      Former Member

      Hello Monica, i have the same problem. Did you solve it? kind regards. SHeela

      Author's profile photo Filipe Ferreira
      Filipe Ferreira

      It can be solved using the standard activity variable from FS00 program in the PBO of your subscreen.

        constants: c_input(1)       type c value '1',
                   c_noinput(1)     type c value '0',
                   c_displaymode(1) type c value '1'.
      
        assign ('(SAPLGL_ACCOUNT_MASTER_MAINTAIN)STATUS-ACTIVITY') to field-symbol(<fs_ctivity>).
      
        loop at screen.
          case <fs_ctivity>.
            when c_displaymode.
              screen-input = c_noinput.
      
            when others.
              screen-input = c_input.
          endcase.
      
          modify screen.
        endloop.
      Author's profile photo Filipe Ferreira
      Filipe Ferreira

      Despite the great post, there could be a bit of confusion with the group box assignment.

      Steps 9 and 10 should be performed before step 7 so SAP can "derive" the group boxes from the subscreens created in your function group.

      Author's profile photo jinjing huang
      jinjing huang

      HI Filipe:

      i have according to your operation Steps9 and 10 be performed before step 7,but “derive” the group

      boxes from the subscreens not created in my function group.

      Detail steps are mentioned below-

      1.  Add new field “ ZFIELD” in Table ‘SKB1’ with append structure .

      2.  Also add new field in structure ‘GLACCOUNT_CCODE_DATA’  using append structure

      That is required for data transfer purpose from screen to database and vice versa.

      3.  Goto SPRO-> Financial Accounting-> General
      Ledger Accounting-> G/L Accounts-> Master Data->Preparations->Additional
      Activities->Layouts for Individual Processing->Define Layout

      4.   For ex  Here new added entry is with tab 7(Additional fields)

      but when i need add new entry postion group with tab7,i can’t find the ‘S+screen number 9650’ group.so i not add new entry postion group.

      5、then i follow the above step9 and 10 and 11.

      remark:

      after from the 1 and 4 step, i can find the content in table “TAMLAY0″ ,”TAMLAY1”,but not find the  configuration  in table “TAMLAY2”.

      after step9 and step 10 i can’t find the configuration  in table “TAMLAYA”.

       

      can i tell me how it get ressolved?

      hope for your reply!

      thanks you!

      best wishes!

       

       

      Author's profile photo Warren Nash
      Warren Nash

      Use debug /H method to add the entries in the table.  Not in production of course.

      My question, the SAPLGL_ACCOUNT_MASTER_MAINTAIN program is not finding the ZFIELD function group screen number .... does it have to be 0100?  Getting a short dump and it is a dynamic call to the screen no too.  Since SAPLGL_ACCOUNT_MASTER_MAINTAIN is a function group then shall I just create a '0900' screen?

       

      Category ABAP programming error
      Runtime Errors DYNPRO_NOT_FOUND
      ABAP Program SAPLGL_ACCOUNT_MASTER_MAINTAIN
      Application Component FI-GL-GL
      Date and Time 23.05.2021 19:13:29

      Author's profile photo Warren Nash
      Warren Nash

      I found it .... I guess the blog is just an overview, but not 100% of the details.  Now just need an ABAP developer to add the extra stuff.  View is VC_TAMLAYA_00.

       

      Field%20Dynpro

      Field Dynpro

      Author's profile photo Srihari k
      Srihari k

      Warren,

      Could you please provide all steps which you were followed to populate Custom field of SKA1 table because I also struck up with the same kind of Requirement.

      Thank in Advance

      Author's profile photo Tiago Silva
      Tiago Silva

      Follow same steps using table SKA1 and structure GLACCOUNT_COA_DATA

      Author's profile photo Tiago Silva
      Tiago Silva

      Group Box Validation

      Just a comment regarding the Steps sequence. Step 10 should be performed before Step 7 otherwise you can't add the group box ID cause system validates if screen 100 exit in the new custom group Z.

      Another comments the group box should starts with U (U0100).

      Example

      Example

      Author's profile photo rodrigo d amorim
      rodrigo d amorim

      Hi Tiago,

      I was not able to find the Group Box ID even after the creation of the Group Function.

      It should be created in table TAMLAYB? Is it done by /h or IMG?

      Author's profile photo Tiago de Souza Silva
      Tiago de Souza Silva

      Check your Group ID. It should starts with "U".

      Author's profile photo rodrigo d amorim
      rodrigo d amorim

      Hi,

       

      I found where to update and insert the new Group Box.

      It should be done by SM34 for the following cluster view:

      Or by the following program:

       

      Adding the new group box at the appl "GL_MASTER" (here is also possible to insert the Function Group without the /h in the table, as suggested in the blog):

       

      after that, the group box will become available to be selected.