Loop Fields

[#1]

Managed to create a master calendar  but i get loop..any help would be appreciated.

See the attached for the datamodel

My script for this looks like:

let vStartDate= num(MakeDate(2010));

cal1:

load Date($(vStartDate)+RowNo()-1) as Date

AutoGenerate(num(today())- $(vStartDate)+1);

cal2:

load

*,

year(Date) as [Year],

Month(Date) as [Month],

Day(Date) as Day,

dual((Month(Date) &'-'&Year(Date)),num(MakeDate(year(Date),month(Date)))) as Monthyear

Resident cal1;

drop table cal1;

CalendarLinkage:

LOAD

          %InvoiceBillingDocument_Key,

          'Open Date' as DataType,

          Date(DateValueSales) as Date//CalendarDate

          FROM data\SAPMM\Projects\BSID_OpenItems_Header.qvd (qvd);

CONCATENATE (CalendarLinkage)

LOAD

          %InvoiceBillingDocument_Key ,

          'Close Date' as DataType,

          Date(DateValueSales_C) as Date//CalendarDate

          FROM data\SAPMM\Projects\BSAD_ClosedItems_Header.qvd (qvd);

CONCATENATE (CalendarLinkage)

LOAD

          %KEY_BELNR_BUZEI_KOKRS_MANDT,

          'COVP Date' as DataType,

          Date([Posting Date]) as Date

From Data\SAPMM\Projects\COVP.qvd(Qvd) WHERE Year_Pur>2010 and  Year_Pur<=Year(today()) and Month_Pur<NUM(Month(today(1)));