gctools/cognos7/data/mdl/Fin_Belege_SKR_queries.sql

CREATE
	OR

ALTER VIEW [load].[current_date_Prognose]
AS
SELECT --[Bundeslaender Id] AS [Bundeslaender Id],
	[Datum] AS [Bookkeep Date],
	--[Wochentage Id] AS [Wochentage Id],
	[Arbeitstag Mofr] AS [Arbeitstag Mofr],
	[Zaehler Mofr] AS [Zaehler Mofr],
	[Summe Mofr] AS [Summe Mofr],
	--[Arbeitstag Mosa] AS [Arbeitstag Mosa],
	--[Zaehler Mosa] AS [Zaehler Mosa],
	--[Summe Mosa] AS [Summe Mosa],
	--[Feiertage Id] AS [Feiertage Id],
	--[Jahr] AS [Jahr],
	[Arbeitstag Nr Jahr] AS [Arbeitstag Nr Jahr],
	[Gesamt Arbeitstage] AS [Gesamt Arbeitstage] 
FROM [export_csv].[current_date_Prognose]
GO

CREATE
	OR

ALTER VIEW [load].[Kontenrahmen_GC_Struct_SKR]
AS
SELECT --[Konto Nr] AS [Konto Nr],
	--[Konto Bezeichnung] AS [Konto Bezeichnung],
	--[Konto Art_ori] AS [Konto Art_ori],
	[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],
	--[Ebene61] AS [Ebene61],
	--[Ebene62] AS [Ebene62],
	--[Ebene63] AS [Ebene63],
	--[Ebene64] AS [Ebene64],
	--[Ebene65] AS [Ebene65],
	--[Ebene66] AS [Ebene66],
	--[Ebene67] AS [Ebene67],
	--[Ebene68] AS [Ebene68],
	--[Ebene69] AS [Ebene69],
	--[Ebene70] AS [Ebene70],
	[Ebene71] AS [Ebene71],
	[Ebene72] AS [Ebene72],
	[Ebene73] AS [Ebene73],
	[Ebene74] AS [Ebene74],
	[Ebene75] AS [Ebene75],
	[Ebene76] AS [Ebene76],
	[Ebene77] AS [Ebene77],
	--[Ebene78] AS [Ebene78],
	--[Ebene79] AS [Ebene79],
	--[Ebene80] AS [Ebene80],
	[Ebene81] AS [Ebene81],
	[Ebene82] AS [Ebene82],
	[Ebene83] AS [Ebene83],
	[Ebene84] AS [Ebene84],
	[Ebene85] AS [Ebene85],
	[Ebene86] AS [Ebene86],
	--[Ebene87] AS [Ebene87],
	--[Ebene88] AS [Ebene88],
	--[Ebene89] AS [Ebene89],
	--[Ebene90] AS [Ebene90],
	--[Anzahl Stellen_Konto_Nr] AS [Anzahl Stellen_Konto_Nr],
	--[Konto Art] AS [Konto Art],
	[GuV_Bilanz] AS [GuV_Bilanz],
	[Acct Nr] AS [Acct Nr],
	[Konto] AS [Konto],
	[Susa] AS [Susa] 
FROM [export_csv].[Kontenrahmen_GC_Struct_SKR]
GO

CREATE
	OR

ALTER VIEW [load].[Kontenrahmen_GC_Struct_SKR_731000_Teile_intern]
AS
SELECT --[Konto Nr_ori] AS [Konto Nr_ori],
	--[Konto Bezeichnung_ori] AS [Konto Bezeichnung_ori],
	--[Konto Art_ori] AS [Konto Art_ori],
	[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_ori] AS [Ebene4_ori],
	[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],
	--[Ebene61] AS [Ebene61],
	--[Ebene62] AS [Ebene62],
	--[Ebene63] AS [Ebene63],
	--[Ebene64] AS [Ebene64],
	--[Ebene65] AS [Ebene65],
	--[Ebene66] AS [Ebene66],
	--[Ebene67] AS [Ebene67],
	--[Ebene68] AS [Ebene68],
	--[Ebene69] AS [Ebene69],
	--[Ebene70] AS [Ebene70],
	[Ebene71] AS [Ebene71],
	[Ebene72] AS [Ebene72],
	[Ebene73] AS [Ebene73],
	[Ebene74] AS [Ebene74],
	[Ebene75] AS [Ebene75],
	[Ebene76] AS [Ebene76],
	[Ebene77] AS [Ebene77],
	--[Ebene78] AS [Ebene78],
	--[Ebene79] AS [Ebene79],
	--[Ebene80] AS [Ebene80],
	[Ebene81] AS [Ebene81],
	[Ebene82] AS [Ebene82],
	[Ebene83] AS [Ebene83],
	[Ebene84] AS [Ebene84],
	[Ebene85] AS [Ebene85],
	[Ebene86] AS [Ebene86],
	--[Ebene87] AS [Ebene87],
	--[Ebene88] AS [Ebene88],
	--[Ebene89] AS [Ebene89],
	--[Ebene90] AS [Ebene90],
	--[Anzahl Stellen_Konto_Nr] AS [Anzahl Stellen_Konto_Nr],
	--[Konto Art] AS [Konto Art],
	[GuV_Bilanz] AS [GuV_Bilanz],
	[Acct Nr] AS [Acct Nr],
	[Konto] AS [Konto],
	[Susa] AS [Susa],
	--[Konto Nr] AS [Konto Nr],
	--[Konto Bezeichnung] AS [Konto Bezeichnung],
	[Ebene4] AS [Ebene4] 
