I’m looking for an solution for this challenge:
We have 3 SAP ERP Tables
VTTP (Shipment Items)
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:
But I need it per shipment for further calculating KPI’s, like this:
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