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

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. 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.

    (0) 
        1. 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

          (0) 
  2. 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.

    (0) 

Leave a Reply