Bears for sale

Legacy Alpha Reviews

Music of Cosmos: Selections from the Score of the Television Series Cosmos by Carl Sagan $29.98 …

Street Fighter Alpha – Generations $6.74 Action-packed prequel to “Street Fighter Alpha: The Movie” follows tough Ryu as he returns to his home in order to pay tribute to his slain mentor. While honing his fighting skills, he attempts to distance himself from the evil that lies within himself. But when he is forced to confront his nemesis, Ryu learns the true ability of his powers. 45 min. Soundtracks: Japanese Dolby Digital 5.1, English…

Legacy Of Blood $3.66 LEGACY OF BLOOD (AKA BLOOD LEGACY) – DVD Movie…

Yellowstone Wolves: Territoriality & Clan Behavior $29.99 The Druid clan, so-named by scientific researchers, had been one of the largest and most powerful packs ever studied. When their dominant alpha leaders are killed, their reign over Yellowstone National Park’s spectacular Lamar Valley comes to a sudden end. But a lone male, who has been courting some of the female juveniles, joins the defeated remnant of the Druids and helps them battle to recover …

Slow down brake for DABSII brake for Legacy, Symphony, Maxi+ and Alpha Slow down brake for DABSII brake for Legacy, Symphony, Maxi+ and AlphaSlow down brake system for Dolomite Maxi +, Symphony and Alpha model walkers to help user control speed downhill or compensate for weak side to keep walker running in a straight line through individual tension control knob settings for each wheel. Slow down brake works independent from regular braking system. Product photo may n…

Lexar SDHC 16 GB Class 4 Flash Memory Card LSD16GASBNA $10.10 This Lexar Professional 16GB SDHC Digital Flash Memory Card is for you to expand the memory capacity for your compatible device like digital camera, camcorders, music players, and more devices that is with a SD card slot available.It is ideal for storing media-rich files such as music, videos, and photographs. FEATURES: High storage capacity for storing essential digital contents such as high qu…

10.2 Legacy Notebook Sleeve $22.32 WENGER LEGACY 14.1 COMPUTERSLEEVE BLACK…

Digital to Analog Audio Transformed Effortlessly and Simply $126.25 GEFEN TV DIGITAL TO ANALOGDECODER ANALOG DECODERConverts S/PDIF or TOSLINK digital audio to L/R analog audioDigital interpolation filter and digital to analog converterSupports up to 6 channels of audio encoded in Dolby DigitalAuto samples at frequencies of 32KHz, 44KHz and 48KHz24-bit incoming bitstream on left and right channelsAllows listening to digital audio sources on legacy analog sound sys…

Wenger 16 Legacy Checkpoint-Friendly Computer Case $59.99 Wenger 16 Legacy Checkpoint-Friendly Computer Case…

Learning Resources – Quantum Big Screen Microscope $37.99 This big seven-inch screen microscope projects a whopping 10x, 20x, or 40x clear image. Includes assortment of accessories, glare-reducing shield and Snap-Tight tray to hold components. Operates with three “C” batteries (not included) or AC adapter (sold separately)….

SAP Data Migration – Migrating Fixed Assets

1      Overview

1.1    Introduction

This document is intended as a user guide in how overcome the common problems in migrating fixed assets into SAP.

For a one-time conversion into SAP, we favour using the LSMW tool. It allows you to leverage the full power of ABAP while using standard SAP processing functions, yet it does a lot of the file management and processing work automatically. However, even within LSMW there are a number of possible methods for migrating fixed assets.

This document will discuss loading fixed assets using the standard load program RAALTD01, although two alternatives are briefly discussed below.

1.2    Load methods

1.2.1    BDC recording of transaction AS91

This is the simplest solution and so it might be suitable for a very basic upload. If for example you are not creating fixed assets in SAP, but rather updating one field in fixed assets which already exist in the system, then this might be the right approach. But it is not flexible enough to be used for the creation of fixed asset data.

1.2.2    Business object BUS1022

