A Thing Called Planning Sequence

A planning sequence is a list of planning functions and parameter groups that are processed in the order you have previously defined. You use this function if you want to automate the sequential processing of multiple planning functions that you have defined. [SAP Help]

Planning functions are used within BI Integrated Planning for system-supported editing and generation of data. [SAP Help]

Related transaction: RSPLAN. Enough with the theory, let's jump into action. Read here.

Currently on my desk, SD KPI infocube is doing major data load. We deleted the wrong old data and reload them from the beginning. Wish us well or SD KPI will have zero data.

Debug a Start, End or an Expert Routine in BI 7.0 Transformations

I have been wondering how to debug a transformation routine in SAP BI. Well this is how. After that, I wonder what should I do with the data I extract using the debug mode. At the second thought, just delete it after the culprit is found right?

Upgrade Extraction Structure

Consider SAP Notes 328181 when you need to upgrade extraction structure in the Customizing Cockpit (transaction LBWE). And when the trouble has happened, check in SE37 whether you have MCEX_GENERATE_DDIC_HASH. If not, do SAP Notes 834897. Then say a pray and do this and this (the last one only for Purchasing, find relevant notes for other application).

Kartu Kredit

Pelajaran berharga dari proses yang namanya growing up.
Dari ga punya uang sampe bisa cari uang sendiri.
Kartu kredit.
Ga bisa baik-baik sama sales kartu kredit. Repot sendiri.
Kalo ga berminat langsung tolak aja.
Apalagi sama sales kartu kota yang ga pernah tidur.
Dulu saya pengen banget punya kartu itu.
Sekarang mau ditutup susah banget.

Kalo ngerasa tawarannya menggiurkan jangan langsung diterima. Cari info dulu.
You can always call them back right?

Oh ya, saya tutup kartu itu karena tiba-tiba suatu hari saya kepikiran.
Gimana kalo suatu saat saya dipanggil Allah.
Tagihan tahunan datang dan keluarga saya yang repot.
Oh I really don't want to imagine them remember me as anak perempuan tukang ngutang nyusahin keluarga.

So far kartu kredit aktif saya ada 3 (Dek catet ya, in case something happened)
Mandiri corporate gratis iuran tahunan seumur hidup.
BCA iuran tahunan 300 ribu.
Standchart iuran tahunan berapa ya lupa.

Kayanya begitu berhasil upgrade Mandiri jadi Gold, BCA dan Standchart ditutup aja ah.

Youth Is...

Are you searching for something precious? In the end you can't see it. Nor can you touch it. It simply gets carved into your heart...

From the show Invincible Youth - KBS World, Saturday & Sunday (in Indonesia).


I think this variety show has a great way to teach youngsters about wisdom, love and the value of hard work. At the same time it is very entertaining with the presence of seven girl singer group members as regular casts. That's why it is effective to attract a lot of young viewers. Very great.

All pictures are courtesy of KBS World

What Have Been Happened Lately

First of all, I am officially a commuter starting from 2 months ago. It's a bittersweet. I'll tell you why. Pondok Aren to Gambir is gotten through 1 public transport from Pondok Aren to Jurang Mangu train station, then the train from Jurang Mangu to Tanah Abang, then an 'illegal' public transport from Tanah Abang to Gambir. It took approximately one and a half hour to get to the office. In the morning it is not a big deal. But when got home, it makes me exhausted. Usually I got home around five thirty to six in the afternoon. After that, my body won't cooperate anything more than eat, wash up and prays. No more little browsing or shopping in workdays. It kinda make me feel bored but what can I do? I really value little time spent around my mom and sister. Even if it just to see their faces and say hi. So I think this is better. Go home every day and enjoy my time with them while I can.

Korea's King of Ballad

