I am wanting to find what table our POS Sales that have errored on input are stored in. In transaction code WPER there are 2 expandable trees, "To be Processed" where the failures and yet to be processed sales reside and "Processed Successfully" which contains all the sales that have gone through fine.
The processed successfully sales live in table s120, I am hoping there is a table that is sort of like s120 but contains the records of sales that havent successfully processed yet.
The reason for this is I am trying to write a reconciliation SQL query between our POS system and our SAP ECC6 to check that all of the cash receipt numbers we have for yesterday in our POS system are in SAP. I currently have this working using table S120 but as we get around 10 sales per day that end up in error for various reasons they show in my query as sales in the "to be processed" error state do not exist in s120.
Thanks for any help or advice given.