FI Documents is not available when displaying material document

When creating Good Issue (MIGO) we get the material document generated by SAP. When I display several material documents, I found that for some GI transactions, there are no FI Documents available. Why?? Well from my observation, FI documents exist only if G/L account value is assigned when creating GI transaction.

MM SAP: extend material to other STORAGE LOCATION within the same PLANT

The only way I know to extend material in SAP is through MM01 t-code, the Create Material t-code. But then I experience problem when I was trying to extend Material to another storage location within the same Plant. There was always an error message generated when I was trying to change some property in the Accounting 1 tab-section.

Error message sounds like this: Accounting 1 cannot be chosen here; if possible, enter the organizational level

I couldn’t figure out how to fix this, but as I search from google, in forum I found that there’s an alternative way to extend material, which is through MMSC t-code. So I try using MMSC to extend material to the desired storage location and it works well.

So, now I have two ways of extending material:

  1. Using MM01, we use this t-code if we want to extend the material to a different Plant.
  2. Using MMSC, we use this t-code if we want to extend the material to same Plant but different Storage Location.

Maybe there’s other ways to extend material. Maybe I’ll find out later if there’s problem which can’t be solved with those two t-codes.

how to make unique records on Excel 2007

This article is basically about:

how to make unique records using excel 2007; or

how to make distinct records using excel 2007; or

how to eliminate duplicate records on excel 2007

The case is, I use an excel file imported from SAP. The file contain duplicate records, meanwhile I need to clean this records so that I can a have a clean, unique records. Since I haven’t been exploring Excel 2007 a lot. I thought that there’s no way we can use Excel feature to do all the work. I almost thought that I have to do that all manually. Oh no, this can’t be good, since there was thousands of records to check.

So, I start to explore excel features, and Voila!! There it was. It was there all along. All I need to do is:

  1. Go to the Data menu (you can find it on top of Excel)
  2. Look for the Remove Duplicates function. It’s on the Data Tools group.
  3. Follow the wizard. Quite simple to understand the instructions on the wizard.

Well, I guess I need to explore Excel more :) . It can be very helpful.

SAP GUI 7.10 installation guide

Previously I’m using SAP GUI 6.40 on my vista operating system. At the beginning, SAP GUI is running fine, all the t-codes I access are displayed correctly. But in time, maybe after 2 days intensively use of this 6.40 version, I started to experience trouble. The SAP GUI collapse whenever I attempted to run certain t-code (i think it’s the t-codes that I quite often access).

So I search through google how to solve this problem. I found in several forums that other users are experiencing the same problem, and recommended to upgrade to SAP GUI version 7.10 which is dedicated for windows vista. They also told me to download the latest patch for version 7.10 as well.

So, as they said, I downloaded SAP GUI 7.10 from SAPs’ ftp server along with the patch provided, while I’m writing this, the latest patch is patch level 8.

Here are the step by step installation of SAP GUI 7.10:

  1. If you don’t have .NET framework installed on your computer. Please install the .NET framework version 2.0 or the latest release. (I use the .NET framework 3.5)
  2. Extract the SAP GUI 7.10 zip file on one folder (you can name it whatever you want, example: SAPGUI-710) under the directory C:\Program Files\Windows. If you don’t extract the installer on the previously specified location, you will receive an error message saying: Failed to open/parse setup script. Please check if the script file ’setup/NwSapSetup.xsc’ exists. Though you check that the file referred by the error message is actually exist on folder setup.
  3. Then the installation wizard interface will come out. Next all you need to do is follow the installation wizard, it’s pretty easy to follow, you simply just click next.
  4. When you finish installing SAP GUI 7.10, now it’s time to execute the patch.
  5. Unzip the patch wherever you want.
  6. Run the executable patch file.

Finally, you will now have the SAP GUI 7.10 on your computer. I have test this new version several times, and now the SAP GUI doesn’t collapse even though I access a t-codes for many times. I think it runs normally now :)

oracle: record inserted via sqldevelopers’ query executor is missing

I experience this problem while i was working with sqldeveloper (which downloaded from oracle homepage). I connect to a database, execute some “insert query” (insert into TABLE values……), then sqldeveloper said that all the records are successfully inserted. I check back to the table, refresh the table, and i saw that the records I previously inserted are there. So I assume everything is okay. I close the sqldeveloper (i don’t remember whether I disconnected from the database before I close the sqldeveloper, or not).

As i mentioned on the title, the next time I open the table via the same sqldeveloper, the previous inserted records are gone. I don’t know, maybe it’s because i was using the query executer. But here’s what I do to solve the missing records inserted via sql developers’ query executer:

  1. Input query via sqldevelopers’ query executer.
  2. Check the table to make sure the records are successfully inserted.
  3. If so, then I disconnect from the database.
  4. Then reconnect again to the database or exit the sqldeveloper.

It seems to be that the sqldeveloper commit to the database when it’s disconnected from the database. I assume, when the records are claimed to be successfully inserted, sqldeveloper only commit it locally, not directly to the database. So when I close sqldeveloper without disconnecting from database, the records was not yet committed to the actual database.

Well, i don’t know if it’s true, but it sure solve my problem :)

activate the oracle environment on xampp for windows

The first time we install xampp for windows, by default, the only active database connection is MySQL. Therefore, if user wants to activate connection to oracle database, user needs to set it up first. How to activate/set up oracle database connection in xampp for windows? Here are some things i did to successfully activate oracle connection:

  1. To check whether your oracle setting has been activated or not, go to phpinfo, look for string oci8. If string found it indicate that connection to oracle is available, otherwise to activate connection do the following steps:
  2. Open all php.ini files in xampp folder (or you can open only the currently used php.ini file by looking at the phpinfo), then make the following necessary changes:
  3. Find string extension=php_oci8.dll. You’ll find there’s a semicolon ‘;‘ ahead of the string.
  4. Remove the semicolon to activate the oracle extension.
  5. Save the php.ini file.
  6. Install oracle client. Simply just install it on your computer, there is no settings required. You can download it from this oracle site.
  7. Activate or restart xampp.
  8. To make sure that connection to oracle database has successfully activated, go to phpinfo. Find string: oci8. If founded, then now xampp can communicate with oracle database.

Works for me :)

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!