02-19-2017 12:53 AM - edited 02-03-2024 5:09 PM
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.
Hello
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.