C11/System/WERWISO/SQL/schema/ZdbSNCDatawarehouse/views/TFM_vdMarke.sql

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

AS

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


SELECT [Mandant ID]
      ,[Marke]				AS [Marke]
      ,[Bezeichnung]		AS [Bezeichnung]
      --,[Marke (Bez.)]		AS [Marke (Bez.)]
      --,[Bez. (Marke)]		AS [Bez. (Marke)]
      ,[Fabrikat]			AS [Fabrikat]
	  ,[Hersteller]		AS [Hersteller]
  FROM [dMarke]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO