ABAP / EWM

read Inbound/Outbound/Final delivery using selection criteria in SAP EWM

Tagged , Leave a Comment on read Inbound/Outbound/Final delivery using selection criteria in SAP EWM

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 […]

READ MORE

PROGRAM LIBRARY / SMARTFORMS

dynamically change stylename in smartform

Leave a Comment on 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 […]

READ MORE

ABAP / PROGRAM LIBRARY / SMARTFORMS

generate HTML output from SMARTFORM and send it as email body

Tagged , Leave a Comment on 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.

READ MORE

ABAP / DICTIONARY OBJECTS / PROGRAM LIBRARY / SAP HANA

CDS view approach to connect HANA as secondary database

Tagged Leave a Comment on 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.

READ MORE

ABAP / PROGRAM LIBRARY / SAP HANA

embedded native SQL(EXEC SQL) method to connect HANA as secondary database

Tagged Leave a Comment on 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 […]

READ MORE

ABAP / PROGRAM LIBRARY / SAP HANA

ADBC usage with HANA as a secondary database

Tagged Leave a Comment on 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.

READ MORE

PROGRAM LIBRARY

test your SQL statement before using it in your ABAP program

Tagged Leave a Comment on test your SQL statement before using it in your ABAP program

For a long time i thought that there is a missing SQL console feature integrated in SAP functionality. With ABAP 7.4 and usage of Eclipse as IDE, SAP succeded to fulfill this gap with new Eclipse SQL Console. Actually before this feature, there was a similar feature that we could use for the same aim. Therefore i wanted to write down both options so that you can pick one of the suitable one for you.

READ MORE

SAP HANA / SAP PERFORMANCE

HANA as a secondary database, what is possible what is not

Tagged , , Leave a Comment on HANA as a secondary database, what is possible what is not

It has become 4 years since I first met HANA in CodeJam İstanbul January 2014. From that time i have discovered many capabilities of HANA especially when it is located as seconday […]

READ MORE

PROGRAM LIBRARY / SMARTFORMS

dynamically change stylename in smartform

Leave a Comment on 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 […]

READ MORE

ABAP / EWM

read Inbound/Outbound/Final delivery using selection criteria in SAP EWM

Tagged , Leave a Comment on read Inbound/Outbound/Final delivery using selection criteria in SAP EWM

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 […]

READ MORE

ABAP / PROGRAM LIBRARY / SMARTFORMS

generate HTML output from SMARTFORM and send it as email body

Tagged , Leave a Comment on 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.

READ MORE