Hi, I have a requirement to upload material master data into D.B 1. Which is the best option to use - BDC/LSMW/BAPI(Program)/Direct upload program! 2. Based on Material types fields to be uploaded will change as per sample sheet, Can we make use of single sheet With all fields in it(By removing common fields for all Mat.Types)! Will BAPI - BAPI_MATERIAL_SAVEDATA useful for both MM01/MM02! What is the better approach for the same! Thanks, Deep. Master Data Upload This topic is bit easy but while doing it first time – it would look like huge task, and in a way it is! It needs more attention and some precaution too. This reference article is for those consultants who want to read before starting their task. Master Data is one of the most important task after configuration, rather equal, and need to be done very carefully. Basically, the data/details that you want to store, maintain and use further to perform activities, during actual processes – is your master data. This data do stay in system and appear when required/called in transactions, such as – Customer Master Data, Material Master Data, Credit Master Data etc. and play his role. How Does It Works During Project Most of time consultants share templates after BBP sign-off and ask core team members to fill that up. After successful completion of configuration, uses these data templates to upload in system. Ideally, one should have entire master data in DEV, QAL and PROD system. This ideal scenario will help testing lot of scenarios and enhances confidence at both ends. This helps even after Go-Live. Many organizations have ready-to-use Templates; this is a good practice and save lots of time. What is Master Data Template Master Data Template is nothing but an empty excel-sheet with title heads, descriptions and space to fill actual data. In another worksheet mention all reference values for easy reference (and strictly ask them to follow this list). Some sample data will make it more clear, and easier to fill.
Options For Data Upload There are three ways to load your data in system. All three are important but you need to choose very intelligently at times. List is as follows:
The general rule is – if your data volume is less than 20/30 do it manually, otherwise good to go by LSMW or BDC way. In case of huge data, choose wisely. LSMW – is a best tool and functional-consultant-friendly. Functional people must try working on this. It has capability to work equivalent to BDC. One more benefit is – you are nor dependent on ABAP team (for any last minute modifications or troubles). Here, we will not talk how to use LSMW. I personally prefer this most of the times. So as to learn and gain expertise on LSMW – use these links: http://scn.sap.com/docs/DOC-48866 http://scn.sap.com/docs/DOC-26159#section31 BDC will be developed by ABAPers. Good thing about BDC is – flexibility, validations and logical conversions. For this task your ABAP team would ask for recording using SHDB. While recording, be sure of the fields that want to consider, and choose those fields by entering value or at least put space in that fields (if do not know value now, but planning to record it). In case of doubt, record it instead of excluding. Because, AABPer can comment/hide it if not required, but in case of new field addition they might require to put more efforts. So if there is 1% or 2% chances of using certain filed – consider it in recording. Later on comment that field if unused. Do a clean recording, go in sequence and do not repeat one field (in case of mistake, do it again). At times your client might use this BDC/LSMW for their day today business. Ex. Our open order BDC has been used by our client to load Sales Orders in mass, every day. In fact – your BDC belong to them, you would be asked to handover all those finally. What To Check After Template Receipt You should verify entire received data. Check if it is as per your configuration, check other integration points, such as SD-FI, SD-MM or MM-FI etc. Most of the time you will not get perfect data until 2nd or 3rd iteration, so be very cautious. Test it and change if there are any modifications required, or get it done from client as they are more aware of their own business and data too. Now, get it approved from client before production. Be sure by perform trials on DEV and QAL, this will improve your confidence and data quality!
Some So-called Complications Certain master data, such as Material Master or Customer Master, are complicated. You might use same/simple transactions but the screens, fields, tabs, would vary depending on your selection parameters or input parameters. Simple example: in case of Material Master if you choose less views it will show less number of fields. Similarly in Customer Master if you do not provide company code in XD01 it will only show you two views one is ‘Sales Area’ and another is ‘General Data’ view. So accordingly your LSMW or BDC will differ. So just to get it more easy – for customer master there could be three BDCs (choose as per your requirement):
Precautions Before Upload Make sure you have tested this templates and BDC/LSMW multiple times in DEV and QAL system, and it’s running smoothly. Because, at time of Go-Live you cannot take any risk! It becomes very time critical and this saved time is worth investing on other critical things. Troubles You Might Face
Mass Maintenance: Even after tons of precaution you did not managed to fill an specific filed or maintained erroneous data in specific field. Oops! in such cases there are ways to work on it.
Lastly – More you give attention to the data-templates – more easy will be your life on final day. This entire article is not a rocket science, you will also understand your way of comfort and learn this with time. All the best, happy uploading! Regards, Abhinay Purnale (SAP SD) How do I update material master in SAP?Start Winshuttle Transaction from the desktop shortcut or from the Windows Start menu.. Click New.. Enter transaction code MM02 in the Transaction Code box, and then click Go. ... . Click the SAP system that you want to use, and then click OK.. How do I upload files to MM17?New upload function in MM17 and MASS transaction. Start the engine: MM17. ... . click the Import data from File button to get the file browser to select your source file. ... . Next surprise: One click on the assignment button and SAP was able to assign the columns from my Excel automatically to the fields of table MARD.. How do I use Tcode MM17?You can use MM17 for mass changing of material master data (if something can't be accomplished by this transaction it can be done using LSMW, BDC or BAPI).. Enter the value you want to copy in the box.. Click on the column heading.. Select the button, to overwrite the old values by “PCS”.. Execute.. |