Solutions for SAP Customers
Author: Madhu Sankuru
Improve your SAP environment, develop better operational efficiencies and gain faster access to SAP data. Business people always need to quickly deploy ready-to-use applications that encapsulate best business practices.They need a solution that is certified, affordable, easy to implement, and can make a positive impact on their business in a short period of time.
Software Labs delivers software solutions and acceleration packs that make it easier to work with your SAP system.These applications are designed for business people. So it's easy to use, modify, and extend. Using xFusion Studio, we have made queries in a business category wise so that everybody can easily use as per their requirement. You can join tables without writing any code so that we are saving the time and complexity by using xFusion Studio. By using these queries you can get only neccesary fields and useful data.
In this article, I will show
- How xFusion Studio can easily fetch all blocked vendors data from SAP?
- How to find out final schedule lines for a particular sales order?
How xFusion Studio can easily fetch all blocked vendors data from SAP?
Step 1: Create a connection to SAP data connector
Step 2: Select the tables which you want to join
Create a standard query object.The tables we are interested in is LFA1 and LFB1 .
The columns that we are interested in is vendor name, vendor number, country key,city, company code
Put filter on SPERR field
You now have extracted all the blocked vendors.
How to find out final schedule lines for a particular sales order?
Step 1: Extract records from the sales document schedule line data table
Create a standard query object. The table we are interested in is VBEP .The columns that we are interested in is sales document item,order quantity,confirmed quantity,sales documents,schedule lines.
Step 2: Create a new transformation query object to get the final schedule lines
By grouping sales documents and items, using max function on final schedule line we get final schedule line.
You have now extracted final schedule lines for sales orders.
The complete flow is shown here
xFusion Studio gains an efficient method to quickly retrieve and easily manage vital business information.We have demonstrated quick access to SAP data without writing code.
|