SQVI for SAP TM
SQVI (SAP Quick Viewer) is a powerful tool that enables users to quickly create custom reports in SAP systems. It is a flexible and user-friendly reporting tool that can be used by both technical and non-technical users.
One of the significant advantages of SQVI is that it does not require programming skills. Users can create complex reports without writing any code. SQVI uses a graphical interface that allows users to select fields and tables from a list of available objects. Users can also use predefined templates that provide a starting point for building queries.
SAP TM (SAP Transportation Management) is a comprehensive solution for managing transportation processes and logistics in businesses. Unlike traditional SAP modules, SAP TM does 'not' use traditional database tables for storing its data. Instead, it utilizes a different data model and storage mechanism for improved performance and scalability. This data model is called BOPF: Business Object Processing Framework. Despite the fact that this framework is used, most data is still stored in database tables. Therefore, also SQVI can be a helpful tool for SAP TM consultants, developers or users.
Let's have a step-by-step approach on creating a report where you can search for deliveries and see its corresponding freight units and freight orders. The assumption here is that an S/4 HANA system with embedded TM is used where deliveries are integrated..
Step 1) Create the report in (tcode) SQVI called ZFUFO.
Step 2) Provide a title and choose table join as a data source.
Step 3) Add the following tables:
Note that SQVI automatically will try to set the link between the tables. Often, two tables are connected with one common field, such as the tables MARA and MAKT are connected through field MATNR (Material). However, in the case of SAP TM, tables are connected based on they keys of the node instances. In this example, the SQVI automatically created the link between the Freight Order Root and Freight Order Item on the field DB_KEY. This is wrong and needs to be corrected as the Freight Order Header key (/SCMTMS/D_TORROT-DB_KEY) is linked with the Freight Order Item parent key field (/SCMTMS/D_TORITE-PARENT_KEY). Therefore, the linkage should be corrected as follows:
(Also note, that the Freight Order Root table uses a left outer join with the Freight Order Item table as you can have e.g. a Freight Order without items. Similarly, the Material Description could be missing, which is unlikely, but still it is advised to go for safe...)
Step 4) Indicate the fields for listing and for selection.
For instance, in this example, the following fields are enabled:
Step 5) Execute the report. For instance, if you want to know which Freight Order (TO) is related to Deliveries 80000005 and 80000006, the following input can be used:
This will produce the following result:
It is important to understand that more tables can be linked, such as the table /SCMTMS/C_BTDTYT for getting the description of the Base Document Type, but don't forget to consider the 'left outer join' option when creating the linkage between tables.
The TM data model contains both persistent data and transient data. As transient data is typically not available in database tables, it can not be display in the SQVI. (If transient data is required, custom (BOPF) development knowledge is required.)
Conclusion: SQVI can be a simple and quick tool to list data from SAP TM. Although SAP TM provides worklists (POWL) and other ways to display and export data, the 'traditional' SQVI can be a perfect alternative to create a custom report.
Questions? Feel free to contact us.
About us: AntaForce is a leading consultancy company specializing in SAP Transportation Management (TM). We offer comprehensive services to help businesses optimize their logistics operations and maximize the benefits of SAP TM. AntaForce conducts thorough analysis, designs customized solutions, and assists in the configuration, implementation, development and integration of SAP TM. Additionally, AntaForce offers training, testing, product development and ongoing maintenance services to ensure long-term success. Our goal is to help customers enhance efficiency, reduce costs, and improve supply chain visibility in their international logistics endeavors.
This is useful and great thanks for sharing. An addition to this, one can use SE16H t-code. It has similar capabilities to SQVI but you can include formulas whilst defining the joins which is quite helpful as well. I would obviously advise access to these transactions is only given to Dev or tech savvy members. Albeit, personally I do not prefer querying the operational system as such as it could exhaust the underlying database. SAP BW and/or SAP DataSphere should be the strategic reporting and analytics platforms. But that is just my personal preference from years of experience.
Business Process Digitalization
1 年Useful and very often used in the "old" World - and great to have it in the New World too.
Akdeniz üniversitesi - SAP/TM
1 年Very useful ??