SUM and MAX Function ON PI

[Former Member]

HI Experts,

AM Doing Idoc to File scenario,

Target field is SUPDAT Formula MAX( EDATU ) of all E1EDP20 segments of the current ORDERS05-E1EDK01-E1EDP01 segment.

Target field is PLNQTY Formula SUM( WMENG - AMENG ) of all E1EDP20 segments of the current ORDERS05-E1EDK01-E1EDP01 segment, truncated, with leading zeroes, without decimals.

For this i have to write UDF or can i use Graphical mapping here

give me reply

[Former Member · Accepted solution]

Hi,

You can use the graphical mapping.There are standard functions like sum etc provided.While mapping please note the context level. And for removing leading zeroes u can use the function substring provided in the graphical mappnig.

Thanks,

Arijit guha.

[Former Member · Accepted solution]

HI Arijit ,

I Solved My SUM function .

Regarding MAX(date) can you tell how to mapp this function in PI i want to calculate MAX(date) in orders05 IDOC.

am waiting for ur reply

thanks

[Shabarish_Nair · Accepted solution]

do note that you can only process numeric values when you use arithmetic functions.

so i dnt think you can find out the max when it comes to date values.