Enhancement Logic

[Former Member]

Hi

I'm trying to Enhance fields in R/3 for some data source

lets say

I want to pull the data into BI, these are my two new objects

SAT1

SAT2

In SAT1 SAT2

1 12

6 10

7 10

1 12

10 00

12 28

HERE MY Logic is a such a way that i want to pull only SAT1 1 Fields only instead of All fields like (6,7,10,12...)

How can i fetch only 1 fields only instead of all ?

Regards

Rajeev

[Former Member · Accepted solution]

Hi Rajiv,

I am not very clear with your query. So, correct me if I am wrong. You have a datasource where you would add 2 new fields SAT1 and SAT2.

If it is a generic extractore, you can make the changes in your function module.

If it is a standard extractore, you need to append these fields to extract. structure. Then write a customer exit for this standard extractor.

Coding should be as follows:

case i_datasource.

when 'xyz datasource'.

write select statement deriving the value for SAT1 and SAT2 from your database table where values match e_t_data values (structure for ur datasource) and SAT1 = 1.

when others.

exit.

endcase.

The only problem here is that if you have multiple rows in this database table for SAT1 = 1, then you may get wrong details. So make sure that your table has unique entries.

[Former Member · Accepted solution]

so when we right SAT1 =1

IT WILL FETCH ONLY RECORDS VALUE WITH 1 ?

[Former Member · Accepted solution]

You could use "SELECT SINGLE SAT1, SAT2 FROM..." if all you want is to read only the first record...

[Former Member · Accepted solution]

Hi Rajiv,

Yes, if you write select statement with SAT1 =1 then it would fetch only those records that have this value.

Please note that as you have mentioned, you are enhancing you existing datasource, therefore when you fetch using your select statement in customer exit for SAT1 =1, you are only trying to update the two added fields in your structure.

So, if for your particular record in e_t_data, select statement with SAT1 =1 finds any record, it would fill the 2 fields sat1 and sat2, else it wont.

But if your requirement is that based on this select statement's success, you want to filter out data, then you would need to put delete statement if this select statement does not return any data.

[Former Member · Accepted solution]

Hi All

Thanks for helping me

Solved