SELECT DISTINCT	T5.rounded_month AS PeriodsDIM,
		CASE
			WHEN T2.SDDCTO = 'SK' and T2.SDROUT = 'OPK' THEN T2.SDLNTY + ' (NSSF)'
			ELSE T2.SDLNTY + ' (NS' + T2.SDDCTO + ')'
		END AS ScenarioDIM,
		CASE
			WHEN T2.SDDCTO = 'SK' and T2.SDROUT = 'CPK' THEN 'PP'
			ELSE 'SAP'
		END AS ViewDIM,
		'CO013' AS CompanyDIM,
		T1.IMLITM AS ProductDIM,
		CASE
			WHEN T3.ABAC02 in ('', 'NA') THEN 'CT_NA'
			ELSE 'CT_' + T3.ABAC02
		END AS CustomerTypeDIM,
		'B' + CONVERT(VARCHAR, T2.SDAN8) + ' SUR' AS MarketDIM,
		CASE
			WHEN T1.IMSRP5 in ('', 'NA') THEN 'PRDFAM_NA'
			ELSE T1.IMSRP5
		END AS ProdFamDIM,
		CASE
			WHEN T2.SDLITM in ('99910') THEN SUM(T2.SDAEXP)
			WHEN T2.SDDCTO in ('SK') AND T2.SDROUT in ('CPK','OPK') THEN SUM(T2.SDUPRC * T2.SDSOQS)
			ELSE SUM(T2.SDAEXP)
		END AS ExtSales,
		CASE
			WHEN T2.SDDCTO in ('SK') and T2.SDLNTY in ('N') or SDLITM in ('LOSP') THEN 0
			WHEN T2.SDUOM not in ('EA') THEN SUM(T2.SDSOQS * T4.UMCONV)
			ELSE SUM(T2.SDSOQS)
		END AS ExtUnits,
		CASE
			WHEN T2.SDDCTO in ('SK') AND T2.SDROUT in ('CPK','OPK') THEN SUM(T2.SDUNCS * T2.SDSOQS)
			ELSE SUM(T2.SDECST)
		END AS ExtCost,
		t2.sddoco,
		t2.sddcto,
		t2.sdlnty,
		T2.SDGLC
FROM		JDEF4101 T1,
INNER JOIN	JDEF42119 T2 ON T2.SDITM = T1.IMITM and T2.SDIVD >= '2006-09-01' AND T2.SDIVD <= '2006-09-01'
INNER JOIN	JDEF0101 T3 ON T2.SDAN8 = T3.ABAN8
INNER JOIN	vjdeDimensionTimegr T5 ON T2.SDIVD = T5.Date_Key
INNER JOIN	DimensionScenarioDocType T6 ON T2.SDDCTO = T6.SDDCTO AND T2.SDLNTY = T6.SDLNTY
LEFT JOIN	JDEF41002 T4 ON T1.IMITM = T4.UMITM AND T2.SDUOM = T4.UMUM and T4.UMRUM in ('EA')
WHERE		T1.IMSRP5 not in ('CPP','OPP')
		and T1.IMLITM not in ('99MMLASER1')