 |
 Long Range 125 Mile SUPER BOOSTER HDTV TV Antenna  US $39.99
|
 NEW Outdoor HD Digital TV Antenna for Camping RV Boat US $39.99
|
 150 MILE HDTV AMPLIFIED INDOOR OUTDOOR MOTOR TV ANTENNA US $39.99
|
 NEW Digital TV SUPER BOOSTER HDTV HD Outdoor Antenna US $48.88
|
 ATTIC DIGITAL TV ANTENNA FOR DTV CONVERTER BOX w ROTOR US $48.88
|
 DIRECTV 18 Portable Satellite Tripod Camping RV NEW US $69.99
|
 DISH Network 500 Portable Satellite Tripod Camping RV US $98.99
|
 Channel Master HDTV UHF Indoor TV Antenna New US $20.00
|
 CHANNEL MASTER 7777 TITAN ANTENNA AMPLIFIER DTV HD ANA US $69.95
|
 Channel Master 3010 HDTV Outdoor Antenna VHF UHF FM US $35.49
|
 Channel Master 3000A SMARTenna Omni Directional NEW US $68.95
|
 Channel Master Indoor Antenna 4010 UHF VHF FM NEW US $26.99
|
 Channel Master 4221HD UltratennaTM HDTV UHF Antenna US $35.99
|
 Channel Master CM7778 Signal Amplifier US $59.99
|
 PCT International 9521 Channel Master Antenna Rotor Remote Control System US $92.99
|
 VINTAGE NEW IN BOX CHANNEL MASTER ANTENNA FM TURNSTILE Model 4403 W Mast Mount US $99.99
|
 Channel Master 4248 HDTV Antenna US $24.95
|
 Channel Master HD 9515A Antenna Rotator w Controller US $99.99
|
 CHANNEL MASTER 7778 MEDIUM ANTENNA AMPLIFIER DTV HD ANA US $65.95
|
 Channel Master Digital Indoor TV Antenna UHF HD Open Box Model CM 4040 US $14.99
|
 Channel Master CM 2018 Television Antenna US $54.99
|
 STARCHOICE SHAW DIRECT NEW ELLIPTICAL SATELLITE DISH w XKU LNB US $78.30
|
 Channel Master 4221HD 4 bay HDTV UHF Antenna US $50.84
|
 Channel Master CM 3078 Clamp Mount US $8.99
|
 Winegard CC 7870 All Channel Coupler US $29.05
|
 23298 VIDEO CONVERTER ULTRA PROGRADE RF MODULATOR US $25.56
|
 Channel Master 3020 Deep Fringe Range HDTV Antenna NEW US $72.95
|
 Channel Master 0068DSB UHF VHF Spartan 3 Preamp NEW US $56.95
|
 HD7015 VHF UHF FM Antenna Digital Ready US $71.17
|
 HD7695P Outdoor High Definition VHF UHF Antenna US $101.54
|
 1 Port Digital Signal Booster TV Antenna Cable Internet Amplifier PCTMAB10151A US $29.99
|
 Channel Master 7778 UHF VHF Pre Amplifier NEW US $54.95
|
 RCA CRF907 Compact RF Modulator US $14.95
|
 EIGHT 8 CHANNEL MASTER 4 WALL MOUNT MODEL 3079 NEW US $34.92
|
 Channel Master 4221HD UHF 4 Bay HD TV ULTRAtenna NEW US $39.95
|
 Channel Master 4221HD UHF HD Antenna Off Air TV US $43.98
|
 Channel Master CM0068DSB Outdoor Pre Amplifier US $59.99
|
 Channel Master 4228HD UHF 8 Bay HDTV Antenna NEW US $77.95
|
 Channel Master 4228 HD UHF 8 Bay HDTV Antenna NEW US $77.95
|
 Channel Master 4220MHD UHF HDTV Outdoor Antenna US $59.99
|
 WINEGARD HD8200U HDTV Antenna Deep Fringe US $175.47
|
 Antenna Winegard CC 3190 US $19.00
|
 Channel Master 4221 CM 4221HD UHF HD Antenna Off Air TV US $41.32
