SAP SuccessFactors Employee Central Day 8 | Corporate Data Model - XML

0:02 this conference will now be recorded yeah good evening all good evening let me share my okay so what did we discuss yesterday quick recap what are the data models that we have seven data models okay what are those corporate model and specific yeah I can hear you go ahead uh corporate data model country specific corporate data model sucession data model specific country sucession data model H propagation event reason event reason deration

0:48 worklow worklow rules worklow rules okay so what is in h propagation yes go ahead we create a position H position this is for new employee yes if I if I added for existing employee can we do in this HRS propagation what is HRS propagation create position creation of a position is not propagation it is propagating from one object yes one object to another from one

1:33 object while creating position the data gets transferred from job classification or job code to position similarly you have all of those details on the position while while creating position you maintain lot of details like job classification job title position title pay grade location company business unit division so these are all Fields what we maintain on position so when this position is ready to hire you have to assign this position to a person okay we are hiring today one of the person then go search for the vacant position and pick that position add that position to employee system again propagates all of the data from position to employee because we have all of the information on position so that data

2:20 gets transferred to employee again that is also propagation okay yeah what else what is event reason what is the logic to trigger event result logic to trigger event Trier the transaction reason okay yeah where do you define the national IDs the country specific country

3:07 specific corporate data model no country specific corporate data model succession dat country specific succession data model Yeah country specific succession data model employee data is all in either succession data model or country specific succession data model okay okay and what is corporate data model yeah corporate data model includes the structure job okay job structure and the pay structure defines the foundation object corporate data model is used to define

3:53 Foundation objects and what are Foundation objects structure Foundation objects are objects that uh objects that are used to define the structure of a job and pay and these are the building blocks of e system okay clear so far so where do we Define succession data model where can we Define succession data model it can we upload or import upload or

4:39 download the uploads where do we upload succession data model is not uploaded in instance succession data model is always uploaded in provisioning provision provision only these two can be uploaded downloaded from provisioning and instance these two are always uploaded from provisioning okay and then we don't have this data models these two are already migrated this also you don't see in all

5:26 of the systems this is also migrated the these are migrated by sap there is no option of data model this customers has a choice whether now they want to use data model or the business rules initial discussions they will decide whether they want to use data model or they want to use business rules so always 99% of the times or 100 percentage of The Times They always prefer going with business roles because they are easy to manage okay now the third step is defining the corporate data model so we'll have to go Define the corporate data model so corporate data model is can be imported

6:12 and exported from provisioning or instance first I'll show you from provisioning and then we do it from in the instance because all of you will have access to instance so we'll be doing it from instance okay so first let me show you from provisioning I've logged into provisioning click on your company name now the other day settings we have seen in company settings so these data models you'll find them in succession management you scroll down you'll find a section called succession management under that you see import export data model this is succession data model import export country region specific

6:59 spe ific succession data model corporate data model and Country specific corporate data model so these are the four data models that we have and we don't see here workflow data model because this is migrated to business tool so where do we have that switch if I go to company settings under company settings we have the option of switching from data model to business roles okay you scroll down under employee Cal you see here enable business rules for workflow derivation if this is enabled you'll not see data model if this is not enabled you'll see

7:45 workflow data model and this one is for event reason so earlier we had option of enabling event reason through business rules or data model okay we for enabling this year okay now we only have option of business rules for event reason we don't have data model okay so outside your company settings we have four data models corporate country specific corporate succession and Country specific successions and all of these can be imported and exported from provisioning here okay if I go to corporate data model here you see please select either

8:31 import or export action to for the data model if I have data model with me I can go choose file upload or I want to download you go click on export say submit you submit it will download the data model see my data model is being downloaded okay same thing you can also do it from instance I'll go back to instance this is instance if I have to download the data model from instance should go to [Music] Import and Export corporate data model or you can directly search for corporate data model

9:16 you search for corporate you see import export corporate data model country specific corporate data model anything that you want to search you search for that word system gives you the probable search okay corporate data model now go to import export corporate data model here you can download or upload the data model so you have import okay if I have my file with me to upload I can go and import or if I want to export it first go click on export you see here this is export button at the bottom and you can also see all of this version people have uploaded this data model so

10:02 I can see the versions I can also download any of these versions so every time I upload data model it uploads with a new version this is now the latest version 118 okay now if I export it make some changes upload it would be v19 okay now I'll go and Export this is downloaded so if I go here and right click right click open with XML pad I click and open with XML pad when

10:47 you open a file with XML pad now let me do one thing so there are other files which are open let me close all of them okay so right click on the data model you can open with notepad++ you can open with notepad you can open with XML pad word pad word and use all of these applications so open with XML pad

