Lookup tables

[Former Member]

Hi,

Can we do lookups to database tables when we are using XI.

Regards,

venu

[Former Member · Accepted solution]

HI Venu,

Yes you can do that. Do you want to SAP Data Lookup?

Regards

Vijaya

[Former Member · Accepted solution]

Hi,

Yes, the table information which we created in SAP-ISU or SAP-XI.

I think we compulsory should use Abap mapping right?

First issue.

............

Actually I have a plan to move the file names which i have processed into one table which i created .

when i'm processing next file i will check the value in database and i'll process only if the file not available in database table.

Second issue

..............

I need to modify the field value based on the data in SAP-ISU table

Regards,

venu

[Former Member · Accepted solution]

Venu,

Its not mandatory to use ABAP Mapping, depends on your design considerations.

First Issue : I am assuming that incoming is in a file, if that is the case, why are you maintaining a table for the file names. Once the file is processed you can either delete them or archive them. These are options of the file adapter.

Second Issue : Can you explain the scenario in detail.

Regards,

Ravi

[Former Member]

Venu,

You can absolutely do the JDBC Look up form XI.

Please look at the following weblog on the same.

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

Other blogs regardinng look ups

/people/kausik.medavarapu/blog/2005/12/29/csv-file-lookup-with-http-request-and-response-in-xi

/people/sravya.talanki2/blog/2005/12/21/use-this-crazy-piece-for-any-rfc-mapping-lookups

/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

/people/michal.krawczyk2/blog/2005/09/15/xi-rfc-mapping-lookups-from-bc-to-xi

Regards,

Ravi

[Former Member]

Hi Venu,

NO, it's not mandatory to use ABAP mapping.

As I understand your table is in SAP R3 or SAP XI.

All you need to do is in your module process call a RFC ( RFC LOOKUP) which will check your table and you can process or reject the file accordingly.

You can get the Details of RFC lookup in one of the url mentioned above.

Regards

Vijaya

[Former Member]

Hi,

It is possible to do the lookup in XI. Refer to following couple of blogs for the same.

/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

/people/sundararamaprasad.subbaraman/blog/2005/12/09/making-csv-file-lookup-possible-in-sap-xi

Thanks,

Prateek

[Former Member]

HI venu ,

Yes you can surely lookup tables in Xi.

If you want ot lookup SAP tables , the best approach is to use ABAP MAPPING.

If you want to look up a java table, that you can do in JAVA mapping.

Regards,

Yomesh.