cancel
Showing results for 
Search instead for 
Did you mean: 

message mapping based on field condition

Former Member
0 Kudos

Hello ALL,

I have a urgent requirement on message mapping.but i am not able to do.

I have five fields empid,department,designation,salry,experiance.

Based on Department i need to spilt the payload at message level.

This is my messages structures.

This is my file data.

Based on department i need to spilt rows data into separate files at mapping level.

ex abap rows data into one file,HR into one file,PI into one file etc....

Please it is urgent help me.

Please your posts as soon as possible.

Thanks and Best Regards,

s.k.prabhakar.

former_member190293
Active Contributor
0 Kudos

Hi, Prabhakar!

What's your target file type? Is it xml or plain text?

Regards, Evgeniy.

Former Member
0 Kudos

Hi Evgeniy,

sorry to say this you posted previously mapping successfully working. i did worng at context change.

My file is moving from sender side but receiver side it wont come.

I got error "values misssing in queue context cannot create target element at target side". for this error i used node function " map with default value". like this

but still not resolve the error. is it any useful if i change my source structure as 0.1.

post your valuable comments,

Thanks,

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member207703
Active Participant
0 Kudos

Hi,

If you want to generate multiple files based on departments that come under payload, then you have to use BPM.
Because as per my knowledge you cant generate more than one file at a time when you call Receiver File Adapter. So you have to do looping, that is only possible in BPM. If you are too good in Java and have proper knowlege SAP PI Jar Packages, then you can go for Java mapping too.

But its good, to go for BPM, as data is very less and i don't think you face any problem while doing it using BPM.

For your error, you change context of all elements that came under payload, but for what?? I didn't get your logic here. And also, share full error taht appearing to you. But in fist look, i can say, due to missmatch with records contexts you are geting this error because u removed all higher context nodes. Now its dificult for system to judge, which empid belongs to whom. But share full error that you are getting.

Regards,

Anoop Kumar Rai.

former_member186851
Active Contributor
0 Kudos

Hello Prabhakar,

Press referesh button in the mapping after changing the occurence.

Former Member
0 Kudos

Hello Raghuraman,

I want to know about thsi error, why this error will come.

Even i refresh the mapping also same error.

can you post abou this error detailedly.

Thanks,

s.k.prabhakar.

former_member186851
Active Contributor
0 Kudos

Hello Prabhakar,

Its because of multi mapping,since your changing the occurrence of messages additional node of messages with occurrence 0-unbounded will be added,Since your XML after FCC is not satisfying the condition its failing.

srikanthe_sapxi
Explorer
0 Kudos

Hello,

Please change the target structure occurence.

Former Member
0 Kudos

Hello srikanth,

My scenario is based on department spilt the payload, so thats why i used targeta s 0.unbound.

how can i re solve this error.

Thanks,

srikanthe_sapxi
Explorer
0 Kudos

Hello Prabhakar,

Please change the field occurrences from 1-1 to 0-1

Former Member
0 Kudos

Hello srikanth,

I changed as your suggested source 1.1 to target 0.1.

But still no luck.

i share my message structure with you check onece. let me understand why this error coming.

check it once Please make me understand. How can i resolve the issue.

Thanks,

s.k.prabhakar.

Former Member
0 Kudos

Hello All,

I changed my source structure is 0.1. but still it showing same error.

values missing in queue context cannot create target element at receiver side.

How can i resolve the issue. please help me.

Thanks,