This document is prepared on HANA SPS 12 based on this thread.
Use case: The user is asked to enter a date. If nothing is specified then it should be default to first day of...
In this document we will see how to fetch data based on the conditions available in a table. Typically we will see such requirements when applications are built based on SAP HANA. This document is prepared based on version SPS 11 Revision 112...
Hi,A requirement is like this: 2 tables - employee and condition. In condition table, there can be 0 or n number of records.Based on condition table, data from employee has to be fetched depending on attribute operator and value.An attribute may occu...
Hi,Before i did Visualize plan many times without any problem.Now I am getting error while doing so.I was able to run "Explain Plan" successfully.I am on HANA revision 60. I saved above error log and the log information is given below:I can identif...
Hi,Problem description:After creating design-time artifacts, Analytic view with Anlaytic privilege having assign restriction as repository procedure is not returning desired results.HANA AWS revision 70.Problem Recreation:Below I am giving the proces...
One chance could be:In Purchase Order creation, check the Vendor Name.You might have added the Plant Assignment to this Vendor (Tcode: BP, BP Role FLVN01 Supplier, Purchasing - Vendor-General Data)If the Plant is assigned, Remove the Assignment.In EW...
Hi Rahul,You need to Update Standard Characteristics for Batch Valuation.Path: SPRO -> Logistics General -> Batch Management -> Batch Valuation -> Update Standard Characteristicsor using TCode: BMSMYou will get the pop-up screen asking for Update the...
You can get the list of all the tables used in a view by just using the option "Auto Documentation" .
If you are not aware of this option then by google you can find it.