Dear Experts ,
my database table contains json data , now i have to convert that data into internal table . my tried number of methods but unfortunately i didn't get proper result.
json data is like
{
"userSession": {
"name": "X1234500",
"lastname": "",
"firstname": "",
"emailaddress": "",
"connRegistrationId": "738b584ebf8258c",
"userSystemId": "xxxxx"
},
"bfmData": [
{
"controlArea": "1000",
"rpaGroup": "US"
},
{
"controlArea": "1000",
"rpaGroup": "TS"
},
{
"controlArea": "1000",
"rpaGroup": "AS"
}
]
}
how do i convert that data into internal table .
please guide me.
Regards,
Venkatesh.
Please indicate both the expected result, and what you tried.
You need to create a structure
1.
s_struct {
userSession type s_user_Session,
bfmData type t_bfmData
}
2.
s_usersession{
name,
lastname,
firstname ,
emailaddress,
connRegistrationId,
userSystemId
}
3. s_bfmData {
controlArea,
rpaGroup
}
You need to write a simple transformation to covert JSON into internal table ....
Add a comment