FROM [export_csv].[Kontenrahmen_GC_Struct_SKR_731000_Teile_intern]
GO

CREATE
	OR

ALTER VIEW [load].[Kontenrahmen_Stk_GC_Struct_SKR]
AS
SELECT --[Konto Nr] AS [Konto Nr],
	--[Konto Bezeichnung] AS [Konto Bezeichnung],
	--[Konto Art_ori] AS [Konto Art_ori],
	[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_ori] AS [Ebene1_ori],
	--[Ebene2_ori] AS [Ebene2_ori],
	[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],
	--[Ebene61] AS [Ebene61],
	--[Ebene62] AS [Ebene62],
	--[Ebene63] AS [Ebene63],
	--[Ebene64] AS [Ebene64],
	--[Ebene65] AS [Ebene65],
	--[Ebene66] AS [Ebene66],
	--[Ebene67] AS [Ebene67],
	--[Ebene68] AS [Ebene68],
	--[Ebene69] AS [Ebene69],
	--[Ebene70] AS [Ebene70],
	[Ebene71] AS [Ebene71],
	[Ebene72] AS [Ebene72],
	[Ebene73] AS [Ebene73],
	[Ebene74] AS [Ebene74],
	[Ebene75] AS [Ebene75],
	[Ebene76] AS [Ebene76],
	[Ebene77] AS [Ebene77],
	--[Ebene78] AS [Ebene78],
	--[Ebene79] AS [Ebene79],
	--[Ebene80] AS [Ebene80],
	--[Anzahl Stellen_Konto_Nr] AS [Anzahl Stellen_Konto_Nr],
	--[Konto Art] AS [Konto Art],
	[GuV_Bilanz] AS [GuV_Bilanz],
	[Acct Nr] AS [Acct Nr],
	[Konto] AS [Konto],
	[Susa] AS [Susa],
	[Ebene1] AS [Ebene1],
	[Ebene2] AS [Ebene2] 
FROM [export_csv].[Kontenrahmen_Stk_GC_Struct_SKR]
GO

CREATE
	OR

ALTER VIEW [load].[SKR_Herkunft_KST]
AS
SELECT [Ebene11] AS [Ebene11],
	--[Ebene13] AS [Ebene13],
	--[Ebene14] AS [Ebene14],
	--[Ebene15] AS [Ebene15],
	--[Ebene16] AS [Ebene16],
	--[Ebene17] AS [Ebene17],
	--[Ebene18] AS [Ebene18],
	--[Ebene19] AS [Ebene19],
	--[Ebene20] AS [Ebene20],
	[KST] AS [KST],
	[KST_mit_Bez] AS [KST_mit_Bez] 
FROM [export_csv].[SKR_Herkunft_KST]
GO

CREATE
	OR

ALTER VIEW [load].[SKR_Marke]
AS
SELECT [Marke_mit_Bez] AS [Marke_mit_Bez],
	[Marke] AS [Marke],
	--[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] 
FROM [export_csv].[SKR_Marke]
GO

CREATE
	OR

ALTER VIEW [load].[SKR_Absatzkanal]
AS
SELECT [Ebene21] AS [Ebene21],
	[Absatzkanal_mit_Bez] AS [Absatzkanal_mit_Bez],
	--[Ebene23] AS [Ebene23],
	--[Ebene24] AS [Ebene24],
	--[Ebene25] AS [Ebene25],
	--[Ebene26] AS [Ebene26],
	--[Ebene27] AS [Ebene27],
	--[Ebene28] AS [Ebene28],
	--[Ebene29] AS [Ebene29],
	--[Ebene30] AS [Ebene30],
	[Absatzkanal] AS [Absatzkanal] 
FROM [export_csv].[SKR_Absatzkanal]
GO

CREATE
	OR

ALTER VIEW [load].[SKR_Kostenträger]
AS
SELECT [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],
	[Kostenträger_mit_Bez] AS [Kostenträger_mit_Bez],
	[Kostenträger] AS [Kostenträger],
	--[Ebene_Marke] AS [Ebene_Marke] 
FROM [export_csv].[SKR_Kostenträger]
GO

CREATE
	OR

