CREATE
	OR

ALTER VIEW [load].[Kontenrahmen]
AS
SELECT --[Konto_Nr] AS [Konto_Nr],
	--[Konto_Bezeichnung] AS [Konto_Bezeichnung],
	--[Konto_Art] AS [Konto_Art],
	[Kostenstelle] AS [Kostenstelle],
	--[STK] AS [STK],
	--[Konto_1] AS [Konto_1],
	--[Konto_2] AS [Konto_2],
	--[Konto_3] AS [Konto_3],
	--[Konto_4] AS [Konto_4],
	--[Konto_5] AS [Konto_5],
	[Ebene1] AS [Ebene1],
	[Ebene2] AS [Ebene2],
	[Ebene3] AS [Ebene3],
	[Ebene4] AS [Ebene4],
	[Ebene5] AS [Ebene5],
	--[Ebene6] AS [Ebene6],
	--[Ebene7] AS [Ebene7],
	--[Ebene8] AS [Ebene8],
	--[Ebene9] AS [Ebene9],
	--[Ebene10] AS [Ebene10],
	--[Ebene11] AS [Ebene11],
	[Ebene12] AS [Ebene12],
	[Ebene13] AS [Ebene13],
	[Ebene14] AS [Ebene14],
	[Ebene15] AS [Ebene15],
	--[Ebene16] AS [Ebene16],
	--[Ebene17] AS [Ebene17],
	--[Ebene18] AS [Ebene18],
	--[Ebene19] AS [Ebene19],
	--[Ebene20] AS [Ebene20],
	[Ebene21] AS [Ebene21],
	[Ebene22] AS [Ebene22],
	[Ebene23] AS [Ebene23],
	[Ebene24] AS [Ebene24],
	[Ebene25] AS [Ebene25],
	[Ebene26] AS [Ebene26],
	--[Ebene27] AS [Ebene27],
	--[Ebene28] AS [Ebene28],
	--[Ebene29] AS [Ebene29],
	--[Ebene30] AS [Ebene30],
	[Ebene31] AS [Ebene31],
	[Ebene32] AS [Ebene32],
	[Ebene33] AS [Ebene33],
	[Ebene34] AS [Ebene34],
	[Ebene35] AS [Ebene35],
	[Ebene36] AS [Ebene36],
	--[Ebene37] AS [Ebene37],
	--[Ebene38] AS [Ebene38],
	--[Ebene39] AS [Ebene39],
	--[Ebene40] AS [Ebene40],
	--[Ebene41] AS [Ebene41],
	--[Ebene42] AS [Ebene42],
	--[Ebene43] AS [Ebene43],
	--[Ebene44] AS [Ebene44],
	--[Ebene45] AS [Ebene45],
	--[Ebene46] AS [Ebene46],
	--[Ebene47] AS [Ebene47],
	--[Ebene48] AS [Ebene48],
	--[Ebene49] AS [Ebene49],
	--[Ebene50] AS [Ebene50],
	--[Ebene51] AS [Ebene51],
	--[Ebene52] AS [Ebene52],
	--[Ebene53] AS [Ebene53],
	--[Ebene54] AS [Ebene54],
	--[Ebene55] AS [Ebene55],
	--[Ebene56] AS [Ebene56],
	--[Ebene57] AS [Ebene57],
	--[Ebene58] AS [Ebene58],
	--[Ebene59] AS [Ebene59],
	--[Ebene60] AS [Ebene60],
	[Konto_Art] AS [GuV_Bilanz],
	left ( [Konto_Nr] , 1 ) AS [Susa],
	[Konto_Nr] AS [Acct Nr],
	[Konto_Nr] + ' - ' + [Konto_Bezeichnung] AS [Konto] 
FROM [export_csv].[Kontenrahmen]
GO

