LOAD t_AR_receivable.LE_ID,

[t_AR_receivable.LCY CODE],

t_AR_receivable.SYSTEM,

date(num#(t_AR_receivable.#DataDateTime, '#.##0,0', ',', '.')) ,

date(num#(t_AR_receivable.#DataDate, '#.##0,0', ',', '.')) ,

t_AR_receivable.FID as FID,

t_AR_receivable.FBILLNO as SALES_GROSS_SALES.process_id,

t_AR_receivable.FCUSTOMERID as FCUSTOMERID,

date(num#(t_AR_receivable.FCREATEDATE, '#.##0,0', ',', '.')) AS SALES_GROSS_SALES.date,

t_AR_receivable.FCURRENCYID as FCURRENCYID ,

t_AR_receivable.FSALEERID as FSALEERID

FROM

[C:\Users\thinkpad\Desktop\QLIKVIEW\SalesGrossSales\t_AR_receivable.qvd]

(qvd);

Inner join

LOAD T_AR_RECEIVABLEENTRY.LE_ID,

[T_AR_RECEIVABLEENTRY.LCY CODE],

T_AR_RECEIVABLEENTRY.SYSTEM,

T_AR_RECEIVABLEENTRY.#DataDateTime,

T_AR_RECEIVABLEENTRY.#DataDate,

T_AR_RECEIVABLEENTRY.FID AS FID,

T_AR_RECEIVABLEENTRY.FENTRYID AS FENTRYID,

T_AR_RECEIVABLEENTRY.FMATERIALID AS FMATERIALID,

T_AR_RECEIVABLEENTRY.FSEQ AS SALES_GROSS_SALES.process_pos_nr,

num#(T_AR_RECEIVABLEENTRY.FALLAMOUNTFOR, '####,##', ',', '.') AS SALES_GROSS_SALES.amount,

num#(T_AR_RECEIVABLEENTRY.FPRICEQTY, '####,##', ',', '.') AS SALES_GROSS_SALES.qty

FROM

[C:\Users\thinkpad\Desktop\QLIKVIEW\SalesGrossSales\T_AR_RECEIVABLEENTRY.qvd]

(qvd);

left join

LOAD T_BD_CUSTOMER.LE_ID,

[T_BD_CUSTOMER.LCY CODE],

T_BD_CUSTOMER.SYSTEM,

T_BD_CUSTOMER.#DataDateTime,

T_BD_CUSTOMER.#DataDate,

T_BD_CUSTOMER.FCUSTID as FCUSTOMERID,

T_BD_CUSTOMER.FNUMBER AS SALES_GROSS_SALES.customer.id

FROM

[C:\Users\thinkpad\Desktop\QLIKVIEW\SalesGrossSales\T_BD_CUSTOMER.qvd]

(qvd);

Left Join

LOAD T_BD_CURRENCY.LE_ID,

[T_BD_CURRENCY.LCY CODE],

T_BD_CURRENCY.SYSTEM,

T_BD_CURRENCY.#DataDateTime,

T_BD_CURRENCY.#DataDate,

T_BD_CURRENCY.FCURRENCYID AS FCURRENCYID ,

T_BD_CURRENCY.FCODE AS SALES_GROSS_SALES.currency

FROM

[C:\Users\thinkpad\Desktop\QLIKVIEW\SalesGrossSales\T_BD_CURRENCY.qvd]

(qvd);

Left join

LOAD T_BD_MATERIAL.LE_ID,

[T_BD_MATERIAL.LCY CODE],

T_BD_MATERIAL.SYSTEM,

T_BD_MATERIAL.#DataDateTime,

date(num#(T_BD_MATERIAL.#DataDate, '#.##0,0', ',', '.')) AS T_BD_MATERIAL.#DataDate,

T_BD_MATERIAL.FMATERIALID as FMATERIALID,

T_BD_MATERIAL.FNUMBER as SALES_GROSS_SALES.article.id

FROM

[C:\Users\thinkpad\Desktop\QLIKVIEW\SalesGrossSales\T_BD_MATERIAL.qvd]

(qvd);

Left join

LOAD T_BD_OPERATORENTRY.LE_ID,

[T_BD_OPERATORENTRY.LCY CODE],

T_BD_OPERATORENTRY.SYSTEM,

T_BD_OPERATORENTRY.#DataDateTime,

T_BD_OPERATORENTRY.#DataDate,

T_BD_OPERATORENTRY.fentryid as FENTRYID,

T_BD_OPERATORENTRY.FSTAFFID as SALES_GROSS_SALES.sales.representative_id

FROM

[C:\Users\thinkpad\Desktop\QLIKVIEW\SalesGrossSales\T_BD_OPERATORENTRY.qvd]

(qvd);

Left join

LOAD T_BD_STAFF_L.LE_ID,

[T_BD_STAFF_L.LCY CODE],

T_BD_STAFF_L.SYSTEM,

T_BD_STAFF_L.#DataDateTime,

T_BD_STAFF_L.#DataDate,

T_BD_STAFF_L.FSTAFFID as SALES_GROSS_SALES.sales.representative_id,

T_BD_STAFF_L.FNAME as SALES_GROSS_SALES.sales.representative.Code

FROM

[C:\Users\thinkpad\Desktop\QLIKVIEW\SalesGrossSales\T_BD_STAFF_L.qvd]

(qvd);