In EWM Documents are one of the main objects which we always need to access through our custom developments. There are different types of Documents which most of them you can already see in the famous /SCWM/MON – Warehouse Management…
dynamically change stylename in smartform
Lately we had a requirement to use different smart styles for different plants in our outputs. However smartform has a one-to-one relation with smartstyle. It means you can only provide one style for a particular smartform name. Below code can…
generate HTML output from SMARTFORM and send it as email body
There was a standard process in our system which sends a text as the body of a mail, after a certain operation is completed. For this program a change had been done so that the program could send a custom SMARTFORM as a PDF attachment beside to the text body. This change had been done as a repair in a program. So far so good, everything was working fine.
CDS view approach to connect HANA as secondary database
CDS view approach is maybe the safest approach while connecting to a secondary HANA database. If there is a safer approach it would be using directly OpenSQL. However there are cases where OpenSQL is not enough to cover all the states. So CDS technique becomes the only option to connect secondary HANA.
embedded native SQL(EXEC SQL) method to connect HANA as secondary database
Another Top-Down approach of HANA usage is EXEC SQL method which you write SQL commands between EXEC SQL/ENDEXEC lines. Difficult side of this approach is you will be dependent to static special SQL statements which does not follow ABAP syntax.…
ADBC usage with HANA as a secondary database
“ADBC is an API for the Native SQL interface of the AS ABAP that is based on ABAP Objects. The ADBC methods can be used to pass Native SQL statements to the database interface”. It was a definition from SAP Help. It is obvious that ADBC can be used ABAP on HANA systems. I think there are very few advantages of ADBC method but on the other hand many disadvantages that demotivates to use.