11:33 now this is my file yesterday we discussed about some of the basics of XML right so if you see here this is all the XML code is around 34375 lines of code is very easy to understand maybe it looks lengthy but easy to understand this is the main section where we have the code on the left hand side you see the document outline like you can go and navigate to element a particular section of the code you can navigate from here you have plus expand and go just click on that it navigates you to that particular

12:18 code okay and the beauty of XML pad is we can see the entire code in the table structure as well can see the entire code in table structure but first let's try to understand this from xmlpad now yesterday we discussed that any piece of code that is to be written it should be between opening and closing tab and the highest element here in corporate data model is corporate data model if I see if I place my cursor here corporate data model this is the starting of corporate data model you forgot about these lines this is the starting of corporate data model you see the Blue Line it is starting from here and it is going till end of the corporate data model this is ending of corporate data model the

13:05 opening this is the closing tag opening and closing tag and then next line you have description this is the opening and closing is on the same line you see the blue line here on the left hand side extreme left hand side you see the blue line is open and closed on line number six so description open description closed and next is hris element first element hris element is nothing but the foundation object so it is starting from here and it is going down okay it is the first element okay it's gone now if I see this

13:52 is the ending of hris element this is the ending of H element and next element is starting from here I place my cursor here it shows the blue line starting here starting and closing so system will show you where is it starting and where is it ending now the same thing entire thing what we have in the code we can look at that code in the table structure as well if you go to table view if you are new to coding and you don't want to do the changes in coding you can go and have the change in table structure now this is your corporate data model initially you'll see this as corporate data model you expand corporate data

14:38 model corporate data model you have description this is the description and there are 17 elements here you expand all of those 17 elements these are the elements these are the first line first row if you see these are the 17 HR elements each element this is about this element I see this is highlighted if I place my cursor here this is highlighted here I place my cursor here this is highlighted here okay I place my cursor here label see this is label so it will also show you the document outline you can also navigate from document outline or you can go to table structure the first row that we have in HRS element is

15:23 the row ID or element ID every element has got an ID which cannot be changed these are the 17 HRS elements and these each and every element has got an ID and you cannot change the ID of the element if you change and upload if you if I try to change something like this pay range one if I try to upload this system will consider this as a new element and it will not allow you to upload because this is a new object or new element so it should always be with this so you should not be changing the ID you should not be touching the ID keep the ID as it is don't touch it or don't change

16:09 anything in the ID now if you don't want to have you don't want to call this object let's say pay grd we have a pay grd we don't want to call it as pay grd we want to name it as band Yes you can do but you cannot do it for ID you need to change it for label every element has got label for location group if you see this is location group this is geozone this is location so every element has got the labels now if you see labels it says there are 39 labels so what are these 39 labels expand 39 labels you see the location group label is maintained in 39 different

16:54 languages 39 different languages that means anybody with Hindi as their language they see the location group as this one Stan Samu because the location group object is labeled as Stan Samu in Hindi language okay everybody will see everybody with Hindi language will see the location group with this name so you have the first field which is the default label this is the default label if some label is not maintain let's say for this language I'm not maintaining the label so they will see the default label for any language if the label is not maintained they will see the default

17:39 label default label should be there default is the mandatory or default label for each element okay now it is fine if you don't have label for any of these languages system will pick the default label okay clear on the labels Now location group where do I see this I if I go to instance I can duplicate the session right click on the tab and the tab and say duplicate it opens up a new tab so the all of these Foundation objects are managed in manage organization pay and job structure there

18:26 is a navigation there is an action called man manage organization pay and job structure where you maintain the foundation objects definition is done in corporate data model definition meaning the design part What fields you want to have in each of the objects what should be the name of the object What fields are text Fields What fields are date fields What fields are drop- down Fields so you define all of that in corporate data model but if you are to create a department or create a location or create a grid so then you would be doing it from manage organization pay and job structure now I want to create a location group go to create new here you see location group the label of these

19:13 object location group it is showing as location group here and these are the fields of location group now I don't want to call it as location group I want to call it as something else your customer says I don't want to have it as location group but some locations I want to group and I want to call it as a state not locations so what we can do is we can go change the label of the location group here to State okay place your cursor outside that field and save it and save your file now once you save your file you try to upload this data model go to import export corporate data

19:58 model import browse the file you have your file here and put some comments LG to State okay just to understand what changes you have done location group I've changed it to States and say import here when you click import system now will validate whether the code is correct or not and then it will upload it says corporate data model has been uploaded successfully data model is uploaded successfully now I'll go to manage organization pay refresh the screen go refresh the screen and here if

