C11/System/ARI/IQD/NW_GW/NW_GW_VK_TIM.sql

SELECT "No" AS "No",
	"Name" AS "Name",
	"Account Type" AS "Account Type",
	"Department Code_2" AS "Department Code_2",
	"Make Code_2" AS "Make Code_2",
	"Income Balance" AS "Income Balance",
	"Entry No" AS "Entry No",
	"G L Account No" AS "G L Account No",
	"Posting Date" AS "Posting Date",
	"Document Type" AS "Document Type",
	"Document No" AS "Document No",
	"Description" AS "Description",
	"Amount" AS "Amount",
	"Bal Account No" AS "Bal Account No",
	"Department Code" AS "Department Code",
	"Make Code" AS "Make Code",
	"User Id" AS "User Id",
	"Source Code" AS "Source Code",
	"Quantity" AS "Quantity",
	"Debit Amount" AS "Debit Amount",
	"Credit Amount" AS "Credit Amount",
	"Document Date" AS "Document Date",
	"Source Type" AS "Source Type",
	"Source No" AS "Source No",
	"No Series" AS "No Series",
	"Branch Code" AS "Branch Code",
	"Main Area" AS "Main Area",
	"Vin" AS "Vin",
	"Book No" AS "Book No",
	"Veh Source Code" AS "Veh Source Code",
	"Betrag" AS "Betrag",
	"Vin_Vehicle" AS "Vin_Vehicle",
	"Vehicle Status" AS "Vehicle Status",
	"Model_ori" AS "Model_ori",
	"Type" AS "Type",
	"Class" AS "Class",
	"Model No" AS "Model No",
	"Hauptbetrieb" AS "Hauptbetrieb",
	"Standort_alt" AS "Standort_alt",
	"Make Code_Vehicle" AS "Make Code_Vehicle",
	"Fabrikat_ori" AS "Fabrikat_ori",
	"Model" AS "Model",
	"Market Segment Code" AS "Market Segment Code",
	"Modellbez" AS "Modellbez",
	"Fahrzeugart" AS "Fahrzeugart",
	"Vat Prod Posting Group" AS "Vat Prod Posting Group",
	"Fahrzeugtyp_alt" AS "Fahrzeugtyp_alt",
	"FZG" AS "FZG",
	"Location Code" AS "Location Code",
	"VB_Einkauf" AS "VB_Einkauf",
	"Purchase Receipt Date" AS "Purchase Receipt Date",
	"Standtage_ori" AS "Standtage_ori",
	"Standtagestaffel" AS "Standtagestaffel",
	"Initial Registration" AS "Initial Registration",
	"EZ/Eingang" AS "EZ/Eingang",
	"Polster" AS "Polster",
	"Farbe" AS "Farbe",
	"Einsatz_ori" AS "Einsatz_ori",
	"Heute" AS "Heute",
	"Fahrzeugstatus" AS "Fahrzeugstatus",
	"FZG-Liste" AS "FZG-Liste",
	"Anzahl" AS "Anzahl",
	"Standtage" AS "Standtage",
	"Inventory Posting Group" AS "Inventory Posting Group",
	"Date Of Sale" AS "Date Of Sale",
	"Invoice Date" AS "Invoice Date",
	"Customer No" AS "Customer No",
	"No_Customer" AS "No_Customer",
	"Name_Customer" AS "Name_Customer",
	"Kunde" AS "Kunde",
	"Customer Type" AS "Customer Type",
	"Kundenart" AS "Kundenart",
	"Old Customer No_2" AS "Old Customer No_2",
	"Old Customer No" AS "Old Customer No",
	"No_Vorbesitzer" AS "No_Vorbesitzer",
	"Name_Vorbesitzer" AS "Name_Vorbesitzer",
	"Vorbesitzer" AS "Vorbesitzer",
	"Engine Code" AS "Engine Code",
	"Motor Code" AS "Motor Code",
	"Gesch�ftsart" AS "Gesch�ftsart",
	"FZG_Liste_1_ori" AS "FZG_Liste_1_ori",
	"FZG_Liste_2" AS "FZG_Liste_2",
	"FZG_Liste_3" AS "FZG_Liste_3",
	"FZG_Liste_4" AS "FZG_Liste_4",
	"Erl�s" AS "Erl�s",
	"Einsatz" AS "Einsatz",
	"EK Fahrzeug" AS "EK Fahrzeug",
	"Bonus" AS "Bonus",
	"int. Kosten" AS "int. Kosten",
	"Current Branch Book No" AS "Current Branch Book No",
	"Current Book No" AS "Current Book No",
	"Summe EK-FZG" AS "Summe EK-FZG",
	"Fabrikat" AS "Fabrikat",
	"Buchnummer gleich_ja_nein" AS "Buchnummer gleich_ja_nein",
	"Menge1" AS "Menge1",
	"Menge2" AS "Menge2",
	"Menge3" AS "Menge3",
	"Menge4" AS "Menge4",
	"VIN + PostingDate" AS "VIN + PostingDate",
	SUM("Menge4") OVER (PARTITION BY "Vin") AS "Summe Menge4",
	"Menge_2_test" AS "Menge_2_test",
	"Menge3_test" AS "Menge3_test",
	"Menge4_test" AS "Menge4_test",
	"Fahrzeugart_Schmidt" AS "Fahrzeugart_Schmidt",
	"Salespers Purch Code_VLE" AS "Salespers Purch Code_VLE",
	"Code_f�r_VEH_Ledger_Entry" AS "Code_f�r_VEH_Ledger_Entry",
	"Name_f�r_VEH_Ledger_Entry" AS "Name_f�r_VEH_Ledger_Entry",
	"Verk�ufer" AS "Verk�ufer",
	"FZG_Liste_1_falsch" AS "FZG_Liste_1_falsch",
	"FZG_Liste_0_ori" AS "FZG_Liste_0_ori",
	"FZG_Liste_1" AS "FZG_Liste_1",
	"FZG_Liste_0" AS "FZG_Liste_0",
	"Beleg" AS "Beleg",
	"Standort_FIBU" AS "Standort_FIBU",
	"Fahrzeugart_neu" AS "Fahrzeugart_neu",
	"Standort" AS "Standort",
	"Summe_Betrag" AS "Summe_Betrag",
	"Country Code_Kunde" AS "Country Code_Kunde",
	"Vat Bus Posting Group_Kunde" AS "Vat Bus Posting Group_Kunde",
	"FZG_Liste_5_ori" AS "FZG_Liste_5_ori",
	"Customer Group Code" AS "Customer Group Code",
	"FZG_Liste_5" AS "FZG_Liste_5",
	"FZG_Liste_6" AS "FZG_Liste_6",
	"FZG_Liste_7" AS "FZG_Liste_7",
	"FZG_Detail" AS "FZG_Detail",
	"Anz. S�tze" AS "Anz. S�tze",
	"Menge_final" AS "Menge_final",
	"No_Item" AS "No_Item",
	"Description_Item" AS "Description_Item",
	"Vehicle Type Code_Item" AS "Vehicle Type Code_Item",
	"Modell_zwischen" AS "Modell_zwischen",
	"Vehicle Category Code" AS "Vehicle Category Code",
	"Summe Erl�s FZG" AS "Summe Erl�s FZG",
	"Erl�se FZG" AS "Erl�se FZG",
	"Modell_final" AS "Modell_final",
	"Fahrzeugtyp" AS "Fahrzeugtyp"