|
 AR 500 Digiwave Programmable Antenna and Satellite Rotor New AR500 US $106.68
|
 nte tb 105 US $34.00
|
 CHANNEL MASTER TELSTAR 0027 ANTENNA AMPLIFIER with FM TRAP US $12.99
|
 CHANNEL MASTER 4228HD 8 BAY BOWTIE ANTENNA US $92.95
|
 Channel Master 1M Reflector Dish Feed Legs Stand NEW US $465.96
|
 |
Channel Master CM 7777 TITAN2 UHF/VHF PREAMPLIFIER CM7777 List Price: $83.99 Sale Price: $52.25  |
|
The Channel Master CM 7777 is a high gain, low noise preamplifier used for weak signal areas to allow a weak signal that is present at the antenna to be amplified to a viewable strength. This TV antenna preamplifier works best for persons in weak signal areas and is subject to overdrive if used in areas with fairly strong signals... |
 |
Channel Master CM 4228 8-bay HDTV/UHF Antenna CM4228HD List Price: $89.99 Sale Price: $85.99 |
|
Channel Master's 4228HD antenna can receive digital and analog over-the-air TV signals in the UHF band and high VHF band. The 4228HD is optimized for "deep-fringe" reception of HDTV and receives digital and analog UHF and high-band VHF TV signals; range is 60 miles for UHF (ch... |
 |
Channel Master CM7400 1080p Internet Compatible HDTV DVR List Price: $399.99 Sale Price: $398.00 |
|
Channel Master Internet compatible subscription free HDTV DVR. RJ-45 Ethernet/ USB 2.0/HDMI/eSATA/ Digital audio (optical)/ RF output/ RF antenna/cable input/RCA component andcomposite video Stereo audio |
 |
PCT International Channel Master CM-3418 Signal Splitter List Price: $55.99 Sale Price: $44.96 |
|
Channel Master distribution amps boost your digital TV and HDTV signals, increasing their overall signal strength. Our distribution amplifiers are commercial grade and meet stringent US and international standards, including SCTE... |
 |
