cancel
Showing results for 
Search instead for 
Did you mean: 

Query CCOM - Receipts

former_member10129
Discoverer
0 Kudos

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

Accepted Solutions (0)

Answers (0)