Skip to main content
Question

Data Extraction filter help

  • June 10, 2025
  • 1 reply
  • 19 views
gauri.pai11
Level 3
Forum|alt.badge.img+3

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.

    1 reply

    thomas.guerr
    Level 7
    Forum|alt.badge.img+1
    • thomas.guerr
    • Level 7
    • 13 replies
    • June 11, 2025

    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


    Community Code of ConductAccessibility statement