How to Add Special fields to GL, Vendor, Customer reports as per User requirement in SAP FI

    SAP Scenario/Issue:-

          How to Add Special fields to GL, Vendor, Customer line item display reports as per User requirement in SAP FI

                        (OR)

User wants to have a field transaction code in the output display of transaction  code FBL3N. This will eagerly help the user find the source from which the document is posted.

The details of the prerequisites are given below:-

Go to T.C >>>>>>>  FBL3N ---- Enter

                       

Enter any Gl Account no ,company code  ----- execute

Here  we can’t find transaction code field in the report

Click

 to see whether the field transaction code is available or not ?

Click find

’

Enter text as’ transaction code’

Check the status

 There is no Transaction field in standard layout…

So click ’cancel’   and    come ‘back’

As per User requirement we need to configure/set the field …so just follow the below steps ….

 First  we must find the field Technical name …so

Now Double click  any document no-

Display the document

Click ‘Display Document Header ‘icon

Find Transaction code

Note down the Transaction code name and  click function key ‘F1’

Click  ‘Technical Information’ Icon  

Now find the Field name and Table Name of the Transaction code

The Table is BKPF and Field Name is TCODE

 Solution:-

We can configure/set the field ....

Go to FBL3N  and open any GL account  line item display

Go to Menu-------settings------Special Fields

                                       (OR)

Spro---Financial Accounting-------- General Ledger Accounting------- G/L Accounts----- Line Items ------- Display Line items------- Define special fields for Finding and sorting data

Click ‘Continue’ at cross client msg  window

Select  New entries

Enter   TABLE---BKPF

              FIELD-TCODE

SAVE (Ctrl+s)

Give request description and enter

 select  new request

enter description and save

 click continue

click continue the request and save.....

After doing the above Configuration you are now ready with the field Available in FBL3N display output list.

Again execute  transaction code fbl3n

Click

click find icon and enter transaction code

Enter

Select  the ‘Transaction code’

And  select left arrow icon

Select  ‘copy /enter’.

then come back and check the traction field is there or not

Now we can find the transaction code column in the line item report