Alternative to LIS (for Inventory Control) in S/4 HANA

[prabhu_sundararaman2]

Dear all,

We are in the process of converting our client system from ECC6.0 to S/4 HANA 1610.

In ECC system, the following settings exist:

1. The LIS info-structures for inventory (S031, S032, S033, S034 & S035) are activated, with S031, S032 and S033 setup for V1 update and S034 & S035 with V2 update) - tcode OMO9. LIS reports used are MC.1, MC.4, MC.5, MC.6, MC.9 & MC.A

2. As for material blocking status, "Late exclusive block" is set - tcode OMJI.

We did a trial conversion of sandbox system and found that the above settings did not allow any material document to be posted in the S/4 HANA system. We had to switch to "Exclusive block" (i.e early lock) in order to make the system ready for any posting.

We have studied SAP Note 2319579 that explains the lock behaviour and its relation to LIS. We understand that "Late exclusive block" and "Active LIS" cannot co-exist in S/4 HANA system.

So, we would like to advise our client to go for "late exclusive block" to enjoy the benefits of parallel processing and improved throughput offered in S/4 HANA; and de-activate existing LIS info-structures and offer an alternative to LIS.

Is this an acceptable approach ?

Also, in lieu of the de-activated LIS (S031... S035 and the LIS reports), is there any other reporting functionality that S/4 HANA offers ?

SAP talks about Virtual Data model and HANA Analytics.

Can you please advise what is the alternative to LIS and how to go about implementing the same?

Thanks

Prabhu

[prabhu_sundararaman2]

Hello Jurgen,

We are stuck here.

Can you please advise if there are any FIORI apps that give the same information as LIS info-structures S031, S032....... S035 ?

thanks.

Prabhu

[JL23]

I am not yet on S4HANA, so I can't answer this question.

[prabhu_sundararaman2]

Its Ok Jurgen.

[former_member506928]

Did you guys find any alternative app or tables in SAP S$ for LIS?

[dkle]

Hello all,

I have also been looking for CDS views as an alternative for the obsolete Inventory Management infostructures S031-S035, and CDS-View I_GoodsMovementCube seems to be the best alternative so far:

https://help.sap.com/viewer/8308e6d301d54584a33cd04a9861bc52/1909.001/en-US/f7d909f215d54cb69580bd57...

I tried to replace S031-AGVBR and achieved it with the following query:

SELECT 
   I_GOODSMOVEMENTCUBE~MATERIAL,
   I_GOODSMOVEMENTCUBE~YEARMONTH, 
   SUM( I_GOODSMOVEMENTCUBE~NUMBEROFGOODSISSUES ) AS GIS
 FROM 
  I_GOODSMOVEMENTCUBE
 WHERE 
  MATERIAL = 'WK3' AND
  ISCONSUMPTIONMOVEMENT = 'X'
 GROUP BY
  I_GOODSMOVEMENTCUBE~MATERIAL,
  I_GOODSMOVEMENTCUBE~YEARMONTH
 ORDER BY 
  MATERIAL ASCENDING
  YEARMONTH ASCENDING

Consider creating your own consumption views on top of this CDS-View.

Regards Daniel

[csaba_szommer]

White paper: Simplification List for SAP S/4HANA 1610 Initial Shipment Stack

"MM-IM development plans to provide step by step Virtual Data Model (VDM) views as successor for LIS. The first VDM's released with S/4HANA OP1610 and CE1608 will be for stock quantity reporting."

[prabhu_sundararaman2]

Hi Csaba,

Yes, I got to see that comment in Simplification List.. There are only a few FIORI Apps for Inventory management like Inventory Turnover Analysis as of 1610.. Do you have the list of VDMs/FIORI apps in 1610 ? If yes, please share the same.

Thanks

Prabhu

[former_member257493]

2268063 - S4TWL - Logistic Information System in PP

Remark: For the general approach regarding analytics within SAP S/4HANA see the following analytics simplification item in cross topics area.

The shop floor information system is part of the logistics information system LIS (Note: If you use a material number longer than 18 characters - see restriction note “Extended Material Number in LIS: SAP Note 2232362”). The LIS can be used to compare planned vs. actual parameters like lead time, execution time, queue times, scrap, and so on. The classic ERP implementation of the LIS has some specifics:

• LIS operates on redundant data. Every business transaction not only updates the business documents, but also pre-aggregated data in LIS. Performance suffers, locking conflicts might occur, and memory is wasted. Whether or not LIS causes locking conflicts depends on the frequency of change of the aggregated information. If several transactions want to update the same aggregated dataset in parallel, then you will experience a locking conflict.
• LIS operates on pre-aggregated data. It is not possible to drill down into the individual business documents. Multi-dimensional reporting (aka Slicing and dicing) is only possible for dimensions provided in the pre-aggregated data
• LIS uses an old UI technology making multi-dimensional reporting clumsy
• LIS only supports material numbers with up to 30 characters

Future production analytics will be based on HANA, CDS views aggregating transactional data dynamically, and powerful analytical UIs for multi-dimensional reporting. With this it will be possible to replace the current LIS. You will be able to use classic LIS and the future production analytics in parallel for some time as long as you do not switch off the update of the LIS tables (Functionality available in SAP S/4HANA on-premise edition delivery but not considered as future technology).

LIS is part of the S/4HANA compatibility pack. You can continue using LIS. All LIS tables are available in S/4HANA.

Once future production analytics supports all your analytics requirements, you can switch off the update of the LIS tables. Once you have switched off updating LIS tables, you will notice the following improvements:

• Improved performance of many transactions (fewer tables to update, fewer locking conflicts)
• Less memory required

[2002684820]

Hi William,

Could you please clarify my understanding for the future of LIS?

LIS are part of the S/4HANA Compatibility Pack, but compatibility pack can only be used until 2025. What will happen with LIS structures they are not switched off after 2025 and the compatibility period is over?

Another question is actually about all custom Sxxx structures created for different own needs (reporting & analytics)?

BR,

Mikalai

[former_member257493]

Hello Kim,

Please review the reply from team.

LIS is indeed part of the compatibility pack. I am not exactly sure what is meant with “Switching off LIS structures”. You can switch off the update of LIS tables any time and you have to do it now if you want to benefit from the new inventory data model (parallel goods movements w/o locking conflicts). Most likely we will not delete the LIS artifacts, the LIS code after 2025, but we will also not make sure LIS is always updated by different business events.

SAP provides various CDS views, which aggregate data and translate it into a format similar to LIS. For details seehttps://help.sap.com/viewer/8308e6d301d54584a33cd04a9861bc52/2020.000/en-US/20bb26e53e12432a830a4243.... I’d recommend to create custom CDS views to replace custom Sxxx tables. Custom CDS views can join the before mentioned CDS views provided by SAP. For details on how to create custom CDS views refer tohttps://help.sap.com/viewer/9a281eac983f4f688d0deedc96b3c61c/202009.000/en-US/e30de6eae4d24d70b65996....

If need more detail explain, please consider create incident or request the SAP service for the assessment.

Thanks,

William

[Former Member]

Hi Prabhu, have you found an answer for your question? We have same story here.