20:43 you see create new and if I go here the first object it is changed to State location group object is now changed to state if you see here there is a field called location group ID here okay now the object name I have changed it to State it is changed here clear now any element if you want to change the label you will have to go here and change now I will rever that change location I'll say group okay I'll change this now I've not I've just saved it but I've have not uploaded it it is showing a state for me

21:29 the default label what is the language that I have selected for me the language is English us there's no English US separate in these languages we have English GB English GB it is location group now if I go change my language Let Me Go duplicate the screen again you can open another screen and you can change the language from here settings go to settings and then change language you see here I have selected English US instead of English us I'll go and select English UK and say

22:16 switch if I go to manage organization pay here now just refresh the screen create new what do we see here it is showing as location loation group and where is the location group ID for UK the field I field name is showing as code and name and here it is location group why because I have changed the language for English US UK the Lang the label is location group now again I will go back change my language to us settings change Lang language if you have not

23:01 changed that particular language they will see if they will see the label whatever that we have earlier okay now I will refresh the page again see it a state you see State location group ID and name clear on ID and label any doubts here know when we are saying import we are importing that uh uh that XML file from the sap system from your local system to

23:48 success factors you're uploading from your local system you have made changes uploading means yeah uploading means import import export means download or download means export okay clear on first two things ID and label for any object you want to change the label you go expand the label change the label here change the label but we can't change the ID right you cannot change ID why do you want to change can add a new ID no when I say system doesn't allow

24:35 you to make changes to the ID that means that's a new ID that's a new object system consider it as a new object in and doesn't allow you to upload with new element go simple okay got it okay so moving to next thing in a row we have fields for each element we have Fields so what did we discuss yesterday here the table we have element we have data model element under element we have labels this we have seen and under element we have Fields so for each

25:21 element we have this fields for location group I can see there are 76 fields there are 76 Fields but if I go here the instance how many fields do we see you see only 1 2 3 4 and five there are only five Fields what about other fields let's see expand here you see the fields and their attributes every field has got maximum length ID of the field which cannot be changed again visibility of the field

26:07 whether it should show or not required mandatory or optional the label of the field so there is a field called external I external code so do we see anything called external code no this is the visibility set as both but here there is no field called external code if I go here and say expand labels it shows me the label of that field it is location group ID that means external code field is labeled as location group ID and this field is mandatory this field is

26:53 mandatory okay this is mandatory true visible visibility set as both so how many fields the visibility set as both 1 2 3 4 and 5 these five Fields have visibility both okay and for rest of the fields it is set as none that means out of 76 Fields only these five fields are enabled and rest of the fields are not enabled for them the visibility set as none so that's why they don't show up on the screen and one two and three three Fields have the required attribute as true so if I go and see here this is one

27:39 this is two and this is three three Fields have the required attribute true now required attribute blank or false meaning optional blank or false meaning optional only if it is mandatory you should go and maintain it as mandatory and length of the field each Fields length can be maintained or changed here it says 10 here if I goes try to type it says reach the maximum length load of 10 characters why because here it is set as 10 usually it is not 10 it should be 32 by default all the external code Fields will have the maximum length of 32 characters okay so name can be anything

28:25 name can be up to 128 characters or 256 characters I can change the length now if I go change the length it will increase now here I see for five Fields 1 2 3 4 5 now I want to add one more field so here these are the fields custom string 1 2 3 up to 20 we have and then we have 10 date fields 20 long Fields 20 double or decimal Fields so these are all available for each element now here I want to enable a field custom string one so what should we do go change the attribute to both if you want this to be mandatory go maintain it as true here mandatory what is this field called

29:10 you go have the label as let's say it is showing a gender but let me add it as location okay let's say I want to add a field called location there I've changed the label to label location okay what did I do I've have enabled a field called custom string one by changing the attribute visibility to both required is equal to true and the lab I've labeled it as location so this says 30 characters usually it is 256 characters I'll set it to 256 okay now save it so there are four changes that I have done I've changed the length of this ID length of the name I've changed the

29:57 length of the custom string one I've changed the visibility of custom string one to both required to True label I've changed to location now I will save this file and upload I'll go here import export data model browse and import I have also change the location group fee or location group object to group it is no more State now okay that also I've have said now let me upload this corporate data model has been uploaded successfully now I'll go to manage organization pay just

30:42 refresh this page refresh this page create new and if I go here it says location group there's a new field called location here which is mandatory Now location group earlier was not allowing us more than 10 characters but it is allowing now up to 32 characters because I've changed the length here I've enabled this custom string one labeled it as location made it mandatory and I've changed the length of the field 256 characters okay we can CH we can add up to 256

