Skip to Content

Mapping issue

Dear All,

I have requirement that IDOC to JDBC. From ECC they are sending one field only but in receiver side .,i.e in data base need to update 6 feilds.

So remaining 5 fields need to send from PI only. That fields are

1. Sl.NO : its starting from 1 and increased by 1

2. added date : system date

3. added by : constant 1

4. modified by: system date

5. modified by : constant 1

So i have mapped added and modified dates with current date function and added and modified by with constant function.

But the problem is with Sl.NO field. this is also i have mapped with counter but the problem with this is every time the data is coming from ECC the sl.no starts with 1 right. In the data base sl.no must be unique number.

For this is there any solution.kindly let me know.

Regards,

Ramu.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 22, 2017 at 08:21 AM

    Hello Ramu,

    Check the below possibilities.

    1.Map the IDOC number to SI.NO which will be always unique.

    2.If you have B2B Add on use NRO which will be unique for every mapping.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2017 at 09:20 AM

    Ramu,

    You can try this . Till will suffice your requirement.

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded