Gantt Chart

courtesy of Mr. Arya Nugraha

We can display Gantt chart by using function module GRAPH_GANTT, but first of all we need to know the parameters we will use in this function module. (for  more example, please go to transaction code GRAL)

send mail via ABAP using SO_NEW_DOCUMENT_SEND_API1

how to send mail to user SAP office (transaction code SBWP) via ABAP?

we can use function module SO_NEW_DOCUMENT_SEND_API1, but first of all we need to know the basic need of this function module

Checking equipment number before PO saved

when user determine quantity in a Purchase Order (PO), must be followed by maintaining equipment number in Item texts.
In short term, the amount of equipment number must be the same with PO quantity, if it’s not, the PO creation must be prevented.

i do the combination between 2 method in BADI implementation because the prevention to create a PO will be done when CHECK method is executed while the item text (long text) reading process will be done when PROCESS_ITEM method is executed.

why i use this BADI, because through this BADI, we can get the real time data which has been inputted by user.
What i do exactly is to force CHECK method to call PROCESS_ITEM method.

These are the steps..

ALV Hierarchy

Here’s the example about how to create report using ALV hierarchy (courtesy of Sigit Rachmanto)

PO Release Date

I don’t know why i find this very hard to get, the PO release date. But lucky me, after browsing through Google I get this way.

Go to table CDHDR (Change document header) and select UDATE with these parameters

OBJECTID = PO number

TCODE = ‘ME28′ or ‘ME29N’

And then..tadaaaa…you will get the PO release date

Haha, silly me..

 

document->execute_macro

Recently i was assigned to make a report in Excel template using the spreadsheet interface.
i kind of confuse when i need to merge some cells, because i can not find it in any methods of i_oi_spreadsheet.

ascii to character

i was in need to know what is the column name in excel (A, B, C, D, …, AA, …, IV), based on column number (1,2,3,4,…)
by browsing through google and made some modifications, here’s the function module which can change column number to column name.

split long sentence into two lines

how to split long sentence into two lines?this is a problem i faced in previous days, and i don’t know if SAP already have a special function to do this. That’s why i made one function module to handle this. I hope it can help you