cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Ramu

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Thanks for you reply Harish,

I will check with functional team and get back to you.

sugata_bagchi2
Active Contributor
0 Kudos

Hi Ramu,

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

Sugata B

Former Member
0 Kudos

Thanks for you response Bagchi,

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

iaki_vila
Active Contributor
0 Kudos

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.

Regards

Former Member
0 Kudos

Thanks Vila for your quick response,

I have checked by implementing your suggestions,

payload tested been tested, i haven't found the type 1 and type 3 records in test.

only one mapping level is available.

is there anything else pls.

former_member186851
Active Contributor
0 Kudos

Hello Ramu,

Did you check the UDF section.Any code written to fetch the values.

Former Member
0 Kudos

Thanks for you response Sritharan,

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