on 07-16-2008 2:36 PM
Hi all,
i would want to check data migration process in FIAA (compare point 1 and point 2)
Point 1 : I have the original excel file which contains master and value data from legacy application.
Point 2 : I have to extract from SAP legacy data migrated, and only legacy data (migration was in may, since this date 2 depreciation run occured).
In my point of view, we can identify master and value data in table ANLA - ANLB - ANLC- ANLZ. But how can i extract only legacy data from these table?
Many thanks for your answer.
You can write a query on Ordinary staart depreciatin start date. In your case if you have went live in SAP on 1st May, all those assets for which the ordinary start depreciation date <01.05.2008 should belong to legcy provided you have the depreciation policy as "Depreciation in the month of Purchase".
If you have depreciation from the next month of purchase, in that case you need to query on 01.06.2008.
Hope I am clear.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
yes you are clear. But i have one question.
In ANLC table (asset value field), i want to identify following fields :
- KANSW: acquisition cost (legacy data, and not additional cost)
- NAFAG : ordinary depreciation posted (legacy data = dep posted from januar to april, and not depreciation posted in may and june).
Do you think this is possible? does these fields (KANSW and NAFAG) contain cumulated value (from begining of the year to date of extract) or individual value (januar, february ...june separately)?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.