Skip to Content

Total Stock in customized LIS

Feb 19, 2017 at 12:53 AM


avatar image

Hi all

I'd create a customized LIS as S999, the idea is that the company can use the info structure S999 as planning table in T code MC93..

S999 info structure is application: 40

info structure type: Standard.

I only have one characteristic: Material

The ratios for Material are:

Total stock: MCBEST-GSBEST

Order quantity: MCVBAP-KWMENG

Delivery quantity: MCLIPS-LFIMG

Also I have other ratios but I believe I only need to create update rules for these three. My problem is to update the ratio Total Stock (MCBEST-GSBEST). I don't find any standard formula or condition to this.

Then I have another issue and it is, that I am using some macros to calculate a projected stock base on order quantity, calculated production quantity, projected sales, etc. But when the result of this macros is negative I want to put zero in that field.

Anybody had face these problems? Somebody know what I should do?

Thanks in advance for any idea

All ideas are welcome.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Héctor Fabio Chacón Feb 24, 2017 at 01:19 PM


I have done some setup and test until now and I looks it is working. For Total Stock (GSBEST field) in MC24 I put the next:

Event: BF

Update type: B

Condition: routine to select only FERT materials in a specific center

Also in rules for Key figure I am using as source field MCBEST-LBKUM and data field for period determination MCBEST-BUDAT

Rules for Characteristic MATERIAL Source table MCBEST and Source table MATNR

It is necessary to run Setup of Statistical Data in this case for Inventory controlling (transaction OLI2).

I hope this information will be useful for somebody.

10 |10000 characters needed characters left characters exceeded