=======================================================================

=======================================================================

From 09/2019 : PF1 integrated margins is an extrapolation done daily in PURGE_RECYCLAGE_P2

SALES BETWEEN ENTITIES and MEXICANA (5726)

To create integrated margins for PF1-Mexicana, we take integrated margin from a list a material codes sold by various entities (mainly entity 6322) to Mexicana-5726

Then we replace the original plant code by MEX, place source code = PF1, and add corresponding lines for MEX plant in BI4.

-For MATERIAL-XXX (sold from INDUS à to Mexicana à to final customer) :

MEXICANA PF1 market margin = Qty * (Unit Mexicana Std margin + Unit INDUS market margin)

à by material code

-For other material (not sold from INDUS) :

MEXICANA PF1 market margin = Qty * (Unit Mexicana Std margin)

à by material code

Table PF1_MAT_MEX_INT

Table PF1_MAT_MEX_INT has been manually loaded from a file of RCS materials sold by INDUSTRIAL to MEXICANA
File has bee sent by PEPOL

SQL CHART-FLOW