Hello,

I’m looking for an solution for this challenge:

We have 3 SAP ERP Tables

VTTK (Shipments)

VTTP (Shipment Items)

LIKP (Deliveries)

LIPS (Delivery Items)

VTTK is linked 1:N with VTTP

VTTP is linked 1:1 with LIKP

LIKP is linked 1:N with LIPS

I want to count the distinct material numbers per **shipment**.

Count per delivery works fine: `PU_COUNT_DISTINCT(LIKP, "LIPS"."MATNR")`

But I need it per shipment for further calculating KPI’s, like this:

`PU_COUNT_DISTINCT(VTTK, "LIPS"."MATNR")`

Here I get the following error:

*“No common parent between tables could be found - Please check your schema. The tables VTTK und LIPS do not have a common parent in the schema”*

Within the help I found the BIND function. I tought, this can be the solution:

`PU_COUNT_DISTINCT(VTTK, BIND(LIKP, "LIPS"."MATNR"))`

But here I get an error in the formula.

How can I solve this with a formula und without changing the data schema.

Thanks for you help

Thomas