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:
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?