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

select "No" as "No",
	   "Name" as "Name",
	   "Account Type" as "Account Type",
	   "Department Code" as "Department Code",
	   "Make Code" as "Make Code",
	   "Income Balance" as "Income Balance",
	   "Entry No" as "Entry No",
	   "G L Account No" as "G L Account No",
	   "Posting Date" as "Posting Date",
	   "Document Type" as "Document Type",
	   "Document No" as "Document No",
	   "Description" as "Description",
	   "Amount" as "Amount",
	   "Bal Account No" as "Bal Account No",
	   "Department Code" as "Department Code",
	   "Make Code" as "Make Code",
	   "User Id" as "User Id",
	   "Source Code" as "Source Code",
	   "Quantity" as "Quantity",
	   "Debit Amount" as "Debit Amount",
	   "Credit Amount" as "Credit Amount",
	   "Document Date" as "Document Date",
	   "Source Type" as "Source Type",
	   "Source No" as "Source No",
	   "No Series" as "No Series",
	   "Branch Code" as "Branch Code",
	   "Main Area" as "Main Area",
	   "Vin" as "Vin",
	   "Book No" as "Book No",
	   "Veh Source Code" as "Veh Source Code",
	   "Betrag" as "Betrag",
	   "Vin_Vehicle" as "Vin_Vehicle",
	   "Vehicle Status" as "Vehicle Status",
	   "Model_ori" as "Model_ori",
	   "Type" as "Type",
	   "Class" as "Class",
	   "Model No" as "Model No",
	   "Hauptbetrieb" as "Hauptbetrieb",
	   "Standort_alt" as "Standort_alt",
	   "Make Code_Vehicle" as "Make Code_Vehicle",
	   "Fabrikat_ori" as "Fabrikat_ori",
	   "Model" as "Model",
	   "Market Segment Code" as "Market Segment Code",
	   "Modellbez" as "Modellbez",
	   "Fahrzeugart" as "Fahrzeugart",
	   "Vat Prod Posting Group" as "Vat Prod Posting Group",
	   "Fahrzeugtyp_alt" as "Fahrzeugtyp_alt",
	   "FZG" as "FZG",
	   "Location Code" as "Location Code",
	   "VB_Einkauf" as "VB_Einkauf",
	   "Purchase Receipt Date" as "Purchase Receipt Date",
	   "Standtage_ori" as "Standtage_ori",
	   "Standtagestaffel" as "Standtagestaffel",
	   "Initial Registration" as "Initial Registration",
	   "EZ/Eingang" as "EZ/Eingang",
	   "Polster" as "Polster",
	   "Farbe" as "Farbe",
	   "Einsatz_ori" as "Einsatz_ori",
	   "Heute" as "Heute",
	   "Fahrzeugstatus" as "Fahrzeugstatus",
	   "FZG-Liste" as "FZG-Liste",
	   "Anzahl" as "Anzahl",
	   "Standtage" as "Standtage",
	   "Inventory Posting Group" as "Inventory Posting Group",
	   "Date Of Sale" as "Date Of Sale",
	   "Invoice Date" as "Invoice Date",
	   "Customer No" as "Customer No",
	   "No_Customer" as "No_Customer",
	   "Name_Customer" as "Name_Customer",
	   "Kunde" as "Kunde",
	   "Customer Type" as "Customer Type",
	   "Kundenart" as "Kundenart",
	   "Old Customer No" as "Old Customer No",
	   "Old Customer No" as "Old Customer No",
	   "No_Vorbesitzer" as "No_Vorbesitzer",
	   "Name_Vorbesitzer" as "Name_Vorbesitzer",
	   "Vorbesitzer" as "Vorbesitzer",
	   "Engine Code" as "Engine Code",
	   "Motor Code" as "Motor Code",
	   "Geschäftsart" as "Geschäftsart",
	   "FZG_Liste_1_ori" as "FZG_Liste_1_ori",
	   "FZG_Liste_2" as "FZG_Liste_2",
	   "FZG_Liste_3" as "FZG_Liste_3",
	   "FZG_Liste_4" as "FZG_Liste_4",
	   "Erlös" as "Erlös",
	   "Einsatz" as "Einsatz",
	   "EK Fahrzeug" as "EK Fahrzeug",
	   "Bonus" as "Bonus",
	   "int. Kosten" as "int. Kosten",
	   "Current Branch Book No" as "Current Branch Book No",
	   "Current Book No" as "Current Book No",
	   "Summe EK-FZG" as "Summe EK-FZG",
	   "Fabrikat" as "Fabrikat",
	   "Buchnummer gleich_ja_nein" as "Buchnummer gleich_ja_nein",
	   "Menge1" as "Menge1",
	   "Menge2" as "Menge2",
	   "Menge3" as "Menge3",
	   "Menge4" as "Menge4",
	   "VIN + PostingDate" as "VIN + PostingDate",
	   SUM("Menge4") OVER (partition by "Vin") as "Summe Menge4",
	   "Menge_2_test" as "Menge_2_test",
	   "Menge3_test" as "Menge3_test",
	   "Menge4_test" as "Menge4_test",
	   "Fahrzeugart_Schmidt" as "Fahrzeugart_Schmidt",
	   "Salespers Purch Code_VLE" as "Salespers Purch Code_VLE",
	   "Code_für_VEH_Ledger_Entry" as "Code_für_VEH_Ledger_Entry",
	   "Name_für_VEH_Ledger_Entry" as "Name_für_VEH_Ledger_Entry",
	   "Verkäufer" as "Verkäufer",
	   "FZG_Liste_1_falsch" as "FZG_Liste_1_falsch",
	   "FZG_Liste_0_ori" as "FZG_Liste_0_ori",
	   "FZG_Liste_1" as "FZG_Liste_1",
	   "FZG_Liste_0" as "FZG_Liste_0",
	   "Beleg" as "Beleg",
	   "Standort_FIBU" as "Standort_FIBU",
	   "Fahrzeugart_neu" as "Fahrzeugart_neu",
	   "Standort" as "Standort",
	   "Summe_Betrag" as "Summe_Betrag",
	   "Country Code_Kunde" as "Country Code_Kunde",
	   "Vat Bus Posting Group_Kunde" as "Vat Bus Posting Group_Kunde",
	   "FZG_Liste_5_ori" as "FZG_Liste_5_ori",
	   "Customer Group Code" as "Customer Group Code",
	   "FZG_Liste_5" as "FZG_Liste_5",
	   "FZG_Liste_6" as "FZG_Liste_6",
	   "FZG_Liste_7" as "FZG_Liste_7",
	   "FZG_Detail" as "FZG_Detail",
	   "Anz. Sätze" as "Anz. Sätze",
	   "Menge_final" as "Menge_final",
	   "No_Item" as "No_Item",
	   "Description_Item" as "Description_Item",
	   "Vehicle Type Code_Item" as "Vehicle Type Code_Item",
	   "Modell_zwischen" as "Modell_zwischen",
	   "Vehicle Category Code" as "Vehicle Category Code",
	   "Summe Erlös FZG" as "Summe Erlös FZG",
	   "Erlöse FZG" as "Erlöse FZG",
	   "Modell_final" as "Modell_final",
	   "Fahrzeugtyp" as "Fahrzeugtyp"
from 
(select "No" as "No",
	   "Name" as "Name",
	   "Account Type" as "Account Type",
	   "Department Code" as "Department Code",
	   "Make Code" as "Make Code",
	   "Income Balance" as "Income Balance",
	   "Entry No" as "Entry No",
	   "G L Account No" as "G L Account No",
	   "Posting Date" as "Posting Date",
	   "Document Type" as "Document Type",
	   "Document No" as "Document No",
	   "Description" as "Description",
	   "Amount" as "Amount",
	   "Bal Account No" as "Bal Account No",
	   "Department Code" as "Department Code",
	   "Make Code" as "Make Code",
	   "User Id" as "User Id",
	   "Source Code" as "Source Code",
	   "Quantity" as "Quantity",
	   "Debit Amount" as "Debit Amount",
	   "Credit Amount" as "Credit Amount",
	   "Document Date" as "Document Date",
	   "Source Type" as "Source Type",
	   "Source No" as "Source No",
	   "No Series" as "No Series",
	   "Branch Code" as "Branch Code",
	   "Main Area" as "Main Area",
	   "Vin" as "Vin",
	   "Book No" as "Book No",
	   "Veh Source Code" as "Veh Source Code",
	   "Betrag" as "Betrag",
	   "Vin_Vehicle" as "Vin_Vehicle",
	   "Vehicle Status" as "Vehicle Status",
	   "Model_ori" as "Model_ori",
	   "Type" as "Type",
	   "Class" as "Class",
	   "Model No" as "Model No",
	   "Hauptbetrieb" as "Hauptbetrieb",
	   "Standort_alt" as "Standort_alt",
	   "Make Code_Vehicle" as "Make Code_Vehicle",
	   "Fabrikat_ori" as "Fabrikat_ori",
	   "Model" as "Model",
	   "Market Segment Code" as "Market Segment Code",
	   "Modellbez" as "Modellbez",
	   "Fahrzeugart" as "Fahrzeugart",
	   "Vat Prod Posting Group" as "Vat Prod Posting Group",
	   "Fahrzeugtyp_alt" as "Fahrzeugtyp_alt",
	   "FZG" as "FZG",
	   "Location Code" as "Location Code",
	   "VB_Einkauf" as "VB_Einkauf",
	   "Purchase Receipt Date" as "Purchase Receipt Date",
	   "Standtage_ori" as "Standtage_ori",
	   "Standtagestaffel" as "Standtagestaffel",
	   "Initial Registration" as "Initial Registration",
	   "EZ/Eingang" as "EZ/Eingang",
	   "Polster" as "Polster",
	   "Farbe" as "Farbe",
	   "Einsatz_ori" as "Einsatz_ori",
	   "Heute" as "Heute",
	   "Fahrzeugstatus" as "Fahrzeugstatus",
	   "FZG-Liste" as "FZG-Liste",
	   "Anzahl" as "Anzahl",
	   "Standtage" as "Standtage",
	   "Inventory Posting Group" as "Inventory Posting Group",
	   "Date Of Sale" as "Date Of Sale",
	   "Invoice Date" as "Invoice Date",
	   "Customer No" as "Customer No",
	   "No_Customer" as "No_Customer",
	   "Name_Customer" as "Name_Customer",
	   "Kunde" as "Kunde",
	   "Customer Type" as "Customer Type",
	   "Kundenart" as "Kundenart",
	   "Old Customer No" as "Old Customer No",
	   "Old Customer No" as "Old Customer No",
	   "No_Vorbesitzer" as "No_Vorbesitzer",
	   "Name_Vorbesitzer" as "Name_Vorbesitzer",
	   "Vorbesitzer" as "Vorbesitzer",
	   "Engine Code" as "Engine Code",
	   "Motor Code" as "Motor Code",
	   "Geschäftsart" as "Geschäftsart",
	   "FZG_Liste_1_ori" as "FZG_Liste_1_ori",
	   "FZG_Liste_2" as "FZG_Liste_2",
	   "FZG_Liste_3" as "FZG_Liste_3",
	   "FZG_Liste_4" as "FZG_Liste_4",
	   "Erlös" as "Erlös",
	   "Einsatz" as "Einsatz",
	   "EK Fahrzeug" as "EK Fahrzeug",
	   "Bonus" as "Bonus",
	   "int. Kosten" as "int. Kosten",
	   "Current Branch Book No" as "Current Branch Book No",
	   "Current Book No" as "Current Book No",
	   "Summe EK-FZG" as "Summe EK-FZG",
	   "Fabrikat" as "Fabrikat",
	   "Buchnummer gleich_ja_nein" as "Buchnummer gleich_ja_nein",
	   "Menge1" as "Menge1",
	   "Menge2" as "Menge2",
	   "Menge3" as "Menge3",
	   "Menge4" as "Menge4",
	   "VIN + PostingDate" as "VIN + PostingDate",
	   COUNT("Vin") OVER (partition by c248) as "Menge_2_test",
	   ("Menge1" / COUNT("Vin") OVER (partition by c248)) as "Menge3_test",
	   CASE WHEN ("Document No" LIKE 'VGGF%') THEN (("Menge1" / COUNT("Vin") OVER (partition by c248)) * -1) ELSE ("Menge1" / COUNT("Vin") OVER (partition by c248)) END as "Menge4_test",
	   "Fahrzeugart_Schmidt" as "Fahrzeugart_Schmidt",
	   "Salespers Purch Code_VLE" as "Salespers Purch Code_VLE",
	   "Code_für_VEH_Ledger_Entry" as "Code_für_VEH_Ledger_Entry",
	   "Name_für_VEH_Ledger_Entry" as "Name_für_VEH_Ledger_Entry",
	   "Verkäufer" as "Verkäufer",
	   "FZG_Liste_1_falsch" as "FZG_Liste_1_falsch",
	   "FZG_Liste_0_ori" as "FZG_Liste_0_ori",
	   "FZG_Liste_1" as "FZG_Liste_1",
	   "FZG_Liste_0" as "FZG_Liste_0",
	   "Beleg" as "Beleg",
	   "Standort_FIBU" as "Standort_FIBU",
	   "Fahrzeugart_neu" as "Fahrzeugart_neu",
	   "Standort" as "Standort",
	   "Summe_Betrag" as "Summe_Betrag",
	   "Country Code_Kunde" as "Country Code_Kunde",
	   "Vat Bus Posting Group_Kunde" as "Vat Bus Posting Group_Kunde",
	   "FZG_Liste_5_ori" as "FZG_Liste_5_ori",
	   "Customer Group Code" as "Customer Group Code",
	   "FZG_Liste_5" as "FZG_Liste_5",
	   "FZG_Liste_6" as "FZG_Liste_6",
	   "FZG_Liste_7" as "FZG_Liste_7",
	   "FZG_Detail" as "FZG_Detail",
	   "Anz. Sätze" as "Anz. Sätze",
	   "Menge_final" as "Menge_final",
	   "No_Item" as "No_Item",
	   "Description_Item" as "Description_Item",
	   "Vehicle Type Code_Item" as "Vehicle Type Code_Item",
	   "Modell_zwischen" as "Modell_zwischen",
	   "Vehicle Category Code" as "Vehicle Category Code",
	   "Summe Erlös FZG" as "Summe Erlös FZG",
	   "Erlöse FZG" as "Erlöse FZG",
	   "Modell_final" as "Modell_final",
	   "Fahrzeugtyp" as "Fahrzeugtyp"
from 
(select "No" as "No",
	   "Name" as "Name",
	   "Account Type" as "Account Type",
	   "Department Code" as "Department Code",
	   "Make Code" as "Make Code",
	   "Income Balance" as "Income Balance",
	   "Entry No" as "Entry No",
	   "G L Account No" as "G L Account No",
	   "Posting Date" as "Posting Date",
	   "Document Type" as "Document Type",
	   "Document No" as "Document No",
	   "Description" as "Description",
	   "Amount" as "Amount",
	   "Bal Account No" as "Bal Account No",
	   "Department Code" as "Department Code",
	   "Make Code" as "Make Code",
	   "User Id" as "User Id",
	   "Source Code" as "Source Code",
	   "Quantity" as "Quantity",
	   "Debit Amount" as "Debit Amount",
	   "Credit Amount" as "Credit Amount",
	   "Document Date" as "Document Date",
	   "Source Type" as "Source Type",
	   "Source No" as "Source No",
	   "No Series" as "No Series",
	   "Branch Code" as "Branch Code",
	   "Main Area" as "Main Area",
	   "Vin" as "Vin",
	   "Book No" as "Book No",
	   "Veh Source Code" as "Veh Source Code",
	   "Betrag" as "Betrag",
	   "Vin_Vehicle" as "Vin_Vehicle",
	   "Vehicle Status" as "Vehicle Status",
	   "Model_ori" as "Model_ori",
	   "Type" as "Type",
	   "Class" as "Class",
	   "Model No" as "Model No",
	   "Hauptbetrieb" as "Hauptbetrieb",
	   "Standort_alt" as "Standort_alt",
	   "Make Code_Vehicle" as "Make Code_Vehicle",
	   "Fabrikat_ori" as "Fabrikat_ori",
	   "Model" as "Model",
	   "Market Segment Code" as "Market Segment Code",
	   "Modellbez" as "Modellbez",
	   "Fahrzeugart" as "Fahrzeugart",
	   "Vat Prod Posting Group" as "Vat Prod Posting Group",
	   "Fahrzeugtyp_alt" as "Fahrzeugtyp_alt",
	   "FZG" as "FZG",
	   "Location Code" as "Location Code",
	   "VB_Einkauf" as "VB_Einkauf",
	   "Purchase Receipt Date" as "Purchase Receipt Date",
	   "Standtage_ori" as "Standtage_ori",
	   "Standtagestaffel" as "Standtagestaffel",
	   "Initial Registration" as "Initial Registration",
	   "EZ/Eingang" as "EZ/Eingang",
	   "Polster" as "Polster",
	   "Farbe" as "Farbe",
	   "Einsatz_ori" as "Einsatz_ori",
	   "Heute" as "Heute",
	   "Fahrzeugstatus" as "Fahrzeugstatus",
	   "FZG-Liste" as "FZG-Liste",
	   "Anzahl" as "Anzahl",
	   "Standtage" as "Standtage",
	   "Inventory Posting Group" as "Inventory Posting Group",
	   "Date Of Sale" as "Date Of Sale",
	   "Invoice Date" as "Invoice Date",
	   "Customer No" as "Customer No",
	   "No_Customer" as "No_Customer",
	   "Name_Customer" as "Name_Customer",
	   "Kunde" as "Kunde",
	   "Customer Type" as "Customer Type",
	   "Kundenart" as "Kundenart",
	   "Old Customer No" as "Old Customer No",
	   "Old Customer No" as "Old Customer No",
	   "No_Vorbesitzer" as "No_Vorbesitzer",
	   "Name_Vorbesitzer" as "Name_Vorbesitzer",
	   "Vorbesitzer" as "Vorbesitzer",
	   "Engine Code" as "Engine Code",
	   "Motor Code" as "Motor Code",
	   "Geschäftsart" as "Geschäftsart",
	   "FZG_Liste_1_ori" as "FZG_Liste_1_ori",
	   "FZG_Liste_2" as "FZG_Liste_2",
	   "FZG_Liste_3" as "FZG_Liste_3",
	   "FZG_Liste_4" as "FZG_Liste_4",
	   "Erlös" as "Erlös",
	   "Einsatz" as "Einsatz",
	   "EK Fahrzeug" as "EK Fahrzeug",
	   "Bonus" as "Bonus",
	   "int. Kosten" as "int. Kosten",
	   "Current Branch Book No" as "Current Branch Book No",
	   "Current Book No" as "Current Book No",
	   "Summe EK-FZG" as "Summe EK-FZG",
	   "Fabrikat" as "Fabrikat",
	   "Buchnummer gleich_ja_nein" as "Buchnummer gleich_ja_nein",
	   "Menge1" as "Menge1",
	   COUNT("Vin") OVER (partition by "VIN + PostingDate") as "Menge2",
	   ("Menge1" / COUNT("Vin") OVER (partition by "VIN + PostingDate")) as "Menge3",
	   CASE WHEN ("Document No" LIKE 'VGGF%') THEN (("Menge1" / COUNT("Vin") OVER (partition by "VIN + PostingDate")) * -1) ELSE ("Menge1" / COUNT("Vin") OVER (partition by "VIN + PostingDate")) END as "Menge4",
	   "VIN + PostingDate" as "VIN + PostingDate",
	   "Fahrzeugart_Schmidt" as "Fahrzeugart_Schmidt",
	   "Salespers Purch Code_VLE" as "Salespers Purch Code_VLE",
	   "Code_für_VEH_Ledger_Entry" as "Code_für_VEH_Ledger_Entry",
	   "Name_für_VEH_Ledger_Entry" as "Name_für_VEH_Ledger_Entry",
	   "Verkäufer" as "Verkäufer",
	   "FZG_Liste_1_falsch" as "FZG_Liste_1_falsch",
	   "FZG_Liste_0_ori" as "FZG_Liste_0_ori",
	   "FZG_Liste_1" as "FZG_Liste_1",
	   "FZG_Liste_0" as "FZG_Liste_0",
	   "Beleg" as "Beleg",
	   "Standort_FIBU" as "Standort_FIBU",
	   "Fahrzeugart_neu" as "Fahrzeugart_neu",
	   "Standort" as "Standort",
	   "Summe_Betrag" as "Summe_Betrag",
	   "Country Code_Kunde" as "Country Code_Kunde",
	   "Vat Bus Posting Group_Kunde" as "Vat Bus Posting Group_Kunde",
	   "FZG_Liste_5_ori" as "FZG_Liste_5_ori",
	   "Customer Group Code" as "Customer Group Code",
	   "FZG_Liste_5" as "FZG_Liste_5",
	   "FZG_Liste_6" as "FZG_Liste_6",
	   "FZG_Liste_7" as "FZG_Liste_7",
	   "FZG_Detail" as "FZG_Detail",
	   "Anz. Sätze" as "Anz. Sätze",
	   "Menge_final" as "Menge_final",
	   "No_Item" as "No_Item",
	   "Description_Item" as "Description_Item",
	   "Vehicle Type Code_Item" as "Vehicle Type Code_Item",
	   "Modell_zwischen" as "Modell_zwischen",
	   "Vehicle Category Code" as "Vehicle Category Code",
	   "Summe Erlös FZG" as "Summe Erlös FZG",
	   "Erlöse FZG" as "Erlöse FZG",
	   "Modell_final" as "Modell_final",
	   "Fahrzeugtyp" as "Fahrzeugtyp",
	   c248 as c248
from 
(select "No" as "No",
	   "Name" as "Name",
	   "Account Type" as "Account Type",
	   "Department Code" as "Department Code",
	   "Make Code" as "Make Code",
	   "Income Balance" as "Income Balance",
	   "Entry No" as "Entry No",
	   "G L Account No" as "G L Account No",
	   "Posting Date" as "Posting Date",
	   "Document Type" as "Document Type",
	   "Document No" as "Document No",
	   "Description" as "Description",
	   "Amount" as "Amount",
	   "Bal Account No" as "Bal Account No",
	   "Department Code" as "Department Code",
	   "Make Code" as "Make Code",
	   "User Id" as "User Id",
	   "Source Code" as "Source Code",
	   "Quantity" as "Quantity",
	   "Debit Amount" as "Debit Amount",
	   "Credit Amount" as "Credit Amount",
	   "Document Date" as "Document Date",
	   "Source Type" as "Source Type",
	   "Source No" as "Source No",
	   "No Series" as "No Series",
	   "Branch Code" as "Branch Code",
	   "Main Area" as "Main Area",
	   "Vin" as "Vin",
	   "Book No" as "Book No",
	   "Veh Source Code" as "Veh Source Code",
	   "Betrag" as "Betrag",
	   "Vin_Vehicle" as "Vin_Vehicle",
	   "Vehicle Status" as "Vehicle Status",
	   "Model_ori" as "Model_ori",
	   "Type" as "Type",
	   "Class" as "Class",
	   "Model No" as "Model No",
	   "Hauptbetrieb" as "Hauptbetrieb",
	   "Standort_alt" as "Standort_alt",
	   "Make Code_Vehicle" as "Make Code_Vehicle",
	   "Fabrikat_ori" as "Fabrikat_ori",
	   "Model" as "Model",
	   "Market Segment Code" as "Market Segment Code",
	   "Modellbez" as "Modellbez",
	   "Fahrzeugart" as "Fahrzeugart",
	   "Vat Prod Posting Group" as "Vat Prod Posting Group",
	   "Fahrzeugtyp_alt" as "Fahrzeugtyp_alt",
	   "FZG" as "FZG",
	   "Location Code" as "Location Code",
	   "VB_Einkauf" as "VB_Einkauf",
	   "Purchase Receipt Date" as "Purchase Receipt Date",
	   "Standtage_ori" as "Standtage_ori",
	   "Standtagestaffel" as "Standtagestaffel",
	   "Initial Registration" as "Initial Registration",
	   "EZ/Eingang" as "EZ/Eingang",
	   "Polster" as "Polster",
	   "Farbe" as "Farbe",
	   "Einsatz_ori" as "Einsatz_ori",
	   "Heute" as "Heute",
	   "Fahrzeugstatus" as "Fahrzeugstatus",
	   "FZG-Liste" as "FZG-Liste",
	   COUNT("Standtage_ori") OVER (partition by "Vin") as "Anzahl",
	   ("Standtage_ori" / COUNT("Standtage_ori") OVER (partition by "Vin")) as "Standtage",
	   "Inventory Posting Group" as "Inventory Posting Group",
	   "Date Of Sale" as "Date Of Sale",
	   "Invoice Date" as "Invoice Date",
	   "Customer No" as "Customer No",
	   "No_Customer" as "No_Customer",
	   "Name_Customer" as "Name_Customer",
	   "Kunde" as "Kunde",
	   "Customer Type" as "Customer Type",
	   "Kundenart" as "Kundenart",
	   "Old Customer No" as "Old Customer No",
	   "Old Customer No" as "Old Customer No",
	   "No_Vorbesitzer" as "No_Vorbesitzer",
	   "Name_Vorbesitzer" as "Name_Vorbesitzer",
	   "Vorbesitzer" as "Vorbesitzer",
	   "Engine Code" as "Engine Code",
	   "Motor Code" as "Motor Code",
	   "Geschäftsart" as "Geschäftsart",
	   "FZG_Liste_1_ori" as "FZG_Liste_1_ori",
	   "FZG_Liste_2" as "FZG_Liste_2",
	   "FZG_Liste_3" as "FZG_Liste_3",
	   "FZG_Liste_4" as "FZG_Liste_4",
	   "Erlös" as "Erlös",
	   "Einsatz" as "Einsatz",
	   "EK Fahrzeug" as "EK Fahrzeug",
	   "Bonus" as "Bonus",
	   "int. Kosten" as "int. Kosten",
	   "Current Branch Book No" as "Current Branch Book No",
	   "Current Book No" as "Current Book No",
	   SUM("EK Fahrzeug") OVER (partition by "Vin") as "Summe EK-FZG",
	   "Fabrikat" as "Fabrikat",
	   "Buchnummer gleich_ja_nein" as "Buchnummer gleich_ja_nein",
	   "Menge1" as "Menge1",
	   "VIN + PostingDate" as "VIN + PostingDate",
	   "Fahrzeugart_Schmidt" as "Fahrzeugart_Schmidt",
	   "Salespers Purch Code_VLE" as "Salespers Purch Code_VLE",
	   "Code_für_VEH_Ledger_Entry" as "Code_für_VEH_Ledger_Entry",
	   "Name_für_VEH_Ledger_Entry" as "Name_für_VEH_Ledger_Entry",
	   "Verkäufer" as "Verkäufer",
	   "FZG_Liste_1_falsch" as "FZG_Liste_1_falsch",
	   "FZG_Liste_0_ori" as "FZG_Liste_0_ori",
	   "FZG_Liste_1" as "FZG_Liste_1",
	   "FZG_Liste_0" as "FZG_Liste_0",
	   "Beleg" as "Beleg",
	   "Standort_FIBU" as "Standort_FIBU",
	   "Fahrzeugart_neu" as "Fahrzeugart_neu",
	   "Standort" as "Standort",
	   "Summe_Betrag" as "Summe_Betrag",
	   "Country Code_Kunde" as "Country Code_Kunde",
	   "Vat Bus Posting Group_Kunde" as "Vat Bus Posting Group_Kunde",
	   "FZG_Liste_5_ori" as "FZG_Liste_5_ori",
	   "Customer Group Code" as "Customer Group Code",
	   "FZG_Liste_5" as "FZG_Liste_5",
	   "FZG_Liste_6" as "FZG_Liste_6",
	   "FZG_Liste_7" as "FZG_Liste_7",
	   "FZG_Detail" as "FZG_Detail",
	   COUNT("No") OVER (partition by "Vin") as "Anz. Sätze",
	   ("Menge1" / COUNT("No") OVER (partition by "Vin")) as "Menge_final",
	   "No_Item" as "No_Item",
	   "Description_Item" as "Description_Item",
	   "Vehicle Type Code_Item" as "Vehicle Type Code_Item",
	   "Modell_zwischen" as "Modell_zwischen",
	   "Vehicle Category Code" as "Vehicle Category Code",
	   SUM("Erlöse FZG") OVER (partition by "Vin") as "Summe Erlös FZG",
	   "Erlöse FZG" as "Erlöse FZG",
	   "Modell_final" as "Modell_final",
	   "Fahrzeugtyp" as "Fahrzeugtyp",
	   (c137) as c248
from 
(select "No" as "No",
	   "Name" as "Name",
	   "Account Type" as "Account Type",
	   "Department Code" as "Department Code",
	   "Make Code" as "Make Code",
	   "Income Balance" as "Income Balance",
	   "Entry No" as "Entry No",
	   "G L Account No" as "G L Account No",
	   "Posting Date" as "Posting Date",
	   "Document Type" as "Document Type",
	   "Document No" as "Document No",
	   "Description" as "Description",
	   "Amount" as "Amount",
	   "Bal Account No" as "Bal Account No",
	   "Department Code" as "Department Code",
	   "Make Code" as "Make Code",
	   "User Id" as "User Id",
	   "Source Code" as "Source Code",
	   "Quantity" as "Quantity",
	   "Debit Amount" as "Debit Amount",
	   "Credit Amount" as "Credit Amount",
	   "Document Date" as "Document Date",
	   "Source Type" as "Source Type",
	   "Source No" as "Source No",
	   "No Series" as "No Series",
	   "Branch Code" as "Branch Code",
	   "Main Area" as "Main Area",
	   "Vin" as "Vin",
	   "Book No" as "Book No",
	   "Veh Source Code" as "Veh Source Code",
	   "Betrag" as "Betrag",
	   "Vin_Vehicle" as "Vin_Vehicle",
	   "Vehicle Status" as "Vehicle Status",
	   "Model_ori" as "Model_ori",
	   "Type" as "Type",
	   "Class" as "Class",
	   "Model No" as "Model No",
	   "Hauptbetrieb" as "Hauptbetrieb",
	   "Standort_alt" as "Standort_alt",
	   "Make Code_Vehicle" as "Make Code_Vehicle",
	   "Fabrikat_ori" as "Fabrikat_ori",
	   "Model" as "Model",
	   "Market Segment Code" as "Market Segment Code",
	   "Modellbez" as "Modellbez",
	   "Fahrzeugart" as "Fahrzeugart",
	   "Vat Prod Posting Group" as "Vat Prod Posting Group",
	   "Fahrzeugtyp_alt" as "Fahrzeugtyp_alt",
	   "FZG" as "FZG",
	   "Location Code" as "Location Code",
	   "VB_Einkauf" as "VB_Einkauf",
	   "Purchase Receipt Date" as "Purchase Receipt Date",
	   "Standtage_ori" as "Standtage_ori",
	   "Standtagestaffel" as "Standtagestaffel",
	   "Initial Registration" as "Initial Registration",
	   "EZ/Eingang" as "EZ/Eingang",
	   "Polster" as "Polster",
	   "Farbe" as "Farbe",
	   "Einsatz_ori" as "Einsatz_ori",
	   "Heute" as "Heute",
	   "Fahrzeugstatus" as "Fahrzeugstatus",
	   "FZG-Liste" as "FZG-Liste",
	   "Inventory Posting Group" as "Inventory Posting Group",
	   "Date Of Sale" as "Date Of Sale",
	   "Invoice Date" as "Invoice Date",
	   "Customer No" as "Customer No",
	   "No_Customer" as "No_Customer",
	   "Name_Customer" as "Name_Customer",
	   "Kunde" as "Kunde",
	   "Customer Type" as "Customer Type",
	   "Kundenart" as "Kundenart",
	   "Old Customer No" as "Old Customer No",
	   "Old Customer No" as "Old Customer No",
	   "No_Vorbesitzer" as "No_Vorbesitzer",
	   "Name_Vorbesitzer" as "Name_Vorbesitzer",
	   "Vorbesitzer" as "Vorbesitzer",
	   "Engine Code" as "Engine Code",
	   "Motor Code" as "Motor Code",
	   "Geschäftsart" as "Geschäftsart",
	   "FZG_Liste_1_ori" as "FZG_Liste_1_ori",
	   "FZG_Liste_2" as "FZG_Liste_2",
	   "FZG_Liste_3" as "FZG_Liste_3",
	   "FZG_Liste_4" as "FZG_Liste_4",
	   "Erlös" as "Erlös",
	   "Einsatz" as "Einsatz",
	   "EK Fahrzeug" as "EK Fahrzeug",
	   "Bonus" as "Bonus",
	   "int. Kosten" as "int. Kosten",
	   "Current Branch Book No" as "Current Branch Book No",
	   "Current Book No" as "Current Book No",
	   "Fabrikat" as "Fabrikat",
	   "Buchnummer gleich_ja_nein" as "Buchnummer gleich_ja_nein",
	   "Menge1" as "Menge1",
	   "VIN + PostingDate" as "VIN + PostingDate",
	   "Fahrzeugart_Schmidt" as "Fahrzeugart_Schmidt",
	   "Salespers Purch Code_VLE" as "Salespers Purch Code_VLE",
	   "Code_für_VEH_Ledger_Entry" as "Code_für_VEH_Ledger_Entry",
	   "Name_für_VEH_Ledger_Entry" as "Name_für_VEH_Ledger_Entry",
	   "Verkäufer" as "Verkäufer",
	   "FZG_Liste_1_falsch" as "FZG_Liste_1_falsch",
	   "FZG_Liste_0_ori" as "FZG_Liste_0_ori",
	   "FZG_Liste_1" as "FZG_Liste_1",
	   "FZG_Liste_0" as "FZG_Liste_0",
	   "Beleg" as "Beleg",
	   "Standort_FIBU" as "Standort_FIBU",
	   "Fahrzeugart_neu" as "Fahrzeugart_neu",
	   "Standort" as "Standort",
	   "Summe_Betrag" as "Summe_Betrag",
	   "Country Code_Kunde" as "Country Code_Kunde",
	   "Vat Bus Posting Group_Kunde" as "Vat Bus Posting Group_Kunde",
	   "FZG_Liste_5_ori" as "FZG_Liste_5_ori",
	   "Customer Group Code" as "Customer Group Code",
	   "FZG_Liste_5" as "FZG_Liste_5",
	   "FZG_Liste_6" as "FZG_Liste_6",
	   "FZG_Liste_7" as "FZG_Liste_7",
	   "FZG_Detail" as "FZG_Detail",
	   "No_Item" as "No_Item",
	   "Description_Item" as "Description_Item",
	   "Vehicle Type Code_Item" as "Vehicle Type Code_Item",
	   "Modell_zwischen" as "Modell_zwischen",
	   "Vehicle Category Code" as "Vehicle Category Code",
	   "Erlöse FZG" as "Erlöse FZG",
	   "Modell_final" as "Modell_final",
	   "Fahrzeugtyp" as "Fahrzeugtyp",
	   c137 as c137,
	   SUM("Erlöse FZG") OVER (partition by "Vin") as c138
from 
(select c247 as "No",
	   c246 as "Name",
	   c245 as "Account Type",
	   c244 as "Department Code",
	   c243 as "Make Code",
	   c242 as "Income Balance",
	   c241 as "Entry No",
	   c240 as "G L Account No",
	   c239 as "Posting Date",
	   c238 as "Document Type",
	   c237 as "Document No",
	   c236 as "Description",
	   c235 as "Amount",
	   c234 as "Bal Account No",
	   c233 as "Department Code",
	   c232 as "Make Code",
	   c231 as "User Id",
	   c230 as "Source Code",
	   c229 as "Quantity",
	   c228 as "Debit Amount",
	   c227 as "Credit Amount",
	   c226 as "Document Date",
	   c225 as "Source Type",
	   c224 as "Source No",
	   c223 as "No Series",
	   c222 as "Branch Code",
	   c221 as "Main Area",
	   c220 as "Vin",
	   c219 as "Book No",
	   c218 as "Veh Source Code",
	   c198 as "Betrag",
	   c217 as "Vin_Vehicle",
	   c216 as "Vehicle Status",
	   c182 as "Model_ori",
	   c215 as "Type",
	   c214 as "Class",
	   c213 as "Model No",
	   '1' as "Hauptbetrieb",
	   c212 as "Standort_alt",
	   c211 as "Make Code_Vehicle",
	   c211 as "Fabrikat_ori",
	   c210 as "Model",
	   c209 as "Market Segment Code",
	   c182 as "Modellbez",
	   c208 as "Fahrzeugart",
	   c207 as "Vat Prod Posting Group",
	   c206 as "Fahrzeugtyp_alt",
	   c205 as "FZG",
	   c204 as "Location Code",
	   '' as "VB_Einkauf",
	   c203 as "Purchase Receipt Date",
	   c202 as "Standtage_ori",
	   c201 as "Standtagestaffel",
	   c200 as "Initial Registration",
	   c199 as "EZ/Eingang",
	   '' as "Polster",
	   '' as "Farbe",
	   c198 as "Einsatz_ori",
	   (getdate()) as "Heute",
	   'Bestand' as "Fahrzeugstatus",
	   c197 as "FZG-Liste",
	   c196 as "Inventory Posting Group",
	   c195 as "Date Of Sale",
	   c194 as "Invoice Date",
	   c193 as "Customer No",
	   c192 as "No_Customer",
	   c191 as "Name_Customer",
	   c153 as "Kunde",
	   c190 as "Customer Type",
	   c189 as "Kundenart",
	   c188 as "Old Customer No",
	   c188 as "Old Customer No",
	   c187 as "No_Vorbesitzer",
	   c186 as "Name_Vorbesitzer",
	   c186 as "Vorbesitzer",
	   c185 as "Engine Code",
	   c185 as "Motor Code",
	   '' as "Geschäftsart",
	   c184 as "FZG_Liste_1_ori",
	   c183 as "FZG_Liste_2",
	   c182 as "FZG_Liste_3",
	   c181 as "FZG_Liste_4",
	   c180 as "Erlös",
	   c179 as "Einsatz",
	   c178 as "EK Fahrzeug",
	   c177 as "Bonus",
	   c176 as "int. Kosten",
	   c175 as "Current Branch Book No",
	   c174 as "Current Book No",
	   c173 as "Fabrikat",
	   c172 as "Buchnummer gleich_ja_nein",
	   1 as "Menge1",
	   c171 as "VIN + PostingDate",
	   c170 as "Fahrzeugart_Schmidt",
	   c169 as "Salespers Purch Code_VLE",
	   c168 as "Code_für_VEH_Ledger_Entry",
	   c167 as "Name_für_VEH_Ledger_Entry",
	   c166 as "Verkäufer",
	   c165 as "FZG_Liste_1_falsch",
	   c164 as "FZG_Liste_0_ori",
	   c163 as "FZG_Liste_1",
	   c162 as "FZG_Liste_0",
	   c161 as "Beleg",
	   c160 as "Standort_FIBU",
	   c159 as "Fahrzeugart_neu",
	   c158 as "Standort",
	   SUM(c198) OVER (partition by c142) as "Summe_Betrag",
	   '' as "Country Code_Kunde",
	   c157 as "Vat Bus Posting Group_Kunde",
	   c156 as "FZG_Liste_5_ori",
	   c155 as "Customer Group Code",
	   c154 as "FZG_Liste_5",
	   CASE WHEN ('' IS NULL) THEN (' - ') WHEN ('' IN ('')) THEN (' - ') ELSE ('') END as "FZG_Liste_6",
	   c153 as "FZG_Liste_7",
	   c152 as "FZG_Detail",
	   c151 as "No_Item",
	   c150 as "Description_Item",
	   c149 as "Vehicle Type Code_Item",
	   c148 as "Modell_zwischen",
	   c147 as "Vehicle Category Code",
	   c146 as "Erlöse FZG",
	   c145 as "Modell_final",
	   c144 as "Fahrzeugtyp",
	   c143 as c137
from 
(select (((T2."VIN"))) as c142,
	   ((T2."VIN")) + T2."Document No_" as c143,
	   CASE WHEN ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') THEN (T3."Inventory Posting Group") ELSE ((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END)) END as c144,
	   CASE WHEN (not (CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) IN ('Fremdfabrikat')) THEN ((CASE WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW') and ((left(T4."Description",1)) BETWEEN '1' AND '9')) THEN ((left(T4."Description",1)) + 'er') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW') and ((left(T4."Description",1)) BETWEEN 'A' AND 'Z')) THEN ((left(T4."Description",2))) WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%3-T%') or (T3."Model" LIKE '%3-T%'))) THEN ('3-Türer') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%5-T%') or (T3."Model" LIKE '%5-T%'))) THEN ('5-Türer') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Club%') or (T3."Model" LIKE '%Club%'))) THEN ('Clubman') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Count%') or (T3."Model" LIKE '%Count%'))) THEN ('Countryman') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Cou%') or (T3."Model" LIKE '%Cou%'))) THEN ('Coupe') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Hatch%') or (T3."Model" LIKE '%Hatch%'))) THEN ('Hatch') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Pace%') or (T3."Model" LIKE '%Pace%'))) THEN ('Paceman') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Road%') or (T3."Model" LIKE '%Road%'))) THEN ('Roadster') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Cab%') or (T3."Model" LIKE '%Cab%'))) THEN ('Cabrio') ELSE (T4."Description") END)) ELSE ('Fremd') END as c145,
	   CASE WHEN ((left(T1."No_",3)) IN ('882','884','887')) THEN (0) ELSE ((CASE WHEN ((T1."No_" LIKE '8%') and ((od_right(T2."Global Dimension 1 Code",2)) IN ('10','20','80','11','21'))) THEN (((convert(float, T2."Amount"))) * -1) ELSE (0) END)) END as c146,
	   T4."Vehicle Category Code" as c147,
	   CASE WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW') and ((left(T4."Description",1)) BETWEEN '1' AND '9')) THEN ((left(T4."Description",1)) + 'er') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW') and ((left(T4."Description",1)) BETWEEN 'A' AND 'Z')) THEN ((left(T4."Description",2))) WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%3-T%') or (T3."Model" LIKE '%3-T%'))) THEN ('3-Türer') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%5-T%') or (T3."Model" LIKE '%5-T%'))) THEN ('5-Türer') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Club%') or (T3."Model" LIKE '%Club%'))) THEN ('Clubman') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Count%') or (T3."Model" LIKE '%Count%'))) THEN ('Countryman') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Cou%') or (T3."Model" LIKE '%Cou%'))) THEN ('Coupe') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Hatch%') or (T3."Model" LIKE '%Hatch%'))) THEN ('Hatch') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Pace%') or (T3."Model" LIKE '%Pace%'))) THEN ('Paceman') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Road%') or (T3."Model" LIKE '%Road%'))) THEN ('Roadster') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Cab%') or (T3."Model" LIKE '%Cab%'))) THEN ('Cabrio') ELSE (T4."Description") END as c148,
	   T4."Vehicle Type Code" as c149,
	   T4."Description" as c150,
	   T4."No_" as c151,
	   ((T2."VIN")) + ' - ' + T3."Location Code" + ' - ' + (CASE WHEN ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') THEN (T3."Inventory Posting Group") ELSE ((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END)) END) + ' - ' + (CASE WHEN (T7."Code" IS NOT NULL) THEN (T7."Code" + ' - ' + T7."Name") ELSE (T8."Salespers__Purch_ Code") END) + ' - ' + (T5."No_" + ' - ' + T5."Name") + ' - ' + (convert(varchar(50), year((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), month((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END)))) as c152,
	   (T5."No_" + ' - ' + T5."Name") as c153,
	   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 c154,
	   T5."Customer Group Code" as c155,
	   CASE WHEN ('' = '') THEN (T5."Customer Group Code" + ' / ' + ' - ' + ' / ' + T5."Gen_ Bus_ Posting Group" + ' / ' + (T5."No_" + ' - ' + T5."Name")) ELSE (T5."Customer Group Code" + ' / ' + '' + ' / ' + T5."Gen_ Bus_ Posting Group" + ' / ' + (T5."No_" + ' - ' + T5."Name")) END as c156,
	   T5."VAT Bus_ Posting Group" as c157,
	   CASE WHEN (T3."Location Code" = 'BUR') THEN ('10') WHEN (T3."Location Code" = 'MUE') THEN ('20') ELSE ('10') END as c158,
	   CASE WHEN ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) IS NULL) THEN ((CASE WHEN ((substring(T1."Global Dimension 1 Code", 3, 2)) = '10') THEN ('NA') WHEN ((substring(T1."Global Dimension 1 Code", 3, 2)) = '20') THEN ('GA') WHEN ((substring(T1."Global Dimension 1 Code", 3, 2)) = '80') THEN ('NA') WHEN ((substring(T1."Global Dimension 1 Code", 3, 2)) = '90') THEN ('NA') ELSE null END)) ELSE ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END)) END as c159,
	   (left(T1."Global Dimension 1 Code",2)) as c160,
	   T2."Document No_" + ' - ' + T2."Description" + ' - ' + T2."User ID" as c161,
	   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 c162,
	   CASE WHEN ((CASE WHEN (((T2."VIN")) = ' ') THEN ('Buchungen o. FZG') ELSE ('Buchungen m. FZG') END) = 'Buchungen o. FZG') THEN (T2."Document No_" + ' - ' + T2."Description") ELSE ((CASE WHEN ((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) IS NOT NULL) THEN ((od_right(((T2."VIN")),7)) + ' - ' + (CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) + ' / ' + (convert(varchar(50), year((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), month((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))))) ELSE ((od_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 c163,
	   CASE WHEN (((T2."VIN")) = ' ') THEN ('Buchungen o. FZG') ELSE ('Buchungen m. FZG') END as c164,
	   CASE WHEN (T1."No_" IN ('78700','78710','79000','79030','79100','79130','88210','88220','88230','88240','88290','88310','88320','88400','88410','88420','88430','88560','88570','88700','88710','88720','88730','88740','88750','88760','88770','88780','88790')) THEN ('Buchungen aus Sonstige Erlöse') ELSE ((CASE WHEN ((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) IS NOT NULL) THEN ((od_right(((T2."VIN")),7)) + ' - ' + (CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) + ' / ' + (convert(varchar(50), year((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), month((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))))) ELSE ((od_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 c165,
	   CASE WHEN (T7."Code" IS NOT NULL) THEN (T7."Code" + ' - ' + T7."Name") ELSE (T8."Salespers__Purch_ Code") END as c166,
	   T7."Name" as c167,
	   T7."Code" as c168,
	   T8."Salespers__Purch_ Code" as c169,
	   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 c170,
	   ((T2."VIN")) + (convert(varchar(50), year(T2."Posting Date")) + '-' + convert(varchar(50), month(T2."Posting Date")) + '-' + convert(varchar(50), day(T2."Posting Date"))) as c171,
	   CASE WHEN ((T2."Book No_" = T3."Current Book No_") and ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA')) THEN ('ja') WHEN ((T2."Book No_" <> T3."Current Book No_") and ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA')) THEN ('nein') ELSE null END as c172,
	   CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END as c173,
	   T3."Current Book No_" as c174,
	   T3."Current Branch Book No_" as c175,
	   CASE WHEN (T1."No_" LIKE '4%') THEN (((convert(float, T2."Amount")))) ELSE (0) END as c176,
	   CASE WHEN (T1."No_" BETWEEN '71400' AND '71690') THEN (((convert(float, T2."Amount"))) * -1) ELSE (0) END as c177,
	   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 c178,
	   (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 c179,
	   CASE WHEN ((T1."No_" LIKE '8%') and ((od_right(T2."Global Dimension 1 Code",2)) IN ('10','20','80','11','21'))) THEN (((convert(float, T2."Amount"))) * -1) ELSE (0) END as c180,
	   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 c181,
	   T3."Model" as c182,
	   CASE WHEN ('' IS NULL) THEN (' - ' + ' / ' + T6."Name") ELSE ('' + ' / ' + T6."Name") END as c183,
	   CASE WHEN ((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) IS NOT NULL) THEN ((od_right(((T2."VIN")),7)) + ' - ' + (CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) + ' / ' + (convert(varchar(50), year((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), month((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))))) ELSE ((od_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 c184,
	   T3."Engine Code" as c185,
	   T6."Name" as c186,
	   T6."No_" as c187,
	   T3."Old Customer No_" as c188,
	   T5."Gen_ Bus_ Posting Group" as c189,
	   T5."Customer Type" as c190,
	   T5."Name" as c191,
	   T5."No_" as c192,
	   T3."Customer No_" as c193,
	   CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END as c194,
	   T3."Date of Sale" as c195,
	   T3."Inventory Posting Group" as c196,
	   (od_right(((T2."VIN")),7)) as c197,
	   ((convert(float, T2."Amount"))) as c198,
	   CASE WHEN ((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'VFW') THEN ((convert(varchar(50), year(T3."Initial Registration")) + '-' + convert(varchar(50), month(T3."Initial Registration")) + '-' + convert(varchar(50), day(T3."Initial Registration")))) WHEN ((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group")) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'NA') THEN ((convert(varchar(50), year(T3."Purchase Receipt Date")) + '-' + convert(varchar(50), month(T3."Purchase Receipt Date")) + '-' + convert(varchar(50), day(T3."Purchase Receipt Date")))) WHEN ((CASE WHEN ((left(T3."Inventory Posting Group")) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') THEN ((convert(varchar(50), year(T3."Purchase Receipt Date")) + '-' + convert(varchar(50), month(T3."Purchase Receipt Date")) + '-' + convert(varchar(50), day(T3."Purchase Receipt Date")))) ELSE null END as c199,
	   T3."Initial Registration" as c200,
	   CASE WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'NA') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) BETWEEN 0 AND 30)) THEN ('0 - 30 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'NA') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) BETWEEN 31 AND 60)) THEN ('31 - 60 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'NA') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) BETWEEN 61 AND 90)) THEN ('61 - 90 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'NA') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) BETWEEN 91 AND 180)) THEN ('91 - 180 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'NA') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) > 180)) THEN ('> 180 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'VFW') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) BETWEEN 0 AND 90)) THEN ('0 - 90 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'VFW') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) BETWEEN 91 AND 150)) THEN ('91 - 150 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'VFW') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) BETWEEN 151 AND 210)) THEN ('151 - 210 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'VFW') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) > 210)) THEN ('> 210 Tage') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) BETWEEN 0 AND 30)) THEN ('0 - 30 Tage') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) BETWEEN 31 AND 60)) THEN ('31 - 60 Tage') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) BETWEEN 61 AND 90)) THEN ('61 - 90 Tage') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (((day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date"))) BETWEEN 91 AND 180)) THEN ('91 - 180 Tage') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (((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 c201,
	   (day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END) - T3."Purchase Receipt Date")) as c202,
	   T3."Purchase Receipt Date" as c203,
	   T3."Location Code" as c204,
	   CASE WHEN ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') THEN ((od_right(((T2."VIN")),7)) + ' / ' + T3."Model" + ' / ' + (CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) + ' / ' + T3."Location Code" + ' / ' + (T5."No_" + ' - ' + T5."Name")) ELSE ((od_right(((T2."VIN")),7)) + ' / ' + T3."Model" + ' / ' + T3."Location Code" + ' / ' + (T5."No_" + ' - ' + T5."Name")) END as c205,
	   CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'FA')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END as c206,
	   T3."VAT Prod_ Posting Group" as c207,
	   CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF','FA')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END as c208,
	   T3."Market Segment Code" as c209,
	   (CASE WHEN (not (CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) IN ('Fremdfabrikat')) THEN ((CASE WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW') and ((left(T4."Description",1)) BETWEEN '1' AND '9')) THEN ((left(T4."Description",1)) + 'er') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW') and ((left(T4."Description",1)) BETWEEN 'A' AND 'Z')) THEN ((left(T4."Description",2))) WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%3-T%') or (T3."Model" LIKE '%3-T%'))) THEN ('3-Türer') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%5-T%') or (T3."Model" LIKE '%5-T%'))) THEN ('5-Türer') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Club%') or (T3."Model" LIKE '%Club%'))) THEN ('Clubman') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Count%') or (T3."Model" LIKE '%Count%'))) THEN ('Countryman') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Cou%') or (T3."Model" LIKE '%Cou%'))) THEN ('Coupe') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Hatch%') or (T3."Model" LIKE '%Hatch%'))) THEN ('Hatch') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Pace%') or (T3."Model" LIKE '%Pace%'))) THEN ('Paceman') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Road%') or (T3."Model" LIKE '%Road%'))) THEN ('Roadster') WHEN (((CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END) = 'BMW-MINI') and ((T4."Description" LIKE '%Cab%') or (T3."Model" LIKE '%Cab%'))) THEN ('Cabrio') ELSE (T4."Description") END)) ELSE ('Fremd') END) as c210,
	   T3."Make Code" as c211,
	   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 c212,
	   T3."Model No_" as c213,
	   T3."Class" as c214,
	   T3."Type" as c215,
	   T3."Vehicle Status" as c216,
	   T3."VIN" as c217,
	   T2."Veh_ Source Code" as c218,
	   T2."Book No_" as c219,
	   (T2."VIN") as c220,
	   T2."Main Area" as c221,
	   T2."Branch Code" as c222,
	   T2."No_ Series" as c223,
	   T2."Source No_" as c224,
	   T2."Source Type" as c225,
	   T2."Document Date" as c226,
	   T2."Credit Amount" as c227,
	   T2."Debit Amount" as c228,
	   T2."Quantity" as c229,
	   T2."Source Code" as c230,
	   T2."User ID" as c231,
	   T2."Global Dimension 2 Code" as c232,
	   T2."Global Dimension 1 Code" as c233,
	   T2."Bal_ Account No_" as c234,
	   T2."Amount" as c235,
	   T2."Description" as c236,
	   T2."Document No_" as c237,
	   T2."Document Type" as c238,
	   T2."Posting Date" as c239,
	   T2."G_L Account No_" as c240,
	   T2."Entry No_" as c241,
	   T1."Income_Balance" as c242,
	   T1."Global Dimension 2 Code" as c243,
	   T1."Global Dimension 1 Code" as c244,
	   T1."Account Type" as c245,
	   T1."Name" as c246,
	   T1."No_" as c247
from "Vogl7x"."dbo"."BMW AH Vogl$G_L Account" T1,
	(((((("Vogl7x"."dbo"."BMW AH Vogl$G_L Entry" T2 left outer join "Vogl7x"."dbo"."BMW AH Vogl$Vehicle" T3 on T3."VIN" = T2."VIN") left outer join "Vogl7x"."dbo"."BMW AH Vogl$Item" T4 on T4."No_" = T3."Model No_") left outer join "Vogl7x"."dbo"."BMW AH Vogl$Customer" T5 on T3."Customer No_" = T5."No_") left outer join "Vogl7x"."dbo"."BMW AH Vogl$Customer" T6 on T3."Old Customer No_" = T6."No_") left outer 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 outer join "Vogl7x"."dbo"."BMW AH Vogl$Salesperson_Purchaser" T7 on T8."Salespers__Purch_ Code" = T7."Code")
where (T1."No_" = T2."G_L Account No_")
and ((((((((((T1."No_" IN ('88200','78200','78700','78710','79000','79030','79100','79130','88210','88220','88230','88240','88290','88310','88320','88400','88410','88420','88430','88560','88570','88700','88710','88720','88730','88740','88750','88760','88770','88780','88790','89000','89030','88580','88581','88582','78580','88584','88583')) or (T1."No_" BETWEEN '71000' AND '72990')) or (T1."No_" BETWEEN '81000' AND '82990')) or (((T1."No_" LIKE '4%') and (T2."Book No_" <> ' ')) and (T2."Posting Date" >= T3."Purchase Receipt Date"))) and (not T2."Description" IN ('GuV-Konten Nullstellung','GuV Konten Nullstellung'))) and (T2."Posting Date" >= convert(datetime, '2019-12-01 00:00:00.000'))) and (((T2."VIN")) <> ' ')) and (T3."Inventory Posting Group" <> 'GROSSKD')) and (T3."Current Book No_" = T2."Book No_")) and (T3."Date of Sale" >= convert(datetime, '2020-01-01 00:00:00.000')))
) D3
) D7
) D1
where (("Summe_Betrag" <> 0) and (not c138 BETWEEN -0.1 AND 0.1))
) D6
) D5
) D2
-- order by "Summe EK-FZG" asc,"Vin" asc,"Posting Date" asc,"Document No" asc