Re-posting an old joke

It's going to be a difficult period for global citizens. Most of us have never experienced any crisis like this before. It is even more suffering that 2008 economics crisis, everyone says this is gonna be another 1930's recession. However, I still have strong belief that everything will be fine. It just slows down your …

Demo Profit center valuation – Material cost estimate

So in this post, I will demo setting for material cost estimate with profit center valuation. In this demo, plant Z010 and Z011 belong to a company code. Z011 provide material 20 to plant Z010. Group cost of this material is fixed as $1. Profit center transfer pricing is calculated by Base costing(in this example, …

Preparing test environment for Financial Accounting – Copying Chart of Account

After copying company code in Enterprise Structure, there may be a need to reassign chart of account data for the copied company code. Follow steps below to get it done. OBR2 - Delete GL Master data if any If GL master was copied during copying company code, it is required to delete all those master …

Delete Controlling Area/Company code for testing purpose

Common error messages and resolution: Error: Deletion not possible (master data). Message no: KT304 -> KA24 – Delete Cost elements Deletion not possible (master data). Message no: KT304 ->OBR2 – Reset master data Groups still exist in controlling area xxx. Message no: KT307 You want to delete controlling area Z001, although groups still exist: 0101Z001Z001 …

Resolve error message: Pricing/euro: Attention: Euro Customizing not maintained

Pricing/euro: Attention: Euro Customizing not maintained Message no. VH777 Diagnosis The EURO currency table (EWUCURRS) could not be set up. Cause There is no entry in table EWUKEYS. In pricing, a list of the EMU currencies is required to ensure correct translation in all cases - irrespective of whether you explicitly use those currencies. Remark …

974504 – Inconsistencies in link tables of master data sync.

Master data of BP has been deleted. Vendor/Customer remains. To resolve this issue, follow below steps. ZVENDOR_LINK_CHECK_REPORT (execute by SE38)    After running, create new BP (only General data – BP role 0000000) Mapping newly created BP with Existing Vendor/customer master Transaction code: FLBPC2  Now you can see vendor again in BP transaction.

Notes Transfer Documents from Financial Accounting

Notes Transfer Documents from Financial Accounting When you first go live with new EC-CS module, there may be need to subsequently transfer posted document into EC-CS. At this step, I got the error message like this: Account xxx (chart xxx) cannot be mapped to cons chart RS Message no. G3104 Diagnosis No group account, which …

Do not use Notepad++ for LSMW

Notepad++ is my favourite text editor. I have some advance function in text highlighting, show additional character, search and replace by regex pattern, etc… However, I have bad experience with Notepad++ when using it for data migration in SAP, especially when working with Unicode texts. Sample below show different output with same manipulation on default …

Tải tài liệu miễn phí từ sciencedirect.com

 Như các bạn đã biết sciencedirect.com là trang web cung cấp các bài viết học thuật với cơ sở dữ liệu vô cùng lớn. Tuy nhiên phí tải tài liệu hơi mắc so với người VN. Đợt rồi mình cần tìm một số bài viết trên trang này nên đã tìm hiểu cách tải tài …

Powershell script to open excel file; calculate formulas and save file as csv into a folder

When working with BW data, there is 1 interface that extracts data by an Excel plugin and save it into folder. PI will pickup the file and upload to BW. The extraction is supposed to run once a month. The file name has fixed part and dynamic part with year and month. Formulas in each …