Proudly introducing you (if you haven't know) Mr. Shin Seung Hoon! ^_^ I'm currently smitten by his voice in OST of IRIS, Love of IRIS. This IRIS drama is soo on hype. With it's high production budget, abroad shoots (so far I had seen scenes in Hungary and Japan) and a lot of stars playing in it. It has Lee Byung Hun, Kim Tae Hee, TOP. It's OST has Baek Ji Young, Kim Tae Woo, Big Bang and yes, Mr. Shin Seung Hoon himself. Oh he has that mysterious aura which makes him even more charismatic as he gets older. I really hope his prodigy will be as as good as him, or even better. May I wish a hard work and good luck for Tei, Shin Hye Sung, who else? Lee Seung Gi? Kim Jong Kook? No? Hihi.

Download Shin Seung Hoon - Love of IRIS [Credit: Soompi IRIS forum]

SAP BI GetQueryViewData

Now that my scope of work has shifted, I found new things to play with. Good bye ABAP-ing in ECC 6.0. Welcome ABAP-ing in SAP BI, kekekke. More than that, I am challenged to bring out SAP BI data to the world company. Like what my seniors and I have been doing in R3, we abused brought out the precious information to Web Services and SQL Servers. And the result are dynamic heart beats of transactions and reports that have the spirit of single source of truth. Speaking of information in our company is speaking of SAP data. No other. Of course, without having to remember a T-Code.

Years passed through. My interest got hooked on SAP BI. With all massive storage and OLAP techniques that makes reporting finally got its attention in the first place. To communicate with SAP BI from outside, I've tried the hard way and currently using the easy way. The hard way, learn MDX Query and pass it to BI by calling a BAPI. I can't remember the BAPI name, I don't want to discuss that now. Me feels too hard to coupe with MDX query. The easy way, using a web service that SAP BI provide. For doing this, you have to work with some one who have access to SAP BI GUI and can operate SAP Query Designer. Ask the dude to follow the steps to prepare the web service in SAP BI here. That document is a starter, the journey to have a ready-to-call web service has just begun my friend. This is tricky, you thought you got the web service link, but when you tried to access it, BUM! Failed. Well if that's the case, kindly contact me. See if I can help you. Been there, me. Sorry but I really need to skip so that I can finish this fast.

Specify your output data to SAP BI dude so that they can build that into a query, of course from the Query Designer. As a result, you will get query name and info provider name.

Now it's web application's turn. The service you need to call is GetQueryViewData. When testing, use a simple query without any variable screen. Because dealing with variable screen is the second confusing thing. Explanation from SAP on how to pass parameter to variable screen in this service is veeery hard. It is far away from plain. I have to google and google again until accidentally met the same programmer with the same problem. And this is how GetQueryViewData is called using parameter:

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Collections.Generic;
using System.Net;
using WSDashboardEnterprisePortal.SAPBIProxy.GetQueryData;
//That was the class of the web reference
public static GetQueryViewDataResponse GetQueryData() {
       NetworkCredential login = new NetworkCredential();
       GET_QUERY_DATA BWQuery = new GET_QUERY_DATA();
       login = new NetworkCredential();
       login.UserName = "UserName";
       login.Password = "Password";
       BWQuery.Credentials = login;
       BWQuery.PreAuthenticate = true;
       GetQueryViewData gqvd = new GetQueryViewData();
       gqvd.Infoprovider = "InfoProvider";
       gqvd.Query = "QueryName";
       List listParam = new List();
       W3query param;
       for (int k = 0; k < arrParameter.Length; k++) {
       //If you only have one parameter, omit this loop
            param = new W3query();
            param.Name = string.Concat("VAR_NAME_",(k+1).ToString()); //VAR_NAME_1, VAR_NAME_2, and so on
            param.Value = "0CALMONTH";
            listParam.Add(param);
            param = null;
            param = new W3query();
            param.Name = string.Concat("VAR_VALUE_EXT_",(k+1).ToString());
            //That was VAR_VALUE_EXT_1, VAR_VALUE_EXT_2, and so on
            param.Value = "200909";
            listParam.Add(param);
      }
      gqvd.Parameter = listParam.ToArray();
      gqvd.ViewId = null;
      GetQueryViewDataResponse response = BWQuery.GetQueryViewData(gqvd);
      return response;
}

Two Things That I Don't Need To Do

In my case, gaining weight and being improvident are two things in common. Things that I don't need to do.

Sinetron It Is

There are dramas in Korean being called as makjang series. Makjang plot it self is described as:

outrageous storylines involving adultery, revenge, rape, deception and the like, designed to keep viewers hooked no matter how ridiculous the stories became.

In Indonesia, I am sure we call that sinetron :D
Credit: dramabeans

On Rainy Days Like This

Suddenly remind me of old-office days. 8 o'clock in the morning, inside angkot B-09 Ciledug, listening to Opick's song. It was cloudy outside, rain began to pour in. I was wondering will I pass the last of lots of Pertamina exam. Then, if not how long will I be working in current office. All feelings got in my heart. The memories of friends who are already pass Telkom exam. My parents who wish me to work in decent hours. Allah Who is very kind to me. It was hard days. And I was alone. Like I always do. Ah no~~. Allah is there ^^

Create New User in SQL Server

Credit: Dr. Herong Yang [www.herongyang.com]

C:\>sqlcmd -S localhost -U sa -P xxxx

1> -- Set DBPMSPemasaran as the current database
2> USE DBPMSPemasaran;
3> GO
Changed database context to 'DBPMSPemasaran'.

1> -- Create a new server login name: PMSPemasaran
2> CREATE LOGIN PMSPemasaran WITH PASSWORD = 'xxxxx'
3> GO

1> -- Create a new database user linked to the login name
2> CREATE USER PMSPemasaran FOR LOGIN PMSPemasaran;
3> GO

1> -- Grant database ALTER permision to the user
2> GRANT ALTER To PMSPemasaran;
3> GO

1> -- Grant database CONTROL permision to the user
2> GRANT CONTROL To PMSPemasaran;
3> GO

Here is what I did to test this new login name and user: PMSPemasaran

C:\>sqlcmd -S localhost -U PMSPemasaran -P xxxxx

1> -- Set DBPMSPemasaran as the current database
2> USE DBPMSPemasaran;
3> GO
Changed database context to 'DBPMSPemasaran'.

1> -- Create a new table
2> CREATE TABLE Test (ID INT);
3> GO

1> -- Drop the table
2> DROP TABLE Test;
3> GO

Konglish

Andy's Single Man song is released. Listen to it a bit. And shocked how Andy who ever stayed at US and experienced education there incorporated some Konglish in the song, "Wannabe a sing sing boy." LOL. I guess he finds it cute so he agreed to sing it. Oh and just listen how he pronounced sweetheart like he didn't know the meaning, kekekeke. Andy-sshi, don't need to be so modest about your English. You are loved for who you are.

And, this is one of Korea's hot single man singing that he only want a free love.

At Surabaya

Staying at Town Square Suite Hotel for the first time. Nice. Might come back here for another business trip. Taste the food from the Surabaya Town Square's Qua-Li for dinner. Not bad. Have to finish a short presentation, so I will get back to this later.

Dan Airmata Saya Terbetik

Membaca tulisan A. Fuadi di Negeri 5 Menara-nya. Dia menulis, "Inilah energi yang terus memutar mesin sekolah kami, aura tebal yang menyelimuti segala penjuru, dan ruh yang menguasai kami semua. Apa pun kegiatan, baik senang maupun tidak, selalu dilipur dan dihibur dengan potongan kalimat: "ikhlaskan ya akhi..." Dan begitu potongan itu disebut, rasanya hati menjadi plong dan badan menjadi segar, seperti habis merenggak STMJ. Sebuah prinsip yang sakti dan manjur"

Lalu selanjutnya dia menulis, "Jiwa keikhlasan dipertontonkan setiap hari di PM. Guru-guru kami yang tercinta dan hebat-hebat sama sekali tidak menerima gaji untuk mengajar. Mereka semua tinggal di dalam PM dan diberi fasilitas hidup yang cukup, tapi tidak ada gaji. Dengan tidak adanya ekspektasi gaji dari semenjak awal, niat mereka menjadi khalis. Mengajar hanya karena ibadah, karena perintah Tuhan. Titik."

Saya jadi terinspirasi, mengikhlaskan setiap pemberian, pengorbanan, hati yang tersakiti, waktu yang terbuang. Semua punya Allah, bukan punya saya. Lalu.. ya, hati jadi tenang, semangat lagi. Semua amanah Allah pada saya adalah rahmatan lil 'alamin. Bukan punya saya.

In Bandung

Currently developing SPC Customer Care application. They call it eServe. I call it Carlita, stands for Customer Care Online Pertamina. How do you think? Which name prettier?
Anyway when you hit Bandung, don't forget to stop by at Batagor Kingsley at Jalan Veteran. Not only the batagor are worth the money to be taken home as present, they also sell various snacks for alternative presents. Many kinds of keripik, brownies, dodol, you name it.
For dinner I don't go places high and cold which offer beautiful view like Kampung Daun. I am all the time a city girl :p But BIP also lack of the essence of Bandung. So Paris Van Java it is. A beautifully designed shopping place with some culinary delicacies. Starbucks, BMC yoghurt, Duck King and many more. And never forget to spare a dinner for nasi or mie goreng in front of Savoy Homann Hotel.
When craving for Sundanese food, simply hit Ampera restaurant at any places around Bandung. Still the first opened restaurant is the one located in front of Kalapa terminal. Aaah, and I see two Padang restaurants named Sederhana Bintaro here ^__^v
Drop by to Kartika Sari for its famous brownies and molen coklat keju. Following Prima Rasa for my very own favorite (again) brownies and molen kacang ijo.

Dealing With XMLSerializer

The error caught was:

File or assembly name yofdjhlq.dll, or one of its dependencies, was not found.
at SerializationClass.ToXml() in d:\nur\work\iataadapter\serialization.cs:line
20
at IATAAdapter.IATAAdapter.Main(String[] args) in d:\nur\work\iataadapter\iat
aadapter.cs:line 25

What to do? another class that I tried to serialize has no problem. Got hint from 2 days googling for this problem. I add this line in app.config.







Then tried to run the application again. Write the name of the missing assembly and find it in the temp folder that the Visual Studio used to store its temporary assembly. At first I search it in wrong folder, which is C:\Windows\Temp. Well all of them in the asp.net forum make me concentrate on that folder, including granting the security for ASPNET user account as well. It turn out that the temporary assembly is stored in C:\Documents and Settings\[logged_user]\Local Settings\Temp. The result of adding the lines in app.config finally paid off. I found the [assembly_name].0.cs file and [assembly_name].out file which shows the actual error. In my case, this is it says:

error CS0030: Cannot convert type 'InvoiceTransmissionInvoiceSubInvoiceHeaderInvoiceLineSubItemSubItemProduct[]' to 'InvoiceTransmissionInvoiceSubInvoiceHeaderInvoiceLineSubItemSubItemProduct'
error CS0029: Cannot implicitly convert type 'InvoiceTransmissionInvoiceSubInvoiceHeaderInvoiceLineSubItemSubItemProduct' to 'InvoiceTransmissionInvoiceSubInvoiceHeaderInvoiceLineSubItemSubItemProduct[]'

The end of this story is a happy end. Finally found the mishaps in the class I tried to serialize and the XML Serializer is working just amazing.

The Power of ST22

Bukan, bukan ST12 yang saya tonton waktu diundang dateng gebyar BCA yang ada Aura Kasih dan Glenn Fredly. Ini ST22 ABAP Runtime Error, yang menyelamatkan kebingungan Mas Azhar dan saya karena hari ini job SAP BI dari ECC kebakaran. Hampir semua dengan error ABAP/4 processor: OBJECTS_TABLES_NOT_COMPATIBLE. Cari-cari di Google malah diarahkan patch SAP Notes. Padahal ga ada perubahan apa-apa dari BASIS antara kemarin dan hari ini. Padahal kemarin job BI jalan2 aja. Maka pergilah Mas Azhar dan saya ke ST22, isi user dengan BIREMOTE dan keluarlah stack trace error ABAP-nya. Programnya teridentifikasi, line penyebab error tertera dengan jelas. Tinggal ke SE38, masukkan nama programnya, masuk tab Properties, lihat last updated by dan date-nya. Hah, baru diupdate kemarin *evil grin*

Dream of 2013

In 2013 Shinhwa should be re-unite *if Allah wish*. And if they hold concert at that time AND promise that M will sing this song, I MIGHT COME! *evil laugh*

Awwww.. It happened!

Gw delete formula di Key Figure!! NOOOO... Untung ada contekan dari PBD. Langsung balikin lagi. Gila. Kalo gw ngerti bikinnya mah santai, ini.. ga mudeng .. T__T Ya Allah.. selamatkan tanganku dari perbuatan aneh.. amiin. Hihi.

New Experience, Worried but Excited

Kredit rumah bikin saya semakin mendekat sama Allah, bener-bener pasrah, berserah diri, tawakkal. Berapapun jumlahnya, semoga Allah kasih keluasan rejeki. Semoga selalu sehat lahir dan batin. Amiiin.

Unicode Program in Unicode Environment

This person said it deeply :D
"Unchecking the unicode is a bad idea. Unchecking the unicode on a unicode system is a worst idea."
The code that I tried to copy wrote:
DO 20 TIMES
VARYING wa_0008 FROM p0008-lga01 NEXT p0008-lga02.
Because of the unicode check, the error came: "P0008-LGA01" and "WA_0008" are type-incompatible.
Then the solution:
DO 20 TIMES
VARYING wa_0008-lga FROM p0008-lga01 NEXT p0008-lga02
VARYING wa_0008-bet FROM p0008-bet01 NEXT p0008-bet02.

:)

A Present for Tomorrow

Doing some kind of a present for tomorrow. Although it might not be come. Feels great and full of spirit. Facing it.

Di Balikpapan

Di Balikpapan sampe besok. Makanan di Blue Sky Hotel kena banget sama lidah saya. Morning coffee-nya enak. Racikan saus 1000 Island-nya juga enak. Kamarnya lega, lay-outnya bagus, ada KBS World ^__^, deket sama kantor, ada antar-jemput bandara. Alhamdulillaah, orang-orang di kantor sini kooperatif. Nice.

Bored Mode ON

Spamming time... hehehe, so bored after half day filling in people review.
Maybe one of the reason i like Korean entertainment is the FEEL it creates when they speak. I can only feel it right now, because without sub, I practically don't understand what (on earth) are these Koreans saying. Their intonation and accentuation on different syllable sounds traditional, thus polite, yet warm. I just looove conversation between singer Shin Hye Sung, Lee Ji Hoon on Kim Jung Eun's Chocolate. Simply cute. Even until now I don't have the sub, don't understand a bit :p
I may have to let go the opportunity to attend 10-year reunion with my high school friends. Luckily because I have to go somewhere nice hehe.
The Son of Sol's Pharmacy House is my recent recommended kdrama. Great dialogue, heartwarming story, full of life lesson.
Going home now. President election is tomorrow. Lanjutkan? :D