ALTER VIEW [load].[Belege_EDS_SKR_mit_Kto_KST]
AS
SELECT --[Nr] AS [Nr],
	--[Name] AS [Name],
	--[Kontoart] AS [Kontoart],
	--[Guv Bilanz] AS [Guv Bilanz],
	--[Soll Haben] AS [Soll Haben],
	--[Kostenstellen Buchung] AS [Kostenstellen Buchung],
	--[Lfd Nr] AS [Lfd Nr],
	--[Sachkontonr] AS [Sachkontonr],
	--[Buchungsdatum] AS [Buchungsdatum],
	--[Belegart] AS [Belegart],
	--[Belegnr] AS [Belegnr],
	--[Beschreibung] AS [Beschreibung],
	--[Gegenkontonr] AS [Gegenkontonr],
	--[Betrag_ori] AS [Betrag_ori],
	--[Kostenstellencode] AS [Kostenstellencode],
	--[Markencode] AS [Markencode],
	--[Benutzer Id] AS [Benutzer Id],
	--[Herkunftscode] AS [Herkunftscode],
	--[Nachbuchung] AS [Nachbuchung],
	--[Menge_ori] AS [Menge_ori],
	--[Mwst Betrag] AS [Mwst Betrag],
	--[Buchungsart] AS [Buchungsart],
	--[Geschäftsbuchungsgruppe] AS [Geschäftsbuchungsgruppe],
	--[Geschäftsbuchungsgruppe_Beschreibung] AS [Geschäftsbuchungsgruppe_Beschreibung],
	--[Produktbuchungsgruppe] AS [Produktbuchungsgruppe],
	--[Produktbuchungsgruppe_Beschreibung] AS [Produktbuchungsgruppe_Beschreibung],
	--[Gegenkontoart] AS [Gegenkontoart],
	--[Transaktionsnr] AS [Transaktionsnr],
	--[Sollbetrag] AS [Sollbetrag],
	--[Habenbetrag] AS [Habenbetrag],
	--[Belegdatum] AS [Belegdatum],
	--[Externe Belegnummer] AS [Externe Belegnummer],
	--[Herkunftsart] AS [Herkunftsart],
	--[Herkunftsnr] AS [Herkunftsnr],
	--[Filialcode] AS [Filialcode],
	--[Hauptbereich] AS [Hauptbereich],
	--[Fahrgestellnummer] AS [Fahrgestellnummer],
	--[Buchnummer] AS [Buchnummer],
	--[Fahrzeug-kz] AS [Fahrzeug-kz],
	--[Umgebucht] AS [Umgebucht],
	--[Storniert] AS [Storniert],
	--[Fahrzeugklassecode] AS [Fahrzeugklassecode],
	--[Code] AS [Code],
	--[Name] AS [(2) Name],
	--[Code] AS [(2) Code],
	--[Bezeichnung] AS [Bezeichnung],
	--[Betrag_1] AS [Betrag_1],
	[Rechtseinheit] AS [Rechtseinheit],
	--[Betrieb_Nr] AS [Betrieb_Nr],
	--[Betrieb_1] AS [Betrieb_1],
	--[Marke_ori] AS [Marke_ori],
	[Mandant] AS [Mandant],
	--[Menge_1] AS [Menge_1],
	[Bookkeep Date] AS [Bookkeep Date],
	[Text] AS [Text],
	--[KST_aus_Code] AS [KST_aus_Code],
	--[Kostenstelle_ori] AS [Kostenstelle_ori],
	--[KST_1] AS [KST_1],
	--[KST_2] AS [KST_2],
	--[Acct Nr_ori] AS [Acct Nr_ori],
	[Acct Nr] AS [Acct Nr],
	[Betrag] AS [Betrag],
	[Menge] AS [Menge],
	[Betrieb] AS [Betrieb],
	--[Benutzer] AS [Benutzer],
	--[Fahrgestellnummer] AS [(2) Fahrgestellnummer],
	--[Modell_neu] AS [Modell_neu],
	--[Markencode] AS [(2) Markencode],
	--[Verkäufer Nr Verkauf] AS [Verkäufer Nr Verkauf],
	--[Konto KZ] AS [Konto KZ],
	--[Plausibilität] AS [Plausibilität],
	--[Marke aus KST] AS [Marke aus KST],
	[Marke] AS [Marke],
	--[Susa] AS [Susa_],
	--[GuV_Bilanz] AS [GuV_Bilanz_],
	--[Absatzkanal_Code] AS [Absatzkanal_Code],
	--[KST_ori] AS [KST_ori],
	[KST] AS [KST],
	--[Mb Makecode] AS [Mb Makecode],
	--[Mb Locationcode] AS [Mb Locationcode],
	--[Mb Costcentercode] AS [Mb Costcentercode],
	--[Mb Distributionchannelcode] AS [Mb Distributionchannelcode],
	--[Mb Costunitcode] AS [Mb Costunitcode],
	--[Mb Taxationcode] AS [Mb Taxationcode],
	[Kostenträger] AS [Kostenträger],
	[Absatzkanal] AS [Absatzkanal],
	[Buchungen ohne Marke] AS [Buchungen mit/ohne Marke],
	[Buchungen ohne KST] AS [Buchungen mit/ohne KST],
	[Kto_KST_Service] AS [Kto_KST_Service] 
FROM [export_csv].[Belege_EDS_SKR_mit_Kto_KST]
GO

CREATE
	OR