31:34 characters T 250 characters Le okay clear on fields any doubts here looks easy when one thing sorry uh so we are doing it in the code somewhere yesterday or may before yesterday you shown me in the app in the sap model to add fields and delete Fields so what's the difference between both of these and that now what did we discuss yesterday succession data model we Define employee data we have option of changing the data in data model and we

32:20 can also do it in manage business configuration screen this is from instance there a screen called manage business configuration where you can go add a field remove a field hide a field change a properties all of those things what we are doing in XML these things can be done in instance also only for these two data models but for corporate data model we have to do it in the corporate data model only this Foundation objects can only be defined in data model not through front end okay clear thank you yeah venu for any reason if the file is not uploaded properly okay then what will be the situation like okay it will it will have

33:07 the previous configurations as it is intact okay so now here I will remove this true okay I saved this okay I've saved my file if I go back to corporate data model browse this data model and say import now it says there is there is some problem with the file doesn't say that data model is uploaded you see this error message invalid file format

33:52 specified please ensure the import file is XML format okay line number 293 column number 84 attribute required with values must have a value true or false so here I have deleted the value required okay now if I go to this field in the source now see line number 23 okay max length 256 hris field max length 256 ID is custom string 1 visibility is both and required is blank because I've just removed the true there you don't want you can completely

34:38 remove the code when you are removing the value true okay it is not removing the attribute required is equal to it is just removing the value inside it required is now blank now it should have either true or false or if you don't want you come here and remove it completely okay now I've have removed the attribute required is equal to so this is fine okay now I go back to table view go to table View Place your cursor on the same line go to table view it takes you to the same line there here you see this line it is also blank now okay but the required attribute is not

35:25 maintained now if I go here import this data model if you don't import it will have the old version whatever value that we have uploaded here 120 version 120 whatever changes that we have in0 we'll have it in system now I have uploaded the new version v21 121 now if I go back to location group so mandatory is now remoted star it is not mandatory it is now optional field clear yeah

36:12 clear any other doubts before we proceed further come on so so venu uh I have one question uh basically from from the XML we can edit uh any label yes and uh when we are going to upload that file it is going to be shows as you want H so is there uh any basically uh necessary thing we need to go through the basically uh the previous method you told us through the app basically through the going to different channels

36:57 there is no different Channel you have to follow only one channel import export corporate data model download upload okay uhu I have a question uh within the fields we will also enter the data so can we uh like uh specify numeric or alphabetic numeric or alphabet where do you want to specify like it should allow only numeric or it should allow only alphabet such thing is there here string no string allows you to input either text or number decimals double Fields allows

37:45 you to input numbers these double Fields double one to 20 these are decimal Fields decimal Fields you only these are the data types okay yeah do we do we have a list of data types which is accepted by the SF success factor yeah so in data model we only have this dat data types string date and then long double okay now a string can be converted into a pick list as well now this location if I go and can see here this location is now a text

38:30 field free text so I can maintain some text okay now if I don't want this to be open field where we where user enters the data I want this to be a drop- down value yes we can change it to a drop down value so this field can be converted into a drop- down using pick list using pick list there is a option called pick list okay pick list are the drop downs and these pick list are maintained in instance so if I go to pick list Center the other day when we were discussing the configuration workbook we I have shown you the pick list values gender has got some picklist values right so if I go to pick list

39:16 Center here it shows up all of these picklist these are all picklist all of these are pick list so if I see here there is a field called there's a pick list called blood group or maybe City okay so you have something called cities what is this let me go and check so inside cities let me go here okay there's something called cityor 8 maybe the k it is but let me check here if there are any values so I have these

40:02 values all of these are values okay now I want to convert this text field or a string field into a drop down so this can be converted if I go here this field if I want to convert into drop down so that can be done in Source I cannot do it in the table so the HRS field is starting here HRS El sorry field is starting here and ending here right go to the end of the line here it is ending just before that okay if you don't have line let's say this is if don't have line just press enter and open the tag pick

40:51 list ID is equal to okay and copy paste the ID of the pck list Center here this is the code pck list code ctor qat so I have copied that and then you close it pick list ID if you want to convert any text field into a drop down field this is the code you just have the pick list ID is equal to add the ID in inverted double inverted commas and close it this is the closing of pick list now if I go save this okay so if I go back to table

