Z1K_BATCHES_MENU5 - CO BATCHES: Menu - Submit Z1K_BATCHES5

This transaction runs for three purposes in sequence:

1 – BATCHES

2 – SLOW MOVING

3 – UPIS (Unrealized Profits in Inventory)

This is a replacement of three transactions, respectively:

1- Z1K_BATCHES5 : This program extracts the production related batches by cny ;

main input: FI Documents (BSEG), MM stocks (MBEW, EBEW,MARC,MARCH), MM batches (MCHB, MSLB, MSKU, MSKA,MCH1, MCHA)  

main Output: the table Z1K_BATCH3 ;

only part of the figures are filled in, other data will be inserted by the following programs.

This program:

- calculates the Stock in transit from the FI procedure

- reads the stock values in MM.

- reads the batches master data and quantities

- calculates how old is a batch (in days) based on the Date of Manufacture (hsdat)

- in case of Specialty Polymers Italy , the program reads some more data from the batches to better determine the status of the batch (can be sold, in quality , blocked…)

- valuates the batches based on the article actual price

- the values are not split in Fix/Var/Dep, it’s a full value, as in MM.

2- Z1K_SLOWMOVING5:  This program reads the result of the previous program and updates some figures:

Slow moving amount, i.e. the value of the batch if older than a given number of days (usually a couple of years)

LCM (lower of the cost or market): it reads the sales of the last 6 months and compares the sales price with the stock price; if the sales price is lower than the stock price , the program suggests to reduce the stock price.

It converts the calculated figures to EUR to allow an easier management by the GBU 

Input : Z1K_BATCH3, CO-PCA (glpca)

Output: Z1K_BATCH3

3- Z1K_UPIS_3 : This program reads the result of the previous programs and upload the Z1K_BATCH3 table.

It calculates the legal actual value of the articles with fix/var/dep split .

It calculates the conso value of the articles with fix/var/dep split .

It updates the duties and the freigth costs of the articles coming from abroad, if foreseen by the GBU

Input : Z1K_BATCH3, ML tables

Output: Z1K_BATCH3

Query infoset: CO-BATCH-NEW5

User Group: SXS-PRD1