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

[Former Member]

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.

     

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)

      

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

    (new one created ). Entry is as below.

   

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

     Entry is as below.

    

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.

   

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)

     

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.

    

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

 

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

      

[former_member227339]

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.

[former_member227339]

No worries - I managed to get that working.

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi Leopard,

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

Thanks,
Mukesh

[Former Member]

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

Please Reply.

Thanks.

[Former Member]

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

[Former Member]

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

[former_member299143]

HI,

 

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

[former_member550089]

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.

[former_member550089]

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.

[former_member681432]

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!

[wnash7658]

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

[wnash7658]

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 Dynpro

[former_member760260]

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

[former_member3643]

Follow same steps using table SKA1 and structure GLACCOUNT_COA_DATA

[former_member3643]

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

[former_member799829]

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?

[tiago_silva]

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

[former_member799829]

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.

[former_member339897]

Hi Leopard,

I have requirement to add a new customer filed in FS00 COA data (Text/Description tab).

Can you please share the compete details how to aching this enhancement.

New filed length one CHAR or it may radio button like YES or NO.

Hope your will help on this.  Thanks you.

 

Best regards

Partha

[former_member828609]

Hi All,

 

Do we have program/transactions to do Mass update of custom fields.

 

Thanks,