ALTER VIEW [load].[Auftraege_EDS_FIBU_SKR51]
AS
SELECT --[A_Belegart] AS [A_Belegart],
	--[A_Nr] AS [A_Nr],
	--[A_Verk An Deb -nr] AS [A_Verk An Deb -nr],
	--[A_Rech An Deb -nr] AS [A_Rech An Deb -nr],
	--[A_Auftragsdatum] AS [A_Auftragsdatum],
	--[A_Buchungsdatum] AS [A_Buchungsdatum],
	--[A_Filialcode] AS [A_Filialcode],
	--[B_Belegart] AS [B_Belegart],
	--[B_Nr] AS [B_Nr],
	--[B_Verk An Deb -nr] AS [B_Verk An Deb -nr],
	--[B_Rech An Deb -nr] AS [B_Rech An Deb -nr],
	--[B_Auftragsdatum] AS [B_Auftragsdatum],
	--[B_Buchungsdatum] AS [B_Buchungsdatum],
	--[B_Interne Belegnr] AS [B_Interne Belegnr],
	--[A_Interner Auftrag] AS [A_Interner Auftrag],
	--[A_Interne Belegnr] AS [A_Interne Belegnr],
	--[B_Filialcode] AS [B_Filialcode],
	--[Belegart] AS [Belegart],
	--[Nr] AS [Nr],
	--[Verk An Deb -nr] AS [Verk An Deb -nr],
	--[Auftragsdatum] AS [Auftragsdatum],
	--[Buchungsdatum] AS [Buchungsdatum],
	--[Filialcode] AS [Filialcode],
	--[Belegnr] AS [Belegnr],
	--[Art] AS [Art],
	--[APO_TEILE_Nr] AS [APO_TEILE_Nr],
	--[Beschreibung] AS [Beschreibung],
	--[Menge_ori] AS [Menge_ori],
	--[Ek-preis] AS [Ek-preis],
	--[Einstandspreis] AS [Einstandspreis],
	--[Einstandsbetrag_ori] AS [Einstandsbetrag_ori],
	--[Vk-preis] AS [Vk-preis],
	--[Verkaufsbetrag_ori] AS [Verkaufsbetrag_ori],
	--[Fakturierbar] AS [Fakturierbar],
	--[Werkstattbuchungsgruppe] AS [Werkstattbuchungsgruppe],
	--[Kostenstellencode] AS [Kostenstellencode],
	--[Markencode] AS [Markencode],
	--[Arbeitstypencode] AS [Arbeitstypencode],
	--[Benutzer Id] AS [Benutzer Id],
	--[Herkunftscode] AS [Herkunftscode],
	--[Postenart] AS [Postenart],
	--[Positiv] AS [Positiv],
	--[Geschäftsbuchungsgruppe] AS [Geschäftsbuchungsgruppe],
	--[Produktbuchungsgruppe] AS [Produktbuchungsgruppe],
	--[Belegdatum] AS [Belegdatum],
	--[Nummernserie] AS [Nummernserie],
	--[Storniert] AS [Storniert],
	--[Buchnr] AS [Buchnr],
	--[Zeitart] AS [Zeitart],
	--[Fahrzeugtyp] AS [Fahrzeugtyp],
	--[Paketnr] AS [Paketnr],
	--[Kostenstellencode Verkauf] AS [Kostenstellencode Verkauf],
	--[Verrechnungspreis] AS [Verrechnungspreis],
	--[Verrechnungsbetrag_ori] AS [Verrechnungsbetrag_ori],
	--[Verrechnungsbetrag (bw)] AS [Verrechnungsbetrag (bw)],
	--[Abgeschlossen] AS [Abgeschlossen],
	--[Fahrgestellnummer] AS [Fahrgestellnummer],
	--[Menge Pro Stunde] AS [Menge Pro Stunde],
	--[Menge (stunde)] AS [Menge (stunde)],
	--[Artikelgruppencode] AS [Artikelgruppencode],
	--[Belegtyp] AS [Belegtyp],
	--[Fahrzeugartencode] AS [Fahrzeugartencode],
	--[Fahrzeugstatus] AS [Fahrzeugstatus],
	--[Marktsegmentcode] AS [Marktsegmentcode],
	--[Hauptgruppencode] AS [Hauptgruppencode],
	--[Untergruppencode] AS [Untergruppencode],
	--[Positionsgruppencode] AS [Positionsgruppencode],
	--[Kundengruppencode] AS [Kundengruppencode],
	--[Ist-menge (stunde)] AS [Ist-menge (stunde)],
	--[Vorgabezeit] AS [Vorgabezeit],
	--[Vorgabezeitart] AS [Vorgabezeitart],
	--[Herkunftsart] AS [Herkunftsart],
	--[Herkunftsnr] AS [Herkunftsnr],
	--[Auftragszeilennr] AS [Auftragszeilennr],
	--[Interne Verrechnung Erfolgt] AS [Interne Verrechnung Erfolgt],
	--[Verrechnungspreis Fix] AS [Verrechnungspreis Fix],
	--[Auftrag Erledigt] AS [Auftrag Erledigt],
	--[Buchungsdatum (letzte Rechn )] AS [Buchungsdatum (letzte Rechn )],
	--[Offen] AS [Offen],
	--[Betrag Int Zu Verrechnen] AS [Betrag Int Zu Verrechnen],
	--[Betrag Int Zu Verrechnen (bw)] AS [Betrag Int Zu Verrechnen (bw)],
	--[Betrag Int Verrechnet] AS [Betrag Int Verrechnet],
	--[Betrag Int Verrechnet (bw)] AS [Betrag Int Verrechnet (bw)],
	--[Serviceberaternr] AS [Serviceberaternr],
	--[Mitarbeiternr] AS [Mitarbeiternr],
	--[Tätigkeitsartcode] AS [Tätigkeitsartcode],
	--[Monteur Nr 1] AS [Monteur Nr 1],
	--[Aw Mont 1] AS [Aw Mont 1],
	--[Monteur Nr 2] AS [Monteur Nr 2],
	--[Aw Mont 2] AS [Aw Mont 2],
	--[Hauptbetrieb] AS [Hauptbetrieb],
	--[Standort] AS [Standort],
	--[FIL-Code] AS [FIL-Code],
	--[FIL-Bezeichnung] AS [FIL-Bezeichnung],
	--[Standort_1] AS [Standort_1],
	--[Vorname] AS [Vorname],
	--[Nachname] AS [Nachname],
	--[Serviceberater] AS [Serviceberater],
	--[Menge] AS [Menge_],
	--[Einstandsbetrag] AS [Einstandsbetrag],
	--[Verkaufsbetrag] AS [Verkaufsbetrag],
	--[Rech An Deb -nr] AS [Rech An Deb -nr],
	--[Umsatzart_ori] AS [Umsatzart_ori],
	--[KD_Nr] AS [KD_Nr],
	--[KD_Name] AS [KD_Name],
	--[Kunde] AS [Kunde],
	--[Invoice Date] AS [Invoice Date],
	--[Order Number] AS [Order Number],
	--[Fabrikat] AS [Fabrikat],
	--[Modell] AS [Modell],
	--[Model] AS [Model],
	--[Fahrzeug] AS [Fahrzeug],
	--[KST_aus_Code] AS [KST_aus_Code],
	--[Kostenstelle_alt] AS [Kostenstelle_alt],
	--[Auftragsart] AS [Auftragsart],
	--[Lines Net Value] AS [Lines Net Value],
	--[Umsatz Lohn] AS [Umsatz Lohn],
	--[Umsatz Teile Service] AS [Umsatz Teile Service],
	--[Umsatz Sonstiges] AS [Umsatz Sonstiges],
	--[Einsatz Teile Service_ori] AS [Einsatz Teile Service_ori],
	--[Einsatz Teile Service] AS [Einsatz Teile Service],
	--[Einsatz Sonstiges] AS [Einsatz Sonstiges],
	--[Menge_pro_Stunde] AS [Menge_pro_Stunde],
	--[Menge_stunde] AS [Menge_stunde],
	--[Sollzeit] AS [Sollzeit],
	--[Sollzeit_Art] AS [Sollzeit_Art],
	--[AW_Mont_1] AS [AW_Mont_1],
	--[AW_Mont_2] AS [AW_Mont_2],
	[verk. Stunden] AS [verk. Stunden],
	--[Soll-Stunden] AS [Soll-Stunden],
	--[benutzte Zeit_ori] AS [benutzte Zeit_ori],
	--[Auftragsnr] AS [Auftragsnr],
	--[A_Belegnr] AS [A_Belegnr],
	--[A_Zeilennr] AS [A_Zeilennr],
	--[Archivierungsdatum] AS [Archivierungsdatum],
	--[Arch Durch Benutzer Id] AS [Arch Durch Benutzer Id],
	--[Archivierungsgrund] AS [Archivierungsgrund],
	--[Umsatzart] AS [Umsatzart],
	[Marke] AS [Marke],
	--[Kundenart] AS [Kundenart],
	--[DG_1] AS [DG_1],
	--[Herkunftsnr (zahlung)] AS [Herkunftsnr (zahlung)],
	--[Hauptdebitor] AS [Hauptdebitor],
	--[DB Teile] AS [DB Teile],
	--[Verr_Betrag] AS [Verr_Betrag],
	--[Nr] AS [(2) Nr],
	--[Beschreibung] AS [(2) Beschreibung],
	--[Basiseinheitencode] AS [Basiseinheitencode],
	--[Vk-preis] AS [(2) Vk-preis],
	--[Einstandspreis_ART] AS [Einstandspreis_ART],
	--[Ek-preis (neuester)_ART] AS [Ek-preis (neuester)_ART],
	--[Einstandspreis (durchschn )_ART] AS [Einstandspreis (durchschn )_ART],
	--[Einstandspreis_Art] AS [Einstandspreis_Art],
	--[EK_preis_neu_Art] AS [EK_preis_neu_Art],
	--[Einstandspreis_Durch_Art] AS [Einstandspreis_Durch_Art],
	--[Heute] AS [Heute],
	--[Tag] AS [Tag],
	--[Buchungsdatum_Datum] AS [Buchungsdatum_Datum],
	--[Rechnungsausgang] AS [Rechnungsausgang],
	--[Order_Number_RG_Ausg] AS [Order_Number_RG_Ausg],
	--[DG_1] AS [(2) DG_1],
	--[DG_2] AS [DG_2],
	--[Durchgänge] AS [Durchgänge],
	[Bookkeep Date] AS [Bookkeep Date],
	[Rechtseinheit] AS [Rechtseinheit],
	[Betrieb] AS [Betrieb],
	[Ebene1] AS [Ebene1],
	[Ebene2] AS [Ebene2],
	[Ebene3] AS [Ebene3],
	[Ebene4] AS [Ebene4],
	[Kostenstelle] AS [Kostenstelle],
	[Ebene11] AS [Ebene11],
	--[KST_vor_Produktbuchungsgruppe] AS [KST_vor_Produktbuchungsgruppe],
	[KST] AS [KST],
	--[Code_Kostenstelle] AS [Code_Kostenstelle],
	--[Name_Kostenstelle] AS [Name_Kostenstelle],
	[KST_mit_Bez] AS [KST_mit_Bez] 
