Customers often request the addition of extra fields that were created as a custom fields in SAP that needs to be added as input fields to the selection screen of standard reports specifically from Finance module . Such kind of report changes cannot be implemented directly. However, they can involve the assistance of ABAP developers to customize the report.
This is an overview of adding custom fields to SAP dynamic selection and these steps generally involve enhancing the standard program or logical database associated with the transaction code to include the custom fields.
In the requirement, to add custom fields in the dynamic selection of standard transaction codes are FAGLL03, FAGLB03, F.08, S_ALR_87009815 and S_ALR_87012301.
The custom fields to be maintained in the SPRO customization level and the path to maintain is SPRO->Financial Accounting->General Ledger Accounting ->Master Data->G/L Accounts->Line Items->Define Special fields for Line Items Display or T-code SM30 and pass the view name as V_FAGL_T021S .
Fields to be maintained in the above path :
Logical database to be identified based on the required standard t-code and the logical database for all the transactions mentioned above is SDF
Pass Logical database SDF in the transaction SE36 and click display. Once the transaction opened, place the cursor on the GSEG structure and Menu option Extras ->Selection Screen Versions
Select 908 (Variant 8: Without chart of accounts and item selection) where we can see the line item details.
Place the cursor again on GSEG and go to Menu option Extras and select Dynamic Selections and choose FAGLFREESEL(General Ledger: Custom Selections (Enhanced)) Node structure.
Open the FAGLFREESEL structure by using the SE11 transaction code and add the required custom fields that needs to be enabled.
Again go back to SE36 transaction and Place the cursor on GSEG and go to Menu option Extras and select Field Selections and choose FAGLFREESEL(General Ledger: Custom Selections (Enhanced)) Node.
and select GSEG(Offsetting Items for B-Segment in Reporting) Node as mentioned below
Place the cursor again on GSEG and go to Menu option Extras and select Selections Views and Copy the Origin of View from SAP to CUS
Source View from SAP to Target View CUS to be selected and click on proceed further. once its created you will have an option to create a functional group to group the custom fields.
In selection views, fields are selected and collected together in functional groups. All fields assigned to a functional group can be found in the view. The grouping of fields in functional groups facilitates the combination of fields according to contents and means that they are easier to find later.
Functional groups are defined by assigning a functional group ID and a text. The functional group ID can consist of any two characters which are only of significance when maintaining the datasets. Here I have created with 04 and the description maintained as Custom Selections
This names of the tables/nodes from which fields for the selection view can be selected. The fields of each of these tables can be displayed in the lower part of the screen.
When you open Transactions like F.08, you will see the folder you made under Dynamic Selections. If you drill down into the folder, you can see the newly added custom fields.
In summary, this will assist in improving the standard report logical database in accordance with client requirements.
- SAP Managed Tags:
2 Comments