This would create IDOCs of type FIXEDASSET_CREATEINCLVALUES01 and process them through the SAP BAPI function BAPI_FIXEDASSET_OVRTAKE_CREATE.

This is possibly the solution that SAP would recommend. SAP is keen on BAPIs as they are powerful, flexible and can be easily called from an external system via an RFC. But that does not necessarily make them the right choice for data migration. The structure of BAPIs is not always particularly intuitive and the upfront development work can be complicated.

Also this method involves the processing of IDOCs. While the standard error handling and reprocessing functionality for IDOCs in SAP is impressive, it is not always transparent. Migrating fixed assets using this method would be suitable for someone who is particularly strong in the area of BAPIs and IDOCs..

1.2.3    Standard load program RAALTD01

This is generally the approach I would favour for the migration of fixed assets into SAP.

The standard load program is not perfect. As discussed later, there are one or two areas which it does not cover and like many SAP standard programs, it has its quirks: for example, when you come to load the assets, you do not have the option to create a BDC session yet if any of the transaction calls fail, then the program will create a BDC session for those records.

Nevertheless, it is a powerful and flexible program, and it is relatively simple to use. The fact that you can run the asset load in test mode before creating any data is also a major advantage, even though the test run does not always pick up 100% of the errors.

1.3    Assumptions

This document assumes a working knowledge of LSMW, and at least some basic understanding of the structure of fixed assets data in SAP.

2      The Basics

2.1    Data structures

There are two data structures in the asset load program RAALTD01 – BALTD and BALTB.

2.1.1    BALTD

This structure is mandatory and contains all the basic fixed asset master data.

2.1.2    BALTB

This structure is for what are known as asset transactions. The two common scenarios in which this structure needs to be populated are:

a) An asset was capitalised after the start of the current financial year (the current financial year being the year in which you are going to migrate these assets into SAP), or

b) An asset was disposed of in the current financial year

2.2    Important fields

Key fields:

Asset number
Asset subnumber
Company code
Asset class
Legacy asset main number
Legacy asset sub number
SAP transaction
Record type

Master Data:

Capitalisation date
Description
Additional description
Location
Plant
Cost centre
Vendor
Inventory number
Vendor name
Original Vendor Number

Depreciation Data (multiple records per asset):

Depreciation area
Planned useful life (years)
Planned useful life (months)
Depreciation key
Depreciation start date
Gross book value
Accumulated depreciation
Ord dep posted

Transactions:

Number of transactions
Company code
Asset class
Legacy asset main number
Legacy asset sub number
SAP transaction
Transaction date
Record type
Transaction type
Amount

2.3    Modifying the standard asset structure

It is possible (and sanctioned by SAP) to modify SAP structures BALTD and BALTB. You only need to modify BALTB if you have added extra depreciation areas to BALTD.

You will of course need an object key to do so, but as long as the fields you are adding are active in transactions AS91, AS92, etc, then this is the only change you will need to make. RAALTD01 will do the rest.

Common reasons for modifying BALTD might be to remove to increase the number of investment keys (default setting is 2) or the number of depreciation areas (default setting is 8). See more on the depreciation areas below.

There is more information in SAP OSS note 23716.

3      Common Problems

3.1    Alpha conversion

As RAALTD01 is very closely linked with the direct upload program RAALTD11, it retains some of the features of a direct upload program. One of these is that it checks during upload whether key data referenced in the asset exists in SAP. It does this without making any alpha conversion.

So, if you are creating an asset with asset class (field ANLKL) ‘100’, you must specify this in the LSMW mapping in its internal SAP format, ie. ‘00000100’. The same goes for cost centres, vendors, etc.

3.2    Legacy asset number

It is crucial when migrating data into SAP to store a reference to the legacy data key.

It is important for business reasons – so that a user can easily see the link between their old data and the new – but it is also important for technical reasons. This is obvious for certain objects like vendors and customers where you need to store the link in order to be able to migrate follow-on transactional data like AR and AP. But it is also useful for assets.

