gctools/cognos7/data/mdl/F_Belege_SKR_SKR_Boettche_queries.sql

CREATE
	OR

ALTER VIEW [load].[current_date_Prognose]
AS
SELECT --[Bundeslaender Id] AS [Bundeslaender Id],
	[Invoice Date] 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],
	month ( [Bookkeep Date] ) AS [Monat_Belege] 
FROM [export_csv].[current_date_Prognose]
GO

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],
	[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] 
FROM [export_csv].[Kontenrahmen]
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],
	--[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_KST_90]
AS
SELECT --[Konto_Nr] AS [Konto_Nr],
	--[_90] AS [_90],
	[Acct Nr] AS [Acct 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],
	[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] 
FROM [export_csv].[Kontenrahmen_KST_90]
GO

CREATE
	OR

ALTER VIEW [load].[Kontenrahmen_STK]
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],
	[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] 
FROM [export_csv].[Kontenrahmen_STK]
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_Herkunft_KST]
AS
SELECT [Ebene11] AS [Ebene11],
	[KST_mit_Bez] AS [KST_mit_Bez],
	--[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] 
FROM [export_csv].[SKR_Herkunft_KST]
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],
	--[Ebene_Marke] AS [Ebene_Marke],
	[Kostenträger_FIBU] AS [Kostenträger_FIBU] 
FROM [export_csv].[SKR_Kostenträger]
GO

CREATE
	OR

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

CREATE
	OR

ALTER VIEW [load].[Belege_EDS_SKR_ohne_KST_90]
AS
SELECT [Rechtseinheit_ID] AS [Rechtseinheit_ID],
	[Rechtseinheit_Name] AS [Rechtseinheit_Name],
	[Betrieb_ID] AS [Betrieb_ID],
	[Betrieb_Name] AS [Betrieb_Name],
	[Konto] AS [Konto],
	[Acct Nr] AS [Acct Nr],
	[Text] AS [Text],
	--[Kostenstelle_ori] AS [Kostenstelle_ori],
	--[KST_mit_Bez_ori] AS [KST_mit_Bez_ori],
	[KST] AS [KST],
	[Markencode] AS [Markencode],
	[Fahrgestellnummer] AS [Fahrgestellnummer],
	[Konto_Buchung] AS [Konto_Buchung],
	--[Marke_mit_Bez_ori] AS [Marke_mit_Bez_ori],
	[Marke] AS [Marke],
	--[Ebene21_ori] AS [Ebene21_ori],
	--[Absatzkanal_mit_Bez_ori] AS [Absatzkanal_mit_Bez_ori],
	[Absatzkanal] AS [Absatzkanal],
	--[Ebene31_ori] AS [Ebene31_ori],
	--[Kostenträger_mit_Bez_ori] AS [Kostenträger_mit_Bez_ori],
	[Kostenträger_FIBU] AS [Kostenträger_FIBU],
	[Ebene71] AS [Ebene71],
	[Ebene72] AS [Ebene72],
	[Ebene73] AS [Ebene73],
	[Ebene74] AS [Ebene74],
	[Ebene75] AS [Ebene75],
	[Ebene76] AS [Ebene76],
	[Ebene77] AS [Ebene77],
	--[Ebene81] AS [Ebene81],
	--[Ebene82] AS [Ebene82],
	--[Ebene83] AS [Ebene83],
	--[Ebene84] AS [Ebene84],
	--[Ebene85] AS [Ebene85],
	--[Ebene86] AS [Ebene86],
	[GuV_Bilanz] AS [GuV_Bilanz],
	[Susa] AS [Susa],
	[Mandant] AS [Mandant],
	[Ist] AS [Ist],
	[Menge] AS [Menge],
	--[Fabrikat] AS [Fabrikat],
	--[Fabrikat_Order_By] AS [Fabrikat_Order_By],
	[Bookkeep Date] AS [Bookkeep Date],
	[Ebene61] AS [Ebene61],
	[Ebene62] AS [Ebene62],
	[Ebene63] AS [Ebene63],
	[Ebene64] AS [Ebene64],
	[Ebene65] AS [Ebene65],
	[Ebene66] AS [Ebene66],
	month ( [Bookkeep Date] ) AS [Monat_Belege] 
FROM [export_csv].[Belege_EDS_SKR_ohne_KST_90]
GO

CREATE
	OR

