cancel
Showing results for 
Search instead for 
Did you mean: 

Billing document number incorrectly in custom analytical query (S4HANA public cloud)

floydaus
Participant
0 Kudos
116

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.

Incorrect Billing doc. Item.png

I have used CDS I_SalesOrderItemCube as primary source and linked CDS I_BillingDocumentItem with the following fields as Join Condition:

Join condition billing and SO.png

Does anyone know the reason and how I can solve this?

Kind regards,

Floyd

Accepted Solutions (0)

Answers (0)