SM69: Execute External Command from SAP

Ceritanya lagi copy program Electronic Bank Statement dari server SAP satu ke server lain. Trus ketemu program yang execute function module 'SXPG_COMMAND_EXECUTE'. Yang membawa saya ke parameter command name. Berharap SAP meninggalkan sedikit jejak di dokumentasinya, dengan H2C saya klik tombol documentation. Ada link di tulisan command name, harapan semakin besar. Setelah di klik, yes, tujuan berikutnya adalah SM69. T-code tempat setting external command yang bisa di jalankan dari SAP. Tinggal copy command dari server SAP acuan, tapi.. ah OS nya beda. OS SAP acuan Sun, OS SAP yang mo dicopy Windows. Lalu, apakah saya yang dodol di Praktikum Sistem Operasi ingat 'ls' di Sun mappingnya apa di Windows? Inget ^_^ 'dir', 'mv' = 'ren', 'rm' = 'del', 'cp' = 'copy'. Next, tes. Yak, error, hihi. Langsung menuju google, pasti udah ada yang pernah begini sebelumnya. Dan ternyata, command Windows harus didaftarkan dengan format 'cmd /c [command]'. Selesai update semua, tes. Dan yak, sukses v^_^

Pasang FastNet

Pagi ini baru telepon first media, minta dipasang fastnet. Karena lagi promo dapet diskon macem-macem, yang dibilang mbaknya tadi ada 5. Yang saya ingat, modem diskon 50% jadi 250 ribu, bulan-1 gratis, biaya pasang gratis. Selanjutnya saya main ke om gugel, liat-liat percakapan maya tentang si fastnet ini. Banyak. Yang paling saya perhatikan saat ini adalah koneksi ke modemnya cuma bisa dari 1 komputer karena server ISP ngecek MAC Address dari komputer yang terhubung. Saya berniat menggunakan laptop kantor untuk dihubungkan ke modemnya. Tapi saya juga perlu laptop rumah bisa terhubung, secara laptop kantor cuma ada di rumah weekend saja. Dan mulailah saya mencari software yang istilahnya bisa "meng-cloning MAC Address". Laptop rumah akan saya instal itu, kemudia saya samakan MAC Address-nya dengan laptop kantor. Dapat installer yang ini. Hope it works. Itu PR pertama. PR kedua, kalo kedua laptop ada di rumah, saya mau dua2-nya bisa terhubung ke internet. Beli router nanti dulu. Saya berniat melakukan ini tanpa modal :p Ingat kejadian dulu pas class room sekamar sama Chie dan Reni di Simprug. Kabel LAN cuma satu, tapi laptop ada 3, dan Chie mengeluarkan jurus dari buku 'Wireless Kungfu'. Berhasil. Kita bertiga bisa terhubung ke internet. Jadi kayanya harus pinjam buku itu. Secara saya adalah perempuan ndak mudeng network, ini adalah pekerjaan susah. Dulu kuliah sistem operasi, komunikasi data, praktikum, sampai nginep ngerjain instalasi server linux untuk tugas akhir praktikum segala, tetap ga mudeng. Wish me luck! :D

