Skip to Content

SAP Path

SAP Transaction Code

FBL1N, FBL3N and FBL5N etc..

Introduction

There may be cases where the user is interested to maintain reports as per their requirement. Sometimes user may want to maintain layout with the document currency and transaction currency and sometimes user may want to have the invoices with cash discount, assignment or text fields to display with the document line item display.

Enter Selection Parameters

0801.JPG

Transaction FBL1N and execute.

You can see in application toolbar there are three icons (082.JPG) used for managing report layout.

A) Change Layout (first icon ):

                        This icon will be used for changing layout of the currently executed report. Here you can change the different fields to display or hide.

083.JPG

Select ‘Document Currency’ and ‘Purchasing document’ fields from Column Set and select show selected fields button as showed above screen. Click on OK button (Green Tick Box).

084.JPG

Here you can see additionally added columns to report.

B)  Save Layout (Second Icon):

0805.JPG

Save Layout by pressing on Save layout button from application toolbar and specify layout name starting with / slash (/PONO). If you want to make this layout as default whenever you execute this report select ‘Default setting’ check box or if you want to use this layout only for yourself please select ‘User-specific’ check box.

C) Select Layout (third icon):


                      If you want to select existing layout to see the report as required. Please select ‘Select Layout’ button.

0806.JPG

Please select required layout and Click on OK button (Green Tick Box).

Making Layout as Default Layout:

0807.JPG

Select ‘Settings -> Layout -> Administration’ from the menu bar.

0808.JPG

Select ‘Default Setting’ row from the required layout and save.

You can change any layout as default layout by select layout administration default settings.

Kind Regards,

Prasad

To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

  1. E. Traag

    Thank you Prasad for this information, but I have a question about this, I hope you have an answer.

    Our users have the authorisation only to make a user-specific layout, but sometimes it is worth to share a layout with other users. Do you know if there is a possibility (a transaction or a report) to change this layout from user-specific to global?

    Kind regards

    Erik.

    (0) 
    1. Prasad Tatikonda Post author

      Hi Erik,

      Thanks for the posting your doubt.

      If you create Layout as explained above (C) by selecting default layout check box and make that layout as default setting as explained above. This layout will apply to all users.

      There is one more option to make default layout is assign layout in transaction FB00 (Accounting Editing options) under Line item tab or you can even assign layout in the selection screen of the reports like FBL5N or FBL3n etc.ve

      Making default layout as explained above process is suggestible to your requirement.

      Kind Regards,

      Prasad

      (0) 
  2. Nima sep

    hello Prasad

    in additional of thank you for your information,i have a question

    how i can find who changed my layout?with table “LTDX” i can get a bad report.

    there isn’t any transaction??

    if there isn’t how i can use with this table??

    thank you a lot

    (0) 
  3. Nima sep

    i got my answer

    LTDX With LTDXT get you a good.but there is a problem

    Layout Report Result.jpg

    it give me 3 and 2 line for a report 🙁

    can you help me in solving this problem??

    (0) 

Leave a Reply