cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping

Former Member
0 Kudos

hi...

i want to map these,

1. Sum of <field1> for all <field2 of diff table> = <field2 from diff table> where <filed4> > 900000

2.left justy a field

3.checking condition...

plz help me on this....

thanks...

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Can you pls expain the mapping requirement in detail?

Specially first condition.

If possible, its better if you can mention your source and target structures as well.

Regards,

Supriya.

Former Member
0 Kudos

hi...

thes the condition for 1st....

Sum of LIPS-LFIMG for all LIPS-VBELN = LIKP-VBELN where LIPS-POSNR > 100.

plz help me on this..

thx....

Former Member
0 Kudos

Hi,

Check this links and follow that mapping

http://www.flickr.com/photos/42898709@N07/4013604333/

Regards

Ramesh

Former Member
0 Kudos

HI ramesh,

Thanks for ur reply... it is very help ful....

can u give suggestion for my 2nd and 3rd question....

thanks a lot...

Former Member
0 Kudos

Hi,

What you mean by left justify and checking field? could you please eloborate.

if your input is 5 characters and you need 10 characters at this time you can use Format NUmber predefined function in the mapping. give input to that function and double click on that function and give the total number of characters.

Ex: 200 output: 000200 then you menation 000000 in the format number function.

(for right justify)

Regards

Ramesh

Former Member
0 Kudos

hi ramesh,

can u help me on this,

Use first instance in LIPS : Left-most char of LIPS-MFRGR in position 1, leftmost char of LIPS-LADGR in position 2

what function i want to use...

thx..

Former Member
0 Kudos

Hi,

Use the sub string and concatenate function.

Check this below link

http://www.flickr.com/photos/42898709@N07/4015044928/

Regards

Ramesh

Answers (0)