FROM [export_csv].[Auftraege_EDS_FIBU_SKR51]
GO

CREATE
	OR

ALTER VIEW [load].[Belege_EDS_SKR_Stk]
AS
SELECT --[Nr] AS [Nr],
	--[Name] AS [Name],
	--[Kontoart] AS [Kontoart],
	--[Guv Bilanz] AS [Guv Bilanz],
	--[Soll Haben] AS [Soll Haben],
	--[Kostenstellen Buchung] AS [Kostenstellen Buchung],
	--[Lfd Nr] AS [Lfd Nr],
	--[Sachkontonr] AS [Sachkontonr],
	--[Buchungsdatum] AS [Buchungsdatum],
	--[Belegart] AS [Belegart],
	--[Belegnr] AS [Belegnr],
	--[Beschreibung] AS [Beschreibung],
	--[Gegenkontonr] AS [Gegenkontonr],
	--[Betrag_ori] AS [Betrag_ori],
	--[Kostenstellencode] AS [Kostenstellencode],
	--[Markencode] AS [Markencode],
	--[Benutzer Id] AS [Benutzer Id],
	--[Herkunftscode] AS [Herkunftscode],
	--[Nachbuchung] AS [Nachbuchung],
	--[Menge_ori] AS [Menge_ori],
	--[Mwst Betrag] AS [Mwst Betrag],
	--[Buchungsart] AS [Buchungsart],
	--[Geschäftsbuchungsgruppe] AS [Geschäftsbuchungsgruppe],
	--[Geschäftsbuchungsgruppe_Beschreibung] AS [Geschäftsbuchungsgruppe_Beschreibung],
	--[Produktbuchungsgruppe] AS [Produktbuchungsgruppe],
	--[Produktbuchungsgruppe_Beschreibung] AS [Produktbuchungsgruppe_Beschreibung],
	--[Gegenkontoart] AS [Gegenkontoart],
	--[Transaktionsnr] AS [Transaktionsnr],
	--[Sollbetrag] AS [Sollbetrag],
	--[Habenbetrag] AS [Habenbetrag],
	--[Belegdatum] AS [Belegdatum],
	--[Externe Belegnummer] AS [Externe Belegnummer],
	--[Herkunftsart] AS [Herkunftsart],
	--[Herkunftsnr] AS [Herkunftsnr],
	--[Filialcode] AS [Filialcode],
	--[Hauptbereich] AS [Hauptbereich],
	--[Fahrgestellnummer] AS [Fahrgestellnummer],
	--[Buchnummer] AS [Buchnummer],
	--[Fahrzeug-kz] AS [Fahrzeug-kz],
	--[Umgebucht] AS [Umgebucht],
	--[Storniert] AS [Storniert],
	--[Fahrzeugklassecode] AS [Fahrzeugklassecode],
	--[Code] AS [Code],
	--[Name] AS [(2) Name],
	--[Code] AS [(2) Code],
	--[Bezeichnung] AS [Bezeichnung],
	--[Betrag_1] AS [Betrag_1],
	[Rechtseinheit] AS [Rechtseinheit],
	--[Betrieb_Nr] AS [Betrieb_Nr],
	--[Betrieb_1] AS [Betrieb_1],
	--[Marke_ori] AS [Marke_ori],
	[Mandant] AS [Mandant],
	--[Menge_1] AS [Menge_1],
	[Bookkeep Date] AS [Bookkeep Date],
	[Text] AS [Text],
	--[KST_aus_Code] AS [KST_aus_Code],
	--[Kostenstelle_ori] AS [Kostenstelle_ori],
	--[KST_1] AS [KST_1],
	--[KST_2] AS [KST_2],
	--[Acct Nr_ori] AS [Acct Nr_ori],
	[Betrag] AS [Betrag],
	[Menge] AS [Menge],
	[Betrieb] AS [Betrieb],
	--[Benutzer] AS [Benutzer],
	--[Fahrgestellnummer] AS [(2) Fahrgestellnummer],
	--[Modell_neu] AS [Modell_neu],
	--[Markencode] AS [(2) Markencode],
	--[Verkäufer Nr Verkauf] AS [Verkäufer Nr Verkauf],
	--[Konto KZ] AS [Konto KZ],
	--[Plausibilität] AS [Plausibilität],
	--[Marke aus KST] AS [Marke aus KST],
	[Marke] AS [Marke],
	--[Susa] AS [Susa_],
	--[GuV_Bilanz] AS [GuV_Bilanz_],
	--[Absatzkanal_Code] AS [Absatzkanal_Code],
	--[KST_ori] AS [KST_ori],
	[KST] AS [KST],
	--[Mb Makecode] AS [Mb Makecode],
	--[Mb Locationcode] AS [Mb Locationcode],
	--[Mb Costcentercode] AS [Mb Costcentercode],
	--[Mb Distributionchannelcode] AS [Mb Distributionchannelcode],
	--[Mb Costunitcode] AS [Mb Costunitcode],
	--[Mb Taxationcode] AS [Mb Taxationcode],
	[Kostenträger] AS [Kostenträger],
	[Acct Nr] AS [Acct Nr],
	--[Mb Makecode] AS [(2) Mb Makecode],
	--[Code_MB_Cost_Unit] AS [Code_MB_Cost_Unit],
	--[Description_MB_Cost_Unit] AS [Description_MB_Cost_Unit],
	--[Kostenträger_FIBU] AS [Kostenträger_FIBU],
	[Absatzkanal] AS [Absatzkanal],
	[Buchungen ohne Marke] AS [Buchungen mit/ohne Marke],
	[Buchungen ohne KST] AS [Buchungen mit/ohne KST],
	[Kto_KST_Service] AS [Kto_KST_Service] 
