cancel
Showing results for 
Search instead for 
Did you mean: 

Find Material ID from Inconsistent Transactions Through Query

aftab25
Explorer
0 Kudos
386

I need to find inconsistent transactions through a query. I looked into CCO Manager tables but I could not find a way to differentiate between consistent and inconsistent transactions. I can see them through Checkout Monitor but there are hundreds of inconsistent transactions and it will take a long time to do it manually. I want to take material IDs (item codes) out of these inconsistent transactions. Is there any way?

View Entire Topic
R_Zieschang
Contributor

Hi aftab25,

have a look at this:

SELECT
    SI.MaterialID,
    SI.Quantity,
    SI.NetAmount,
    SI.GrossAmount,
    SI.TaxAmount,
    POSR.TotalTaxAmount,
    SI.TaxCode,
    SI.QuantityTypeCode,
    POSR.DiscountAmount,
    POSR.DiscountPercentage,
    POSR.CashDeskID,
    POSR.CashierID,
    POSR.ExternalID,
    POSR.ReleaseStatusCode AS "Status",
    DATEADD(SECOND, POSR.BusinessTransactionDateTime, '1970-01-01') AS "Datum",
    PI.PaymentFormCode,
	EL.ErrorMessage
FROM
    dbo.SalesItem SI
INNER JOIN dbo.PointOfSaleReceipt POSR ON SI.ReceiptKey = POSR.POSKey
INNER JOIN dbo.PaymentDetails PD ON POSR.POSKey = PD.ReceiptKey
INNER JOIN dbo.PaymentItem PI ON PD.PaymentDetailsKey = PI.PayDetailsKey
INNER JOIN dbo.ErrorLog EL ON EL.ReceiptKey = POSR.POSKey
WHERE 
 POSR.ReleaseStatusCode = 'INC'
ORDER BY
    POSR.BusinessTransactionDateTime;

Adjust for your needs!

HTH
Robert

aftab25
Explorer
0 Kudos

Hi Robert,

Thank you but I don't have ReleaseStatusCode field. I see just STATUS field in Receipt table and it has 2 for consistent transactions as well as inconsistent transactions. Similarly I dont see ErrorLog table in my CCO Manager db. We are on B1 integration and CCOM is SQL Server based.

R_Zieschang
Contributor
0 Kudos

Hi aftab25,

you meant the database of CCO Manager? What do you mean with incosistent transactions?
I thought you were referring to the transaction in the SAP CCO Monitor.

Regards
Robert

aftab25
Explorer
0 Kudos

Hi Robert, I am referring to SAP Checkout Monitor. And I want to see the item codes for these transactions through query which have status as Inconsistent.