Powered By

Free XML Skins for Blogger

Powered by Blogger

Showing posts with label SAP ABAP Query. Show all posts
Showing posts with label SAP ABAP Query. Show all posts

Saturday, October 18, 2008

Difference Between LIS, Reports, Abap Query

LIS stands for Logistics Information System.

It is the information systems used to plan, control, and monitor business events at different stages in the decision-making process.

The Logistics Information System is made up of the following information systems which all have a modular structure:

- Sales Information System
- Purchasing Information System
- Inventory Controlling
- Shop Floor Information System
- Plant Maintenance Information System
- Quality Management Information System

Tools are available in Customizing to allow a self-defined information system to be created and tailored to specific requirements.

2) Reports:

SAP Reports are Programmes which are used to fetch data from SAP database under specified selection criteria and show in list viewer. Later you can view, download & take decisions appropriately.

There are many standard reports in SAP for various modules. For SD Module watchout TCode SD01. You can always code your own report they way you want in some cases.

3) ABAP Queries

These are the report which users can prepare without knowledge of the ABAP programming language to define and execute their own reports. Normally Functional Consultants use these ABAP query tool to create and run simple reports by themselves instead of coding by ABAPer. Its flexible and convinent. However you should be well thorough with different tables to map query and fetch data.

SAP Some ABAP/4 Query header line variable

  • &%NAME Name of user executing the query
  • &%DATE Current date when executing the query
  • &%TIME Current time when executing the query
  • &%PAGE Current page number (output 6 characters)

SAP ABAP Quick Viewer

In SAP 4.6x, you can used a simplified ABAP query. The Quick Viewer ( SQVI ) can be used to generate simple report without any programming.

You select fields according to your data source that determine the structure of your report. The report can be executed in basis mode with standard layout or may be edited using drag and drop and other toolbox functions available in WYSIWYG mode.

However, only transparent table are allow to be use in SQVI.

e.g. Your cannot use BSEG as it is a cluster table, instead use BSIS.

  • BKPF - Accounting Document Header
  • BSIS - Accounting: Secondary Index for G/L Accounts

Archives