FROM [export_csv].[Belege_EDS_SKR_Stk]
GO

CREATE
	OR

ALTER VIEW [load].[Service_EW_Lohn_Plan_2019_SKR51]
AS
SELECT [Rechtseinheit] AS [Rechtseinheit],
	[Betrieb] AS [Betrieb],
	[Ebene1] AS [Ebene1],
	[Ebene2] AS [Ebene2],
	[Ebene3] AS [Ebene3],
	[Ebene4] AS [Ebene4],
	[Ebene5] AS [Ebene5],
	[Kostenstelle] AS [Kostenstelle],
	--[Bookkeep Date_ori] AS [Bookkeep Date_ori],
	--[Wert1] AS [Wert1],
	--[Wert2] AS [Wert2],
	--[Wert3] AS [Wert3],
	--[Wert4] AS [Wert4],
	--[Wert5] AS [Wert5],
	--[Wert6] AS [Wert6],
	--[Wert7] AS [Wert7],
	--[Wert8] AS [Wert8],
	--[Wert9] AS [Wert9],
	--[Wert10] AS [Wert10],
	--[Wert11] AS [Wert11],
	--[Wert12] AS [Wert12],
	--[Datum] AS [Datum],
	--[Arbeitstag Mofr] AS [Arbeitstag Mofr_],
	--[Zaehler Mofr] AS [Zaehler Mofr_],
	--[Summe Mofr] AS [Summe Mofr_],
	--[Monat_Datum] AS [Monat_Datum],
	[EW Lohn Plan Tag] AS [EW Lohn Plan Tag],
	[Bookkeep Date] AS [Bookkeep Date],
	[Ebene11] AS [Ebene11],
	[KST_mit_Bez] AS [KST_mit_Bez] 
