Skip to Content
avatar image
Former Member

Data is fetching from a table, how to find it out.

Hi Dear friends and experts,

My scenario is SFTP to IDOC_AAE (SRM)

Procurement data coming from 3rd party to SRM system

The issue is

For example there are:

type 1 record

type 2 record

type 3 record....

In my scenario functional spec states that they have mapped only for type 2 record, for remaining records type 1 and type 3 the data is fetching directly from some tables, to check this to which table PI is mapped with, i have checked the following,

In ID part ( single stack in receiver interfaces OM is available) there is no lookup or anything else, even i have checked in mapping level, there also i found nothing.

No value mapping.

Is there any where else need to look or any logic behind that.

Now user is asking for a change in type 1 record.

please could anyone help me out

Thanks in advance


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 27, 2015 at 03:43 PM

    Hi Ramu,

    I think you have checked all. I can advice this suggestion, with a payload that you have checked some data is look up try to go to the ESR operation mapping test tab and check if something changes, also if you have several mappings inside, go step to step. May be, there is not a lookup and inside the mapping it is using FixValues standard function or similar UDF.


    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2015 at 03:19 AM

    Hi Ramu,

    Did you check if any udf is there which is pulling data from table using pure java jdbc ?

    Sugata B

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for you response Bagchi,

      I have checked for UDF's but nothing i found to fetch the values using java JDBC.

  • avatar image
    Former Member
    Oct 28, 2015 at 04:36 AM

    Hi Rambabu,

    When you say data is being fetched from tables for type 1 & 3, are you referring to the tables within SRM ? Let's say:

    Type 1 - Supplier Master Data/Address data(fetched within the IDOC function within SRM)

    Type 2- Order item data comes from supplier via File(SFTP)

    Type 3 - Summary ( calculated within SRM)

    Is this the case ? Check with your functional team.

    Add comment
    10|10000 characters needed characters exceeded