SAP for Retail Discussions
Join conversations about personalization, omnichannel strategies, and operational excellence in retail using SAP for Retail software.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

What table to find "To be Processed" Sales from tcode WPER

Former Member

‎12-12-2013 10:23 PM

0 Kudos

Hi,

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.

Lance

1 REPLY 1

govind_ramesh
Active Participant

‎12-18-2013 9:59 AM

0 Kudos

Dear Lance,

I do not think there is a repository that holds in all the data you require to see for unprocessed lines.

You might have to depend on table : WPLST to get the Assortment Owner, Date of creation, The reason for being unprocessed...etc.

Also check tables : EDIDC, EDIDS, WPTST

Regards,

Govind