Skip to Content
Author's profile photo Prasad Tatikonda

How to manage SAP report Layout?

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

Assigned Tags

      19 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Muthukumareshan vijayan
      Muthukumareshan vijayan

      Hi Prasad,

      Thank you for sharing knowledge and Good resource for all..

      Thanks

      Muthu

      Author's profile photo Prasad Tatikonda
      Prasad Tatikonda
      Blog Post Author

      Thank you Muthu..

      Thanks & Regards,

      Prasad

      Author's profile photo Former Member
      Former Member

      Hi,

      Really thanks goods sources

      Author's profile photo Prasad Tatikonda
      Prasad Tatikonda
      Blog Post Author

      Thank you Rakesh..

      Author's profile photo Former Member
      Former Member

      Helpful information to all...

      Best Regards,

      Naresh K.

      Author's profile photo Sreekanta Marikeri
      Sreekanta Marikeri

      Thank you Prasad for sharing valuable information....

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Prasad Tatikonda
      Prasad Tatikonda
      Blog 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

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama

      Hello Prasad,

      Good document and thanks for sharing your knowledge. Keep sharing 🙂

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Prasad,

      Very good document, Thanks for putting it together.

      Thanks

      Giri

      Author's profile photo Saravana Kumar Subramaniam
      Saravana Kumar Subramaniam

      Prasad,

      Very useful & informative.

      Thanks

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member

      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??

      Author's profile photo Hector CONTRERAS
      Hector CONTRERAS

      You are missing some columns. One of them the Language Column. You might have different languages in your system.

      Check that.

      Author's profile photo Khadija NAZIH
      Khadija NAZIH

      Hello Prasad,

      Thank you for sharing this valuable information.

      I still have a little problem when saving my layout as default, I cannot check the User-specific checkbox because it is disabled, and this makes any other users modify the layout whenever they want to. Is there a solution to enable the User-specific checkbox?

      Regards.

      Author's profile photo Eric Yeargain
      Eric Yeargain

      Prasad,

       

      Any idea why my user-specific option would be greyed out? User restrictions?

      Author's profile photo Remi Kaimal
      Remi Kaimal

      Hi Khadija NAZIH,
      Hi Eric Yeargain

      If you are still looking for a solution the authorization object needs to be added to your user : S_ALV_LAYO

      Author's profile photo Adil Bouhamidi
      Adil Bouhamidi

      Hi there,

      i am using the transaction LT23 and wanna save MY Layout as default but it does not work.
      I still have to choose my layout each time I call the transaction.
      Can anyone help please!

      Thank you

      Author's profile photo Nalini N
      Nalini N

      Hi ,

      We have customized tcode and layout already set when i executing  with this layout its working fine but some column not populating data .could you help us .

      When user executing this tcode with the layout  the specific column not populating data in the report its coming blank.

      Could you help us here its urgent.

       

      Thanks,

      Nalini