File name with currentdate+Filename+Sequence number in sap pi 7.5

[former_member603838]

Hello Experts,

Could you please let me know, how to place the file with currentdate+Filename+Sequence number with FTP file receiver adapter in SAP PI 7.5.

We are not sending any current value in payload.

I've created NRO for IDOC count...shall I use the same thing for generating file name if yes kindly let me know the process.

or

I'm sending that IDOC number along with some other value.....pls let me know how can I use that to generate the file name.

Thanks in advance for kindly response.

Regards,

Spandana Sree

[isuru_fernando24]

Hello Chodisetti,

I would use a UDF for this scenario with a NRO object. Check if this blog post on NRO would help.

Cheers!

Isuru

[manoj_khavatkopp]

Have explained in detail in this thread, please check.

[sugata_bagchi2]

You are Correct Manoj, I am also passing this value to the payload.
I did not realize that. 🙂

Thanks

Sugata

[former_member603047]

Hi Manoj

-- > So my suggestion is to call NRO via JAVA API in mappign itself and tget the count there itself.

Could you please elaborate it.

I've passed constant: $B2B_UEBNRmynroname$B2B_END_UEBNR to UDF in mapping, but its tried to display the filename with this constant value.

Thanks and Regards,

Sree.

[sugata_bagchi2]

Hi Spandana,

Could you please try the steps I have mentioned ?

we are using the same way in one of our EDI interface to populate the interchange control number in ISA segment.

Thanks

Sugata

[former_member603047]

Any suggestions.....

Thanks,

Sree.

[former_member190293]

Hi Spandana!

What do you mean when saying: "I'm passing that NRO in constant"?

Regards, Evgeniy.

[sugata_bagchi2]

Hi Spandana,
you have to do the following / check if you have already done that -

1. create a NRO in b2bic (hope you have b2b add on installed) NRO maintenance

2. for e.g you have created NRO object as - /B2B/XYZ

then assign a constant with value as -

$B2B_UEBNRXYZ$B2B_END_UEBNR --> the pattern is -

$B2B_UEBNR<your NRO name>$B2B_END_UEBNR

3. in the receiver adapter use the adapter module -

localejbs/TransmissionNumberModule, with

param and value as below -

multipleNumbersPerMessage false

4. create an UDF with the 3 inputs - a. currentdate (from standard date function), filename (you want to provide, you can pass it as parameter as well) and the NRO constant created at step 2 above. Then in the UDF you can dynamically set the file name using dynamic configuration.

Else, you can use the UDF ( without NRO) just to dynamically create the file name and use the add counter option in the receiver file adapter. if you just need to add a number.

Thanks

Sugata

[manoj_khavatkopp]

Passing NRO constant value in Dynamic USF and replacing that with count via TransmissionNumberModule does not work . TransmissionNumberModule will replace value only included in Main Payload.

So my suggestion is to call NRO via JAVA API in mappign itself and tget the count there itself.

[sugata_bagchi2]

you can write a udf to dynamically using dynamic configuration to create the the file name in the mapping.

use currentdate, nro number and filename as input.

[former_member603047]

Hello...

Thanks for reply.

I tried in that way only, but NRO number is not taking as I'm passing that NRO in constant.

Suggest me how to do that.

Thanks

Sree