PCT International CM2016 Channel Master Television Antenna List Price: $44.99 Sale Price: $26.40 |
|
The Channel Master 2016 is a compact outdoor TV antenna that is engineered to receive high-quality digital/HDTV broadcasts over channels 7 to 51. Tune into your favorite broadcast high-definition channels without any monthly fees. |
![BlueRigger High Speed HDMI Cable with Ethernet 6.6 Feet (2m) - Supports 3D and Audio Return [Latest Version]](http://www.thelcdtvzone.com/images/i/31RL9rlYTnL._SL160_.jpg) |
BlueRigger High Speed HDMI Cable with Ethernet 6.6 Feet (2m) - Supports 3D and Audio Return [Latest Version] Sale Price: $1.99 Used From: $3.00 |
|
BlueRigger High Speed HDMI Cables are premium quality cables that help you extract the maximum performance from your gaming or home theater setup. Rugged Build BlueRigger cables are completely certified to support advanced HDMI features such as 3D, Ethernet and Audio Return - The cable is made of a PVC outer layer that protects from physical strain, external interference & maintains efficiency of the digital signal - It has gold plated connectors that help resist corrosion - These cables are ATC (Authorized Testing Center) certified to support all resolutions up to 1440p Quality Picture and Sound - HDMI cable supports 3D content, Ethernet and Audio Return Channel - Guaranteed 4K, 1440p, 1080p, 1080i, 720p, 480p, and 480i Resolutions - Supports Refresh Rates of up to 240hz and 48-Bit Deep Color - Supports Transfer Rates of Up to 340Mhz or 10... |
 |
PCT International CM3020 Channel Master 3020 Outdoor Television Antenna List Price: $139.99 Sale Price: $92.72 |
|
Channel Master 3020 Outdoor Television Antenna which will allow you to receive UHF, VHF, FM and HD signals. This antenna has a signal range of 100 miles and will pick up available local channels 2 through 69... |
 |
Channel Master 3414 4 Outputs Distribution Amplifier List Price: $39.99 Sale Price: $31.99 |
|
Channel Master distribution amps boost your digital TV and HDTV signals, increasing their overall signal strength. Our distribution amplifiers are commercial grade and meet stringent US and international standards, including SCTE... |
 |
PCT International CM2020 Channel Master CM-2020 Digital Advantage HDTV Antenna List Price: $99.99 Sale Price: $58.12 |
|
Channel Master 2020 DIGITAL ADVANTAGE (HDTV / VHF / UHF) Outdoor Antenna. Turning Radius 69.5" 41 Elements |
 |
Channel Master 3079 Antenna Mount Kit - 2 Pack List Price: $19.99 Sale Price: $3.80 |
|
Mounting hardware included * warranty: 90 days * |
|
|
PylePro 2-channel USB/ iPod DJ Mixer $79.99 3-band EQ, Gain, and Volume control per channelMaster level controlMicrophone input with Gain, Tone control |
Channel Master
SAP Data Migration - Migrating Customer Master into SAP
1 Overview
1.1 Introduction
Along with vendors and materials, the customer master is one of the key master data objects to be loaded as part of a SAP migration.
The customer data will be very important to your client’s business and, as a result, you need to make sure that you get the data correct in this area. This white paper will look at some of the different aspects of the customer master and some of the main issues that arise when trying to migrate data into an SAP system.
1.2 Assumptions
The best approach to loading customer master into SAP is via LSMW using either the standard load program RFBIDE00 or the customer master IDOC or BAPI.
2 Discussion Points
2.1 Address Data
One of the main attributes of the customer is the address data. This is important for delivering goods to the correct place, billing the correct company, etc.
As part of migration, the address data is often found to be inconsistent in the legacy system through years of maintenance by different users. A migration is a good time to review and improve such data. This is known as “data cleansing”. It is normally best practice for the cleansing to occur in the legacy database prior to the migration so that the migration is a clean and transparent as possible. Examples of inconsistencies might be:
- The Address city may be “Kiev” in some addresses, in others, “Kv”
- Some telephone numbers may have brackets around the area code, others may not
- Some addresses may be missing a postal code which isn’t mandatory in the legacy system but which may be in SAP
As data cleansing often involves heavy user interaction, it’s often beneficial to look at ways in which the migration team can help, eg. using an ABAP routine within the LSMW to format the telephone numbers correctly.
Another option might be to use a middleware system such as DataStage or Informatica, but this will be discussed in a separate paper.
The best method for loading customer master data is by using the LSMW tool with the standard program RFBIDE00 which creates a BDC session to be processed. Some extended address data (held in table ADRC) is not found in the standard structures for this program but this is easily solved by creating a simple recording which can populate up the missing fields.
Another LSMW option is to use the BAPI which creates customer master IDOCs in the DEBMAS structure. This option is also flexible and benefits from being based on SAP standard programs, but the IDOC processing is less transparent than the BDC and it is rather slow when processing large volumes of data.
Also note that even though many of the address fields for customer master are length 40 (or more in later versions) you should not use more than 35 as many SAP standard programs only look at the first 35.
2.2 Legacy Customer Number
Often when migrating customer master from a legacy system to SAP, there will be an legacy customer ID. In a simple migration you may be able to bring this legacy number into SAP as the main SAP number (KNA1-KUNNR) but this is often not possible due to number range clashes, or not desirable as it will not fit into the range determined for future customers.
In this case it is customary to store the old number in another field on the customer master for the following reasons:
- The users may like to have the security of knowing that the legacy ID is not completely erased. They can search for their customers based on their legacy IDs while they get used to the new system.
- It is useful to have the legacy number stored as part of an initial load of customers so that when subsequent update loads take place (e.g. adding extra data using a recording or updating the partner functions), these update programs will have a way of identifying the SAP customers.
- Apart from update loads, there are also other dependent objects such as pricing conditions, sales orders and open AR items where your source file will normally reference the old legacy IDs.
SAP has provided a field called “Previous Account Number” (KNB1-ALTKN) stored at the company code level. This is where you would commonly store the legacy number. This works even on multi-country projects where the same customer may exist in different legacy systems, because the field is at company code level. If it is not sufficient due to multiple legacy customers in the same company code pointing to one customer, you may need to consider other options such create a custom table or using multi-value characteristics in customer classification.
The person responsible for building the LSMW load program should also create a routine which enables other loads to find the new SAP customer for a given ID by interrogating the chosen field.
2.3 Partner Types
Be aware of the SD configuration surrounding customers, specifically the Account Group settings. How many Account Groups are to be configured in the new system and how many account groups need to be loaded as part of the migration? The fewer the better for load simplicity. A sold to party will have one Account Group, a ship to party will have another account group. The customer master screens can be configured differently depending on the account group. For instance a bill to party customer will not have a sales organisation screen and a ship to will not have any finance data. You need to cater for these differences in your LSMW field population.
Sometimes, it is possible to simplify the process. For example, it is possible to create all the customers with one account group – Sold To and when it comes to loading the sales orders, if the delivery address is different from the sold to address then you can reflect that difference in the delivery address of the sales order.
If you are loading partner relationships, this is normally done in a second step after the creation of the main data. You may need to work some partners into your initial load if they have been configured as mandatory.
2.4 Multiple Company Codes and Sales Areas
A simple migration will contain just one company code and one sales area per customer. But sometimes (especially in multi-country rollouts), there are multiple company codes and sales organisations. If this is the case, then best practice will involve careful examination of the source structure. Data normalisation dictates that it is best in this situation to separate input files depending on the data. So you would have one file for the basic data (KNA1), one file for the company code data (KNB1) and one for the sales organisation data (KNVV). For example:
2.4.1 Basic File
ID Name Street City Country
FR12 Acme Ltd 9 Roman Road London UK
2.4.2 Company Code File
ID Company Code Account Assignment Group Sort Key
FR12 GB01 A1 001
FR12 GB02 A5 005
2.4.3 Sales Organisation File
ID Sales Org Dist Channel Division Sales Office
FR12 GBX7 01 01 AB1
FR12 GBX6 01 01 AC3
You would assign these files to the different segments in the target structures of the standard program input within the LSMW. Note that the Sales Area could be further broken down in more complex projects so that there are multiple distribution channels and divisions per sales org, in which case this file structure would still hold.
Also, remember that one feature of a normalised system such as SAP is that customer-dependent data will pull through information from the customer master. Many of the fields on the customer master are shared with the sales order object for instance. So when a user is creating a sales order manually then they don’t have to type a lot of the information each time; they type in the customer and that brings in a whole wealth of information into the order automatically. (This is the same with materials and vendors, e.g. purchase orders and goods movement documents). Bear this in mind when mapping data. It may be that a default is made in the customer and isn’t that important because it is going to be altered in the dependent sales order e.g. some shipping information.
2.5 Bank Master
It is rare that you would enter bank details for a customer (this being more relative for vendor payments) however it is worth noting that there is a special feature of the customer and vendor masters is that if a bank key and country combination is entered on the bank screen within the customer and this bank does not exist in SAP (in master table BNKA) then SAP allows you to create the bank master record at the same time as creating the customer relationship to it.
So you must be careful when creating your customers that you do not unintentionally create a number of bank records at the same time. Nevertheless allowing the customer and vendor loads to do this can be a legitimate method of creating the banks (if done intentionally) rather than by developing a separate load program. The bank master is a small object with only one mandatory field (bank name) apart from the primary key.
2.6 Reporting
Often on a project the sales group and sale office set up is a key reporting feature that impacts directly on the loading of customers. It is advisable to speak to the functional consultants and business early to ascertain whether the structure has been defined and how the customers can be mapped to the structure. Other fields used for reporting include the customer group fields: customer group 1, customer group 2 etc, which can be customised according to the client’s requirements.
3 Footnote
Customer Master migrations, as with all aspects of an SAP project will vary from client to client. There are inevitably data load requirements specific to your own project.
For further information on customer master or indeed any data conversion topic, please contact Harlex Consulting Services Ltd at info@harlex-ltd.com.
You can find more Harlex Guides on our website at http://www.harlex-ltd.com/downloads.html
About the Author
Harlex Consulting Services are specialists in SAP Data Migration.
http://www.harlex-ltd.com