cancel
Showing results for 
Search instead for 
Did you mean: 

New customized report using PLD or QUERY PRINT LAYOUT to show customers onl

Former Member
0 Kudos

I am working with a Software Developing firm as an SAP Consultant.

Please tell me how to create a new customized report displaying various details as required by the client in the report using PLD or Query Print Layout.

Please help me asap.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

I have another query.

How to add a final row in a report to calculate the total of all the amounts in the previous rows in any of the clumns in the report.

Rgds

Former Member
0 Kudos

Hi there...

You can use the ColSum("Field_xxx"). where Field_xxx is the field that you want to compute the sum. But please remember that the ColSum will only work for those values in the repetitive area.

If your having difficulty on creating one... You may also load the System PLD's and learn from there... Your questions could be answer there... and here's this site that I come across when I'm looking for references which is actually free.. You may learn from it,...Although its 2004 version but it is somehow identical...

here is the site: http://abbasoft.com/sap_videos/cd1/sap_flash_book_menu1.htm

Hope this helps...

former_member186095
Active Contributor
0 Kudos

Hi,

You can create queries using the Query Generator or the Query Wizard tools.

After you have created your own queries, you can link them to a required print layout.

for user reports.Look at:

Tools --> Queries --> Query Print Layout

Set there your query reports.

Printing User-Defined Queries

After you had linked a user-defined query to a user report template, you can now print it

according to its linked print layout.

There are two ways for printing your user-defined queries.

1. Using the Query Print Layout window:

• Select from the upper menu Tools 􀃆 Queries 􀃆 Query Print Layout.

• Click the Reports tab page.

• Click to highlight the required query you would like to print.

• Click on the printer icon or select from the upper menu File 􀃆 Print.

• The user-defined query is printed according to its linked print layout.

2. Using the Queries Manager window:

• Click the Queries Manager icon on the upper tool bar.

• Click to highlight the required query you would like to print.

• Click on the printer icon or select from the upper menu File 􀃆 Print.

• The user-defined query is printed according to its linked print layout.

Note! You can also print preview user-defined queries. Do so by selecting the Print

Preview option as described in the methods above for printing your query.

Btw, you could search the manual training files relate to query PLD in http://www.service.sap.com/smb

Rgds,