Communi'y

SAP Community  Products and Technology  Supply Chain Management  SCM Blogs by Members

 SQVI Reporting | Easiest and Fastest Way to Create...

Supply Chain Management Blogs by Members

Learn about SAP SCM software from firsthand experiences of community members. Share your own post
and join the conversation about supply chain management.

Blog  What are you looking for today?

SQVI Reporting | Easiest and Fastest Way to Create Reports

Without Technical Skills.

Sumit_Holey
Participant

06-20-2023 1:35 PM

 11 Kudos  22,293

SAP Managed Tags: ABAP Development, ABAP Testing and Analysis, SAP ERP,
EWM - Basic Functions, FIN (Finance), MM (Materials Management),
SD (Sales and Distribution)

Hello Everyone,

Although ABAP programmers are typically credited with creating custom reporting,
this may not necessarily be the case for straightforward and general reporting that
isn't heavily dependent on calculations.

SAP has a robust reporting tool that anyone, regardless of technical proficiency,
may utilize to easily create reports.

Go to transaction SQVI
 Give Viewname anything you want

Click on Create

Give the Title

Provide data source as Tabel Join

Click on Tick to move to the next step

Various Possible Data Sources:

Tables (Single or connect): To get data, you can pick individual tables or connect
multiple tables together. This approach is appropriate when you need to directly
extract data from specific tables.

Infosets: Infosets allow you to construct a customized view by combining tables

and fields from various SAP modules. They allow you to connect similar tables and
extract data based on your individual requirements.
QuickViews are pre-defined data sources provided by SAP for typical reporting
scenarios. These are reusable data sources that have been performance optimized.
If it meets your reporting needs, you can choose a QuickView.

For preparing reports in SAP SQVI, there are two options: Basic Mode and Layout
Mode.

SQVI's Basic Mode provides a simplified interface for preparing simple reports
that lack complex formatting and style options. It is appropriate for users who need
to extract data from SAP tables rapidly and generate basic reports. You can select
data sources, specify selection criteria, and customize the display fields for your
report in Basic Mode. However, formatting, sorting, and layout customization
capabilities are limited as compared to Layout Mode.

SQVI's Layout Mode provides more extensive options for preparing reports with
greater formatting and layout features. It has a full range of tools for defining the
report structure, such as field formatting, sorting, grouping, subtotal calculations,
and others. You have more control over the visual presentation of the report with
Layout Mode, and you can customize the design and structure to meet your
individual needs. It enables you to produce more sophisticated reports with a more
professional appearance and feel.

To switch between Basic Mode and Layout Mode in SQVI:

1. When creating a new report or editing an existing one, you will initially be in
Basic Mode.

2. To switch to Layout Mode, click on the "Layout" button in the toolbar.

3. The interface will change, providing additional options for formatting and
layout settings.

4. In Layout Mode, you can define the report structure, customize field
properties, apply sorting and grouping, and set up subtotals and other
advanced features.

5. If you want to switch back to Basic Mode, click on the "Basic Mode" button in
 the toolbar.

Note that Layout Mode offers more extensive capabilities and flexibility for
designing complex reports, while Basic Mode provides a streamlined approach for
quick and straightforward reporting needs.

You will redirect to the next screen, there click on Add Table button as shown

Add as many database tables as you required considering Key Feilds

To illustrate I am adding 2 tables i.e MARC and T001W for material, Plant, and
Plant Address
Click on the Back button, and you will redirect to the next screen for List Field
selection for Output Screen and Selection screen for the Input screen
Highlighted fields are selected for output

In the selection fields ( Input Screen) field has been added

Click on save and go back to SQVI, select the newly created view, and click on
Execute

Your work is done, Give the input and get the output

Input Screen:
 Output Screen:

Conclusion:
SQVI is a basic query tool in SAP that enables you to choose a data
source, define selection criteria, and layout for ad-hoc reports. The report
can be run, with the option to export it or analyze the results on-screen.
You may store and reuse report definitions using SQVI.

For more articles like these, kindly like, share, follow, and leave comments.

LinkedIn : www.linkedin.com/in/sumit-holey

1 Comment

r_lindemann
Explorer

06-20-2023 3:33 PM

 2 Kudos

True, vastly underused in most places I've been. Thanks for bringing it up.

Being the killjoy that I am, though, I think that some substantial drawbacks need to
 be addressed:

Query and Quick Viewer will bypass any and all functional authorization
checks. So, unless you have a very solid authorization concept that also
covers direct table access (with restrictions on S_TABU_DIS, S_TABU_NAM
and the likes), this will tear a massive hole in your data security

