Skip to main content

Hi team,

I need help in understanding how to apply filter for KONP table in data extraction joining another table.
My requirement is:

1.For A018 table - I need all the records where A018.MATNR =  EKPO.MATNR.
2.For KONP table, all the records from KONP table where A018.KSCHL = KONP.KSCHL

 

If i am trying to implement 1st point in filter condition of A018 extraction as screenshot below,

Data extraction fails with error : Error loading resource A017. The multi-part identifier "ts1.EKPO.MATNR" could not be bound.

Can you please help in this?

 

Thank you in advance.

Hello,

the configuration is not completely clear with the screenshot you sent.
Have you joined the Tables A018 and EKPO in the extraction process?

From my gut I would say that I would rather solve this problem in the transformation. Unless it is the case that table A018 are too big to be extracted without other filter criteria.

BR Thomas

Reply


Community Code of Conduct