Need suggestion for upgrade a scenario for FILE (FCC) to IDOC with jdbc lookup

[gagandeep_batra]

Hi folks,

my scenario is  FILE to IDOC in which sender side i am using FCC and in Mapping i am using JDBC lookup.

in this each send file have multiple records and for each record output is one idoc and each time it hit the database for each mesage.

now i want to upgrade my scenario means i want to reduce the hit for database for each message .

ex. for 10 record only one message will create and only one time  hit to database..

and jdbc lookup is also need to change to upper level. so it combine for  for all 10 records

plz can you suggest how to proceed with it.

Regards

GAgandeep

[baskar_gopalakrishnan2 · Accepted solution]

> i want to reduce the hit for database for each message

There is shabarish blog that explains about handling multiple records using single call in jdbc lookup. Please search SCN.

I dont see that blog now.. It might have not moved during migration the link was

http://scn.sap.com/people/shabarish.vijayakumar/blog/2010/01/28/graphical-rfc-lookup-and-how-you-can...

[nageshwar_reddy · Accepted solution]

Shabarish Vijayakumar blog is available @ .

You may have to change your lookup to return all the values at once.... Not sure how simple / complex it is in your case.

[gagandeep_batra]

Hi all,

I have created this scenario but problem with mapping context occur plz help me out.

our input is like that

-

  <?xml version="1.0" encoding="utf-8" ?>

- <ns:RFBIBL00_STAHL_FILE_READ_MT xmlns:ns="http://xyz.com/xi/COMMON/POCRecyInvoice">

- <FI_BELEG>

- <BGR00>

  <STYPE>0</STYPE>

  <GROUP>F13002012062</GROUP>

  <MANDT>001</MANDT>

  <USNAM>BATCH</USNAM>

  <START />

  <XKEEP>/</XKEEP>

  <NODATA>/</NODATA>

  </BGR00>

<BBKPF>

  <STYPE>1</STYPE>

  <TCODE>FB01</TCODE>

  <BLDAT>20120621</BLDAT> .

.

.

.

.

.

<BBSEG>

  <STYPE>2</STYPE>

  <TBNAM>BBSEG</TBNAM>

  <NEWBS>50</NEWBS>

  <DUMMYX>2</DUMMYX>

.

.

.

.

<PSEGMENT>/</PSEGMENT>

  <HKTID>/</HKTID>

  <SENDE>/</SENDE>

  </BBSEG>

  </FI_BELEG>

- <FI_BELEG>

- <BGR00>

  <STYPE>0</STYPE>

  <GROUP>F13002012062</GROUP>

  <MANDT>001</MANDT>

  <USNAM>BATCH</USNAM>

  <START />

  <XKEEP>/</XKEEP>

  <NODATA>/</NODATA>

  </BGR00>

<BBKPF>

  <STYPE>1</STYPE>

  <TCODE>FB01</TCODE>

  <BLDAT>20120621</BLDAT> .

.

.

.

.

.

<BBSEG>

  <STYPE>2</STYPE>

  <TBNAM>BBSEG</TBNAM>

  <NEWBS>50</NEWBS>

  <DUMMYX>2</DUMMYX>

.

.

.

.

<PSEGMENT>/</PSEGMENT>

  <HKTID>/</HKTID>

  <SENDE>/</SENDE>

  </BBSEG>

</FI_BELEG>

  </ns:RFBIBL00_STAHL_FILE_READ_MT>

Required output is like:

But coming like that

Plz help me this we are also using jdbc lookup.

Thanks

Gagandeep

[rajasekhar_reddy14]

Hi Gagan,

JDBC look up retriving same value for multiple records or the value is different?

If same value then you can achive uisng one JDBC call other wise you need multiple.

Regards,

Raj

[gagandeep_batra]

Hi Raja,

Actually in jdbc lookup we call database for corresponding account numbers and category for each records but now we change the scenario  that we want    call only one time for all records but at end it merges the output to single idoc. i think there is problem with context.

[nageshwar_reddy]

Gagan,

From results you posted, it looks like one context change is missing.

Can you provide your lookup configuration? That might help in analyzing the issue..

Also, input data is not readable. Can you re-post and ensure it is readable?

What version of PI are you working on?

[gagandeep_batra]

Hi,

Actually i am  using jdbc lookup so i am confuse with mapping logic where to call jdbc lookup.

earlier i am  calling at following level.

but know occurrence is change to "unbounded" so from where i need to change.

Regards

Gagandeep