Update: barusan diajarin caranya supaya bisa sharing koneksi internet dengan maksimal 3 laptop terhubung. Ternyata di Vista cukup bikin Adhoc network, trus Allow sharing internet connection. Ah.. can't wait..

Ehm..

Duh... yuk, fighting!

Passing a list/array to an SQL Server stored procedure

Just what I need at the moment. Nice article.

Que Sera Sera

I gave 10 out of 10 stars. All stars belong to Eric-sshi. He acted beautifully, grabbing my heart so that i found myself don't care of any logic the writer use, as long as Kang Tae Joo (his role) is happy. In this drama, he is getting me on my nerves when it comes to his role's jerk-ness. Making me really happy when he behaved accordingly. And my heart was hurt seeing his sadness and helplessness. Allah surely gave him blessings for his distinctive ability to show such expressions, acts and voice. And he used it to the max. What a weekend!

NB: baby pink and softened yellow sweatshirts worn in one of the scene look stunning as couple shirts.

SAP Pricing Procedure

While making the sales order, pricing procedure is depend on the five parameters:
1.Sales Organisation
2.Document Pricing Procedure
3.Distribution Channel
4.Division
5.Customer Pricing Procedure

So that is it.

Long Text for All HR Objects

HRP1000, field STEXT is the description of whatever object you are viewing. It can be a Job, Position, Work Center, Org_Unit, etc.

