Skip to Content

File Lookup in PI

Hi All,

Please help me to create the UDF for file lookup to fulfill the below logic.

We have some list of policy number,(200+) When the file arrived with that policy number I have to send the value 'FL' to target field. Policy number apart from that list am validating with BETALING Category field and updating different values.

Am thinking to keep the list of policy number in the .txt file in FTP and access through File lookup.

1. How to maintain the policy numbers? Should I use comma separator or some thing else?

2. How can I read this file over UDF? Please help me to create UDF, Bcoz am not strong on JAVA.

Already gone through this blog File Lookup in UDF - Process Integration - SCN Wiki

Please let me know if you required further details.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 16, 2015 at 11:03 AM


    If values do not change frequently maintain them in FixValues or UDF (200 if conditions).

    If values change frequently try JDBC Lookup or RFC Lookup. File lookup will create concurrency and maintenance issues.

    Defining JDBC Lookups Graphically - SAP Library 

    Add comment
    10|10000 characters needed characters exceeded

    • Arun,

      There will be no performance issue. You can use FixValues or below UDF (200 if conditions)

      public String udf_myLookup(String in, Container container) throws StreamTransformationException{
        if (in.equals("ABC")) return "0001";
        if (in.equals("DEF")) return "0001";
        if (in.equals("GHI")) return "0002";
        return in;
  • Jun 16, 2015 at 09:21 PM

    You can try with value mapping, this is dynamic

    you can transport records

    it is configuration, you need not to modify design objects

    Add comment
    10|10000 characters needed characters exceeded