Report

Former Member — Wed, 16 May 2007 10:50:21 GMT

hi experts,

internal table i_data contains

vkorg(sales organisation),

vtweg(channel) ,

gsber(business area) ,

spart(division) ,

vkbur(sales office),

vkgrp (sales group) ,

bzirk(sales district.

I need to display descrption for the above field's data. that is description for sales group/org/district which are in different master table.. i know it is possible by using select query. Is there any other way other than using select query. ?

Rewards will be awarded.

thanks.

Message was edited by:

Murugan Arumugam

Re: Report

Former Member — Wed, 16 May 2007 10:53:07 GMT

Hi Murugan,

We can manually append the descriptions for the Fields through the Internal table.

Thanks.

Re: Report

Former Member — Wed, 16 May 2007 10:54:28 GMT

Hello,

U can use ABAP Query : SQ01, SQ02,SQ03.

Use

As the person responsible or as the manager for warranty claim processing in the SAP Discrete Industries System you can use online reporting to create ad hoc reports for warranty claim processing. Examples for possible reports are:

· all claims for which the sum that the claimant makes lies within specific amount restrictions

· all claims with parts that have to be returned

· all claims for a specific vehicle model

· all claims of a specific claimant

· all claims in which a specific replacement part is contained

Integration

The basic reports via SAP Query with InfoSets form the basis for online reporting (BC-SRV-QUE).

You can find further information in the standard documentation under InfoSet Query.

Features

You can use online reporting both to define basic reports, i.e.: define and save selection criteria and report layouts, and to create the reports yourself. You cannot, however, save the results in the system.

You can evaluate data that is created in warranty processing itself and external data that warranty processing uses, for example data on the customer, vendor, material, warranty object and so on. However, not all the fields of these object masters are available, only the most important ones. All this data can be used as selection criteria and as output fields in the report.

The SAP standard system delivery contains user group WTY_OR for warranty claim processing. The InfoSet WTY and the logical database WTY is assigned to this user group. All the available warranty claim processing data is contained in the InfoSet WTY.

Activities

· Choose transaction SQ01 for creating, changing, displaying and executing queries for a specific user group.

· Choose transaction SQ02 for creating, changing and displaying InfoSets and for assigning InfoSets to user groups.

· Choose transaction SQ03 for creating, changing and displaying user groups and for assigning InfoSets and users to user groups.

· Choose transaction WTYOR to execute queries. Set the Global Area indicator, enter WTY_OR as user group, enter one of the existing queries and, if required, a variant and then choose to execute. You can see which queries already exist in transaction SQ01.

Regards,

Deepu.K

Re: Report

Former Member — Wed, 16 May 2007 10:55:22 GMT

Make use of the FM.

Rgds,

Vasanth

Re: Report

Former Member — Wed, 16 May 2007 10:58:19 GMT

pls. explain with an example.

thanks.

topic Re: Report in Application Development and Automation Discussions

Report

Re: Report

Re: Report

Re: Report

Re: Report