Skip to Content

Total Stock in customized LIS

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.

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on 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.

    Add comment
    10|10000 characters needed characters exceeded