41:43 view I go back to table view these are labels because I have enabled labels it is showing labels and if I see this there's a ID maintained now picklist ID picklist ID what is that ID we can change once it is maintained in the source view you can change here to a different ID now I will save this data model and go to import export data model import

42:37 okay now this is uploaded if I go to location here again just to refresh I'll select this again now this location field is changed to a drop- down what values does it show up showing the values Abu TAA okay so these are all the cities that are made maintained okay these are the values that are maintained where are these maintained these are maintained in this Pi list so these are all those values clear yes no so we should have the pick list in uh okay if you have the pi like you have this this as a city K yes okay

43:26 so first you have to create the pck list and then you have to change over there yes yes now you can use success factors gives us some standard pick list or close to th000 pick list here okay see here 980 so there are around 6 700 standard ones you can also create your own pick list then tag that to any of the text fields to change the text to a drop down you have over after the search button you have the plus sign so you you can add you can add we'll we'll see that in we'll see that in coming session okay no problem but I have one this one like when you go to the XML okay you have only one tag okay you did not open and close the tag okay within the S if you

44:12 come to the code in the source source type go to the source type yeah here okay now how can we say okay this is applicable for oh this is only for yeah this is for pick list you are mentioning this pick list but this is applicable for which uh this one like now this is for the field the field is closing here right yeah yeah okay okay okay okay just before the ending of just before ending of the field I have placed this code of pick list ID is equal to yeah yeah so the the this one is a okay custom string one okay before that before that custom string one is closed you have added the pick list okay with the IDE now we have yes now we have

44:57 custom string two here okay just before custom string two one is closed and before closing that you have pick list yeah I got it okay yeah clear everybody if you don't understand let me know I'll explain again now usually we not have any changes here your customer will not ask ask you any changes in the data model okay but still we have to download this data model standard data model upload it in this if required there are any changes we have to make those change and upload otherwise not

45:46 needed okay uh venu one question yes hi uh see um so the custom string that you have used to convert it into uh you know a pck list so is uh you said it can be done in uh XML so is that the only way to create a pick list or can we do it also from the front end like from the instance also no conversion of a field from text to picklist is done in the code okay by adding the code picklist ID is equal to but where did we Define this pick list what values are to show up in the drop down that we do it in the instance okay okay clear now the once we maintain

46:31 the code here we can change now I don't want to show up City pick list I want to show this 1 2 3 4 5 6 okay or I want to have something else 0987 this has got some values inside go what values we have 0987 this code is 0987 right so if I go and maintain this 0987 it will show these two these two values mother and father here I can change 0986 okay now it will refer to this pick list called 0986 what values we have in 0 sorry 0987 right 0987 okay now if I upload this file instead of those old cities what were

47:18 showing up in the drop down it will start showing up these two values mother and father okay I go here browse data model UT here what did I do I've changed the value of pick list okay pick list ID to 0987 now you go here refresh location group see here mother father okay now if if I want to have more values I can go and add here okay let's say here I I want to

48:04 add s sister okay this pick list can be maintained here in the instance okay and we add one more value B brother active create okay once we maintain those values here if I go drop down you see sister mother brother all of them are showing up yeah you also have the reusability means wherever we are using this ID okay again in all those yes yeah if we are using the same pick list somewhere else it will show up all those values what we have in that pick list all of these four

48:49 values okay I think I think as you said uh most of the things are already predefined and customer will not be know willing to change things why your customer will not yeah why your customer doesn't ask you any custom Fields is you customer doesn't know what fields we have now they will give you a list of locations that are to be added in the system it is our responsibility to go add all of those locations location groups grades whatever objects they have given they'll say I have this list of 100 grades which are to be maintained in the system so we have to come here go maintain those grades your customer will not have access to these fields or to these pages okay they doesn't they they don't bother what how do we create how

49:34 do you create or how do you add or what Fields you add that's not just give the requirement in the workbook and from there we have [Music] to yeah there is one scenario where we may have to go and add that value okay change the corporate data model I'll tell you that in tomorrow session okay give me one second I'm get yeah sorry so we will stop it here for today I'll continue tomorrow I have a hard stop at 7 today I have another know office call to attend we'll stop it here and rest of the data model we'll see in tomorrow session so meanwhile I want all of you to log to the system

50:22 download the data model practice these things at least enable some fields make some FS mandatory try to make changes in the required attribute visibility attribute maximum length try to change the label okay can this be done log to the system you mean in the server yes into the server I don't have access to that I was not given the okay you can check with your representative once okay who's that Ahmed you or who said that yeah okay you can check with your representatives you'll be they will be

51:07 granting you they'll be giving you the access thank you okay yeah get that access and start practicing the system thank you you