FACT:
LOAD
 	applymap('MAP_BU_NAMES',upper(DATAAREAID),null())  						as BU,
    'BEA270' 																as Type,
    applymap('MAP_BU_NAMES',upper(DATAAREAID),null())&'/'&SALESID 			as ID_Sales,
    INVOICEDATE 															as Date,
    applymap('MAP_BU_NAMES',upper(DATAAREAID),null())&'/'&BEASECTEURVENTEID as %Secteur,
    BEASECTEURVENTEID					     		 						as %Secteur_SN,
    if(BEA552SEGMENTID='PIE','PED',BEA552SEGMENTID) 						as %Segment,
    BEA671NEWSEGMENTID 														as %New_Segment,
	upper(DATAAREAID)&'/'&ITEMID&'/'&CONFIGID 								as %Item,
    upper(DATAAREAID)&'/'&CUSTACCOUNT 										as %Customer,
  	BEAATTRIBUTPAYSID 														as CountryISO,
    BEACHAINEID 															as Billing.Brand,
    ECHANTILLON 															as Billing.ECHANTILLON,

    INVOICEDQTY 																			as #Billing.Qty,

    LINEAMOUNTMST 																			as #Billing.LocalCurrencyAmount,
    applymap('Mapping_PRBU',upper(DATAAREAID)&'/'&ITEMID&'/'&CONFIGID ,0)					as #Billing.LocalCurrencyPRBU_Unit,
    applymap('Mapping_PRBU',upper(DATAAREAID)&'/'&ITEMID&'/'&CONFIGID ,0) * INVOICEDQTY  	as #Billing.LocalCurrencyPRBU_Total,
    LINEAMOUNTMST-((applymap('Mapping_PRBU',upper(DATAAREAID)&'/'&ITEMID&'/'&CONFIGID ,0)*applymap('Map_BU_CoeffPRBU',upper(DATAAREAID),0)) * INVOICEDQTY)
    																						as #Billing.LocalCurrencyPRBU_Margin,

    LINEAMOUNTEURO 																			as #Billing.EuroAmount,
    applymap('Mapping_PRBU',upper(DATAAREAID)&'/'&ITEMID&'/'&CONFIGID ,0) *applymap('MapCurrency3',applymap('MapCurrencyByDataArea',upper(DATAAREAID),0)&'/'&num(floor(INVOICEDATE)),0)
    																						as #Billing.EuroPRBU_Unit,
    (applymap('Mapping_PRBU',upper(DATAAREAID)&'/'&ITEMID&'/'&CONFIGID ,0) * INVOICEDQTY)*applymap('MapCurrency3',applymap('MapCurrencyByDataArea',upper(DATAAREAID),0)&'/'&num(floor(INVOICEDATE)),0)
    																						as #Billing.EuroPRBU_Total,
    (LINEAMOUNTMST-((applymap('Mapping_PRBU',upper(DATAAREAID)&'/'&ITEMID&'/'&CONFIGID ,0)*applymap('Map_BU_CoeffPRBU',upper(DATAAREAID),0)) * INVOICEDQTY))*applymap('MapCurrency3',applymap('MapCurrencyByDataArea',upper(DATAAREAID),0)&'/'&num(floor(INVOICEDATE)),0)
    																						as #Billing.EuroPRBU_Margin

FROM [lib://Global_Qlik_Folder (europe_weqan)/Common\02. QVD\BEA270STATISTIQUESCLIENT.QVD]
(qvd)
where wildmatch(applymap('Map_CustGroup',upper(DATAAREAID)&'/'&CUSTACCOUNT,null()),'C*');


// ...

// ************* This Part get prefix ********************

CONCATENATE(FACT)
LOAD
    applymap('MAP_BU_NAMES',upper(DATAAREAID),null())                               as BU,
    'Overhead'                                                                      as Type,
    autonumber(upper(DATAAREAID)&'/'&ACCOUNTNUM, null())                            as %Account,
    upper(DATAAREAID)&'/'&ACCOUNTNUM                                                as Account,
    TRANSDATE                                                                       as Date,
    AMOUNTMST                                                                       as #Overheads.LocalCurrencyAmount,
    AMOUNTMST * applyMap('Map_Coeff_M2BEU',upper(DATAAREAID)&'/'&DIMENSION2_, 1)    as #Overheads.LocalCurrencyAmount_EU,

    AMOUNTMST*applymap('MapCurrency3',applymap('MapCurrencyByDataArea',upper(DATAAREAID),0)&'/'&num(floor(TRANSDATE)),0)
                                                                                    as #Overheads.EuroAmount,
    (AMOUNTMST*applyMap('Map_Coeff_M2BEU',upper(DATAAREAID)&'/'&DIMENSION2_)) * applymap('MapCurrency3',applymap('MapCurrencyByDataArea',upper(DATAAREAID),0)&'/'&num(floor(TRANSDATE)),0)
                                                                                    as #Overheads.EuroAmount_EU,
    VOUCHER                                                                         as #Overheads.Doc.Number,
    "TXT"                                                                           as #Overheads.Line_Label,
    DIMENSION2_                                                                     as #Overheads.CostCenter,
    subfield(DIMENSION2_,'.',1)                                                     as #Overheads.Department,
    subfield(DIMENSION2_,'.',2)                                                     as #Overheads.SubCostCenter,
    JOURNALNUM                                                                      as #Overheads.%Journal,
    POSTING                                                                         as #Overheads.%Posting_Type
FROM [lib://Global_Qlik_Folder (europe_weqan)/Common\02. QVD\LEDGERTRANS.QVD]
(qvd)
WHERE match(PERIODCODE,'0','1') // 0 = opening // 1 =  normal // 2 = closing //
and Exists(Account, upper(DATAAREAID)&'/'&ACCOUNTNUM)
and num(TRANSDATE)>=num($(vFirstDate))
;

// *********************************************