When I put a material in project structure, the cost is automatically included as a cost planning for the project. Cost of the material is taken from the material master. There’s a way if you want to exclude material cost in project cost planning. Just click the material from the Project Builder: CJ20N, and then on the material general data, un-check the Cost Rel
Eliminate Material Cost in Project Cost Planning
Create Project Structure and Prepare Fund Center
1. CJ20N, first we create only the Project Definition & complete WBS Structures
2. FM2I, then funds center needs to be created for the project
3. CJSG, to make it easier to assign fund center to WBS elements, create WBS Element group
4. FRC7, then assign fund center to WBS Elements/WBS Element group
5. FM9K, change the budget structure, (in my case, the timeframe should be chose from the selection provided), and “Group assignments” should be checked
5. FMG5, here we generate the new object
——-done with the fund center assignment——-
Create Cost & Revenue Planning
Cost planning has different level of detail depending on the status of the project. Usually on the Business Plan phase the cost planning is less detail than the execution phase. So cost planning can be done in WBS elements level or until activity level, if the structure is already detailed until activity level.
1. CJ40, to create WBS cost planning, can only be planned on planning element WBS.
2. CJ42, to create revenue planning, can only applied on billing element WBS.
3. CJ20N, to create activity cost planning, ex: in activity cost, define the amount and cost element (if you make external service activity, or add some material component, the cost will also automatically added as cost planning)
—–done with the cost&revenue planning—-
Create Budget
This is when we want to take the cost&revenue planning as project budget.
1. CJ9FS, use the operative (0) as the source and choose FM as the target. The output is budget created in CO module.
Then if you want to use the “lock budget” feature then the budget should be uploaded to FM module, using this:
2. FM9C, source is FM and the target is “0″ (the operative version in Funds Management module), tick the Payment Budget checkbox
1. KA06 -> to create secondary cost element to pool the work center costs.
2. KL01 -> create activity type, this is to connect work center data to secondary cost element that created previously.
3. KP26 (mine using layout 1-201C), here we set the rate for the work center/activity type and the cost center as cost allocation for activity type.
4. CNR1, here we create the work center and link it to the activity type from the “Costing” tab, here the cost center should be filled with the one defined in the activity type (KP26) or else it will generates an error message
Customizing Related to work center:
1. OP17 –> this is the Parameters definitions
2.OP21 –> this is to define the formula
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.
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:
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.
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:
Well, I guess I need to explore Excel more 
. It can be very helpful.
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:
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
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:
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
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:
Works for me
Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!
