cancel
Showing results for 
Search instead for 
Did you mean: 

Processing point of sale transactions in real-time to S/4 (or ECC)

t_duyser
Explorer
0 Kudos

We are using SAP ERP software for quite a long time and have implemented S/4 Hana (based on the Model Company for Core Retail) for our Belgian grocery stores. Our store in the Netherlands are still running on ECC 6.0, they will move to S/4 in the near future as well.

Both S/4 and ECC have their own CAR application where the sales transactions are processed in real-time via POS DTA. However, the integration from the both CAR-systems to either S/4 and ECC is still batch oriented. Does someone has experience with processing a large number of sales transactions in real-time from CAR to S/4? We have 700 stores with approx. 2000 sales transactions per store per day, which leads to 1.4 million transactions to be processed in S/4. I know that we can aggregate the sales transactions in CAR (idoc WPUUMS) and process the aggregated sales once or several times a day in S/4, however that is still thinking “batch” and not “real-time”. We have several reasons to process the sales in real-time to S/4 and are looking for ways to do that in an efficient and performant way. Any suggestions?

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member335292
Contributor
0 Kudos

Hi Ton,

If you are planning to trigger WPUBON idocs, you are potentially bombarding ECC or S/4 HANA with 1.4million idocs(1.4 million sales transactions - 700 stores*2000 sales transactions)

If you are going ahead with WPUUMS idocs only with article documents, then In that case too you would have to retrigger the idocs once again to be able to perform the sales postings into ECC or S/4 HANA and you would have a dynamic indicator to tell your ECC or S/4 HANA system to indicate these are for billing documents processing. Even in here the number of idocs will be huge as you are potentially duplicating them once for just the article documents and then for reprocessing the same set of data for sales postings(billing documents).

Alternative options that i can think of

1.You can generate WPUUMS idocs near real time(using immediate processing task settings) to ECC or S/4 HANA and get the idocs confirmation from ECC or S/4 HANA that would decrement the entries in TLOGUS table and thereby providing you a near real time visibility of stock positions in CAR using HANA VDMS(Virtual Data Models) - InventoryVisibilityQuery and you can query the data from HANA itself.The number of idocs created in this aggregated approach would be far less as compared to WPUBON idocs(1.4 million idocs) !

NOTE : InventoryVisibility feature in SAP CAR currently supports only WPUUMS idocs as part of the standard solution(doesn't support WPUBON idocs).

2.You can aggregate all the sales data in a certain format with minimum number of fields such as Article||Store||Sales Qty||Sales UoM||Base UoM etc probably every 15mins(for example) and create a file and write it to AL11 SAP directories. This file can then be read by a program from ECC or S4HANA and update the information accordingly.This option would require quite a bit of custom development both in CAR and ECC or S/4 HANA.

Thanks,

Aram.

t_duyser
Explorer
0 Kudos

Thanks for your reply, Aram. You are completely right that real-time isn’t possible nor realistic: near real-time is the best we can achieve.

We indeed need near real-time stock in S/4 for some of our processes. A call to CAR where stock is calculated works for a single article, but for > 1000 at a time it is not efficient. And besides that, in a 24/7 operation there isn’t in fact an “end-of-day” if you understand what I mean…

So I am still wondering whether there aren’t “smart” or “creative” options to get the stock near real-time available in S/4 (instead of calculated in CAR), without having the overload of millions of FI-documents.

I am thinking f.e. of only sending goods movements Idocs from CAR to S/4 (when a sales transaction is received in CAR). By doing this, at least the stock is up-to-date in S/4. The “goods issue” (billing documents) then still has to follow at the end of the day or several times during the day (by WPUUMS with only billing documents, without article/material documents).

Or is it an option to process the sales transactions with WPUBON (only article/material document flagged) in near real-time followed by a WPUUMS at the end of the day (with only billing document flagged)?

I can’t imagine that we are the first company that runs into this problem…

former_member335292
Contributor
0 Kudos

Hi Ton,

Firstly whenever we use the terminology "Real Time" it implicitly translates into Near Real Time. As per my understanding and based on past experiences there is no way you can have your POS transactions appear in the central processing system(POSDM or CAR) within few seconds, as the POS transactions have to pass at least few hurdles- one in the form of file processing(store server /central servers etc) and then a middleware to transfer the data in the right format to CAR. In other words this is also batch processing and not real time.

Coming back to your question of sending Processed sales transactions from CAR to S/4 in real time. This ideally depends on your business requirements

1.Are you planning to have a near real time view of your stock positions(stock on hand) in CAR using Inventory visibility?

2.Do you have intraday forecasts that are in place for which you need to send the updated stocks to S/4?

3.Are you taking out the data out of S/4 for any of your replenishment purposes during the operational hours (Near Real time).

4.Do you want to have a holistic view of stock on hand in your online portal(for example Hybris) where you need to know the omnichannel article availability(near real time)?

If your answer to any of the above questions is "Yes" then you can definitely go with Real time processing of sales transactions from CAR using immediate processing of aggregated sales transactions and creating an outbound idocs WPUUMS or WPUBON (This will again be Near Real time processing) only.

Definitely there are quite a few customers around the globe who are handling somewhere about 5-10mil transactions per day and aggregating and sending the idocs to ECC or S/4.However It also depends on whether your S/4 or ECC system is capable of handling consistent loads of idocs during the whole day(operational hours).

You can also think of enabling near real time processing of idocs for selected stores(for example based on specific LoB, store format etc) to start off with.

Hope it helps.

Thanks,

Aram.

0 Kudos

Thanks for your information, very well explained . it helped.