Maafkan Kami, Indonesia

Kebanggaan menggunakan SAP yang dulu diperjuangkan dengan susah payah hancur sudah. Mudah-mudahan semua ada hikmahnya.

Ambil Delivered Date SA

Copy paste mentah-mentah dari sini. I think we'll definitely need this some day.

You can find the delivered quantity via a function, it is not as easy as reading the confirmed quantity.. I guess function is RV_DELIVERY_SCHEDULE, this checks all subsequent delivery documents etc and returns the quantity in VBEPVB structure ...

Use of function may look like this:

Data:
lT_VBFA type VBFA occurs 0 with header line,
lT_VBUP type VBUP occurs 0 with header line,
lT_VBEP type VBEPVB occurs 0 with header line,
lT_VBAP type VBAPVB occurs 0 with header line,
l_vsmng like vbepvb-vsmng.

SELECT * FROM vbup INTO TABLE lt_vbup
WHERE vbeln EQ vbeln AND
posnr EQ my_posnr.
SELECT * FROM vbfa INTO TABLE l_vbfa
WHERE vbelv EQ vbeln AND
posnv EQ my_posnr.

SELECT * FROM vbep INTO TABLE l_vbep
WHERE vbeln EQ vbeln AND
posnr EQ my_posnr .

SELECT * FROM vbap INTO TABLE l_vbap
WHERE vbeln EQ vbeln AND
posnr EQ my_posnr .

call function 'RV_SCHEDULE_CHECK_DELIVERIES'
exporting
fbeleg = vbeln
fposnr = my_posnr
tables
fvbfa = lt_vbfa
fvbup = lt_vbup
fxvbep = lt_vbep
fvbap = lt_vbap.

loop at lt_vbep where posnr eq my_posnr.

add lt_vbep-vsmng to l_vsmng. " tot.deliv.quan

endloop.