Skip to Content
0
Dec 09, 2022 at 12:37 PM

Query CCOM - Receipts

94 Views

Hello guys.

We are working with Customer CheckOut Manager (CCOM) on a HANA database.

The idea is to create a Calculation View for sales reports.

The basis of the calculation View is as follows:

Select T0.*

FROM ."RECEIPT" T0

INNER JOIN "SALESITEM" T1 ON T1."RECEIPT_OBJECTKEY"=T0."OBJECTKEY"

The problem with the above query is that it does not return sales of Items that are "SALES SETS".

If we query the "SALESITEM" table we find the "Sales Set" Kits but then we cannot associate them with the receipt.

Can anyone help?

Regards

Tomé Cordeiro