FROM [export_csv].[Service_EW_Lohn_Plan_2019_SKR51]
GO

CREATE
	OR

ALTER VIEW [load].[Service_Bruttoertrag_Plan_2019]
AS
SELECT [Rechtseinheit] AS [Rechtseinheit],
	[Betrieb] AS [Betrieb],
	[Ebene1] AS [Ebene1],
	[Ebene2] AS [Ebene2],
	[Ebene3] AS [Ebene3],
	[Ebene4] AS [Ebene4],
	[Ebene5] AS [Ebene5],
	[Kostenstelle] AS [Kostenstelle],
	--[Bookkeep Date_ori] AS [Bookkeep Date_ori],
	--[Wert1] AS [Wert1],
	--[Wert2] AS [Wert2],
	--[Wert3] AS [Wert3],
	--[Wert4] AS [Wert4],
	--[Wert5] AS [Wert5],
	--[Wert6] AS [Wert6],
	--[Wert7] AS [Wert7],
	--[Wert8] AS [Wert8],
	--[Wert9] AS [Wert9],
	--[Wert10] AS [Wert10],
	--[Wert11] AS [Wert11],
	--[Wert12] AS [Wert12],
	--[Datum] AS [Datum],
	--[Arbeitstag Mofr] AS [Arbeitstag Mofr_],
	--[Zaehler Mofr] AS [Zaehler Mofr_],
	--[Summe Mofr] AS [Summe Mofr_],
	--[Monat_Datum] AS [Monat_Datum],
	[Bruttoertrag Soll Tag] AS [Bruttoertrag Soll Tag],
	[Bookkeep Date] AS [Bookkeep Date],
	[Ebene11] AS [Ebene11],
	[KST_mit_Bez] AS [KST_mit_Bez] 
FROM [export_csv].[Service_Bruttoertrag_Plan_2019]
GO

CREATE
	OR