It is very helpful in the test stages of a data migration to be able to run and rerun your load program without fear of loading duplicate information. By storing the legacy asset number somewhere in the asset master, you can easily check with some ABAP code in your LSMW whether this legacy asset has already been created in table ANLA.

The most common field for storing the legacy number is AIBN1 (Original Asset Number) but do not put your legacy number here without checking. This field was intended to be used for the original asset number in SAP after an it has been transferred to a new number.

If using AIBN1 is going to be a problem, another option is ANLH-ANLHTXT. This is a text field which is often unused.

One red herring in the load program is OLDN1 (Old asset number). This field exists in the load structures but not in the database tables. It is only used in the processing of the load program. See further information on this field below in ‘Other quirks’.

If you find that AIBN1 and ANLHTXT are not appearing in the AS91 screens, you can change the screen layouts in customising:

Financial Accounting > Asset Accounting > Master Data > Screen Layout > Define Screen Layout for Asset Master Data

3.3    Missing customising

Before running your test and live asset migrations, please check that the following customising is in place. For some reason, these steps are often overlooked by the FI-CO functional consultants:

Transfer date – this should be set to close to the date you migrate the assets. As AS91 is specifically for data migration, it expects that the capitalisation date for all the assets you migrate will be before the transfer date. Check this in table T093C.

Current fiscal year – also in T093C, check that this has been correctly set.

Number ranges – transaction SNUM.

3.4    NBV – Net book value

It is not possible to directly migrate the net book value of an asset. You must migrate the gross book value (acquisition cost) and the accumulated depreciation. SAP will then calculate the NBV.

3.5    Time-dependent data

Some of the asset data is time-dependend, ie. you can see the history of these fields. Example fields are cost centre, plant, internal order, location and business area. They are all stored in table ANLZ. The standard SAP load programs can only handle the current values of these fields. You cannot migrate multiple ANLZ records per asset.

If you need to do this, you should first create your assets using RAALTD01 and load the initial values of these fields. Then create another LSMW program using an AS92 recording to upload any changes.

3.6    Mid-year asset migration

In their financial statements, companies must disclose the following:

• Depreciation methods used,
• Depreciation methods used and/or the useful economic lives
• Deprecation charged in the current fiscal year
• Gross amount of depreciable assets and the related total accumulated depreciation

As a result, if you are migrating assets midway through a fiscal year you have to split the depreciation to date into two amounts: depreciation up to the end of the previous fiscal year, and depreciation during the current fiscal year.

One way of doing this is in your LSMW code: in the Takeover Values screen, enter the depreciation amount up to the end of the previous year into the field Accumulated Depreciation (BALTD-KNAFAnn) and the amount of depreciation in the current year into the field Ordinary Depreciation Posted (BALTD-NAFAGnn). This is generally the most popular method.

The second way is to transfer the assets as at the end of the previous fiscal year and then run depreciation in SAP for all months in the current year. This involves more work for the functional consultants.

3.7    Assets created in this year

You also have to distinguish in SAP between assets created in previous years and assets created in the current year. Your capitalisation in the current year needs to be identified as a transaction.

In this situation you will need to post both a BALTD record and a BALTB record.

Your posting will differ from the standard asset creation in the following ways:

• BALTD-BWCNT needs to be populated with ‘0001’ (assuming you are only posting one transaction)
• You need to map the acquisition value into BALTB-ANBTRnn with transaction type ‘100’ instead of mapping it as normal to BALTD-KANSWnn
• BALTD-KNAFAnn does not need to be populated
• BALTD-NAFAGnn should be populated with the depreciation amount
• BALTB-BZDAT should be populated with the capitalisation date

3.8    Asset disposals

Disposals in the current fiscal year must also be identified as transactions.

In this situation you will need to post both a BALTD record and a BALTB record.

Your posting will differ from the standard asset creation in the following ways:

