about reports

[Former Member]

sir,

what is the difference between SIS and ABAP query, how did they helpful in sap sd

whats the purpose kindly explain me

thanku

[Former Member]

Hi Supraja,

ABAP - Query

SAP Users and Functional Consultants to generate quick reports without getting any ABAP coding done – time taken to complete the coding in development, transport and test it in QA system and then transport to production – is sometimes too long. In such cases.

ABAP/4 query is a tool provided by SAP for generating these kind of reports

With the Help of ABAP Query we can create generate a small kind of Reports.

SIS - Sales Information System

A sales information system gives an overview of data and processes in sales and distribution.

This scenario makes this overview possible in distributed sales and distribution systems also (For example: A central view of orders).

Logistics data is sent from the decentral sales and distribution systems to the central sales information system, where it causes information structures to be updated. The data is usually summarized at this point too.

SIS is part of LIS ( logistics information system ). SIS helps in providing SAP standard reports.

The core master data has to be distributed for the following master data:

Material Master

Customer master records

Thanks and Regards,

Sateesh.Kandula

[Former Member]

Hi,

Many times a need arises for SAP Users and Functional Consultants to generate quick reports without getting any ABAP coding done – time taken to complete the coding in development, transport and test it in QA system and then transport to production – is sometimes too long. In such cases, ABAP/4 query is a tool provided by SAP for generating these kind of reports.

Type of Report Desired

Before starting to write an ABAP query, its advisable to decide the type of report that the user wants. ABAP query provides the following type of reports:

Basic List Simple report

Statistics Report containing statistical functions like Average &Percentage

Ranked List Report written for analytical purpose

In a nutshell, an ABAP/4 query can be designed in four steps

Creation of a user group

Creation of functional area

Assignment of user group to functional area

Creation of the query based on functional area

The various objects that form an ABAP query can be created in the following 2 ways:

Tools => ABAP/4 Workbench => Utilities => ABAP/4 Query.

SIS contains various reports for analysis purposes.

regards,

Siddharth.