Integration of custom fields into Standard Reports dynamic selections

[VaraPrasadT]

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.