I recently was requested to implement a feature for merchandise distribution in SAP for putaway and cross-docking methods. There are other methods like stock-placement, flow-through, and others however I will concentrate only on the mentioned ones. Merchandise distribution consists in to group the storage transfer orders from plants to the distribution centers and create purchase […]
ERP
SAP Cloud Platform Integration- Connecting Microsoft SQL Sever
Introduction: JDBC connectivity to On Prem Database Systems-it was long awaited feature in SAP Cloud Platform Integration space. Latest release finally have option to work on it. Lets see how to work on the same. Scenario: Lets consider 3 most used concepts from integration perspective. Setup your SAP Cloud Connector: Follow below tutorial to install […]
SAP Analytics Cloud Story with HANA Live Connection ABAP Cache Warmer
Next to most current and correct data, performance is another very important factor in analytics. In the blog “How to trace widgets in SAP Analytics Cloud stories connected via HANA Live Data Connection“ ( https://www.erpqna.com/how-to-trace-widgets-in-sap-analytics-cloud-stories-connected-via-hana-live-data-connection/ ) it was already described how to grep performance data and link them to a widget in a SAP Analytics […]
Etag In Odata
Introduction E tag is used for Data Concurrency to avoid over writing of same record at the same time by different users similar to Lock objects. Scenario for Etag User 1 and user 2 will get the same record from backend , user 1 will update the data and save the record in database , […]
HCL Workload Automation and SAP best performance together
When we need operational efficiency and orchestration in an IT and Business workflows, Workload Automation is the best approach for Enterprise Resource Planning. We see day by day our customers, especially those using SAP to run their critical jobs with specific time constraints and committed deadline. Business jobs must run and must take less time […]
Identification of Seasonality in Time Series with Python Machine Learning Client for SAP HANA
1. Introduction Seasonality is an important characteristic of a time series and our Python Machine Learning Client for SAP HANA (hana_ml) offers a time series function called seasonal_decompose() which provides a seasonality test and the decomposition the time series into three components: seasonal, trend, and random noise. In this blog post, you will learn: The […]
Outlier Detection by Clustering
In a separate blog post, we have discussed the problem of outlier detection using statistical tests. Generally speaking, statistical tests are suitable for detecting outliers that have extreme values in some numerical features. However, outliers are many and varied, and not all kind of outliers can be characterized by extreme values. In many cases for […]
Internal to Excel with multiple sheets and formatting
Introduction Downloading internal table as excel file is very easy in SAP, But The real struggle starts when you got a requirement like download an excel with multiple sheets or with some cell’s text in different color /Font / Bold /Italic . This can be done by OLE but i got it very confusing. So, […]
How to Share/Deploy/Undeploy local BPM process using NWDS
This blog will provide step by step guide on how to Import/Export,Deploy/Undeploy BPM Process using NWDS and PO. 1) How to Export BPM Process/SC? Open Development Infrastructure Perspective window->Perspective->Open Perspective->Other->Development Infrastructure. Open Component browser and select the SC and click on export Select all development components and click on force build. Click on next and […]
Automate Master Data Vendor Extension Process to Purchase Organization with Approval Workflow
Introduction In every Project or Customer you worked for, you will have the scenario where some Master Data will not be extended to Company Code/Purchase organization and in those scenarios you have to send an email to that Team and wait when this will get extended so that you can create your Business Document. In […]