1. Graphical Mapping In Sap Pi

Java Project Tutorial - Make Login and Register Form Step by Step Using NetBeans And MySQL Database - Duration: 3:43:32. 1BestCsharp blog 1,758,031 views.

I was trying to think of something to write about this weekend, when I happened to stumble upon this gem:After I stopped laughing, I started to cry, because I realized that this happens all the time in SAP PI–it just looks a little differentHowever, most of the time complex mappings can be simplified by using a different approach. The mapping block FixValues is a great tool to reduce needless.

So let’s expand on this example. Reducing Complexity with FixValues Mapping BlockLet’s say I am developing an interface between a database with information about goods/materials and a file for system that needs the database data in an easy to read format. To help visualize here is some pseudo-XML of the database: And here is some pseudo-XML of the file layout: In this example, the database categorizes goods by a category code (A-Z). The type of good determines the unit of measure. In this imaginary scenario, maybe all but 5 categories have unit of measure assignments. Download ride 2 pc game. Everything else has the unit of measure of furlongs.

If we were converting the values using code (ABAP, perhaps?), we could implement the logic using a case statement: CASE LCATEGORY.WHEN 'D'.LUOM = 'pounds'.WHEN 'C'.LOUM = 'ounce'.WHEN 'B'.LOUM = 'kilogram'.WHEN 'Y'.LOUM = 'Units'.WHEN 'Q'.LOUM = 'SQFT'.WHEN 'J'.LOUM = 'Other unit of measure'.WHEN 'G'.LOUM = 'Quarks'.WHEN 'F'.LOUM = 'Kilograms'.WHEN 'E'.LOUM = 'Units'.WHEN OTHERS.LUOM = 'Furlongs'.ENDCASE.But how would we accomplish the same using an SAP PI message mapping? Well, one option would be to implement the logic with nesting IF blocks, but that has the nasty side effect of producing the messy message mapping shown above. Another option is to implement the case statement in a UDF. But a simpler option exists. Use a FixValues mapping block.Here is the same mapping logic using a FixValues mapping block:And here are the FixValues settings:Another favorite trick of mine is to use FixValues to evaluate TRUE and FALSE.

Graphical Mapping In Sap Pi

This can be useful on filtering at the root level (e.g. A requirement to not send a record when the good is a type not relevant to the report you are generating). In this example mapping, the row will not get generated if the type isn’t a D, A, T, X, S, R, E, or M:And here are the FixValues settings:The FixValues mapping block is a very useful message mapping block that can be used to streamline complicated SAP PI message mappings.

Refer PI 7.1 Blogs:/people/peter.gutsche/blog/2008/10/27/what146s-new-in-sap-netweaver-pi-71original link is brokenNew in SAP PI 7.1Mapping enhancements:1. Graphical variables:/people/2. Function library: In lower releases, you were able to save and manage user-defined functions as part of one message mapping only.

You can now create function libraries independently of specific message mappings, and can use the functions you define in them in multiple message mappings.7.1Concept ofFunction Libraryin ProcessIntegration3. Correcting Structural Inconsistencies.