• BALTD-BWCNT needs to be populated with ‘0001’ (assuming you are only posting one transaction)
• You need to map the disposal value into BALTB-ANBTRnn with transaction type ‘200’
• BALTB-BZDAT should be populated with the date of disposal

3.9    Depreciation areas

When creating fixed assets in SAP you will often populate multiple depreciation areas. Common depreciation areas set up in SAP might be Local Depreciation, Group Depreciation (if your company is international) and Tax. The depreciation rules for each of these might be slightly different, therefore you will create one depreciation area for each.

Rarely, you might need more than the 8 depreciation areas provided as a default by SAP in structure BALTD and BALTB. I have only ever experienced this once while loading fixed assets in Italy. It was necessary due to the multiple currency devaluations that the Italian lira had undergone over the past thirty years or so.

This can be handled by modifying the standard structures BALTD and BALTB. See information on this above in the section ‘Modifying the standard asset structure’.

3.10Other quirks

3.10.1 Invalid characters

You may not put the hash character # in any of the BALTB or BALTD fields.

3.10.2 Long texts

The standard upload program does not handle long texts. These would need to be loaded in a separate program. But this situation occurs rarely.

3.10.3 ‘Unexpected record type found’

This error occurs if you enter the wrong record type in the two RCTYP fields. It should be ‘A’ in BALTD and ‘B’ in BALTB.

However, it you are sure that you do not have this problem and you are still getting the error, check that all of the master data you have referenced exists. For example, are all of your cost centre numbers valid. I have had this error in the past when migrating assets with transactions. The ‘real’ error of invalid data in your BALTD record is not given by SAP. It gives this error instead.

The conclusion: always validate your master data fields in LSMW when loading fixed assets. A set of user routines such as CHECK_KOSTL, CHECK_WERKS, CHECK_LIFNR, etc, can save you a lot of time.

3.10.4 Audit and Error report

The error reporting is dreadful in RAALTD01 if you do not populate the field BALTD-OLDN1. If you do not populate this field, the program will list any errors you have with the asset description only, which is not particularly helpful. So, always populate OLDN1 even if you are not migrating transactions.

4      Footnote

This guide should be viewed as a starting point for discussions and is not intended as an exhaustive examination of the various methods available. There will inevitably be circumstances specific to individual situations that cannot be covered here.

You can find more Harlex Guides on our website: http://www.harlex-ltd.com/downloads.html

For further information on the migration of fixed assets into SAP or indeed on any data conversion topic, please contact Harlex Consulting Services Ltd at:

info@harlex-ltd.com

Suggestions For My Legacy Elf Deck?

// Deck file for Magic Workstation (http://www.magicworkstation.com)

Not sure it’s really fast enoug for Legacy, but one really nice new elf is Joraga Warcaller:

1G 1Colorless 1/1 Elf
Multikicker: 1G 1Colorless

When Joraga Warcaller enters the battlefield, it gains a +1/+1 counter for each time it was kicked.

All other elf creatures you control gain +1/+1 for each +1/+1 counter on Joraga Warcaller

Boyd’s Bear Father Time Omega T. Legacy & Alpha COMPLETE! $24.99

Boyds Bear Omega T. Legacy & Alpha Limited Edition Set 16″ $39.95

BOYDS OMEGA T. LEGACY & ALPHA (MILLENNIUM) $19.99

Boyd’s Bears Omega T. Legacy and Alpha The Archive Collection With Tags $9.99

Boyds Omega T. Legacy Millenium edition 1999 No Alpha $45.99

Boyds LEGACY and ALPHA Millenium BEARS 2000 Father Time & Baby New Year w/stand $12.99

BOYDS BEARS OMEGA T. LEGACY AND ALPHA, MILLENNIUM $69.99

OVERSIZED BOYDS BEAR OMEGA T. LEGACY AND ALPHA 1999 $45.00

Boyd’s Bears Plush LE~OMEGA T. LEGACY & ALPHA~New Year~ $64.99