ALTER VIEW [load].[Belege_EDS_SKR_Bilanz_Teilebestand]
AS
SELECT --[Nr] AS [Nr],
	--[Name] AS [Name],
	--[Kontoart] AS [Kontoart],
	--[Guv Bilanz] AS [Guv Bilanz],
	--[Soll Haben] AS [Soll Haben],
	--[Kostenstellen Buchung] AS [Kostenstellen Buchung],
	--[Lfd Nr] AS [Lfd Nr],
	--[Sachkontonr] AS [Sachkontonr],
	--[Buchungsdatum] AS [Buchungsdatum],
	--[Belegart] AS [Belegart],
	--[Belegnr] AS [Belegnr],
	--[Beschreibung] AS [Beschreibung],
	--[Gegenkontonr] AS [Gegenkontonr],
	--[Betrag_ori] AS [Betrag_ori],
	--[Kostenstellencode] AS [Kostenstellencode],
	--[Markencode] AS [Markencode],
	--[Benutzer Id] AS [Benutzer Id],
	--[Herkunftscode] AS [Herkunftscode],
	--[Nachbuchung] AS [Nachbuchung],
	--[Menge_ori] AS [Menge_ori],
	--[Mwst Betrag] AS [Mwst Betrag],
	--[Buchungsart] AS [Buchungsart],
	--[Geschäftsbuchungsgruppe] AS [Geschäftsbuchungsgruppe],
	--[Geschäftsbuchungsgruppe_Beschreibung] AS [Geschäftsbuchungsgruppe_Beschreibung],
	--[Produktbuchungsgruppe] AS [Produktbuchungsgruppe],
	--[Produktbuchungsgruppe_Beschreibung] AS [Produktbuchungsgruppe_Beschreibung],
	--[Gegenkontoart] AS [Gegenkontoart],
	--[Transaktionsnr] AS [Transaktionsnr],
	--[Sollbetrag] AS [Sollbetrag],
	--[Habenbetrag] AS [Habenbetrag],
	--[Belegdatum] AS [Belegdatum],
	--[Externe Belegnummer] AS [Externe Belegnummer],
	--[Herkunftsart] AS [Herkunftsart],
	--[Herkunftsnr] AS [Herkunftsnr],
	--[Filialcode] AS [Filialcode],
	--[Hauptbereich] AS [Hauptbereich],
	--[Fahrgestellnummer] AS [Fahrgestellnummer],
	--[Buchnummer] AS [Buchnummer],
	--[Fahrzeug-kz] AS [Fahrzeug-kz],
	--[Umgebucht] AS [Umgebucht],
	--[Storniert] AS [Storniert],
	--[Fahrzeugklassecode] AS [Fahrzeugklassecode],
	--[Code] AS [Code],
	--[Name] AS [(2) Name],
	--[Code] AS [(2) Code],
	--[Bezeichnung] AS [Bezeichnung],
	--[Betrag_1] AS [Betrag_1],
	[Rechtseinheit] AS [Rechtseinheit],
	--[Betrieb_Nr] AS [Betrieb_Nr],
	--[Betrieb_1] AS [Betrieb_1],
	--[Marke_ori] AS [Marke_ori],
	[Mandant] AS [Mandant],
	--[Menge_1] AS [Menge_1],
	[Bookkeep Date] AS [Bookkeep Date],
	--[Text] AS [Text_],
	--[KST_aus_Code] AS [KST_aus_Code],
	--[Kostenstelle_ori] AS [Kostenstelle_ori],
	--[KST_1] AS [KST_1],
	--[KST_2] AS [KST_2],
	--[Acct Nr] AS [Acct Nr_],
	[Betrag] AS [Betrag_Teilebestand],
	--[Menge] AS [Menge_],
	[Betrieb] AS [Betrieb],
	--[Benutzer] AS [Benutzer],
	--[Fahrgestellnummer] AS [(2) Fahrgestellnummer],
	--[Modell_neu] AS [Modell_neu],
	--[Markencode] AS [(2) Markencode],
	--[Verkäufer Nr Verkauf] AS [Verkäufer Nr Verkauf],
	--[Konto KZ] AS [Konto KZ],
	--[Plausibilität] AS [Plausibilität],
	--[Marke aus KST] AS [Marke aus KST],
	--[Marke] AS [Marke_],
	--[Susa] AS [Susa_],
	--[GuV_Bilanz] AS [GuV_Bilanz_],
	--[Absatzkanal_Code] AS [Absatzkanal_Code],
	--[KST_ori] AS [KST_ori],
	--[KST] AS [KST_],
	--[Mb Makecode] AS [Mb Makecode],
	--[Mb Locationcode] AS [Mb Locationcode],
	--[Mb Costcentercode] AS [Mb Costcentercode],
	--[Mb Distributionchannelcode] AS [Mb Distributionchannelcode],
	--[Mb Costunitcode] AS [Mb Costunitcode],
	--[Mb Taxationcode] AS [Mb Taxationcode],
	--[Kostenträger] AS [Kostenträger_],
	--[Absatzkanal] AS [Absatzkanal_],
	--[Buchungen ohne Marke] AS [Buchungen ohne Marke],
	--[Buchungen ohne KST] AS [Buchungen ohne KST],
	[Ebene1] AS [Ebene1],
	[Ebene2] AS [Ebene2],
	[Ebene3] AS [Ebene3],
	[Ebene4] AS [Ebene4],
	[Ebene5] AS [Ebene5],
	[Ebene6] AS [Ebene6],
	--[Nr] + ' - ' + [Name] AS [Konto_] 
FROM [export_csv].[Belege_EDS_SKR_Bilanz_Teilebestand]
GO