FROM (
	SELECT "No" AS "No",
		"Name" AS "Name",
		"Account Type" AS "Account Type",
		"Department Code_2" AS "Department Code_2",
		"Make Code_2" AS "Make Code_2",
		"Income Balance" AS "Income Balance",
		"Entry No" AS "Entry No",
		"G L Account No" AS "G L Account No",
		"Posting Date" AS "Posting Date",
		"Document Type" AS "Document Type",
		"Document No" AS "Document No",
		"Description" AS "Description",
		"Amount" AS "Amount",
		"Bal Account No" AS "Bal Account No",
		"Department Code" AS "Department Code",
		"Make Code" AS "Make Code",
		"User Id" AS "User Id",
		"Source Code" AS "Source Code",
		"Quantity" AS "Quantity",
		"Debit Amount" AS "Debit Amount",
		"Credit Amount" AS "Credit Amount",
		"Document Date" AS "Document Date",
		"Source Type" AS "Source Type",
		"Source No" AS "Source No",
		"No Series" AS "No Series",
		"Branch Code" AS "Branch Code",
		"Main Area" AS "Main Area",
		"Vin" AS "Vin",
		"Book No" AS "Book No",
		"Veh Source Code" AS "Veh Source Code",
		"Betrag" AS "Betrag",
		"Vin_Vehicle" AS "Vin_Vehicle",
		"Vehicle Status" AS "Vehicle Status",
		"Model_ori" AS "Model_ori",
		"Type" AS "Type",
		"Class" AS "Class",
		"Model No" AS "Model No",
		"Hauptbetrieb" AS "Hauptbetrieb",
		"Standort_alt" AS "Standort_alt",
		"Make Code_Vehicle" AS "Make Code_Vehicle",
		"Fabrikat_ori" AS "Fabrikat_ori",
		"Model" AS "Model",
		"Market Segment Code" AS "Market Segment Code",
		"Modellbez" AS "Modellbez",
		"Fahrzeugart" AS "Fahrzeugart",
		"Vat Prod Posting Group" AS "Vat Prod Posting Group",
		"Fahrzeugtyp_alt" AS "Fahrzeugtyp_alt",
		"FZG" AS "FZG",
		"Location Code" AS "Location Code",
		"VB_Einkauf" AS "VB_Einkauf",
		"Purchase Receipt Date" AS "Purchase Receipt Date",
		"Standtage_ori" AS "Standtage_ori",
		"Standtagestaffel" AS "Standtagestaffel",
		"Initial Registration" AS "Initial Registration",
		"EZ/Eingang" AS "EZ/Eingang",
		"Polster" AS "Polster",
		"Farbe" AS "Farbe",
		"Einsatz_ori" AS "Einsatz_ori",
		"Heute" AS "Heute",
		"Fahrzeugstatus" AS "Fahrzeugstatus",
		"FZG-Liste" AS "FZG-Liste",
		"Anzahl" AS "Anzahl",
		"Standtage" AS "Standtage",
		"Inventory Posting Group" AS "Inventory Posting Group",
		"Date Of Sale" AS "Date Of Sale",
		"Invoice Date" AS "Invoice Date",
		"Customer No" AS "Customer No",
		"No_Customer" AS "No_Customer",
		"Name_Customer" AS "Name_Customer",
		"Kunde" AS "Kunde",
		"Customer Type" AS "Customer Type",
		"Kundenart" AS "Kundenart",
		"Old Customer No_2" AS "Old Customer No_2",
		"Old Customer No" AS "Old Customer No",
		"No_Vorbesitzer" AS "No_Vorbesitzer",
		"Name_Vorbesitzer" AS "Name_Vorbesitzer",
		"Vorbesitzer" AS "Vorbesitzer",
		"Engine Code" AS "Engine Code",
		"Motor Code" AS "Motor Code",
		"Gesch�ftsart" AS "Gesch�ftsart",
		"FZG_Liste_1_ori" AS "FZG_Liste_1_ori",
		"FZG_Liste_2" AS "FZG_Liste_2",
		"FZG_Liste_3" AS "FZG_Liste_3",
		"FZG_Liste_4" AS "FZG_Liste_4",
		"Erl�s" AS "Erl�s",
		"Einsatz" AS "Einsatz",
		"EK Fahrzeug" AS "EK Fahrzeug",
		"Bonus" AS "Bonus",
		"int. Kosten" AS "int. Kosten",
		"Current Branch Book No" AS "Current Branch Book No",
		"Current Book No" AS "Current Book No",
		"Summe EK-FZG" AS "Summe EK-FZG",
		"Fabrikat" AS "Fabrikat",
		"Buchnummer gleich_ja_nein" AS "Buchnummer gleich_ja_nein",
		"Menge1" AS "Menge1",
		"Menge2" AS "Menge2",
		"Menge3" AS "Menge3",
		"Menge4" AS "Menge4",
		"VIN + PostingDate" AS "VIN + PostingDate",
		COUNT("Vin") OVER (PARTITION BY c248) AS "Menge_2_test",
		("Menge1" / COUNT("Vin") OVER (PARTITION BY c248)) AS "Menge3_test",
		CASE 
			WHEN ("Document No" LIKE 'VGGF%')
				THEN (("Menge1" / COUNT("Vin") OVER (PARTITION BY c248)) * - 1)
			ELSE ("Menge1" / COUNT("Vin") OVER (PARTITION BY c248))
			END AS "Menge4_test",
		"Fahrzeugart_Schmidt" AS "Fahrzeugart_Schmidt",
		"Salespers Purch Code_VLE" AS "Salespers Purch Code_VLE",
		"Code_f�r_VEH_Ledger_Entry" AS "Code_f�r_VEH_Ledger_Entry",
		"Name_f�r_VEH_Ledger_Entry" AS "Name_f�r_VEH_Ledger_Entry",
		"Verk�ufer" AS "Verk�ufer",
		"FZG_Liste_1_falsch" AS "FZG_Liste_1_falsch",
		"FZG_Liste_0_ori" AS "FZG_Liste_0_ori",
		"FZG_Liste_1" AS "FZG_Liste_1",
		"FZG_Liste_0" AS "FZG_Liste_0",
		"Beleg" AS "Beleg",
		"Standort_FIBU" AS "Standort_FIBU",
		"Fahrzeugart_neu" AS "Fahrzeugart_neu",
		"Standort" AS "Standort",
		"Summe_Betrag" AS "Summe_Betrag",
		"Country Code_Kunde" AS "Country Code_Kunde",
		"Vat Bus Posting Group_Kunde" AS "Vat Bus Posting Group_Kunde",
		"FZG_Liste_5_ori" AS "FZG_Liste_5_ori",
		"Customer Group Code" AS "Customer Group Code",
		"FZG_Liste_5" AS "FZG_Liste_5",
		"FZG_Liste_6" AS "FZG_Liste_6",
		"FZG_Liste_7" AS "FZG_Liste_7",
		"FZG_Detail" AS "FZG_Detail",
		"Anz. S�tze" AS "Anz. S�tze",
		"Menge_final" AS "Menge_final",
		"No_Item" AS "No_Item",
		"Description_Item" AS "Description_Item",
		"Vehicle Type Code_Item" AS "Vehicle Type Code_Item",
		"Modell_zwischen" AS "Modell_zwischen",
		"Vehicle Category Code" AS "Vehicle Category Code",
		"Summe Erl�s FZG" AS "Summe Erl�s FZG",
		"Erl�se FZG" AS "Erl�se FZG",
		"Modell_final" AS "Modell_final",
		"Fahrzeugtyp" AS "Fahrzeugtyp"
	FROM (
		SELECT "No" AS "No",
			"Name" AS "Name",
			"Account Type" AS "Account Type",
			"Department Code_2" AS "Department Code_2",
			"Make Code_2" AS "Make Code_2",
			"Income Balance" AS "Income Balance",
			"Entry No" AS "Entry No",
			"G L Account No" AS "G L Account No",
			"Posting Date" AS "Posting Date",
			"Document Type" AS "Document Type",
			"Document No" AS "Document No",
			"Description" AS "Description",
			"Amount" AS "Amount",
			"Bal Account No" AS "Bal Account No",
			"Department Code" AS "Department Code",
			"Make Code" AS "Make Code",
			"User Id" AS "User Id",
			"Source Code" AS "Source Code",
			"Quantity" AS "Quantity",
			"Debit Amount" AS "Debit Amount",
			"Credit Amount" AS "Credit Amount",
			"Document Date" AS "Document Date",
			"Source Type" AS "Source Type",
			"Source No" AS "Source No",
			"No Series" AS "No Series",
			"Branch Code" AS "Branch Code",
			"Main Area" AS "Main Area",
			"Vin" AS "Vin",
			"Book No" AS "Book No",
			"Veh Source Code" AS "Veh Source Code",
			"Betrag" AS "Betrag",
			"Vin_Vehicle" AS "Vin_Vehicle",
			"Vehicle Status" AS "Vehicle Status",
			"Model_ori" AS "Model_ori",
			"Type" AS "Type",
			"Class" AS "Class",
			"Model No" AS "Model No",
			"Hauptbetrieb" AS "Hauptbetrieb",
			"Standort_alt" AS "Standort_alt",
			"Make Code_Vehicle" AS "Make Code_Vehicle",
			"Fabrikat_ori" AS "Fabrikat_ori",
			"Model" AS "Model",
			"Market Segment Code" AS "Market Segment Code",
			"Modellbez" AS "Modellbez",
			"Fahrzeugart" AS "Fahrzeugart",
			"Vat Prod Posting Group" AS "Vat Prod Posting Group",
			"Fahrzeugtyp_alt" AS "Fahrzeugtyp_alt",
			"FZG" AS "FZG",
			"Location Code" AS "Location Code",
			"VB_Einkauf" AS "VB_Einkauf",
			"Purchase Receipt Date" AS "Purchase Receipt Date",
			"Standtage_ori" AS "Standtage_ori",
			"Standtagestaffel" AS "Standtagestaffel",
			"Initial Registration" AS "Initial Registration",
			"EZ/Eingang" AS "EZ/Eingang",
			"Polster" AS "Polster",
			"Farbe" AS "Farbe",
			"Einsatz_ori" AS "Einsatz_ori",
			"Heute" AS "Heute",
			"Fahrzeugstatus" AS "Fahrzeugstatus",
			"FZG-Liste" AS "FZG-Liste",
			"Anzahl" AS "Anzahl",
			"Standtage" AS "Standtage",
			"Inventory Posting Group" AS "Inventory Posting Group",
			"Date Of Sale" AS "Date Of Sale",
			"Invoice Date" AS "Invoice Date",
			"Customer No" AS "Customer No",
			"No_Customer" AS "No_Customer",
			"Name_Customer" AS "Name_Customer",
			"Kunde" AS "Kunde",
			"Customer Type" AS "Customer Type",
			"Kundenart" AS "Kundenart",
			"Old Customer No_2" AS "Old Customer No_2",
			"Old Customer No" AS "Old Customer No",
			"No_Vorbesitzer" AS "No_Vorbesitzer",
			"Name_Vorbesitzer" AS "Name_Vorbesitzer",
			"Vorbesitzer" AS "Vorbesitzer",
			"Engine Code" AS "Engine Code",
			"Motor Code" AS "Motor Code",
			"Gesch�ftsart" AS "Gesch�ftsart",
			"FZG_Liste_1_ori" AS "FZG_Liste_1_ori",
			"FZG_Liste_2" AS "FZG_Liste_2",
			"FZG_Liste_3" AS "FZG_Liste_3",
			"FZG_Liste_4" AS "FZG_Liste_4",
			"Erl�s" AS "Erl�s",
			"Einsatz" AS "Einsatz",
			"EK Fahrzeug" AS "EK Fahrzeug",
			"Bonus" AS "Bonus",
			"int. Kosten" AS "int. Kosten",
			"Current Branch Book No" AS "Current Branch Book No",
			"Current Book No" AS "Current Book No",
			"Summe EK-FZG" AS "Summe EK-FZG",
			"Fabrikat" AS "Fabrikat",
			"Buchnummer gleich_ja_nein" AS "Buchnummer gleich_ja_nein",
			"Menge1" AS "Menge1",
			COUNT("Vin") OVER (PARTITION BY "VIN + PostingDate") AS "Menge2",
			("Menge1" / COUNT("Vin") OVER (PARTITION BY "VIN + PostingDate")) AS "Menge3",
			CASE 
				WHEN ("Document No" LIKE 'VGGF%')
					THEN (("Menge1" / COUNT("Vin") OVER (PARTITION BY "VIN + PostingDate")) * - 1)
				ELSE ("Menge1" / COUNT("Vin") OVER (PARTITION BY "VIN + PostingDate"))
				END AS "Menge4",
			"VIN + PostingDate" AS "VIN + PostingDate",
			"Fahrzeugart_Schmidt" AS "Fahrzeugart_Schmidt",
			"Salespers Purch Code_VLE" AS "Salespers Purch Code_VLE",
			"Code_f�r_VEH_Ledger_Entry" AS "Code_f�r_VEH_Ledger_Entry",
			"Name_f�r_VEH_Ledger_Entry" AS "Name_f�r_VEH_Ledger_Entry",
			"Verk�ufer" AS "Verk�ufer",
			"FZG_Liste_1_falsch" AS "FZG_Liste_1_falsch",
			"FZG_Liste_0_ori" AS "FZG_Liste_0_ori",
			"FZG_Liste_1" AS "FZG_Liste_1",
			"FZG_Liste_0" AS "FZG_Liste_0",
			"Beleg" AS "Beleg",
			"Standort_FIBU" AS "Standort_FIBU",
			"Fahrzeugart_neu" AS "Fahrzeugart_neu",
			"Standort" AS "Standort",
			"Summe_Betrag" AS "Summe_Betrag",
			"Country Code_Kunde" AS "Country Code_Kunde",
			"Vat Bus Posting Group_Kunde" AS "Vat Bus Posting Group_Kunde",
			"FZG_Liste_5_ori" AS "FZG_Liste_5_ori",
			"Customer Group Code" AS "Customer Group Code",
			"FZG_Liste_5" AS "FZG_Liste_5",
			"FZG_Liste_6" AS "FZG_Liste_6",
			"FZG_Liste_7" AS "FZG_Liste_7",
			"FZG_Detail" AS "FZG_Detail",
			"Anz. S�tze" AS "Anz. S�tze",
			"Menge_final" AS "Menge_final",
			"No_Item" AS "No_Item",
			"Description_Item" AS "Description_Item",
			"Vehicle Type Code_Item" AS "Vehicle Type Code_Item",
			"Modell_zwischen" AS "Modell_zwischen",
			"Vehicle Category Code" AS "Vehicle Category Code",
			"Summe Erl�s FZG" AS "Summe Erl�s FZG",
			"Erl�se FZG" AS "Erl�se FZG",
			"Modell_final" AS "Modell_final",
			"Fahrzeugtyp" AS "Fahrzeugtyp",
			c248 AS c248
		FROM (
			SELECT "No" AS "No",
				"Name" AS "Name",
				"Account Type" AS "Account Type",
				"Department Code_2" AS "Department Code_2",
				"Make Code_2" AS "Make Code_2",
				"Income Balance" AS "Income Balance",
				"Entry No" AS "Entry No",
				"G L Account No" AS "G L Account No",
				"Posting Date" AS "Posting Date",
				"Document Type" AS "Document Type",
				"Document No" AS "Document No",
				"Description" AS "Description",
				"Amount" AS "Amount",
				"Bal Account No" AS "Bal Account No",
				"Department Code" AS "Department Code",
				"Make Code" AS "Make Code",
				"User Id" AS "User Id",
				"Source Code" AS "Source Code",
				"Quantity" AS "Quantity",
				"Debit Amount" AS "Debit Amount",
				"Credit Amount" AS "Credit Amount",
				"Document Date" AS "Document Date",
				"Source Type" AS "Source Type",
				"Source No" AS "Source No",
				"No Series" AS "No Series",
				"Branch Code" AS "Branch Code",
				"Main Area" AS "Main Area",
				"Vin" AS "Vin",
				"Book No" AS "Book No",
				"Veh Source Code" AS "Veh Source Code",
				"Betrag" AS "Betrag",
				"Vin_Vehicle" AS "Vin_Vehicle",
				"Vehicle Status" AS "Vehicle Status",
				"Model_ori" AS "Model_ori",
				"Type" AS "Type",
				"Class" AS "Class",
				"Model No" AS "Model No",
				"Hauptbetrieb" AS "Hauptbetrieb",
				"Standort_alt" AS "Standort_alt",
				"Make Code_Vehicle" AS "Make Code_Vehicle",
				"Fabrikat_ori" AS "Fabrikat_ori",
				"Model" AS "Model",
				"Market Segment Code" AS "Market Segment Code",
				"Modellbez" AS "Modellbez",
				"Fahrzeugart" AS "Fahrzeugart",
				"Vat Prod Posting Group" AS "Vat Prod Posting Group",
				"Fahrzeugtyp_alt" AS "Fahrzeugtyp_alt",
				"FZG" AS "FZG",
				"Location Code" AS "Location Code",
				"VB_Einkauf" AS "VB_Einkauf",
				"Purchase Receipt Date" AS "Purchase Receipt Date",
				"Standtage_ori" AS "Standtage_ori",
				"Standtagestaffel" AS "Standtagestaffel",
				"Initial Registration" AS "Initial Registration",
				"EZ/Eingang" AS "EZ/Eingang",
				"Polster" AS "Polster",
				"Farbe" AS "Farbe",
				"Einsatz_ori" AS "Einsatz_ori",
				"Heute" AS "Heute",
				"Fahrzeugstatus" AS "Fahrzeugstatus",
				"FZG-Liste" AS "FZG-Liste",
				COUNT("Standtage_ori") OVER (PARTITION BY "Vin") AS "Anzahl",
				("Standtage_ori" / COUNT("Standtage_ori") OVER (PARTITION BY "Vin")) AS "Standtage",
				"Inventory Posting Group" AS "Inventory Posting Group",
				"Date Of Sale" AS "Date Of Sale",
				"Invoice Date" AS "Invoice Date",
				"Customer No" AS "Customer No",
				"No_Customer" AS "No_Customer",
				"Name_Customer" AS "Name_Customer",
				"Kunde" AS "Kunde",
				"Customer Type" AS "Customer Type",
				"Kundenart" AS "Kundenart",
				"Old Customer No_2" AS "Old Customer No_2",
				"Old Customer No" AS "Old Customer No",
				"No_Vorbesitzer" AS "No_Vorbesitzer",
				"Name_Vorbesitzer" AS "Name_Vorbesitzer",
				"Vorbesitzer" AS "Vorbesitzer",
				"Engine Code" AS "Engine Code",
				"Motor Code" AS "Motor Code",
				"Gesch�ftsart" AS "Gesch�ftsart",
				"FZG_Liste_1_ori" AS "FZG_Liste_1_ori",
				"FZG_Liste_2" AS "FZG_Liste_2",
				"FZG_Liste_3" AS "FZG_Liste_3",
				"FZG_Liste_4" AS "FZG_Liste_4",
				"Erl�s" AS "Erl�s",
				"Einsatz" AS "Einsatz",
				"EK Fahrzeug" AS "EK Fahrzeug",
				"Bonus" AS "Bonus",
				"int. Kosten" AS "int. Kosten",
				"Current Branch Book No" AS "Current Branch Book No",
				"Current Book No" AS "Current Book No",
				SUM("EK Fahrzeug") OVER (PARTITION BY "Vin") AS "Summe EK-FZG",
				"Fabrikat" AS "Fabrikat",
				"Buchnummer gleich_ja_nein" AS "Buchnummer gleich_ja_nein",
				"Menge1" AS "Menge1",
				"VIN + PostingDate" AS "VIN + PostingDate",
				"Fahrzeugart_Schmidt" AS "Fahrzeugart_Schmidt",
				"Salespers Purch Code_VLE" AS "Salespers Purch Code_VLE",
				"Code_f�r_VEH_Ledger_Entry" AS "Code_f�r_VEH_Ledger_Entry",
				"Name_f�r_VEH_Ledger_Entry" AS "Name_f�r_VEH_Ledger_Entry",
				"Verk�ufer" AS "Verk�ufer",
				"FZG_Liste_1_falsch" AS "FZG_Liste_1_falsch",
				"FZG_Liste_0_ori" AS "FZG_Liste_0_ori",
				"FZG_Liste_1" AS "FZG_Liste_1",
				"FZG_Liste_0" AS "FZG_Liste_0",
				"Beleg" AS "Beleg",
				"Standort_FIBU" AS "Standort_FIBU",
				"Fahrzeugart_neu" AS "Fahrzeugart_neu",
				"Standort" AS "Standort",
				"Summe_Betrag" AS "Summe_Betrag",
				"Country Code_Kunde" AS "Country Code_Kunde",
				"Vat Bus Posting Group_Kunde" AS "Vat Bus Posting Group_Kunde",
				"FZG_Liste_5_ori" AS "FZG_Liste_5_ori",
				"Customer Group Code" AS "Customer Group Code",
				"FZG_Liste_5" AS "FZG_Liste_5",
				"FZG_Liste_6" AS "FZG_Liste_6",
				"FZG_Liste_7" AS "FZG_Liste_7",
				"FZG_Detail" AS "FZG_Detail",
				COUNT("No") OVER (PARTITION BY "Vin") AS "Anz. S�tze",
				("Menge1" / COUNT("No") OVER (PARTITION BY "Vin")) AS "Menge_final",
				"No_Item" AS "No_Item",
				"Description_Item" AS "Description_Item",
				"Vehicle Type Code_Item" AS "Vehicle Type Code_Item",
				"Modell_zwischen" AS "Modell_zwischen",
				"Vehicle Category Code" AS "Vehicle Category Code",
				SUM("Erl�se FZG") OVER (PARTITION BY "Vin") AS "Summe Erl�s FZG",
				"Erl�se FZG" AS "Erl�se FZG",
				"Modell_final" AS "Modell_final",
				"Fahrzeugtyp" AS "Fahrzeugtyp",
				(c137) AS c248
			FROM (
				SELECT "No" AS "No",
					"Name" AS "Name",
					"Account Type" AS "Account Type",
					"Department Code_2" AS "Department Code_2",
					"Make Code_2" AS "Make Code_2",
					"Income Balance" AS "Income Balance",
					"Entry No" AS "Entry No",
					"G L Account No" AS "G L Account No",
					"Posting Date" AS "Posting Date",
					"Document Type" AS "Document Type",
					"Document No" AS "Document No",
					"Description" AS "Description",
					"Amount" AS "Amount",
					"Bal Account No" AS "Bal Account No",
					"Department Code" AS "Department Code",
					"Make Code" AS "Make Code",
					"User Id" AS "User Id",
					"Source Code" AS "Source Code",
					"Quantity" AS "Quantity",
					"Debit Amount" AS "Debit Amount",
					"Credit Amount" AS "Credit Amount",
					"Document Date" AS "Document Date",
					"Source Type" AS "Source Type",
					"Source No" AS "Source No",
					"No Series" AS "No Series",
					"Branch Code" AS "Branch Code",
					"Main Area" AS "Main Area",
					"Vin" AS "Vin",
					"Book No" AS "Book No",
					"Veh Source Code" AS "Veh Source Code",
					"Betrag" AS "Betrag",
					"Vin_Vehicle" AS "Vin_Vehicle",
					"Vehicle Status" AS "Vehicle Status",
					"Model_ori" AS "Model_ori",
					"Type" AS "Type",
					"Class" AS "Class",
					"Model No" AS "Model No",
					"Hauptbetrieb" AS "Hauptbetrieb",
					"Standort_alt" AS "Standort_alt",
					"Make Code_Vehicle" AS "Make Code_Vehicle",
					"Fabrikat_ori" AS "Fabrikat_ori",
					"Model" AS "Model",
					"Market Segment Code" AS "Market Segment Code",
					"Modellbez" AS "Modellbez",
					"Fahrzeugart" AS "Fahrzeugart",
					"Vat Prod Posting Group" AS "Vat Prod Posting Group",
					"Fahrzeugtyp_alt" AS "Fahrzeugtyp_alt",
					"FZG" AS "FZG",
					"Location Code" AS "Location Code",
					"VB_Einkauf" AS "VB_Einkauf",
					"Purchase Receipt Date" AS "Purchase Receipt Date",
					"Standtage_ori" AS "Standtage_ori",
					"Standtagestaffel" AS "Standtagestaffel",
					"Initial Registration" AS "Initial Registration",
					"EZ/Eingang" AS "EZ/Eingang",
					"Polster" AS "Polster",
					"Farbe" AS "Farbe",
					"Einsatz_ori" AS "Einsatz_ori",
					"Heute" AS "Heute",
					"Fahrzeugstatus" AS "Fahrzeugstatus",
					"FZG-Liste" AS "FZG-Liste",
					"Inventory Posting Group" AS "Inventory Posting Group",
					"Date Of Sale" AS "Date Of Sale",
					"Invoice Date" AS "Invoice Date",
					"Customer No" AS "Customer No",
					"No_Customer" AS "No_Customer",
					"Name_Customer" AS "Name_Customer",
					"Kunde" AS "Kunde",
					"Customer Type" AS "Customer Type",
					"Kundenart" AS "Kundenart",
					"Old Customer No_2" AS "Old Customer No_2",
					"Old Customer No" AS "Old Customer No",
					"No_Vorbesitzer" AS "No_Vorbesitzer",
					"Name_Vorbesitzer" AS "Name_Vorbesitzer",
					"Vorbesitzer" AS "Vorbesitzer",
					"Engine Code" AS "Engine Code",
					"Motor Code" AS "Motor Code",
					"Gesch�ftsart" AS "Gesch�ftsart",
					"FZG_Liste_1_ori" AS "FZG_Liste_1_ori",
					"FZG_Liste_2" AS "FZG_Liste_2",
					"FZG_Liste_3" AS "FZG_Liste_3",
					"FZG_Liste_4" AS "FZG_Liste_4",
					"Erl�s" AS "Erl�s",
					"Einsatz" AS "Einsatz",
					"EK Fahrzeug" AS "EK Fahrzeug",
					"Bonus" AS "Bonus",
					"int. Kosten" AS "int. Kosten",
					"Current Branch Book No" AS "Current Branch Book No",
					"Current Book No" AS "Current Book No",
					"Fabrikat" AS "Fabrikat",
					"Buchnummer gleich_ja_nein" AS "Buchnummer gleich_ja_nein",
					"Menge1" AS "Menge1",
					"VIN + PostingDate" AS "VIN + PostingDate",
					"Fahrzeugart_Schmidt" AS "Fahrzeugart_Schmidt",
					"Salespers Purch Code_VLE" AS "Salespers Purch Code_VLE",
					"Code_f�r_VEH_Ledger_Entry" AS "Code_f�r_VEH_Ledger_Entry",
					"Name_f�r_VEH_Ledger_Entry" AS "Name_f�r_VEH_Ledger_Entry",
					"Verk�ufer" AS "Verk�ufer",
					"FZG_Liste_1_falsch" AS "FZG_Liste_1_falsch",
					"FZG_Liste_0_ori" AS "FZG_Liste_0_ori",
					"FZG_Liste_1" AS "FZG_Liste_1",
					"FZG_Liste_0" AS "FZG_Liste_0",
					"Beleg" AS "Beleg",
					"Standort_FIBU" AS "Standort_FIBU",
					"Fahrzeugart_neu" AS "Fahrzeugart_neu",
					"Standort" AS "Standort",
					"Summe_Betrag" AS "Summe_Betrag",
					"Country Code_Kunde" AS "Country Code_Kunde",
					"Vat Bus Posting Group_Kunde" AS "Vat Bus Posting Group_Kunde",
					"FZG_Liste_5_ori" AS "FZG_Liste_5_ori",
					"Customer Group Code" AS "Customer Group Code",
					"FZG_Liste_5" AS "FZG_Liste_5",
					"FZG_Liste_6" AS "FZG_Liste_6",
					"FZG_Liste_7" AS "FZG_Liste_7",
					"FZG_Detail" AS "FZG_Detail",
					"No_Item" AS "No_Item",
					"Description_Item" AS "Description_Item",
					"Vehicle Type Code_Item" AS "Vehicle Type Code_Item",
					"Modell_zwischen" AS "Modell_zwischen",
					"Vehicle Category Code" AS "Vehicle Category Code",
					"Erl�se FZG" AS "Erl�se FZG",
					"Modell_final" AS "Modell_final",
					"Fahrzeugtyp" AS "Fahrzeugtyp",
					c137 AS c137,
					SUM("Erl�se FZG") OVER (PARTITION BY "Vin") AS c138
				FROM (
					SELECT "No",
						"Name",
						"Account Type",
						"Department Code_2",
						"Make Code_2",
						"Income Balance",
						"Entry No",
						"G L Account No",
						"Posting Date",
						"Document Type",
						"Document No",
						"Description",
						"Amount",
						"Bal Account No",
						"Department Code",
						"Make Code",
						"User Id",
						"Source Code",
						"Quantity",
						"Debit Amount",
						"Credit Amount",
						"Document Date",
						"Source Type",
						"Source No",
						"No Series",
						"Branch Code",
						"Main Area",
						"Vin",
						"Book No",
						"Veh Source Code",
						"Betrag",
						"Vin_Vehicle",
						"Vehicle Status",
						"Model_ori",
						"Type",
						"Class",
						"Model No",
						'1' AS "Hauptbetrieb",
						"Standort_alt",
						"Make Code_Vehicle",
						"Make Code_Vehicle" AS "Fabrikat_ori",
						"Model",
						"Market Segment Code",
						"Model_ori" AS "Modellbez",
						"Fahrzeugart",
						"Vat Prod Posting Group",
						"Fahrzeugtyp_alt",
						"FZG",
						"Location Code",
						'' AS "VB_Einkauf",
						"Purchase Receipt Date",
						"Standtage_ori",
						"Standtagestaffel",
						"Initial Registration",
						"EZ/Eingang",
						'' AS "Polster",
						'' AS "Farbe",
						"Betrag" AS "Einsatz_ori",
						(getdate()) AS "Heute",
						'Bestand' AS "Fahrzeugstatus",
						"FZG-Liste",
						"Inventory Posting Group",
						"Date Of Sale",
						"Invoice Date",
						"Customer No",
						"No_Customer",
						"Name_Customer",
						"Kunde",
						"Customer Type",
						"Kundenart",
						"Old Customer No_2",
						"Old Customer No_2" AS "Old Customer No",
						"No_Vorbesitzer",
						"Name_Vorbesitzer",
						"Name_Vorbesitzer" AS "Vorbesitzer",
						"Engine Code",
						"Engine Code" AS "Motor Code",
						'' AS "Gesch�ftsart",
						"FZG_Liste_1_ori",
						"FZG_Liste_2",
						"Model_ori" AS "FZG_Liste_3",
						"FZG_Liste_4",
						"Erl�s",
						"Einsatz",
						"EK Fahrzeug",
						"Bonus",
						"int. Kosten",
						"Current Branch Book No",
						"Current Book No",
						"Fabrikat",
						"Buchnummer gleich_ja_nein",
						1 AS "Menge1",
						"VIN + PostingDate" AS "VIN + PostingDate",
						"Fahrzeugart_Schmidt",
						"Salespers Purch Code_VLE",
						"Code_f�r_VEH_Ledger_Entry",
						"Name_f�r_VEH_Ledger_Entry",
						"Verk�ufer",
						"FZG_Liste_1_falsch",
						"FZG_Liste_0_ori",
						"FZG_Liste_1",
						"FZG_Liste_0",
						"Beleg",
						"Standort_FIBU",
						"Fahrzeugart_neu",
						"Standort",
						SUM("Betrag") OVER (PARTITION BY c142) AS "Summe_Betrag",
						'' AS "Country Code_Kunde",
						"Vat Bus Posting Group_Kunde",
						"FZG_Liste_5_ori",
						"Customer Group Code",
						"FZG_Liste_5",
						CASE 
							WHEN ('' IS NULL)
								THEN (' - ')
							WHEN ('' IN (''))
								THEN (' - ')
							ELSE ('')
							END AS "FZG_Liste_6",
						"Kunde" AS "FZG_Liste_7",
						"FZG_Detail",
						"No_Item",
						"Description_Item",
						"Vehicle Type Code_Item",
						"Modell_zwischen",
						"Vehicle Category Code",
						"Erl�se FZG",
						"Modell_final",
						"Fahrzeugtyp",
						c143 AS c137
					FROM (
						SELECT (((T2."VIN"))) AS c142,
							((T2."VIN")) + T2."Document No_" AS c143,
							CASE 
								WHEN (
										(
											CASE 
												WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												ELSE NULL
												END
											) = 'GA'
										)
									THEN (T3."Inventory Posting Group")
								ELSE (
										(
											CASE 
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'GA'
															)
														AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
														)
													THEN ('GA - diff.best.')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'GA'
															)
														AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
														)
													THEN ('GA - regelbest.')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
														)
													THEN ('NA')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
														)
													THEN ('NA')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												ELSE NULL
												END
											)
										)
								END AS "Fahrzeugtyp",
							CASE 
								WHEN (
										NOT (
											CASE 
												WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
													THEN (T3."Make Code")
												ELSE ('Fremdfabrikat')
												END
											) IN ('Fremdfabrikat')
										)
									THEN (
											(
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																			THEN (T3."Make Code")
																		ELSE ('Fremdfabrikat')
																		END
																	) = 'BMW'
																)
															AND ((left(T4."Description", 1)) BETWEEN '1' AND '9')
															)
														THEN ((left(T4."Description", 1)) + 'er')
													WHEN (
															(
																(
																	CASE 
																		WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																			THEN (T3."Make Code")
																		ELSE ('Fremdfabrikat')
																		END
																	) = 'BMW'
																)
															AND ((left(T4."Description", 1)) BETWEEN 'A' AND 'Z')
															)
														THEN ((left(T4."Description", 2)))
													WHEN (
															(
																(
																	CASE 
																		WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																			THEN (T3."Make Code")
																		ELSE ('Fremdfabrikat')
																		END
																	) = 'BMW-MINI'
																)
															AND (
																(T4."Description" LIKE '%3-T%')
																OR (T3."Model" LIKE '%3-T%')
																)
															)
														THEN ('3-T�rer')
													WHEN (
															(
																(
																	CASE 
																		WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																			THEN (T3."Make Code")
																		ELSE ('Fremdfabrikat')
																		END
																	) = 'BMW-MINI'
																)
															AND (
																(T4."Description" LIKE '%5-T%')
																OR (T3."Model" LIKE '%5-T%')
																)
															)
														THEN ('5-T�rer')
													WHEN (
															(
																(
																	CASE 
																		WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																			THEN (T3."Make Code")
																		ELSE ('Fremdfabrikat')
																		END
																	) = 'BMW-MINI'
																)
															AND (
																(T4."Description" LIKE '%Club%')
																OR (T3."Model" LIKE '%Club%')
																)
															)
														THEN ('Clubman')
													WHEN (
															(
																(
																	CASE 
																		WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																			THEN (T3."Make Code")
																		ELSE ('Fremdfabrikat')
																		END
																	) = 'BMW-MINI'
																)
															AND (
																(T4."Description" LIKE '%Count%')
																OR (T3."Model" LIKE '%Count%')
																)
															)
														THEN ('Countryman')
													WHEN (
															(
																(
																	CASE 
																		WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																			THEN (T3."Make Code")
																		ELSE ('Fremdfabrikat')
																		END
																	) = 'BMW-MINI'
																)
															AND (
																(T4."Description" LIKE '%Cou%')
																OR (T3."Model" LIKE '%Cou%')
																)
															)
														THEN ('Coupe')
													WHEN (
															(
																(
																	CASE 
																		WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																			THEN (T3."Make Code")
																		ELSE ('Fremdfabrikat')
																		END
																	) = 'BMW-MINI'
																)
															AND (
																(T4."Description" LIKE '%Hatch%')
																OR (T3."Model" LIKE '%Hatch%')
																)
															)
														THEN ('Hatch')
													WHEN (
															(
																(
																	CASE 
																		WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																			THEN (T3."Make Code")
																		ELSE ('Fremdfabrikat')
																		END
																	) = 'BMW-MINI'
																)
															AND (
																(T4."Description" LIKE '%Pace%')
																OR (T3."Model" LIKE '%Pace%')
																)
															)
														THEN ('Paceman')
													WHEN (
															(
																(
																	CASE 
																		WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																			THEN (T3."Make Code")
																		ELSE ('Fremdfabrikat')
																		END
																	) = 'BMW-MINI'
																)
															AND (
																(T4."Description" LIKE '%Road%')
																OR (T3."Model" LIKE '%Road%')
																)
															)
														THEN ('Roadster')
													WHEN (
															(
																(
																	CASE 
																		WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																			THEN (T3."Make Code")
																		ELSE ('Fremdfabrikat')
																		END
																	) = 'BMW-MINI'
																)
															AND (
																(T4."Description" LIKE '%Cab%')
																OR (T3."Model" LIKE '%Cab%')
																)
															)
														THEN ('Cabrio')
													ELSE (T4."Description")
													END
												)
											)
								ELSE ('Fremd')
								END AS "Modell_final",
							CASE 
								WHEN ((left(T1."No_", 3)) IN ('882', '884', '887'))
									THEN (0)
								ELSE (
										(
											CASE 
												WHEN (
														(T1."No_" LIKE '8%')
														AND ((right(T2."Global Dimension 1 Code", 2)) IN ('10', '20', '80', '11', '21'))
														)
													THEN (((convert(FLOAT, T2."Amount"))) * - 1)
												ELSE (0)
												END
											)
										)
								END AS "Erl�se FZG",
							T4."Vehicle Category Code" AS "Vehicle Category Code",
							CASE 
								WHEN (
										(
											(
												CASE 
													WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
														THEN (T3."Make Code")
													ELSE ('Fremdfabrikat')
													END
												) = 'BMW'
											)
										AND ((left(T4."Description", 1)) BETWEEN '1' AND '9')
										)
									THEN ((left(T4."Description", 1)) + 'er')
								WHEN (
										(
											(
												CASE 
													WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
														THEN (T3."Make Code")
													ELSE ('Fremdfabrikat')
													END
												) = 'BMW'
											)
										AND ((left(T4."Description", 1)) BETWEEN 'A' AND 'Z')
										)
									THEN ((left(T4."Description", 2)))
								WHEN (
										(
											(
												CASE 
													WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
														THEN (T3."Make Code")
													ELSE ('Fremdfabrikat')
													END
												) = 'BMW-MINI'
											)
										AND (
											(T4."Description" LIKE '%3-T%')
											OR (T3."Model" LIKE '%3-T%')
											)
										)
									THEN ('3-T�rer')
								WHEN (
										(
											(
												CASE 
													WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
														THEN (T3."Make Code")
													ELSE ('Fremdfabrikat')
													END
												) = 'BMW-MINI'
											)
										AND (
											(T4."Description" LIKE '%5-T%')
											OR (T3."Model" LIKE '%5-T%')
											)
										)
									THEN ('5-T�rer')
								WHEN (
										(
											(
												CASE 
													WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
														THEN (T3."Make Code")
													ELSE ('Fremdfabrikat')
													END
												) = 'BMW-MINI'
											)
										AND (
											(T4."Description" LIKE '%Club%')
											OR (T3."Model" LIKE '%Club%')
											)
										)
									THEN ('Clubman')
								WHEN (
										(
											(
												CASE 
													WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
														THEN (T3."Make Code")
													ELSE ('Fremdfabrikat')
													END
												) = 'BMW-MINI'
											)
										AND (
											(T4."Description" LIKE '%Count%')
											OR (T3."Model" LIKE '%Count%')
											)
										)
									THEN ('Countryman')
								WHEN (
										(
											(
												CASE 
													WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
														THEN (T3."Make Code")
													ELSE ('Fremdfabrikat')
													END
												) = 'BMW-MINI'
											)
										AND (
											(T4."Description" LIKE '%Cou%')
											OR (T3."Model" LIKE '%Cou%')
											)
										)
									THEN ('Coupe')
								WHEN (
										(
											(
												CASE 
													WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
														THEN (T3."Make Code")
													ELSE ('Fremdfabrikat')
													END
												) = 'BMW-MINI'
											)
										AND (
											(T4."Description" LIKE '%Hatch%')
											OR (T3."Model" LIKE '%Hatch%')
											)
										)
									THEN ('Hatch')
								WHEN (
										(
											(
												CASE 
													WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
														THEN (T3."Make Code")
													ELSE ('Fremdfabrikat')
													END
												) = 'BMW-MINI'
											)
										AND (
											(T4."Description" LIKE '%Pace%')
											OR (T3."Model" LIKE '%Pace%')
											)
										)
									THEN ('Paceman')
								WHEN (
										(
											(
												CASE 
													WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
														THEN (T3."Make Code")
													ELSE ('Fremdfabrikat')
													END
												) = 'BMW-MINI'
											)
										AND (
											(T4."Description" LIKE '%Road%')
											OR (T3."Model" LIKE '%Road%')
											)
										)
									THEN ('Roadster')
								WHEN (
										(
											(
												CASE 
													WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
														THEN (T3."Make Code")
													ELSE ('Fremdfabrikat')
													END
												) = 'BMW-MINI'
											)
										AND (
											(T4."Description" LIKE '%Cab%')
											OR (T3."Model" LIKE '%Cab%')
											)
										)
									THEN ('Cabrio')
								ELSE (T4."Description")
								END AS "Modell_zwischen",
							T4."Vehicle Type Code" AS "Vehicle Type Code_Item",
							T4."Description" AS "Description_Item",
							T4."No_" AS "No_Item",
							((T2."VIN")) + ' - ' + T3."Location Code" + ' - ' + (
								CASE 
									WHEN (
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'GA'
											)
										THEN (T3."Inventory Posting Group")
									ELSE (
											(
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - diff.best.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - regelbest.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
															)
														THEN ('VFW')
													ELSE NULL
													END
												)
											)
									END
								) + ' - ' + (
								CASE 
									WHEN (T7."Code" IS NOT NULL)
										THEN (T7."Code" + ' - ' + T7."Name")
									ELSE (T8."Salespers__Purch_ Code")
									END
								) + ' - ' + (T5."No_" + ' - ' + T5."Name") + ' - ' + (
								convert(VARCHAR(50), year((
											CASE 
												WHEN (T3."Date of Sale" IS NULL)
													THEN (T2."Posting Date")
												ELSE (T3."Date of Sale")
												END
											))) + '-' + convert(VARCHAR(50), month((
											CASE 
												WHEN (T3."Date of Sale" IS NULL)
													THEN (T2."Posting Date")
												ELSE (T3."Date of Sale")
												END
											))) + '-' + convert(VARCHAR(50), day((
											CASE 
												WHEN (T3."Date of Sale" IS NULL)
													THEN (T2."Posting Date")
												ELSE (T3."Date of Sale")
												END
											)))
								) AS "FZG_Detail",
							(T5."No_" + ' - ' + T5."Name") AS "Kunde",
							CASE 
								WHEN (T5."Gen_ Bus_ Posting Group" IS NULL)
									THEN (' - ')
								WHEN (T5."Gen_ Bus_ Posting Group" IN (''))
									THEN (' - ')
								ELSE (T5."Gen_ Bus_ Posting Group")
								END AS "FZG_Liste_5",
							T5."Customer Group Code" AS "Customer Group Code",
							CASE 
								WHEN ('' = '')
									THEN (T5."Customer Group Code" + ' / ' + ' - ' + ' / ' + T5."Gen_ Bus_ Posting Group" + ' / ' + (T5."No_" + ' - ' + T5."Name"))
								ELSE (T5."Customer Group Code" + ' / ' + '' + ' / ' + T5."Gen_ Bus_ Posting Group" + ' / ' + (T5."No_" + ' - ' + T5."Name"))
								END AS "FZG_Liste_5_ori",
							T5."VAT Bus_ Posting Group" AS "Vat Bus Posting Group_Kunde",
							CASE 
								WHEN (T3."Location Code" = 'BUR')
									THEN ('10')
								WHEN (T3."Location Code" = 'MUE')
									THEN ('20')
								ELSE ('10')
								END AS "Standort",
							CASE 
								WHEN (
										(
											CASE 
												WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												ELSE NULL
												END
											) IS NULL
										)
									THEN (
											(
												CASE 
													WHEN ((substring(T1."Global Dimension 1 Code", 3, 2)) = '10')
														THEN ('NA')
													WHEN ((substring(T1."Global Dimension 1 Code", 3, 2)) = '20')
														THEN ('GA')
													WHEN ((substring(T1."Global Dimension 1 Code", 3, 2)) = '80')
														THEN ('NA')
													WHEN ((substring(T1."Global Dimension 1 Code", 3, 2)) = '90')
														THEN ('NA')
													ELSE NULL
													END
												)
											)
								ELSE (
										(
											CASE 
												WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												ELSE NULL
												END
											)
										)
								END AS "Fahrzeugart_neu",
							(left(T1."Global Dimension 1 Code", 2)) AS "Standort_FIBU",
							T2."Document No_" + ' - ' + T2."Description" + ' - ' + T2."User ID" AS "Beleg",
							CASE 
								WHEN (
										(
											(
												CASE 
													WHEN (((T2."VIN")) = ' ')
														THEN ('Buchungen o. FZG')
													ELSE ('Buchungen m. FZG')
													END
												) = 'Buchungen m. FZG'
											)
										AND (T3."VIN" IS NULL)
										)
									THEN ('sonst. Buchungen m. FZG')
								ELSE (
										(
											CASE 
												WHEN (((T2."VIN")) = ' ')
													THEN ('Buchungen o. FZG')
												ELSE ('Buchungen m. FZG')
												END
											)
										)
								END AS "FZG_Liste_0",
							CASE 
								WHEN (
										(
											CASE 
												WHEN (((T2."VIN")) = ' ')
													THEN ('Buchungen o. FZG')
												ELSE ('Buchungen m. FZG')
												END
											) = 'Buchungen o. FZG'
										)
									THEN (T2."Document No_" + ' - ' + T2."Description")
								ELSE (
										(
											CASE 
												WHEN (
														(
															CASE 
																WHEN (
																		(
																			(
																				CASE 
																					WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					ELSE NULL
																					END
																				) = 'GA'
																			)
																		AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
																		)
																	THEN ('GA - diff.best.')
																WHEN (
																		(
																			(
																				CASE 
																					WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					ELSE NULL
																					END
																				) = 'GA'
																			)
																		AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
																		)
																	THEN ('GA - regelbest.')
																WHEN (
																		(
																			(
																				CASE 
																					WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					ELSE NULL
																					END
																				) = 'NA'
																			)
																		AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
																		)
																	THEN ('NA')
																WHEN (
																		(
																			(
																				CASE 
																					WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					ELSE NULL
																					END
																				) = 'NA'
																			)
																		AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
																		)
																	THEN ('NA')
																WHEN (
																		(
																			(
																				CASE 
																					WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					ELSE NULL
																					END
																				) = 'NA'
																			)
																		AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
																		)
																	THEN ('VFW')
																ELSE NULL
																END
															) IS NOT NULL
														)
													THEN (
															(right(((T2."VIN")), 7)) + ' - ' + (
																CASE 
																	WHEN (
																			(
																				(
																					CASE 
																						WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																							THEN ('NA')
																						WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																							THEN ('GA')
																						ELSE NULL
																						END
																					) = 'GA'
																				)
																			AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
																			)
																		THEN ('GA - diff.best.')
																	WHEN (
																			(
																				(
																					CASE 
																						WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																							THEN ('NA')
																						WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																							THEN ('GA')
																						ELSE NULL
																						END
																					) = 'GA'
																				)
																			AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
																			)
																		THEN ('GA - regelbest.')
																	WHEN (
																			(
																				(
																					CASE 
																						WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																							THEN ('NA')
																						WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																							THEN ('GA')
																						ELSE NULL
																						END
																					) = 'NA'
																				)
																			AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
																			)
																		THEN ('NA')
																	WHEN (
																			(
																				(
																					CASE 
																						WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																							THEN ('NA')
																						WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																							THEN ('GA')
																						ELSE NULL
																						END
																					) = 'NA'
																				)
																			AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
																			)
																		THEN ('NA')
																	WHEN (
																			(
																				(
																					CASE 
																						WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																							THEN ('NA')
																						WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																							THEN ('GA')
																						ELSE NULL
																						END
																					) = 'NA'
																				)
																			AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
																			)
																		THEN ('VFW')
																	ELSE NULL
																	END
																) + ' / ' + (
																convert(VARCHAR(50), year((
																			CASE 
																				WHEN (T3."Date of Sale" IS NULL)
																					THEN (T2."Posting Date")
																				ELSE (T3."Date of Sale")
																				END
																			))) + '-' + convert(VARCHAR(50), month((
																			CASE 
																				WHEN (T3."Date of Sale" IS NULL)
																					THEN (T2."Posting Date")
																				ELSE (T3."Date of Sale")
																				END
																			))) + '-' + convert(VARCHAR(50), day((
																			CASE 
																				WHEN (T3."Date of Sale" IS NULL)
																					THEN (T2."Posting Date")
																				ELSE (T3."Date of Sale")
																				END
																			)))
																)
															)
												ELSE (
														(right(((T2."VIN")))) + ' - ' + (
															convert(VARCHAR(50), year((
																		CASE 
																			WHEN (T3."Date of Sale" IS NULL)
																				THEN (T2."Posting Date")
																			ELSE (T3."Date of Sale")
																			END
																		))) + '-' + convert(VARCHAR(50), month((
																		CASE 
																			WHEN (T3."Date of Sale" IS NULL)
																				THEN (T2."Posting Date")
																			ELSE (T3."Date of Sale")
																			END
																		))) + '-' + convert(VARCHAR(50), day((
																		CASE 
																			WHEN (T3."Date of Sale" IS NULL)
																				THEN (T2."Posting Date")
																			ELSE (T3."Date of Sale")
																			END
																		)))
															)
														)
												END
											)
										)
								END AS "FZG_Liste_1",
							CASE 
								WHEN (((T2."VIN")) = ' ')
									THEN ('Buchungen o. FZG')
								ELSE ('Buchungen m. FZG')
								END AS "FZG_Liste_0_ori",
							CASE 
								WHEN (T1."No_" IN ('78700', '78710', '79000', '79030', '79100', '79130', '88210', '88220', '88230', '88240', '88290', '88310', '88320', '88400', '88410', '88420', '88430', '88560', '88570', '88700', '88710', '88720', '88730', '88740', '88750', '88760', '88770', '88780', '88790'))
									THEN ('Buchungen aus Sonstige Erl�se')
								ELSE (
										(
											CASE 
												WHEN (
														(
															CASE 
																WHEN (
																		(
																			(
																				CASE 
																					WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					ELSE NULL
																					END
																				) = 'GA'
																			)
																		AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
																		)
																	THEN ('GA - diff.best.')
																WHEN (
																		(
																			(
																				CASE 
																					WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					ELSE NULL
																					END
																				) = 'GA'
																			)
																		AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
																		)
																	THEN ('GA - regelbest.')
																WHEN (
																		(
																			(
																				CASE 
																					WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					ELSE NULL
																					END
																				) = 'NA'
																			)
																		AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
																		)
																	THEN ('NA')
																WHEN (
																		(
																			(
																				CASE 
																					WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					ELSE NULL
																					END
																				) = 'NA'
																			)
																		AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
																		)
																	THEN ('NA')
																WHEN (
																		(
																			(
																				CASE 
																					WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					ELSE NULL
																					END
																				) = 'NA'
																			)
																		AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
																		)
																	THEN ('VFW')
																ELSE NULL
																END
															) IS NOT NULL
														)
													THEN (
															(right(((T2."VIN")), 7)) + ' - ' + (
																CASE 
																	WHEN (
																			(
																				(
																					CASE 
																						WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																							THEN ('NA')
																						WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																							THEN ('GA')
																						ELSE NULL
																						END
																					) = 'GA'
																				)
																			AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
																			)
																		THEN ('GA - diff.best.')
																	WHEN (
																			(
																				(
																					CASE 
																						WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																							THEN ('NA')
																						WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																							THEN ('GA')
																						ELSE NULL
																						END
																					) = 'GA'
																				)
																			AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
																			)
																		THEN ('GA - regelbest.')
																	WHEN (
																			(
																				(
																					CASE 
																						WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																							THEN ('NA')
																						WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																							THEN ('GA')
																						ELSE NULL
																						END
																					) = 'NA'
																				)
																			AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
																			)
																		THEN ('NA')
																	WHEN (
																			(
																				(
																					CASE 
																						WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																							THEN ('NA')
																						WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																							THEN ('GA')
																						ELSE NULL
																						END
																					) = 'NA'
																				)
																			AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
																			)
																		THEN ('NA')
																	WHEN (
																			(
																				(
																					CASE 
																						WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																							THEN ('NA')
																						WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																							THEN ('GA')
																						ELSE NULL
																						END
																					) = 'NA'
																				)
																			AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
																			)
																		THEN ('VFW')
																	ELSE NULL
																	END
																) + ' / ' + (
																convert(VARCHAR(50), year((
																			CASE 
																				WHEN (T3."Date of Sale" IS NULL)
																					THEN (T2."Posting Date")
																				ELSE (T3."Date of Sale")
																				END
																			))) + '-' + convert(VARCHAR(50), month((
																			CASE 
																				WHEN (T3."Date of Sale" IS NULL)
																					THEN (T2."Posting Date")
																				ELSE (T3."Date of Sale")
																				END
																			))) + '-' + convert(VARCHAR(50), day((
																			CASE 
																				WHEN (T3."Date of Sale" IS NULL)
																					THEN (T2."Posting Date")
																				ELSE (T3."Date of Sale")
																				END
																			)))
																)
															)
												ELSE (
														(right(((T2."VIN")))) + ' - ' + (
															convert(VARCHAR(50), year((
																		CASE 
																			WHEN (T3."Date of Sale" IS NULL)
																				THEN (T2."Posting Date")
																			ELSE (T3."Date of Sale")
																			END
																		))) + '-' + convert(VARCHAR(50), month((
																		CASE 
																			WHEN (T3."Date of Sale" IS NULL)
																				THEN (T2."Posting Date")
																			ELSE (T3."Date of Sale")
																			END
																		))) + '-' + convert(VARCHAR(50), day((
																		CASE 
																			WHEN (T3."Date of Sale" IS NULL)
																				THEN (T2."Posting Date")
																			ELSE (T3."Date of Sale")
																			END
																		)))
															)
														)
												END
											)
										)
								END AS "FZG_Liste_1_falsch",
							CASE 
								WHEN (T7."Code" IS NOT NULL)
									THEN (T7."Code" + ' - ' + T7."Name")
								ELSE (T8."Salespers__Purch_ Code")
								END AS "Verk�ufer",
							T7."Name" AS "Name_f�r_VEH_Ledger_Entry",
							T7."Code" AS "Code_f�r_VEH_Ledger_Entry",
							T8."Salespers__Purch_ Code" AS "Salespers Purch Code_VLE",
							CASE 
								WHEN ((substring(T1."Global Dimension 1 Code", 3, 2)) = '10')
									THEN ('NA')
								WHEN ((substring(T1."Global Dimension 1 Code", 3, 2)) = '20')
									THEN ('GA')
								WHEN ((substring(T1."Global Dimension 1 Code", 3, 2)) = '80')
									THEN ('NA')
								WHEN ((substring(T1."Global Dimension 1 Code", 3, 2)) = '90')
									THEN ('NA')
								ELSE NULL
								END AS "Fahrzeugart_Schmidt",
							((T2."VIN")) + (convert(VARCHAR(50), year(T2."Posting Date")) + '-' + convert(VARCHAR(50), month(T2."Posting Date")) + '-' + convert(VARCHAR(50), day(T2."Posting Date"))) AS "VIN + PostingDate",
							CASE 
								WHEN (
										(T2."Book No_" = T3."Current Book No_")
										AND (
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'GA'
											)
										)
									THEN ('ja')
								WHEN (
										(T2."Book No_" <> T3."Current Book No_")
										AND (
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'GA'
											)
										)
									THEN ('nein')
								ELSE NULL
								END AS "Buchnummer gleich_ja_nein",
							CASE 
								WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
									THEN (T3."Make Code")
								ELSE ('Fremdfabrikat')
								END AS "Fabrikat",
							T3."Current Book No_" AS "Current Book No",
							T3."Current Branch Book No_" AS "Current Branch Book No",
							CASE 
								WHEN (T1."No_" LIKE '4%')
									THEN (((convert(FLOAT, T2."Amount"))))
								ELSE (0)
								END AS "int. Kosten",
							CASE 
								WHEN (T1."No_" BETWEEN '71400' AND '71690')
									THEN (((convert(FLOAT, T2."Amount"))) * - 1)
								ELSE (0)
								END AS "Bonus",
							CASE 
								WHEN (
										(
											(T1."No_" BETWEEN '71000' AND '71390')
											OR (T1."No_" BETWEEN '71700' AND '72995')
											)
										OR (T1."No_" IN ('78200', '78700', '78710', '79000', '79030', '79100', '79130', '78580'))
										)
									THEN (((convert(FLOAT, T2."Amount"))))
								ELSE (0)
								END AS "EK Fahrzeug",
							(
								CASE 
									WHEN (
											(
												(T1."No_" BETWEEN '71000' AND '71390')
												OR (T1."No_" BETWEEN '71700' AND '72995')
												)
											OR (T1."No_" IN ('78200', '78700', '78710', '79000', '79030', '79100', '79130', '78580'))
											)
										THEN (((convert(FLOAT, T2."Amount"))))
									ELSE (0)
									END
								) - (
								CASE 
									WHEN (T1."No_" BETWEEN '71400' AND '71690')
										THEN (((convert(FLOAT, T2."Amount"))) * - 1)
									ELSE (0)
									END
								) AS "Einsatz",
							CASE 
								WHEN (
										(T1."No_" LIKE '8%')
										AND ((right(T2."Global Dimension 1 Code", 2)) IN ('10', '20', '80', '11', '21'))
										)
									THEN (((convert(FLOAT, T2."Amount"))) * - 1)
								ELSE (0)
								END AS "Erl�s",
							CASE 
								WHEN (
										(
											CASE 
												WHEN (T7."Code" IS NOT NULL)
													THEN (T7."Code" + ' - ' + T7."Name")
												ELSE (T8."Salespers__Purch_ Code")
												END
											) IS NULL
										)
									THEN (' - ' + ' / ' + (T5."No_" + ' - ' + T5."Name"))
								ELSE (
										(
											CASE 
												WHEN (T7."Code" IS NOT NULL)
													THEN (T7."Code" + ' - ' + T7."Name")
												ELSE (T8."Salespers__Purch_ Code")
												END
											) + ' / ' + (T5."No_" + ' - ' + T5."Name")
										)
								END AS "FZG_Liste_4",
							T3."Model" AS "Model_ori",
							CASE 
								WHEN ('' IS NULL)
									THEN (' - ' + ' / ' + T6."Name")
								ELSE ('' + ' / ' + T6."Name")
								END AS "FZG_Liste_2",
							CASE 
								WHEN (
										(
											CASE 
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'GA'
															)
														AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
														)
													THEN ('GA - diff.best.')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'GA'
															)
														AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
														)
													THEN ('GA - regelbest.')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
														)
													THEN ('NA')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
														)
													THEN ('NA')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												ELSE NULL
												END
											) IS NOT NULL
										)
									THEN (
											(right(((T2."VIN")), 7)) + ' - ' + (
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - diff.best.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - regelbest.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
															)
														THEN ('VFW')
													ELSE NULL
													END
												) + ' / ' + (
												convert(VARCHAR(50), year((
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															))) + '-' + convert(VARCHAR(50), month((
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															))) + '-' + convert(VARCHAR(50), day((
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															)))
												)
											)
								ELSE (
										(right(((T2."VIN")))) + ' - ' + (
											convert(VARCHAR(50), year((
														CASE 
															WHEN (T3."Date of Sale" IS NULL)
																THEN (T2."Posting Date")
															ELSE (T3."Date of Sale")
															END
														))) + '-' + convert(VARCHAR(50), month((
														CASE 
															WHEN (T3."Date of Sale" IS NULL)
																THEN (T2."Posting Date")
															ELSE (T3."Date of Sale")
															END
														))) + '-' + convert(VARCHAR(50), day((
														CASE 
															WHEN (T3."Date of Sale" IS NULL)
																THEN (T2."Posting Date")
															ELSE (T3."Date of Sale")
															END
														)))
											)
										)
								END AS "FZG_Liste_1_ori",
							T3."Engine Code" AS "Engine Code",
							T6."Name" AS "Name_Vorbesitzer",
							T6."No_" AS "No_Vorbesitzer",
							T3."Old Customer No_" AS "Old Customer No_2",
							T5."Gen_ Bus_ Posting Group" AS "Kundenart",
							T5."Customer Type" AS "Customer Type",
							T5."Name" AS "Name_Customer",
							T5."No_" AS "No_Customer",
							T3."Customer No_" AS "Customer No",
							CASE 
								WHEN (T3."Date of Sale" IS NULL)
									THEN (T2."Posting Date")
								ELSE (T3."Date of Sale")
								END AS "Invoice Date",
							T3."Date of Sale" AS "Date Of Sale",
							T3."Inventory Posting Group" AS "Inventory Posting Group",
							(right(((T2."VIN")), 7)) AS "FZG-Liste",
							((convert(FLOAT, T2."Amount"))) AS "Betrag",
							CASE 
								WHEN (
										(
											CASE 
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'GA'
															)
														AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
														)
													THEN ('GA - diff.best.')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'GA'
															)
														AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
														)
													THEN ('GA - regelbest.')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
														)
													THEN ('NA')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
														)
													THEN ('NA')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												ELSE NULL
												END
											) = 'VFW'
										)
									THEN ((convert(VARCHAR(50), year(T3."Initial Registration")) + '-' + convert(VARCHAR(50), month(T3."Initial Registration")) + '-' + convert(VARCHAR(50), day(T3."Initial Registration"))))
								WHEN (
										(
											CASE 
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group")) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'GA'
															)
														AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
														)
													THEN ('GA - diff.best.')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'GA'
															)
														AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
														)
													THEN ('GA - regelbest.')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
														)
													THEN ('NA')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
														)
													THEN ('NA')
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												ELSE NULL
												END
											) = 'NA'
										)
									THEN ((convert(VARCHAR(50), year(T3."Purchase Receipt Date")) + '-' + convert(VARCHAR(50), month(T3."Purchase Receipt Date")) + '-' + convert(VARCHAR(50), day(T3."Purchase Receipt Date"))))
								WHEN (
										(
											CASE 
												WHEN ((left(T3."Inventory Posting Group")) IN ('NW', 'VF', 'FA'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												ELSE NULL
												END
											) = 'GA'
										)
									THEN ((convert(VARCHAR(50), year(T3."Purchase Receipt Date")) + '-' + convert(VARCHAR(50), month(T3."Purchase Receipt Date")) + '-' + convert(VARCHAR(50), day(T3."Purchase Receipt Date"))))
								ELSE NULL
								END AS "EZ/Eingang",
							T3."Initial Registration" AS "Initial Registration",
							CASE 
								WHEN (
										(
											(
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - diff.best.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - regelbest.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
															)
														THEN ('VFW')
													ELSE NULL
													END
												) = 'NA'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) BETWEEN 0 AND 30
											)
										)
									THEN ('0 - 30 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - diff.best.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - regelbest.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
															)
														THEN ('VFW')
													ELSE NULL
													END
												) = 'NA'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) BETWEEN 31 AND 60
											)
										)
									THEN ('31 - 60 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - diff.best.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - regelbest.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
															)
														THEN ('VFW')
													ELSE NULL
													END
												) = 'NA'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) BETWEEN 61 AND 90
											)
										)
									THEN ('61 - 90 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - diff.best.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - regelbest.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
															)
														THEN ('VFW')
													ELSE NULL
													END
												) = 'NA'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) BETWEEN 91 AND 180
											)
										)
									THEN ('91 - 180 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - diff.best.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - regelbest.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
															)
														THEN ('VFW')
													ELSE NULL
													END
												) = 'NA'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) > 180
											)
										)
									THEN ('> 180 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - diff.best.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - regelbest.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
															)
														THEN ('VFW')
													ELSE NULL
													END
												) = 'VFW'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) BETWEEN 0 AND 90
											)
										)
									THEN ('0 - 90 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - diff.best.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - regelbest.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
															)
														THEN ('VFW')
													ELSE NULL
													END
												) = 'VFW'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) BETWEEN 91 AND 150
											)
										)
									THEN ('91 - 150 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - diff.best.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - regelbest.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
															)
														THEN ('VFW')
													ELSE NULL
													END
												) = 'VFW'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) BETWEEN 151 AND 210
											)
										)
									THEN ('151 - 210 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - diff.best.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - regelbest.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
															)
														THEN ('VFW')
													ELSE NULL
													END
												) = 'VFW'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) > 210
											)
										)
									THEN ('> 210 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'GA'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) BETWEEN 0 AND 30
											)
										)
									THEN ('0 - 30 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'GA'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) BETWEEN 31 AND 60
											)
										)
									THEN ('31 - 60 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'GA'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) BETWEEN 61 AND 90
											)
										)
									THEN ('61 - 90 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'GA'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) BETWEEN 91 AND 180
											)
										)
									THEN ('91 - 180 Tage')
								WHEN (
										(
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'GA'
											)
										AND (
											(
												(
													- 1 * datediff(day, (
															CASE 
																WHEN (T3."Date of Sale" IS NULL)
																	THEN (T2."Posting Date")
																ELSE (T3."Date of Sale")
																END
															), T3."Purchase Receipt Date")
													)
												) > 180
											)
										)
									THEN ('> 180 Tage')
								ELSE NULL
								END AS "Standtagestaffel",
							(
								- 1 * datediff(day, (
										CASE 
											WHEN (T3."Date of Sale" IS NULL)
												THEN (T2."Posting Date")
											ELSE (T3."Date of Sale")
											END
										), T3."Purchase Receipt Date")
								) AS "Standtage_ori",
							T3."Purchase Receipt Date" AS "Purchase Receipt Date",
							T3."Location Code" AS "Location Code",
							CASE 
								WHEN (
										(
											CASE 
												WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												ELSE NULL
												END
											) = 'NA'
										)
									THEN (
											(right(((T2."VIN")), 7)) + ' / ' + T3."Model" + ' / ' + (
												CASE 
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - diff.best.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'GA'
																)
															AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
															)
														THEN ('GA - regelbest.')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
															)
														THEN ('NA')
													WHEN (
															(
																(
																	CASE 
																		WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
																			THEN ('NA')
																		WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																			THEN ('GA')
																		ELSE NULL
																		END
																	) = 'NA'
																)
															AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
															)
														THEN ('VFW')
													ELSE NULL
													END
												) + ' / ' + T3."Location Code" + ' / ' + (T5."No_" + ' - ' + T5."Name")
											)
								ELSE ((right(((T2."VIN")), 7)) + ' / ' + T3."Model" + ' / ' + T3."Location Code" + ' / ' + (T5."No_" + ' - ' + T5."Name"))
								END AS "FZG",
							CASE 
								WHEN (
										(
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'GA'
											)
										AND (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
										)
									THEN ('GA - diff.best.')
								WHEN (
										(
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'GA'
											)
										AND (NOT T3."VAT Prod_ Posting Group" LIKE 'DIFF%')
										)
									THEN ('GA - regelbest.')
								WHEN (
										(
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'NA'
											)
										AND ((left(T3."Inventory Posting Group", 2)) = 'NW')
										)
									THEN ('NA')
								WHEN (
										(
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'NA'
											)
										AND ((left(T3."Inventory Posting Group", 2)) = 'FA')
										)
									THEN ('NA')
								WHEN (
										(
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													ELSE NULL
													END
												) = 'NA'
											)
										AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
										)
									THEN ('VFW')
								ELSE NULL
								END AS "Fahrzeugtyp_alt",
							T3."VAT Prod_ Posting Group" AS "Vat Prod Posting Group",
							CASE 
								WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF', 'FA'))
									THEN ('NA')
								WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
									THEN ('GA')
								ELSE NULL
								END AS "Fahrzeugart",
							T3."Market Segment Code" AS "Market Segment Code",
							(
								CASE 
									WHEN (
											NOT (
												CASE 
													WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
														THEN (T3."Make Code")
													ELSE ('Fremdfabrikat')
													END
												) IN ('Fremdfabrikat')
											)
										THEN (
												(
													CASE 
														WHEN (
																(
																	(
																		CASE 
																			WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																				THEN (T3."Make Code")
																			ELSE ('Fremdfabrikat')
																			END
																		) = 'BMW'
																	)
																AND ((left(T4."Description", 1)) BETWEEN '1' AND '9')
																)
															THEN ((left(T4."Description", 1)) + 'er')
														WHEN (
																(
																	(
																		CASE 
																			WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																				THEN (T3."Make Code")
																			ELSE ('Fremdfabrikat')
																			END
																		) = 'BMW'
																	)
																AND ((left(T4."Description", 1)) BETWEEN 'A' AND 'Z')
																)
															THEN ((left(T4."Description", 2)))
														WHEN (
																(
																	(
																		CASE 
																			WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																				THEN (T3."Make Code")
																			ELSE ('Fremdfabrikat')
																			END
																		) = 'BMW-MINI'
																	)
																AND (
																	(T4."Description" LIKE '%3-T%')
																	OR (T3."Model" LIKE '%3-T%')
																	)
																)
															THEN ('3-T�rer')
														WHEN (
																(
																	(
																		CASE 
																			WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																				THEN (T3."Make Code")
																			ELSE ('Fremdfabrikat')
																			END
																		) = 'BMW-MINI'
																	)
																AND (
																	(T4."Description" LIKE '%5-T%')
																	OR (T3."Model" LIKE '%5-T%')
																	)
																)
															THEN ('5-T�rer')
														WHEN (
																(
																	(
																		CASE 
																			WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																				THEN (T3."Make Code")
																			ELSE ('Fremdfabrikat')
																			END
																		) = 'BMW-MINI'
																	)
																AND (
																	(T4."Description" LIKE '%Club%')
																	OR (T3."Model" LIKE '%Club%')
																	)
																)
															THEN ('Clubman')
														WHEN (
																(
																	(
																		CASE 
																			WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																				THEN (T3."Make Code")
																			ELSE ('Fremdfabrikat')
																			END
																		) = 'BMW-MINI'
																	)
																AND (
																	(T4."Description" LIKE '%Count%')
																	OR (T3."Model" LIKE '%Count%')
																	)
																)
															THEN ('Countryman')
														WHEN (
																(
																	(
																		CASE 
																			WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																				THEN (T3."Make Code")
																			ELSE ('Fremdfabrikat')
																			END
																		) = 'BMW-MINI'
																	)
																AND (
																	(T4."Description" LIKE '%Cou%')
																	OR (T3."Model" LIKE '%Cou%')
																	)
																)
															THEN ('Coupe')
														WHEN (
																(
																	(
																		CASE 
																			WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																				THEN (T3."Make Code")
																			ELSE ('Fremdfabrikat')
																			END
																		) = 'BMW-MINI'
																	)
																AND (
																	(T4."Description" LIKE '%Hatch%')
																	OR (T3."Model" LIKE '%Hatch%')
																	)
																)
															THEN ('Hatch')
														WHEN (
																(
																	(
																		CASE 
																			WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																				THEN (T3."Make Code")
																			ELSE ('Fremdfabrikat')
																			END
																		) = 'BMW-MINI'
																	)
																AND (
																	(T4."Description" LIKE '%Pace%')
																	OR (T3."Model" LIKE '%Pace%')
																	)
																)
															THEN ('Paceman')
														WHEN (
																(
																	(
																		CASE 
																			WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																				THEN (T3."Make Code")
																			ELSE ('Fremdfabrikat')
																			END
																		) = 'BMW-MINI'
																	)
																AND (
																	(T4."Description" LIKE '%Road%')
																	OR (T3."Model" LIKE '%Road%')
																	)
																)
															THEN ('Roadster')
														WHEN (
																(
																	(
																		CASE 
																			WHEN (T3."Make Code" IN ('BMW', 'BMW I', 'BMWI', 'BMW-MINI', 'BMW-MOT'))
																				THEN (T3."Make Code")
																			ELSE ('Fremdfabrikat')
																			END
																		) = 'BMW-MINI'
																	)
																AND (
																	(T4."Description" LIKE '%Cab%')
																	OR (T3."Model" LIKE '%Cab%')
																	)
																)
															THEN ('Cabrio')
														ELSE (T4."Description")
														END
													)
												)
									ELSE ('Fremd')
									END
								) AS "Model",
							T3."Make Code" AS "Make Code_Vehicle",
							CASE 
								WHEN (
										(T2."Branch Code" = 'TIM')
										OR (T2."Branch Code" = '')
										)
									THEN ('10')
								WHEN (T2."Branch Code" = 'TNE')
									THEN ('20')
								ELSE ((left(T1."Global Dimension 1 Code", 2)))
								END AS "Standort_alt",
							T3."Model No_" AS "Model No",
							T3."Class" AS "Class",
							T3."Type" AS "Type",
							T3."Vehicle Status" AS "Vehicle Status",
							T3."VIN" AS "Vin_Vehicle",
							T2."Veh_ Source Code" AS "Veh Source Code",
							T2."Book No_" AS "Book No",
							(T2."VIN") AS "Vin",
							T2."Main Area" AS "Main Area",
							T2."Branch Code" AS "Branch Code",
							T2."No_ Series" AS "No Series",
							T2."Source No_" AS "Source No",
							T2."Source Type" AS "Source Type",
							T2."Document Date" AS "Document Date",
							T2."Credit Amount" AS "Credit Amount",
							T2."Debit Amount" AS "Debit Amount",
							T2."Quantity" AS "Quantity",
							T2."Source Code" AS "Source Code",
							T2."User ID" AS "User Id",
							T2."Global Dimension 2 Code" AS "Make Code",
							T2."Global Dimension 1 Code" AS "Department Code",
							T2."Bal_ Account No_" AS "Bal Account No",
							T2."Amount" AS "Amount",
							T2."Description" AS "Description",
							T2."Document No_" AS "Document No",
							T2."Document Type" AS "Document Type",
							T2."Posting Date" AS "Posting Date",
							T2."G_L Account No_" AS "G L Account No",
							T2."Entry No_" AS "Entry No",
							T1."Income_Balance" AS "Income Balance",
							T1."Global Dimension 2 Code" AS "Make Code_2",
							T1."Global Dimension 1 Code" AS "Department Code_2",
							T1."Account Type" AS "Account Type",
							T1."Name" AS "Name",
							T1."No_" AS "No"
						FROM "Vogl7x"."dbo"."BMW AH Vogl$G_L Account" T1,
							(
								(
									(
										(
											(
												(
													"Vogl7x"."dbo"."BMW AH Vogl$G_L Entry" T2 LEFT JOIN "Vogl7x"."dbo"."BMW AH Vogl$Vehicle" T3 ON T3."VIN" = T2."VIN"
													) LEFT JOIN "Vogl7x"."dbo"."BMW AH Vogl$Item" T4 ON T4."No_" = T3."Model No_"
												) LEFT JOIN "Vogl7x"."dbo"."BMW AH Vogl$Customer" T5 ON T3."Customer No_" = T5."No_"
											) LEFT JOIN "Vogl7x"."dbo"."BMW AH Vogl$Customer" T6 ON T3."Old Customer No_" = T6."No_"
										) LEFT JOIN "Vogl7x"."dbo"."BMW AH Vogl$Vehicle Ledger Entry" T8 ON (
											(T8."VIN" = T3."VIN")
											AND (T8."Current Sales Ledger Entry" = 1)
											)
										AND (T8."Book No_" = T3."Current Book No_")
									) LEFT JOIN "Vogl7x"."dbo"."BMW AH Vogl$Salesperson_Purchaser" T7 ON T8."Salespers__Purch_ Code" = T7."Code"
								)
						WHERE (T1."No_" = T2."G_L Account No_")
							AND (
								(
									(
										(
											(
												(
													(
														(
															(
																(T1."No_" IN ('88200', '78200', '78700', '78710', '79000', '79030', '79100', '79130', '88210', '88220', '88230', '88240', '88290', '88310', '88320', '88400', '88410', '88420', '88430', '88560', '88570', '88700', '88710', '88720', '88730', '88740', '88750', '88760', '88770', '88780', '88790', '89000', '89030', '88580', '88581', '88582', '78580', '88584', '88583'))
																OR (T1."No_" BETWEEN '71000' AND '72990')
																)
															OR (T1."No_" BETWEEN '81000' AND '82990')
															)
														OR (
															(
																(T1."No_" LIKE '4%')
																AND (T2."Book No_" <> ' ')
																)
															AND (T2."Posting Date" >= T3."Purchase Receipt Date")
															)
														)
													AND (NOT T2."Description" IN ('GuV-Konten Nullstellung', 'GuV Konten Nullstellung'))
													)
												AND (T2."Posting Date" >= convert(DATETIME, '2019-12-01 00:00:00.000'))
												)
											AND (((T2."VIN")) <> ' ')
											)
										AND (T3."Inventory Posting Group" <> 'GROSSKD')
										)
									AND (T3."Current Book No_" = T2."Book No_")
									)
								AND (T3."Date of Sale" >= convert(DATETIME, '2020-01-01 00:00:00.000'))
								)
						) D3
					) D7
				) D1
			WHERE (
					("Summe_Betrag" <> 0)
					AND (NOT c138 BETWEEN - 0.1 AND 0.1)
					)
			) D6
		) D5
	) D2
	-- order by "Summe EK-FZG" asc,"Vin" asc,"Posting Date" asc,"Document No" asc