C11/System/ARI/IQD/NW_GW/NW_GW_VK_TIM_Grosskd.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" AS "Fahrzeugtyp",
	"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",
	"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",
	"Menge_final" AS "Menge_final",
	"No_Item" AS "No_Item",
	"Description_Item" AS "Description_Item",
	"Vehicle Type Code_Item" AS "Vehicle Type Code_Item"
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" AS "Fahrzeugtyp",
		"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 c232) AS "Menge_2_test",
		("Menge1" / COUNT("Vin") OVER (PARTITION BY c232)) AS "Menge3_test",
		CASE 
			WHEN ("Document No" LIKE 'VGGF%')
				THEN (("Menge1" / COUNT("Vin") OVER (PARTITION BY c232)) * - 1)
			ELSE ("Menge1" / COUNT("Vin") OVER (PARTITION BY c232))
			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",
		"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",
		"Menge_final" AS "Menge_final",
		"No_Item" AS "No_Item",
		"Description_Item" AS "Description_Item",
		"Vehicle Type Code_Item" AS "Vehicle Type Code_Item"
	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" AS "Fahrzeugtyp",
			"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",
			"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",
			"Menge_final" AS "Menge_final",
			"No_Item" AS "No_Item",
			"Description_Item" AS "Description_Item",
			"Vehicle Type Code_Item" AS "Vehicle Type Code_Item",
			c232 AS c232
		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" AS "Fahrzeugtyp",
				"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",
				"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",
				("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",
				(c129) AS c232
			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",
					"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 c132) AS "Summe_Betrag",
					"Vat Bus Posting Group_Kunde",
					"FZG_Liste_5_ori",
					"Customer Group Code",
					"FZG_Liste_5",
					(' - ') AS "FZG_Liste_6",
					"Kunde" AS "FZG_Liste_7",
					"FZG_Detail",
					"No_Item",
					"Model" AS "Description_Item",
					"Vehicle Type Code_Item",
					c133 AS c129
				FROM (
					SELECT (((T2."VIN"))) AS c132,
						((T2."VIN")) + T2."Document No_" AS c133,
						T4."Vehicle Type Code" AS "Vehicle Type Code_Item",
						T4."Description" AS "Model",
						T4."No_" AS "No_Item",
						((T2."VIN")) + ' - ' + T3."Location Code" + ' - ' + (
							CASE 
								WHEN (
										(
											(
												CASE 
													WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													WHEN (T3."Inventory Posting Group" = 'GROSSKD')
														THEN ('GK')
													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'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													WHEN (T3."Inventory Posting Group" = 'GROSSKD')
														THEN ('GK')
													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'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													WHEN (T3."Inventory Posting Group" = 'GROSSKD')
														THEN ('GK')
													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'))
														THEN ('NA')
													WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
														THEN ('GA')
													WHEN (T3."Inventory Posting Group" = 'GROSSKD')
														THEN ('GK')
													ELSE NULL
													END
												) = 'NA'
											)
										AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
										)
									THEN ('VFW')
								WHEN (
										(
											CASE 
												WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												WHEN (T3."Inventory Posting Group" = 'GROSSKD')
													THEN ('GK')
												ELSE NULL
												END
											) = 'GK'
										)
									THEN ('GK')
								ELSE NULL
								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",
						(T5."Customer Group Code" + ' / ' + ' - ' + ' / ' + T5."Gen_ Bus_ Posting Group" + ' / ' + (T5."No_" + ' - ' + T5."Name")) 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'))
												THEN ('NA')
											WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
												THEN ('GA')
											WHEN (T3."Inventory Posting Group" = 'GROSSKD')
												THEN ('GK')
											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'))
												THEN ('NA')
											WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
												THEN ('GA')
											WHEN (T3."Inventory Posting Group" = 'GROSSKD')
												THEN ('GK')
											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'))
																					THEN ('NA')
																				WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																					THEN ('GA')
																				WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																					THEN ('GK')
																				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'))
																					THEN ('NA')
																				WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																					THEN ('GA')
																				WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																					THEN ('GK')
																				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'))
																					THEN ('NA')
																				WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																					THEN ('GA')
																				WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																					THEN ('GK')
																				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'))
																					THEN ('NA')
																				WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																					THEN ('GA')
																				WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																					THEN ('GK')
																				ELSE NULL
																				END
																			) = 'NA'
																		)
																	AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
																	)
																THEN ('VFW')
															WHEN (
																	(
																		CASE 
																			WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																				THEN ('NA')
																			WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																				THEN ('GA')
																			WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																				THEN ('GK')
																			ELSE NULL
																			END
																		) = 'GK'
																	)
																THEN ('GK')
															ELSE NULL
															END
														) IS NOT NULL
													)
												THEN (
														(right(((T2."VIN")), 7)) + ' - ' + (
															CASE 
																WHEN (
																		(
																			(
																				CASE 
																					WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																						THEN ('GK')
																					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'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																						THEN ('GK')
																					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'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																						THEN ('GK')
																					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'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																						THEN ('GK')
																					ELSE NULL
																					END
																				) = 'NA'
																			)
																		AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
																		)
																	THEN ('VFW')
																WHEN (
																		(
																			CASE 
																				WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																					THEN ('NA')
																				WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																					THEN ('GA')
																				WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																					THEN ('GK')
																				ELSE NULL
																				END
																			) = 'GK'
																		)
																	THEN ('GK')
																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'))
																					THEN ('NA')
																				WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																					THEN ('GA')
																				WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																					THEN ('GK')
																				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'))
																					THEN ('NA')
																				WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																					THEN ('GA')
																				WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																					THEN ('GK')
																				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'))
																					THEN ('NA')
																				WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																					THEN ('GA')
																				WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																					THEN ('GK')
																				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'))
																					THEN ('NA')
																				WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																					THEN ('GA')
																				WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																					THEN ('GK')
																				ELSE NULL
																				END
																			) = 'NA'
																		)
																	AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
																	)
																THEN ('VFW')
															WHEN (
																	(
																		CASE 
																			WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																				THEN ('NA')
																			WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																				THEN ('GA')
																			WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																				THEN ('GK')
																			ELSE NULL
																			END
																		) = 'GK'
																	)
																THEN ('GK')
															ELSE NULL
															END
														) IS NOT NULL
													)
												THEN (
														(right(((T2."VIN")), 7)) + ' - ' + (
															CASE 
																WHEN (
																		(
																			(
																				CASE 
																					WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																						THEN ('GK')
																					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'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																						THEN ('GK')
																					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'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																						THEN ('GK')
																					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'))
																						THEN ('NA')
																					WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																						THEN ('GA')
																					WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																						THEN ('GK')
																					ELSE NULL
																					END
																				) = 'NA'
																			)
																		AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
																		)
																	THEN ('VFW')
																WHEN (
																		(
																			CASE 
																				WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																					THEN ('NA')
																				WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																					THEN ('GA')
																				WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																					THEN ('GK')
																				ELSE NULL
																				END
																			) = 'GK'
																		)
																	THEN ('GK')
																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'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												WHEN (T3."Inventory Posting Group" = 'GROSSKD')
													THEN ('GK')
												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'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												WHEN (T3."Inventory Posting Group" = 'GROSSKD')
													THEN ('GK')
												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'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																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'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																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'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																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'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'NA'
														)
													AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
													)
												THEN ('VFW')
											WHEN (
													(
														CASE 
															WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																THEN ('NA')
															WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																THEN ('GA')
															WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																THEN ('GK')
															ELSE NULL
															END
														) = 'GK'
													)
												THEN ('GK')
											ELSE NULL
											END
										) IS NOT NULL
									)
								THEN (
										(right(((T2."VIN")), 7)) + ' - ' + (
											CASE 
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												WHEN (
														(
															CASE 
																WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'GK'
														)
													THEN ('GK')
												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'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																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'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																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'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																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'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'NA'
														)
													AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
													)
												THEN ('VFW')
											WHEN (
													(
														CASE 
															WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																THEN ('NA')
															WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																THEN ('GA')
															WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																THEN ('GK')
															ELSE NULL
															END
														) = 'GK'
													)
												THEN ('GK')
											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'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																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'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																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'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																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'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'NA'
														)
													AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
													)
												THEN ('VFW')
											WHEN (
													(
														CASE 
															WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																THEN ('NA')
															WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																THEN ('GA')
															WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																THEN ('GK')
															ELSE NULL
															END
														) = 'GK'
													)
												THEN ('GK')
											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'))
												THEN ('NA')
											WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
												THEN ('GA')
											WHEN (T3."Inventory Posting Group" = 'GROSSKD')
												THEN ('GK')
											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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												WHEN (
														(
															CASE 
																WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'GK'
														)
													THEN ('GK')
												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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												WHEN (
														(
															CASE 
																WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'GK'
														)
													THEN ('GK')
												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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												WHEN (
														(
															CASE 
																WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'GK'
														)
													THEN ('GK')
												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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												WHEN (
														(
															CASE 
																WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'GK'
														)
													THEN ('GK')
												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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												WHEN (
														(
															CASE 
																WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'GK'
														)
													THEN ('GK')
												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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												WHEN (
														(
															CASE 
																WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'GK'
														)
													THEN ('GK')
												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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												WHEN (
														(
															CASE 
																WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'GK'
														)
													THEN ('GK')
												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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												WHEN (
														(
															CASE 
																WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'GK'
														)
													THEN ('GK')
												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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												WHEN (
														(
															CASE 
																WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'GK'
														)
													THEN ('GK')
												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'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												WHEN (T3."Inventory Posting Group" = 'GROSSKD')
													THEN ('GK')
												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'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												WHEN (T3."Inventory Posting Group" = 'GROSSKD')
													THEN ('GK')
												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'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												WHEN (T3."Inventory Posting Group" = 'GROSSKD')
													THEN ('GK')
												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'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												WHEN (T3."Inventory Posting Group" = 'GROSSKD')
													THEN ('GK')
												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'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												WHEN (T3."Inventory Posting Group" = 'GROSSKD')
													THEN ('GK')
												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'))
												THEN ('NA')
											WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
												THEN ('GA')
											WHEN (T3."Inventory Posting Group" = 'GROSSKD')
												THEN ('GK')
											ELSE NULL
											END
										) = 'NA'
									)
								THEN (
										(right(((T2."VIN")), 7)) + ' / ' + T3."Model" + ' / ' + (
											CASE 
												WHEN (
														(
															(
																CASE 
																	WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	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'))
																		THEN ('NA')
																	WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																		THEN ('GA')
																	WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																		THEN ('GK')
																	ELSE NULL
																	END
																) = 'NA'
															)
														AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
														)
													THEN ('VFW')
												WHEN (
														(
															CASE 
																WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																	THEN ('NA')
																WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																	THEN ('GA')
																WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																	THEN ('GK')
																ELSE NULL
																END
															) = 'GK'
														)
													THEN ('GK')
												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'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												WHEN (T3."Inventory Posting Group" = 'GROSSKD')
													THEN ('GK')
												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'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												WHEN (T3."Inventory Posting Group" = 'GROSSKD')
													THEN ('GK')
												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'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												WHEN (T3."Inventory Posting Group" = 'GROSSKD')
													THEN ('GK')
												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'))
													THEN ('NA')
												WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
													THEN ('GA')
												WHEN (T3."Inventory Posting Group" = 'GROSSKD')
													THEN ('GK')
												ELSE NULL
												END
											) = 'NA'
										)
									AND ((left(T3."Inventory Posting Group", 2)) = 'VF')
									)
								THEN ('VFW')
							WHEN (
									(
										CASE 
											WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
												THEN ('NA')
											WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
												THEN ('GA')
											WHEN (T3."Inventory Posting Group" = 'GROSSKD')
												THEN ('GK')
											ELSE NULL
											END
										) = 'GK'
									)
								THEN ('GK')
							ELSE NULL
							END AS "Fahrzeugtyp",
						T3."VAT Prod_ Posting Group" AS "Vat Prod Posting Group",
						CASE 
							WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
								THEN ('NA')
							WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
								THEN ('GA')
							WHEN (T3."Inventory Posting Group" = 'GROSSKD')
								THEN ('GK')
							ELSE NULL
							END AS "Fahrzeugart",
						T3."Market Segment Code" AS "Market Segment Code",
						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 (
							(
								(
									(
										(
											(
												(
													(
														(NOT ((T2."VIN")) IN ('WBAEJ13431AH60555', 'WBADX71020E767689', '00000000000055098', '00000000002265189', '00000000002262667'))
														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 (T2."Posting Date" >= T3."Purchase Receipt Date")
									)
								AND (
									(
										CASE 
											WHEN (
													(
														CASE 
															WHEN ((left(T3."Inventory Posting Group", 2)) IN ('NW', 'VF'))
																THEN ('NA')
															WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																THEN ('GA')
															WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																THEN ('GK')
															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'))
																THEN ('NA')
															WHEN ((left(T3."Inventory Posting Group", 2)) = 'GW')
																THEN ('GA')
															WHEN (T3."Inventory Posting Group" = 'GROSSKD')
																THEN ('GK')
															ELSE NULL
															END
														)
													)
											END
										) IS NOT NULL
									)
								)
							AND (NOT T2."Global Dimension 1 Code" IN ('1080', '1090', '1091', '1092', '2080', '2090', '3080', '3090'))
							)
					) D3
				) D1
			WHERE ("Summe_Betrag" <> 0)
			) D6
		) D5
	) D2
	-- order by "Summe EK-FZG" asc,"Vin" asc,"Posting Date" asc,"Document No" asc