ALTER VIEW [load].[Belege_EDS_SKR_KST_90]
AS
SELECT [Rechtseinheit_ID] AS [Rechtseinheit_ID],
	[Rechtseinheit_Name] AS [Rechtseinheit_Name],
	[Betrieb_ID] AS [Betrieb_ID],
	[Betrieb_Name] AS [Betrieb_Name],
	[Konto] AS [Konto],
	[Acct Nr] AS [Acct Nr],
	[Text] AS [Text],
	--[Kostenstelle_ori] AS [Kostenstelle_ori],
	--[KST_mit_Bez_ori] AS [KST_mit_Bez_ori],
	[KST] AS [KST],
	[Markencode] AS [Markencode],
	[Fahrgestellnummer] AS [Fahrgestellnummer],
	[Konto_Buchung] AS [Konto_Buchung],
	--[Marke_mit_Bez_ori] AS [Marke_mit_Bez_ori],
	[Marke] AS [Marke],
	--[Ebene21_ori] AS [Ebene21_ori],
	--[Absatzkanal_mit_Bez_ori] AS [Absatzkanal_mit_Bez_ori],
	[Absatzkanal] AS [Absatzkanal],
	--[Ebene31_ori] AS [Ebene31_ori],
	--[Kostenträger_mit_Bez_ori] AS [Kostenträger_mit_Bez_ori],
	[Kostenträger_FIBU] AS [Kostenträger_FIBU],
	[Ebene71] AS [Ebene71],
	[Ebene72] AS [Ebene72],
	[Ebene73] AS [Ebene73],
	[Ebene74] AS [Ebene74],
	[Ebene75] AS [Ebene75],
	[Ebene76] AS [Ebene76],
	[Ebene77] AS [Ebene77],
	--[Ebene81] AS [Ebene81],
	--[Ebene82] AS [Ebene82],
	--[Ebene83] AS [Ebene83],
	--[Ebene84] AS [Ebene84],
	--[Ebene85] AS [Ebene85],
	--[Ebene86] AS [Ebene86],
	[GuV_Bilanz] AS [GuV_Bilanz],
	[Susa] AS [Susa],
	[Mandant] AS [Mandant],
	[Ist] AS [Ist],
	[Menge] AS [Menge],
	--[Fabrikat] AS [Fabrikat],
	--[Fabrikat_Order_By] AS [Fabrikat_Order_By],
	[Bookkeep Date] AS [Bookkeep Date],
	[Ebene61] AS [Ebene61],
	[Ebene62] AS [Ebene62],
	[Ebene63] AS [Ebene63],
	[Ebene64] AS [Ebene64],
	[Ebene65] AS [Ebene65],
	[Ebene66] AS [Ebene66],
	month ( [Bookkeep Date] ) AS [Monat_Belege] 
FROM [export_csv].[Belege_EDS_SKR_KST_90]
GO

CREATE
	OR

ALTER VIEW [load].[Belege_EDS_SKR_Stk]
AS
SELECT [Rechtseinheit_ID] AS [Rechtseinheit_ID],
	[Rechtseinheit_Name] AS [Rechtseinheit_Name],
	[Betrieb_ID] AS [Betrieb_ID],
	[Betrieb_Name] AS [Betrieb_Name],
	[Konto] AS [Konto],
	[Acct Nr] AS [Acct Nr],
	[Text] AS [Text],
	--[Kostenstelle_ori] AS [Kostenstelle_ori],
	--[KST_mit_Bez_ori] AS [KST_mit_Bez_ori],
	[KST] AS [KST],
	[Markencode] AS [Markencode],
	[Fahrgestellnummer] AS [Fahrgestellnummer],
	[Konto_Buchung] AS [Konto_Buchung],
	--[Marke_mit_Bez_ori] AS [Marke_mit_Bez_ori],
	[Marke] AS [Marke],
	--[Ebene21_ori] AS [Ebene21_ori],
	--[Absatzkanal_mit_Bez_ori] AS [Absatzkanal_mit_Bez_ori],
	[Absatzkanal] AS [Absatzkanal],
	--[Ebene31_ori] AS [Ebene31_ori],
	--[Kostenträger_mit_Bez_ori] AS [Kostenträger_mit_Bez_ori],
	[Kostenträger_FIBU] AS [Kostenträger_FIBU],
	[Ebene71] AS [Ebene71],
	[Ebene72] AS [Ebene72],
	[Ebene73] AS [Ebene73],
	[Ebene74] AS [Ebene74],
	[Ebene75] AS [Ebene75],
	[Ebene76] AS [Ebene76],
	[Ebene77] AS [Ebene77],
	--[Ebene81] AS [Ebene81],
	--[Ebene82] AS [Ebene82],
	--[Ebene83] AS [Ebene83],
	--[Ebene84] AS [Ebene84],
	--[Ebene85] AS [Ebene85],
	--[Ebene86] AS [Ebene86],
	[GuV_Bilanz] AS [GuV_Bilanz],
	[Susa] AS [Susa],
	[Mandant] AS [Mandant],
	[Ist] AS [Ist_Stk],
	[Menge] AS [Menge],
	--[Fabrikat] AS [Fabrikat],
	--[Fabrikat_Order_By] AS [Fabrikat_Order_By],
	[Bookkeep Date] AS [Bookkeep Date],
	[Ebene61] AS [Ebene61],
	[Ebene62] AS [Ebene62],
	[Ebene63] AS [Ebene63],
	[Ebene64] AS [Ebene64],
	[Ebene65] AS [Ebene65],
	[Ebene66] AS [Ebene66],
	month ( [Bookkeep Date] ) AS [Monat_Belege] 
FROM [export_csv].[Belege_EDS_SKR_Stk]
GO