2024 Feb 20 4:17 PM - edited 2024 Feb 20 4:19 PM
Hello all,
I have created a custom analytical query to display a lot of sales order related information (sales document, outbound delivery, billing document, production order, inbound delivery etc.).
Everything works as expected, however, the billing document number is displayed in the incorrect row, if a sales order item is rejected.
In the example below, item 10 has been rejected in the sales order. I checked, and it is not included in the outbound delivery document and not included in the billing document.
In the query, no outbound delivery document is displayed in the row of SO item 10, this is correct. However, the billing document is displayed in the row of SO item 10, but not in the rows of SO item 5 and SO item 15, and this is incorrect. Moroever, the billing document item stated is 5, which is on the incorrect row. The billing document number should be displayed in the same rows as the outbound delivery document number.
I have used CDS I_SalesOrderItemCube as primary source and linked CDS I_BillingDocumentItem with the following fields as Join Condition:
Does anyone know the reason and how I can solve this?
Kind regards,
Floyd
Request clarification before answering.
User | Count |
---|---|
6 | |
4 | |
3 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.