Question
No common parent for calculating time difference
Hi all,
Currently we are doing an analysis on late Goods Receipt (i.e. Invoice receipt happens before Goods receipt). This is done based on the data model below:
image.png1032482 32.3 KB
However, now we got stuck on the issue how to calculate the time difference between the goods receipt and the invoice receipt. Using DATEDIFF(dd, MSEG.BUDAT_MKPF, RBKP.BUDAT) results in the error that these tables do not have a common parent in the schema.
Any ideas on how to link these fields and calculate the delta in days?
Thanks!
If you define activities in your eventlog for these timestamps you can simply use the CALC_THROUGHPUT, no need to go to the actual tables. Also, if I may offer some advice, Id recommend simplifying your datamodel (why do you have 2 activity tables!?), and trying to connect as much directly to your case table as possible to avoid the no common parent error.
-Tyler
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.