and all this is Vikram and I keep on posting the videos related to s a ps4 Hana functional topics in this particular YouTube channel so if you are still not subscribed to this channel please subscribe so that you should always get the latest videos on sa ps4 Hana logistics as well as finance topics in this particular session I will discuss about LT MC okay what is LT MC l TM C is a new version of LS MW okay we can say it is an enhanced version of LS MW so previously in s APEC C in order to apply the master data and transitional data from the BBC system we were using LS MW okay which means if a customer is implementing sa P and if he has some data in available in the older systems legacy system like tally or maybe any other ERP that the customer was using so all those customers all those windows all those GL accounts what your cost centers profit centers banks whatever data you have in your source system if you want to upload automatically using the tool you can do through using LS MW okay so for example if I have multiple customers thousands of customers in my previous ERP system and now if I want to upload those in AC P system I am definitely not going to do it one by one okay so I cannot create customer one by one otherwise it will take lot of time and that is the reason we were using the tool called SLS MW previously now in addition to LS MW so LS MW still available even if you want to use LS MW in SPS for Hana so I'm using 1909 system for this demonstration purpose which is the latest version available from ACP so if you try to use transactional s MW as I told you it will still work you will be able to see all the activities all the steps that you are performing in s APEC C so even in s ApS for Hana you can use LS and W if you want but it is recommended to use LS MW because sorry it is recommended to use a TMC because it provides you enhanced functionality or maybe we can say it is a next version of LS MW okay how I will just give you the complete demonstration okay so in order to access any TMC it is just a transaction code you can just write L TMC and this particular transaction will not open in the traditional GUI it will not open in the screen now I say P netweaver screen that we were using earlier instead it will get opened in the web browser okay so you can copy this particular this one and I normally use Google Chrome to work on the wave version of ACP but it is not necessary you can use Internet Explorer also so let me log in with my credentials okay and this will open the screen called s migrate your data so l TM c transaction will take you to this particular screen which is called as migrate your data if you are using sa ps4 Hana cloud in that particular case you can all also access this migrate your data using management solution okay but that is a second thing but let's talk about the LD mc2 now now in order to upload the data let us say in this particular example I want to upload the cost center master data into a CP ok so let's say in my previous system in my legacy system I already have lot of cost centers which I want to upload into a CP system now so how to do that what you need to do is you need to create a new object or you need to create a new project ok so let's click on create whatever name you want to give so I'm giving maybe Z cost Center because I'm planning to upload the cost Center but within one project you can upload multiple objects it is not necessary to create separate project for cost Center separate project for GL you can create one single project and you can have multiple objects within this but in this example since I am only a floating cost Center I took the name as Zico Center okay once this is done you can just click on create' okay and system will give you the list of all those objects that can be uploaded using LT MC okay so you can see you can upload activity types you can upload Bank you can upload the bank account balances which is a transactional data okay but what we want is we want to upload the cost center so you can see cost center is the object is available here okay so within one migration project we can have multiple migration objects so cost Center is one of the migration object just click on this okay and it will give you this warning just press ok what will happen when you click on ok is system will generate the object in the background I will show you once this is completed I will go into the background system and I will show you what exactly has been done in the background so let's click on OK okay it may take some time you can see note that this may take some time also if you want to see the documentation related to this cost Center you can click on this show button it will give you the documentation related to the particular object ok so now here you can see this migration project under this migration project there is a new object created which is for cost center ok where I can go and see in the background this project and this migration object so there is another transaction code which is called as LT M om it is called as landscape transformation migration object modular if you press Enter so it will take you to this screen migration object modular M om ok and within this which object we are looking for we are looking for project which we just now created C cost underscore Center okay so under this project we have this migration object ok so this is what is created in the background ok I will come back to LT mmm later on first let us talk about the at DMC - ok how to migrate data so I will go here back to the migration screen which is LT MC screen and here you can see now system is directly providing you the download template ok previously in s APEC see if you are using LS MW or even if you use LS MW in sa ps4 Hana you have to create a template on your own right you normally create a template which fields are important which fields are not important so you can select whatever fields you want in your template I think you into the business so that they can fill the data and give it back to you so there is lot of work required in order to create the template in order to map the fields right but in LT MC that work can be reduced how because s AP by default is providing you the download template it is providing the template which you can download so click on this download template you can see it is a XML based file which can be opened in Excel and it already contains the list of the source fields it already contains the mapping what you only need to do is you just need to go to this cost center master data sheet and you just need to fill this information okay so in LS MW we need to create this file manually Lite which field will be required what would be the length of the field all those things we need to handle ok but in this particular case s AP is by default providing you the upload file you just need to download the template upload before you upload it you need to fill the information so if I want to upload multiple course centers I need to enter all those cost centers in this file and then I need to upload this file which will automatically upload the data into the ICP system alright so now you can see in this particular file there are many fields most of the fields which are related to cost enter all the standard fields are provided here ok so if you see the number of fields so let's start with 1 2 3 4 so this 4 fields plus there are some so this 4 fields are mandatory fields you can see the star ok there are other fields which are mandatory and there are some fields which are optional whether you enter it or not it not make any difference okay it means it is not mandatory obviously it will make difference in terms of their functionality but it is not mandatory to fill this information okay so you mandatorily need to fill the information of the star fields okay now how this template can be changed so whatever ICP is given if you are happy with that you can use this template but normally when you're working on the project customer is not happy with the standard functionalities which are available in the system there are some functionalities which customers implement on their own okay so that is the reason we call it a Zee process now within Z let's say in the customer master data which is transaction code KS 0 1 so let us assume in my customer master data that is K of 0 1 there are some standard fields okay let me just show you this one so there are some standard fields which are provided by a say P itself so all these fields are part of the LT MC Phi you can see most of the fields which you need to enter at the time of creation of cost enter those fields are available here but in your customer processes there might be some field which you added on your own as the Z fields right so if there are any Z fields those can also be added in your TMC template using this tool called as LT M om which I told you earlier it is called as migration object modeler okay migration object modular what exactly migration object modeler will do you can create additional fields so you can create additional fields okay in the target architecture first right so you will be only able to add the fields to the system once those fields are already available in this transaction right so let's say for example if a customer has a requirement that in addition to this standard fields if there is any C field here so that Z field would be added by whom that Z field is definitely the above task right so a web consultant they will create the Z field here and that Z field will appear in your target structure so this is your target structure what you are trying to do is you this is your target you want to upload the data in this particular screen okay and what is your source source is the excel file right you are providing the information in the excel file this is your source so this source file is assigned to this target architecture okay so now if I have any Z field here and if I want to upload the data not only for the standard fields even the Z fields also so first of all I need to add that Z field in the source file okay and obviously we are assuming that the Z field is already available in the target file ok so how are we going to add because this is a template which is provided by ICP how can we modify this template so just to give an example you can see the last column in this particular file is sorry the last column is printer destination all right if I want to add one more column after the printer destination what I can do is I can easily go to migration object modular in the source structures okay if you double click on the source structures this is where you can create additional fields okay so whatever fields are appearing currently in your excel file this is a complete sequence this is how exactly those Feliz are appearing okay so if you compare your file with this fields you will find one is to one mapping okay so controlling area constant from valid to you can see the same structure is of your five of your source file okay so if you see the last field in this object modular okay so in order to see the last field I need to come down completely and you can see here just give me a minute is it the last or there are more fields to this yes there are more sheets to this let me first go to the change mode because I am changing the object okay so now if I want to add any additional field here what I need to do is I need to click on ok I need to click on this new field or you can click on this insert read when you click on this insert field ok don't create any field on the top so let's remove this and you can use this one add field so it will automatically take you to the last one okay and in this one you can enter whatever information you want so if I say test so this is the test field that I am creating just go to the last one okay and whenever you are creating the Z field you also need to specify the data type so this is character and whatever it's in the size of this length of this particular field is going to be 20 characters you can enter some text here which is nothing but the column header okay here also you need to enter the group text okay and then click on see ok once it is saved you also need to generate the object you also need to generate this runtime object then only your excel file will show you this particular feed okay once this object has been generated you can see as of now we are still not assign this new field that we created to the target okay because for target assignment we need the Z field to be created in the target structure also it should be done by your a bap right so now let's go back to our at DMC let's try to refresh this so that we should be able to see the new field in our migration object so this is our migration object z cost underscore center and within this we want to go for the cost center okay sorry this was migration project and within the migration project we need to go to the cost center migration object click on this and now let's try to download the template so we should be able to see that taste field which we just now added in our file in our source structure you can see this so this is a field which got added just now when we added it from the source LT my M so from LT mm we added this particular field in the source structure but whatever data we entered into this field as of now we are not told the system where exactly this information will flow into the actual cost center why because there is no Z field availability now here okay so this was just to give you the idea what exact is LT my m LT m om allows you to modify this field according to your requirement to modify this particular file according to your requirement you can add a few more columns if you want okay or if you have a requirement that you want to add some Z fields you can easily do it by going through transaction ID mo n okay and now once the file has been downloaded as I told you you can directly give this file to the aid user to fill the information okay so for example I will fill some information here so my controlling area is VI K first let's click on this enable editing yes so my my controlling area I am creating lipstick cost center VI K - cotton okay well it from zero 1.0 1.1 EIN 10 till 31st well nine nine nine nine okay and i will enter only that information which is mandatory so cost center name i'll just copy the same thing which is this one okay description also I will keep it same user responsible is not mandatory but person responsible is mandatory so I'll just enter something like manager cost center category I would enter W here here are key area is again the mandatory fields so I will go through our key a VI K company code I need to specify so my company code is again VI K okay and if there is any other mandatory field we just need to enter that since profit center accounting is active in my company code I will enter the profit Center also which is VI K - one okay I think this much information is enough ok so similarly I want to create let us say around PI cost centers so I take this information and I'll just change this to 14 15 16 and 17 and I will copy this column to these two columns right okay so this is the data that you let us say let us assume that this is the data that you received from your business users okay these are the cost centers that they want to upload so first of all let's save this file save as i will go with okay what your name it is their p we'll make sure that we are uploading the same file so save it yes okay once you enter the data in the file you can again go back to your LT MC transaction but this time you will be uploading the file last time we downloaded it a template we fill the information into the template and now loading the file okay so click on upload the file system will ask you from where we need to upload the file you need to provide the path and the file it should not take this much time maybe something slow in the background okay so now system is asking us the path from where we need to upload the file so you could go to the choose file and you can select I think it was ending with three maybe in the Downloads yes this one okay double click on this and click on upload okay so while uploading you will be able to see that this file has been successfully uploaded and you will be able to see that the new line is created here okay it is telling you that this file was uploaded by this user at this particular time okay as of now there you can see the migration status is not active so before you go ahead with this file you have to activate it click on this activate button ok so data file has been saved successfully now you can see the file status is active ok but the migration is still not started okay in order to start the migration you will click on start transfer ok it is giving me the warning message that migration object is locked so what I need to do is just come out of LTM one because it is creating the lock ok so let's try to do it once again so start transfer okay now system is starting the transfer just click on OK ok so during this time system will perform all the necessary validations whether the data that you have provided in the file is correct or there is any problem in that particular file so when you click on close you will be able to see if there are any errors you will be able to see either warning error or information so if it is information this means everything is ok we can continue so validation part has been done so in order to upload the file we need to convert whatever file whatever data we uploaded we need to convert that data into the supported form so what you will do you will click on this next button click on the next button ok and during the conversion system will ask you to do the mapping ok so in our case maybe we want to upload the same value let's say for example if in my sole spoil if the company code is seen our source why he'll when we say our company code is I think VI K so with our in the target also do we have the company code with VI K or not so you can tell the system if my source file has VI K as a value I want to upload it as VI k1 for example okay so dad mappings you can do it here let me show you one so if I go for mapping of company code you can see in the source file the values VI K here system is asking you in the target system do you want to upload as the same value okay so most of the time all the values that we entered in our excel file will be the target mapping so that is the reason what we can do is we can select all and click on confirm mapping values okay what this will do this will be 1 is to 1 so whatever is my cost center category in the file I want to upload it as the same way okay and there is only one thing which is remaining which is fixed value for controlling area so this is something which you need to provide manually ok so which is the controlling area in our case in my case the controlling areas VI key normally even in a city ECC whenever you are working on any controlling related topic you have to set the controlling area right ok K s this is the same way so we are telling the system that we are uploading this filter in controlling area VI ki okay so let's go to the next one so now the values are converted just keep on clicking on next it will simulate the import which means again it will verify after the conversion of the values whether the system is ready or there are any errors ok so if there are any errors that would be highlighted here as of now everything is just the information which means everything is going fine ok and once you are done with this now you are ready to execute a real import which means as soon as that click on next system will upload all those five cost centers into the ASAP system okay let's try so click on next okay so 100% has been completed just click on close okay again the information messages which means now our conversion has been completed all the file cost centers have been uploaded successfully how can we verify that we can go to transaction KS 0 3 ok to display the list of cost centers and we will just verify what cost centers we uploaded we have loaded 13 till 17 so starting from 13 to 17 so VI K taught him you can see is uploaded and VI K 17 let's see it is also uploaded ok so this finishes the LT MC process what you can do is if that is was the only purpose of your LT MC transaction if you are not expecting any more objects to be uploaded then you can just click here on finish which means the status of this LD MC object will be converted as finished ok if you are planning to upload more data if you have many more cost centers which you want to upload then you may not click on the finish button you will continue to do this activity for the remaining cost centers also ok so let me click on finish so this status of this object will be completed ok you can see it is finished ok any time if I want to upload any other file I can again go to the upload file if I have the template already with me if I don't have the template I can download the template ok if you want to upload more data you can again go to the file fill the information upload the file it will create second line here and you can carry out the same process what we have done ok so first one is validation second one is conversion and finally you have the actual import ok so this is about le TMC ll TM well I hope you like this particular topic and you will be benefited out of this when you will be working on the real-time project so for more such videos as I told you if you are not subscribed till now please subscribe to this channel I will keep on posting many other top - ACPs for Hana finance as well as logistics thank you all thanks for attending this Asian