when dealing with large tables, suboptimal selection conditions and (even
worse) table joins will bring your system to a standstill. I've seen an entire
ERP system brought to a stop through badly made queries.

The first issue can be addressed, to some extent and with substantial work. As for
the second... that's harder. But for anybody interested, I'd like to recommend
"Workshop SAP Query" by Nico Manicone, he shows how to deal with these
challenges.

 You must be a registered user to add a comment. If you've already

registered, sign in. Otherwise, register and sign in.

Comment

Labels In This Area

aATP 1 ABAP Programming 1 Activate Credit Management Basic Steps 1

Activity Area 1 Advance Shipping and Receiving 1 Adverse media monitoring 1

AI in Logistics 1 Alerts 1 APO CIF Queues 1 Ariba 1 ASR 1

Ausnahmehandling 1 Automation 1 bank statements 1 BI 1

Bin Sorting sequence deletion 1 Bin Sorting upload 1 BP NUMBER RANGE 1

Brazil 1 Business Network for Logistics 1

 Business partner creation failed for organizational unit 1

Business Technology Platform 1 Central Purchasing 1 Change History 1

Charge calculation 3 CIF 1 Cloud Extensibility 1 compliance 1

Controlling 1 Controlling Area 1 cycle counting 1 Data Analysis 1

Data Enrichment 1 decentralized ewm 3 Delivery 2

Delivery & Transportation 1 Demand 1 difference analyzer 1

DIGITAL MANUFACTURING 1 digital transformation 1 Dimensional Weight 1

Direct Outbound Delivery 1 E-Mail 1 Energy 1 ETA 1 EWM 9

EWM - Delivery Processing 17 EWM - Goods Movement 11

EWM - Interleaving with RF 1 EWM Monitor 2 EWM Outbound 5

EWM Outbound configuration 3 EWM-RF 2 EWM-TM-Integration 2

Extended Warehouse Management (EWM) 8

Extended Warehouse Management(EWM) 7 Field Logistics 2 FINANCE 1

Fixed Bin - EWM 1 Forecast Consumption 1 forecasting 1

Freight Agreement 1 Freight Order 1 Freight Settlement 2 FSM 1

FUB_Strategy 1 FUBR 1 Geo-coordinates 1 Geo-routing 1 Geocoding 1

Geographic Information System 1 GIS 1 Goods Issue 2 GTT 2

Handling Unit 2 Handling units 1 IBP inventory optimization 1

illuminator services 1 Inbound delivery 2 inbound delivery printing 1

Incoterm 1 Innovation 1 Inspection lot 1 intraday 1 Introduction 1

Inventory Management 1 IS OIL 1 Localization 1 Logistics 1

Logistics Optimization 2 Map Integration 1 Material Management 1

Material Master changes 1 Materials Management 1 MDO queries in SAP MII 1

MDOs 1 MFS 1 New Feature 1 Oil & Gas 1 outbound delivery 1

Related Content
Leveraging BRF+ Decision Tables for Flexible Route Determination in SAP
S4HANA 
in Supply Chain Management Blogs by Members 8 hours ago

SAP S/4 HANA integration with FSM setup activities 

in Supply Chain Management Blogs by Members 8 hours ago

EWM Data Management in a Nutshell 

in Supply Chain Management Blogs by SAP Friday

Live Data Connection To Manufacturing Data Objects for Analytics 

in Supply Chain Management Blogs by SAP Friday

Outbound Delivery Custom report in developer extensibility 

in Supply Chain Management Q&A Friday

Popular Blog Posts

S/4HANA Embedded Extended Warehouse Management (EWM) Overview

lingaiahvanam

Active Contributor

 827828  61  120
S/4HANA Embedded Extended Warehouse Management (EWM) Advanced
Production Integration Configuration
lingaiahvanam

Active Contributor

 62566  24  70

How to get all the Custom Enhancements(BADIs/User Exits/BTE) implemented

for any Transaction Code in SAP?
arghadipkar3013

Contributor

 59971  10  68
Top Kudoed Authors

Muhammad_Ashraf  5

PrasannaG  2

kunalroy  2

RaghavanKathamuthu  1

joseantonio_martinez  1

Dang_Bao_Van  1

former_member204244  1

yogesh_agarwal2  1

former_member677004  1

SimonSch  1

View all
 Follow

Privacy Terms of Use

Copyrigh7 Legal Disclosure

Trademark Suppor7

Cookie Preferences