Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

SAP HCM Text Columns

JohnLawson
Regular Contributor
Regular Contributor

We are converting our SAP IDM implementation to Saviynt. The text and derived columns that IDM pulled from the query are not accessible the way Saviynt connects to the tables.

Does anyone know what the column names are for the text values of MASSN or MASSG for example?

Here is our current configuration for account import:


{
"USERTABLEMAPPING": [
{
"SAPTABLE": "PA0002",
"SAVTABLE": "PA0002",
"SAPMAP": "PERNR,ENDDA,BEGDA,AEDTM,UNAME,NACHN,VORNA,TITEL,CNAME,RUFNM,MIDNM,GBDAT"
},
{
"SAPTABLE": "PA0000",
"SAVTABLE": "PA0000",
"SAPMAP": "PERNR,ENDDA,BEGDA,AEDTM,UNAME,STAT2,MASSG,MASSN"
}
],
"USERIMPORTQRY": "SELECT DISTINCT p0.PERNR employeeid, 1 statuskey, p2.NACHN firstname,p2.VORNA lastname, p0.STAT2 customproperty1,'10000047' customproperty6,p2.ENDDA customproperty30,p2.BEGDA customproperty31,p2.RUFNM preferedFirstName,p2.MIDNM middlename,p2.GBDAT CustomProperty7, p0.MASSG CustomProperty4, p0.MASSN CustomProperty5 FROM PA0000 p0 left join PA0002 p2 on p0.PERNR = p2.PERNR WHERE p2.VORNA like 'aa%' or p2.VORNA like 'ab%' or p2.VORNA like 'ac%' or p2.VORNA like 'ad%'",
"SAVCOLMAPPING": "employeeid,statuskey,firstname,lastname,customproperty1,customproperty6,customproperty30,customproperty31,preferedFirstName,middlename,CustomProperty7,CustomProperty4,CustomProperty5",
"userNotInFileAction": "NOACTION",
"zeroDayProvisioning": "FALSE",
"generateSystemUsername": "FALSE",
"checkRules": "FALSE",
"buildUserMap": "FALSE"
}

We get the reference id but not the text values.

Thank you!

3 REPLIES 3

ManishAcharya
Saviynt Employee
Saviynt Employee

@avinashchhetri Any pointers?

Nikitaj
Saviynt Employee
Saviynt Employee

Hi John,

For, Does anyone know what the column names are for the text values of MASSN or MASSG for example?

: It should be in table infotype0 PA0000 stores actiontype and can get that  text value  from T529T table by matching with the code present in infotype0 PA01

Also please confirm are you looking to add action type and store it in SSM?

 


Thanks
Nikita

JohnLawson
Regular Contributor
Regular Contributor

Thank you for replying! Yes, we are looking to add the action type and reason in SSM. Would the normal way to go about this be to import all the text tables and join them on import?