SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE VIEW [dbo].[TFM_vdStandort]

AS

/* Hier findet das Mapping der Spalten zwischen DWH und Transformer statt, der historisch bedingt ist. */

SELECT [Mandant ID]						
      ,[Hauptbetrieb_ID]				AS [Hauptbetrieb_ID]	
      ,[Hauptbetrieb_Name]				AS [Hauptbetrieb_Name]	
      ,[Standort_ID]					AS [Standort_ID]		
      ,[Standort_Name]					AS [Standort_Name]		
      --,[Standortname (ID)]				AS [Standortname (ID)]	
      --,[Standort ID (Name)]				AS [Standort ID (Name)]	
      --,[Marke_ID]						AS [Marke_ID]			
      --,[Marke_Name]						AS [Marke_Name]			
      --,[Gruppe_ID]						AS [Gruppe_ID]			
      --,[Gruppe_Name]					AS [Gruppe_Name]		
  FROM [dStandort]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO