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.
Add the required field in SKB1 table using
append structure as well add field in structure GLACCOUNT_CCODE_DATA using
- Create new layout in SPRO
- Add entries of layout in tables like TAMLAY0, TAMLAY0T,
TAMLAY1, TAMLAY1T, TAMLAY2, TAMLAYA, TAMLAYAT.
- Create Z function group , add new screen with
required fields in it.
- 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”