C11/System/NAVISION/IQD/NW/nw_gw_be_neu.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_FIBU" as "Standort_FIBU",
	   "Make Code_Vehicle" as "Make Code_Vehicle",
	   "Fabrikat" as "Fabrikat",
	   "Model_alt" as "Model_alt",
	   "Market Segment Code" as "Market Segment Code",
	   "Modellbez" as "Modellbez",
	   "Fahrzeugart_ori" as "Fahrzeugart_ori",
	   "Vat Prod Posting Group" as "Vat Prod Posting Group",
	   "Fahrzeugtyp_ori" as "Fahrzeugtyp_ori",
	   "FZG" as "FZG",
	   "Location Code" as "Location Code",
	   "Code_Salesperson Purchase" as "Code_Salesperson Purchase",
	   "Name_Salesperson Purchase" as "Name_Salesperson Purchase",
	   "VB_Einkauf" as "VB_Einkauf",
	   "Purchase Receipt Date" as "Purchase Receipt Date",
	   "Standtage_ori" as "Standtage_ori",
	   "Standtagestaffel_ori" as "Standtagestaffel_ori",
	   "Initial Registration_2" as "Initial Registration_2",
	   "EZ/Eingang" as "EZ/Eingang",
	   "Farbe" as "Farbe",
	   "Einsatz" as "Einsatz",
	   "Heute" as "Heute",
	   "Fahrzeugstatus" as "Fahrzeugstatus",
	   "FZG-Liste" as "FZG-Liste",
	   "Anzahl" as "Anzahl",
	   "Standtage" as "Standtage",
	   "Summe Standtage" as "Summe Standtage",
	   "Menge_FZG" as "Menge_FZG",
	   "Inventory Posting Group" as "Inventory Posting Group",
	   "Summe Betrag" as "Summe Betrag",
	   "Fzg_Typ_Herkunft" as "Fzg_Typ_Herkunft",
	   "gepl. VK" as "gepl. VK",
	   "Datum letzte Änderung" as "Datum letzte Änderung",
	   "FZG-Kosten" as "FZG-Kosten",
	   "Purchase Date" as "Purchase Date",
	   "EK FZG" as "EK FZG",
	   "Text 3" as "Text 3",
	   "Bestand/reserviert" as "Bestand/reserviert",
	   "Ort_B_R_Dat_Änd" as "Ort_B_R_Dat_Änd",
	   "Date Of Sale" as "Date Of Sale",
	   "Summe EK" as "Summe EK",
	   "Standort" as "Standort",
	   "Dealer Status_ori" as "Dealer Status_ori",
	   "Transmission Type Code" as "Transmission Type Code",
	   "Key No" as "Key No",
	   "Mileage" as "Mileage",
	   "License No" as "License No",
	   "Händlerstatus_Text" as "Händlerstatus_Text",
	   "Händlerstatus" as "Händlerstatus",
	   "Händlerstatus Gruppe" as "Händlerstatus Gruppe",
	   "Dealer Status" as "Dealer Status",
	   "Extra Code 1" as "Extra Code 1",
	   "Text 1_Vorbesitzer" as "Text 1_Vorbesitzer",
	   "Initial Registration" as "Initial Registration",
	   "Deregistration Date" as "Deregistration Date",
	   "VFW zugel./abgem" as "VFW zugel./abgem",
	   "EK erh. Pos." as "EK erh. Pos.",
	   "Name_Vorbesitzer" as "Name_Vorbesitzer",
	   "EK-Datum_Zeichen" as "EK-Datum_Zeichen",
	   "EZ_Zeichen" as "EZ_Zeichen",
	   "Abmeldung_Zeichen" as "Abmeldung_Zeichen",
	   "Dat_letzte_Änderung_Zeichen" as "Dat_letzte_Änderung_Zeichen",
	   "Bemerkung" as "Bemerkung",
	   "Reserved For" as "Reserved For",
	   "reserviert" as "reserviert",
	   "UPE" as "UPE",
	   "Fahrzeugtyp" as "Fahrzeugtyp",
	   "Model" as "Model",
	   "kundenbelegt ja/nein" as "kundenbelegt ja/nein",
	   "Standtagestaffel" as "Standtagestaffel",
	   "Hauptbetrieb_ID" as "Hauptbetrieb_ID",
	   "Hauptbetrieb_Name" as "Hauptbetrieb_Name",
	   "Standort_ID" as "Standort_ID",
	   "Standort_Name" as "Standort_Name",
	   "Fahrzeugart" as "Fahrzeugart"
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_FIBU" as "Standort_FIBU",
	   "Make Code_Vehicle" as "Make Code_Vehicle",
	   "Fabrikat" as "Fabrikat",
	   "Model_alt" as "Model_alt",
	   "Market Segment Code" as "Market Segment Code",
	   "Modellbez" as "Modellbez",
	   "Fahrzeugart_ori" as "Fahrzeugart_ori",
	   "Vat Prod Posting Group" as "Vat Prod Posting Group",
	   "Fahrzeugtyp_ori" as "Fahrzeugtyp_ori",
	   "FZG" as "FZG",
	   "Location Code" as "Location Code",
	   "Code_Salesperson Purchase" as "Code_Salesperson Purchase",
	   "Name_Salesperson Purchase" as "Name_Salesperson Purchase",
	   "VB_Einkauf" as "VB_Einkauf",
	   "Purchase Receipt Date" as "Purchase Receipt Date",
	   "Standtage_ori" as "Standtage_ori",
	   "Standtagestaffel_ori" as "Standtagestaffel_ori",
	   "Initial Registration_2" as "Initial Registration_2",
	   "EZ/Eingang" as "EZ/Eingang",
	   "Farbe" as "Farbe",
	   "Einsatz" as "Einsatz",
	   "Heute" as "Heute",
	   "Fahrzeugstatus" as "Fahrzeugstatus",
	   "FZG-Liste" as "FZG-Liste",
	   "Anzahl" as "Anzahl",
	   "Standtage" as "Standtage",
	   SUM("Standtage") OVER (partition by "Vin") as "Summe Standtage",
	   "Menge_FZG" as "Menge_FZG",
	   "Inventory Posting Group" as "Inventory Posting Group",
	   "Summe Betrag" as "Summe Betrag",
	   "Fzg_Typ_Herkunft" as "Fzg_Typ_Herkunft",
	   "gepl. VK" as "gepl. VK",
	   "Datum letzte Änderung" as "Datum letzte Änderung",
	   "FZG-Kosten" as "FZG-Kosten",
	   "Purchase Date" as "Purchase Date",
	   "EK FZG" as "EK FZG",
	   "Text 3" as "Text 3",
	   "Bestand/reserviert" as "Bestand/reserviert",
	   "Ort_B_R_Dat_Änd" as "Ort_B_R_Dat_Änd",
	   "Date Of Sale" as "Date Of Sale",
	   "Summe EK" as "Summe EK",
	   "Standort" as "Standort",
	   "Dealer Status_ori" as "Dealer Status_ori",
	   "Transmission Type Code" as "Transmission Type Code",
	   "Key No" as "Key No",
	   "Mileage" as "Mileage",
	   "License No" as "License No",
	   "Händlerstatus_Text" as "Händlerstatus_Text",
	   "Händlerstatus" as "Händlerstatus",
	   "Händlerstatus Gruppe" as "Händlerstatus Gruppe",
	   "Dealer Status" as "Dealer Status",
	   "Extra Code 1" as "Extra Code 1",
	   "Text 1_Vorbesitzer" as "Text 1_Vorbesitzer",
	   "Initial Registration" as "Initial Registration",
	   "Deregistration Date" as "Deregistration Date",
	   "VFW zugel./abgem" as "VFW zugel./abgem",
	   "EK erh. Pos." as "EK erh. Pos.",
	   "Name_Vorbesitzer" as "Name_Vorbesitzer",
	   "EK-Datum_Zeichen" as "EK-Datum_Zeichen",
	   "EZ_Zeichen" as "EZ_Zeichen",
	   "Abmeldung_Zeichen" as "Abmeldung_Zeichen",
	   "Dat_letzte_Änderung_Zeichen" as "Dat_letzte_Änderung_Zeichen",
	   "Bemerkung" as "Bemerkung",
	   "Reserved For" as "Reserved For",
	   "reserviert" as "reserviert",
	   "UPE" as "UPE",
	   "Fahrzeugtyp" as "Fahrzeugtyp",
	   "Model" as "Model",
	   "kundenbelegt ja/nein" as "kundenbelegt ja/nein",
	   "Standtagestaffel" as "Standtagestaffel",
	   "Hauptbetrieb_ID" as "Hauptbetrieb_ID",
	   "Hauptbetrieb_Name" as "Hauptbetrieb_Name",
	   "Standort_ID" as "Standort_ID",
	   "Standort_Name" as "Standort_Name",
	   "Fahrzeugart" as "Fahrzeugart"
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_FIBU",
	   "Make Code_Vehicle",
	   "Make Code_Vehicle" as "Fabrikat",
	   "Model_alt",
	   "Model_alt" as "Market Segment Code",
	   "Model_ori" as "Modellbez",
	   "Fahrzeugart_ori",
	   "Vat Prod Posting Group",
	   "Fahrzeugtyp_ori",
	   "FZG",
	   "Location Code",
	   "Code_Salesperson Purchase",
	   "Name_Salesperson Purchase",
	   "VB_Einkauf",
	   "Purchase Receipt Date",
	   "Standtage_ori",
	   "Standtagestaffel_ori",
	   "Initial Registration_2",
	   "EZ/Eingang",
	   '' as "Farbe",
	   "Betrag" as "Einsatz",
	   (getdate()) as "Heute",
	   'Bestand' as "Fahrzeugstatus",
	   "FZG-Liste",
	   COUNT("Standtage_ori") OVER (partition by "Vin") as "Anzahl",
	   ("Standtage_ori") / (COUNT("Standtage_ori") OVER (partition by "Vin")) as "Standtage",
	   1 / (COUNT("Standtage_ori") OVER (partition by "Vin")) as "Menge_FZG",
	   "Inventory Posting Group",
	   SUM("Betrag") OVER (partition by "Vin") as "Summe Betrag",
	   "Fzg_Typ_Herkunft",
	   (c158) / (COUNT("Standtage_ori") OVER (partition by "Vin")) as "gepl. VK",
	   convert(date, '2022-06-13') as "Datum letzte Änderung",
	   "FZG-Kosten",
	   "Purchase Date",
	   "EK FZG",
	   "Text 3",
	   "Bestand/reserviert",
	   "Ort_B_R_Dat_Änd",
	   "Date Of Sale",
	   SUM("EK FZG") OVER (partition by "Vin") as "Summe EK",
	   "Standort",
	   "Dealer Status_ori",
	   "Transmission Type Code",
	   "Key No",
	   "Mileage",
	   "License No",
	   "Händlerstatus_Text",
	   "Händlerstatus",
	   "Händlerstatus Gruppe",
	   "Dealer Status",
	   "Extra Code 1",
	   "Text 1_Vorbesitzer",
	   "Initial Registration_2" as "Initial Registration",
	   "Deregistration Date",
	   "VFW zugel./abgem",
	   "EK erh. Pos.",
	   "Name_Vorbesitzer",
	   "EK-Datum_Zeichen",
	   "EZ_Zeichen",
	   "Abmeldung_Zeichen",
	   (convert(varchar(50), year(convert(date, '2022-06-13')),4) + '-' + convert(varchar(50), month(convert(date, '2022-06-13')),2) + '-' + convert(varchar(50), day(convert(date, '2022-06-13')),2)) as "Dat_letzte_Änderung_Zeichen",
	   "Text 3" as "Bemerkung",
	   "Reserved For",
	   "reserviert",
	   (c129) / (COUNT("Standtage_ori") OVER (partition by "Vin")) as "UPE",
	   "Fahrzeugtyp",
	   "Model",
	   "kundenbelegt ja/nein",
	   "Standtagestaffel",
	   "Hauptbetrieb_ID",
	   "Hauptbetrieb_Name",
	   "Standort" as "Standort_ID",
	   "Standort_Name",
	   "Fahrzeugart"
from 
(select T2."VIN" as "Vin",
	   CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."Inventory Posting Group" IN ('GW_MOT','GW_FR_MOT','GW_DW_MOT'))) THEN ('GA MOT') ELSE ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END)) END as "Fahrzeugart",
	   CASE WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'VÖH') THEN ('20') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('10') END)) IN ('10')) THEN ('MM') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'VÖH') THEN ('20') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('10') END)) IN ('30')) THEN ('KRU') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'VÖH') THEN ('20') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('10') END)) IN ('40')) THEN ('ULM') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'VÖH') THEN ('20') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('10') END)) IN ('50')) THEN ('LL') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'VÖH') THEN ('20') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('10') END)) IN ('55')) THEN ('GZ') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'VÖH') THEN ('20') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('10') END)) IN ('60')) THEN ('AAM') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'VÖH') THEN ('20') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('10') END)) IN ('70')) THEN ('LEH') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'VÖH') THEN ('20') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('10') END)) IN ('80')) THEN ('WTB') ELSE null END as "Standort_Name",
	   (CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'VÖH') THEN ('20') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('10') END) as "Standort",
	   CASE WHEN (T2."Client_DB" = '1') THEN ('AHR') WHEN (T2."Client_DB" = '2') THEN ('AAM') ELSE null END as "Hauptbetrieb_Name",
	   T2."Client_DB" as "Hauptbetrieb_ID",
	   CASE WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 0 AND 90)) THEN ('0 - 90 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 91 AND 120)) THEN ('91 - 120 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 121 AND 180)) THEN ('121 - 180 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 181 AND 240)) THEN ('181 - 240 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 241 AND 300)) THEN ('241 - 300 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 301 AND 360)) THEN ('301 - 360 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) > 360)) THEN ('> 360 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 0 AND 90)) THEN ('0 - 90 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 91 AND 120)) THEN ('91 - 120 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 121 AND 180)) THEN ('121 - 180 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 181 AND 240)) THEN ('181 - 240 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 241 AND 300)) THEN ('241 - 300 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 301 AND 360)) THEN ('301 - 360 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) > 360)) THEN ('> 360 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 0 AND 30)) THEN ('0 - 30 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 31 AND 60)) THEN ('31 - 60 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 61 AND 90)) THEN ('61 - 90 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 91 AND 120)) THEN ('91 - 120 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 121 AND 180)) THEN ('121 - 180 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 181 AND 240)) THEN ('181 - 240 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 241 AND 300)) THEN ('241 - 300 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 301 AND 360)) THEN ('301 - 360 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) > 360)) THEN ('> 360 Tage') ELSE null END as "Standtagestaffel",
	   CASE WHEN (T3."Vehicle Status" = 3) THEN ('kundenbelegt') ELSE ('nicht kundenbelegt') END as "kundenbelegt ja/nein",
	   CASE WHEN ((((T3."Make Code" = 'BMW') and ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA')) and (T3."Market Segment Code" = '')) and ((T3."Model" LIKE '1%') or (T3."Model" LIKE 'BMW 1%'))) THEN ('1ER-REIHE') WHEN ((((T3."Make Code" = 'BMW') and ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA')) and (T3."Market Segment Code" = '')) and (((T3."Model" LIKE '2%') or (T3."Model" LIKE 'BMW 2%')) or (T3."Model" LIKE 'M2%'))) THEN ('2ER-REIHE') WHEN ((((T3."Make Code" = 'BMW') and ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA')) and (T3."Market Segment Code" = '')) and (((T3."Model" LIKE '3%') or (T3."Model" LIKE 'BMW 3%')) or (T3."Model" LIKE 'M3%'))) THEN ('3ER-REIHE') WHEN ((((T3."Make Code" = 'BMW') and ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA')) and (T3."Market Segment Code" = '')) and ((T3."Model" LIKE '4%') or (T3."Model" LIKE 'BMW 4%'))) THEN ('4ER-REIHE') WHEN ((((T3."Make Code" = 'BMW') and ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA')) and (T3."Market Segment Code" = '')) and (((T3."Model" LIKE '5%') or (T3."Model" LIKE 'BMW 5%')) or (T3."Model" LIKE 'M5%'))) THEN ('5ER-REIHE') WHEN ((((T3."Make Code" = 'BMW') and ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA')) and (T3."Market Segment Code" = '')) and (((T3."Model" LIKE '6%') or (T3."Model" LIKE 'BMW 6%')) or (T3."Model" LIKE 'M6%'))) THEN ('6ER-REIHE') WHEN ((((T3."Make Code" = 'BMW') and ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA')) and (T3."Market Segment Code" = '')) and (T3."Model" LIKE '7%')) THEN ('7ER-REIHE') WHEN ((((T3."Make Code" = 'BMW') and ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA')) and (T3."Market Segment Code" = '')) and (T3."Model" LIKE '8%')) THEN ('8ER-REIHE') WHEN ((((T3."Make Code" = 'BMW') and ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA')) and (T3."Market Segment Code" = '')) and ((T3."Model" LIKE 'X%') or (T3."Model" LIKE 'BMW X%'))) THEN ('X-REIHE') WHEN ((((T3."Make Code" = 'BMW') and ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA')) and (T3."Market Segment Code" = '')) and (T3."Model" LIKE 'Z%')) THEN ('Z-REIHE') ELSE (T3."Market Segment Code") END as "Model",
	   CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."Inventory Posting Group" IN ('GW_MOT','GW_FR_MOT'))) THEN ('GA MOT') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."Inventory Posting Group" IN ('GW_DW_PKW','GW_DW_MOT'))) THEN ('BMW JGA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."Inventory Posting Group" IN ('GW_MN_JGA'))) THEN ('MINI JGA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."Inventory Posting Group" IN ('GW_DW_PKW','GW_MN_JGA'))) THEN ('restl. GA-Bestand') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (T3."Make Code" IN ('BMW','BMW-C1','BMWI'))) THEN ('NA BMW') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (T3."Make Code" IN ('BMW-MOT'))) THEN ('NA BMW MOT') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (T3."Make Code" IN ('BMW-MINI'))) THEN ('NA MINI') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (T3."Make Code" IN ('BMW','BMW-C1','BMWI'))) THEN ('VFW BMW') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (T3."Make Code" IN ('BMW-MOT'))) THEN ('VFW BMW MOT') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (T3."Make Code" IN ('BMW-MINI'))) THEN ('VFW MINI') ELSE ((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END)) END as "Fahrzeugtyp",
	   convert(float, T5."List Price Incl_ VAT") as c129,
	   CASE WHEN ((T3."Reserved for" = ' ') or (T3."Reserved for" LIKE 'INTERN%')) THEN ('nein') ELSE ('ja') END as "reserviert",
	   T3."Reserved for" as "Reserved For",
	   T3."Text 3" as "Text 3",
	   (convert(varchar(50), year(T3."Deregistration Date")) + '-' + convert(varchar(50), month(T3."Deregistration Date")) + '-' + convert(varchar(50), day(T3."Deregistration Date"))) as "Abmeldung_Zeichen",
	   (convert(varchar(50), year(T3."Initial Registration")) + '-' + convert(varchar(50), month(T3."Initial Registration")) + '-' + convert(varchar(50), day(T3."Initial Registration"))) as "EZ_Zeichen",
	   (convert(varchar(50), year(T3."Purchase Date")) + '-' + convert(varchar(50), month(T3."Purchase Date")) + '-' + convert(varchar(50), day(T3."Purchase Date"))) as "EK-Datum_Zeichen",
	   T6."Name" as "Name_Vorbesitzer",
	   CASE WHEN ((((T1."No_" LIKE '3%') and (not T2."Document No_" LIKE 'E%')) and (not T2."Document No_" LIKE 'V%')) and (not T2."Document No_" LIKE 'FB%')) THEN (((convert(float, T2."Amount")))) ELSE (0) END as "EK erh. Pos.",
	   CASE WHEN ((((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (T3."Initial Registration" <> convert(datetime, '1753-01-01 00:00:00.000'))) and (T3."Initial Registration" > T3."Deregistration Date")) THEN ('zugelassen') WHEN ((((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (T3."Initial Registration" <> convert(datetime, '1753-01-01 00:00:00.000'))) and (T3."Initial Registration" < T3."Deregistration Date")) THEN ('abgemeldet') ELSE null END as "VFW zugel./abgem",
	   T3."Deregistration Date" as "Deregistration Date",
	   T3."Initial Registration" as "Initial Registration_2",
	   T3."Text 1" as "Text 1_Vorbesitzer",
	   T3."Extra Code 1" as "Extra Code 1",
	   CASE WHEN (T3."Dealer Status" IN ('000','')) THEN ('005') ELSE (T3."Dealer Status") END as "Dealer Status",
	   CASE WHEN ((CASE WHEN (T3."Dealer Status" IN ('000','')) THEN ('005') ELSE (T3."Dealer Status") END) IN ('000','005','019','015')) THEN ('Status 0 - 19') WHEN ((CASE WHEN (T3."Dealer Status" IN ('000','')) THEN ('005') ELSE (T3."Dealer Status") END) IN ('022','030','021','099','020')) THEN ('Status > 19') ELSE ('Status fehlt') END as "Händlerstatus Gruppe",
	   (CASE WHEN (T3."Dealer Status" IN ('000','')) THEN ('005') ELSE (T3."Dealer Status") END) + ' - ' + (CASE WHEN (T3."Dealer Status" IN ('005','000','')) THEN ('Fahrzeug auf Lager') WHEN (T3."Dealer Status" = '015') THEN ('Fahrzeug wird repariert') WHEN (T3."Dealer Status" = '019') THEN ('Übernahme durch Halter') WHEN (T3."Dealer Status" = '020') THEN ('Fahrzeug ist reserviert') WHEN (T3."Dealer Status" = '021') THEN ('Pool-Fahrzeug') WHEN (T3."Dealer Status" = '022') THEN ('FZG für Wiederverkäufer') WHEN (T3."Dealer Status" = '030') THEN ('Fahrzeug ist verkauft') WHEN (T3."Dealer Status" = '099') THEN ('FZG nicht verkaufsrelevant') ELSE ('Händlerstatus fehlt') END) as "Händlerstatus",
	   CASE WHEN (T3."Dealer Status" IN ('005','000','')) THEN ('Fahrzeug auf Lager') WHEN (T3."Dealer Status" = '015') THEN ('Fahrzeug wird repariert') WHEN (T3."Dealer Status" = '019') THEN ('Übernahme durch Halter') WHEN (T3."Dealer Status" = '020') THEN ('Fahrzeug ist reserviert') WHEN (T3."Dealer Status" = '021') THEN ('Pool-Fahrzeug') WHEN (T3."Dealer Status" = '022') THEN ('FZG für Wiederverkäufer') WHEN (T3."Dealer Status" = '030') THEN ('Fahrzeug ist verkauft') WHEN (T3."Dealer Status" = '099') THEN ('FZG nicht verkaufsrelevant') ELSE ('Händlerstatus fehlt') END as "Händlerstatus_Text",
	   T3."License No_" as "License No",
	   (convert(float, T3."Mileage")) as "Mileage",
	   T3."Key No_" as "Key No",
	   T3."Transmission Type Code" as "Transmission Type Code",
	   T3."Dealer Status" as "Dealer Status_ori",
	   T3."Date of Sale" as "Date Of Sale",
	   T3."Location Code" + ' - ' + (CASE WHEN (((CASE WHEN (T3."Dealer Status" IN ('000','')) THEN ('005') ELSE (T3."Dealer Status") END) + ' - ' + (CASE WHEN (T3."Dealer Status" IN ('005','000','')) THEN ('Fahrzeug auf Lager') WHEN (T3."Dealer Status" = '015') THEN ('Fahrzeug wird repariert') WHEN (T3."Dealer Status" = '019') THEN ('Übernahme durch Halter') WHEN (T3."Dealer Status" = '020') THEN ('Fahrzeug ist reserviert') WHEN (T3."Dealer Status" = '021') THEN ('Pool-Fahrzeug') WHEN (T3."Dealer Status" = '022') THEN ('FZG für Wiederverkäufer') WHEN (T3."Dealer Status" = '030') THEN ('Fahrzeug ist verkauft') WHEN (T3."Dealer Status" = '099') THEN ('FZG nicht verkaufsrelevant') ELSE ('Händlerstatus fehlt') END)) IN ('020 - Fahrzeug ist reserviert')) THEN ('reserv.') WHEN (((CASE WHEN (T3."Dealer Status" IN ('000','')) THEN ('005') ELSE (T3."Dealer Status") END) + ' - ' + (CASE WHEN (T3."Dealer Status" IN ('005','000','')) THEN ('Fahrzeug auf Lager') WHEN (T3."Dealer Status" = '015') THEN ('Fahrzeug wird repariert') WHEN (T3."Dealer Status" = '019') THEN ('Übernahme durch Halter') WHEN (T3."Dealer Status" = '020') THEN ('Fahrzeug ist reserviert') WHEN (T3."Dealer Status" = '021') THEN ('Pool-Fahrzeug') WHEN (T3."Dealer Status" = '022') THEN ('FZG für Wiederverkäufer') WHEN (T3."Dealer Status" = '030') THEN ('Fahrzeug ist verkauft') WHEN (T3."Dealer Status" = '099') THEN ('FZG nicht verkaufsrelevant') ELSE ('Händlerstatus fehlt') END)) IN ('030 - Fahrzeug ist verkauft')) THEN ('verkauft') ELSE ('Bestand') END) + ' / ' + (convert(varchar(50), year(convert(date, '2022-06-13')),4) + '-' + convert(varchar(50), month(convert(date, '2022-06-13')),2) + '-' + convert(varchar(50), day(convert(date, '2022-06-13')),2)) as "Ort_B_R_Dat_Änd",
	   CASE WHEN (((CASE WHEN (T3."Dealer Status" IN ('000','')) THEN ('005') ELSE (T3."Dealer Status") END) + ' - ' + (CASE WHEN (T3."Dealer Status" IN ('005','000','')) THEN ('Fahrzeug auf Lager') WHEN (T3."Dealer Status" = '015') THEN ('Fahrzeug wird repariert') WHEN (T3."Dealer Status" = '019') THEN ('Übernahme durch Halter') WHEN (T3."Dealer Status" = '020') THEN ('Fahrzeug ist reserviert') WHEN (T3."Dealer Status" = '021') THEN ('Pool-Fahrzeug') WHEN (T3."Dealer Status" = '022') THEN ('FZG für Wiederverkäufer') WHEN (T3."Dealer Status" = '030') THEN ('Fahrzeug ist verkauft') WHEN (T3."Dealer Status" = '099') THEN ('FZG nicht verkaufsrelevant') ELSE ('Händlerstatus fehlt') END)) IN ('020 - Fahrzeug ist reserviert')) THEN ('reserv.') WHEN (((CASE WHEN (T3."Dealer Status" IN ('000','')) THEN ('005') ELSE (T3."Dealer Status") END) + ' - ' + (CASE WHEN (T3."Dealer Status" IN ('005','000','')) THEN ('Fahrzeug auf Lager') WHEN (T3."Dealer Status" = '015') THEN ('Fahrzeug wird repariert') WHEN (T3."Dealer Status" = '019') THEN ('Übernahme durch Halter') WHEN (T3."Dealer Status" = '020') THEN ('Fahrzeug ist reserviert') WHEN (T3."Dealer Status" = '021') THEN ('Pool-Fahrzeug') WHEN (T3."Dealer Status" = '022') THEN ('FZG für Wiederverkäufer') WHEN (T3."Dealer Status" = '030') THEN ('Fahrzeug ist verkauft') WHEN (T3."Dealer Status" = '099') THEN ('FZG nicht verkaufsrelevant') ELSE ('Händlerstatus fehlt') END)) IN ('030 - Fahrzeug ist verkauft')) THEN ('verkauft') ELSE ('Bestand') END as "Bestand/reserviert",
	   CASE WHEN ((T1."No_" LIKE '3%') and (((T2."Document No_" LIKE 'E%') or (T2."Document No_" LIKE 'V%')) or (T2."Document No_" LIKE 'FB%'))) THEN (((convert(float, T2."Amount")))) ELSE (0) END as "EK FZG",
	   T3."Purchase Date" as "Purchase Date",
	   CASE WHEN (T1."No_" LIKE '4%') THEN (((convert(float, T2."Amount")))) ELSE (0) END as "FZG-Kosten",
	   convert(float, T5."Total Quote Amount") as c158,
	   (CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) + ' / ' + T3."Inventory Posting Group" as "Fzg_Typ_Herkunft",
	   T3."Inventory Posting Group" as "Inventory Posting Group",
	   (-1 * datediff(day, (getdate()), T3."Purchase Receipt Date")) as "Standtage_ori",
	   CASE WHEN ((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') THEN ((right(T2."VIN",7))) WHEN ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') THEN ((right(T2."VIN",7)) + ' / ' + T3."Text 1") WHEN ((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') THEN ((right(T2."VIN",7)) + ' / ' + (CASE WHEN ((((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (T3."Initial Registration" <> convert(datetime, '1753-01-01 00:00:00.000'))) and (T3."Initial Registration" > T3."Deregistration Date")) THEN ('zugelassen') WHEN ((((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (T3."Initial Registration" <> convert(datetime, '1753-01-01 00:00:00.000'))) and (T3."Initial Registration" < T3."Deregistration Date")) THEN ('abgemeldet') ELSE null END)) ELSE null END as "FZG-Liste",
	   ((convert(float, T2."Amount"))) as "Betrag",
	   CASE WHEN ((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) 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 (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) 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 (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0)) THEN ('NA') 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",
	   CASE WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 0 AND 90)) THEN ('0 - 90 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 91 AND 120)) THEN ('91 - 120 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 121 AND 180)) THEN ('121 - 180 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) > 180)) THEN ('> 180 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 0 AND 90)) THEN ('0 - 90 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 91 AND 120)) THEN ('91 - 120 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 121 AND 180)) THEN ('121 - 180 Tage') WHEN (((CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) > 180)) THEN ('> 180 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 0 AND 30)) THEN ('0 - 30 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 31 AND 60)) THEN ('31 - 60 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 61 AND 90)) THEN ('61 - 90 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 91 AND 120)) THEN ('91 - 120 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) BETWEEN 121 AND 180)) THEN ('121 - 180 Tage') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (((-1 * datediff(day, (getdate()), T3."Purchase Receipt Date"))) > 180)) THEN ('> 180 Tage') ELSE null END as "Standtagestaffel_ori",
	   T3."Purchase Receipt Date" as "Purchase Receipt Date",
	   T4."Code" + ' - ' + T4."Name" as "VB_Einkauf",
	   T4."Name" as "Name_Salesperson Purchase",
	   T4."Code" as "Code_Salesperson Purchase",
	   T3."Location Code" as "Location Code",
	   CASE WHEN ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') THEN ((right(T2."VIN",7)) + ' / ' + T3."Model" + ' / ' + (CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END) + ' / ' + T3."Location Code" + ' / ' + T3."Dealer Status") ELSE ((right(T2."VIN",7)) + ' / ' + T3."Model" + ' / ' + T3."Location Code" + ' / ' + T3."Dealer Status") END as "FZG",
	   CASE WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 0)) THEN ('NA') WHEN (((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') and (T3."Vehicle Status" = 2)) THEN ('VFW') ELSE null END as "Fahrzeugtyp_ori",
	   T3."VAT Prod_ Posting Group" as "Vat Prod Posting Group",
	   CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END as "Fahrzeugart_ori",
	   T3."Model" as "Model_ori",
	   T3."Market Segment Code" as "Model_alt",
	   T3."Make Code" as "Make Code_Vehicle",
	   CASE WHEN ((T2."Branch Code" = 'FIL1') or (T2."Branch Code" = '')) THEN ('10') WHEN (T2."Branch Code" = 'FIL2') THEN ('20') ELSE ((left(T1."Department Code",2))) END as "Standort_FIBU",
	   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."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."Make Code" as "Make Code",
	   T2."Department 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."Make Code" as "Make Code_2",
	   T1."Department Code" as "Department Code_2",
	   T1."Account Type" as "Account Type",
	   T1."Name" as "Name",
	   T1."No_" as "No"
from "NAVISION"."import"."G_L_Account" T1,
	(((("NAVISION"."import"."G_L_Entry" T2 left outer join "NAVISION"."import"."Vehicle" T3 on (T3."VIN" = T2."VIN") and (T3."Client_DB" = T2."Client_DB")) left outer join "NAVISION"."import"."Salesperson_Purchaser" T4 on (T3."Purchaser Code" = T4."Code") and (T3."Client_DB" = T4."Client_DB")) left outer join "NAVISION"."import"."Veh_Price_Sticker_Header" T5 on (((T3."VIN" = T5."VIN") and (T3."Current Price Sticker" = T5."Line No_")) and (T3."Current Book No_" = T5."Vehicle Book No_")) and (T3."Client_DB" = T5."Client_DB")) left outer join "NAVISION"."import"."Customer" T6 on (T6."No_" = T3."Old Customer No_") and (T6."Client_DB" = T3."Client_DB"))
where ((T1."No_" = T2."G_L Account No_") and (T1."Client_DB" = T2."Client_DB"))
and (((((T1."No_" BETWEEN '31000' AND '32905') or (((T1."No_" LIKE '4%') and (T2."Book No_" <> ' ')) and (T2."Posting Date" >= T3."Purchase Receipt Date"))) and (T3."Vehicle Status" <> 3)) and (T3."Inventory Posting Group" <> 'GROSSKD')) and (not T2."Document No_" LIKE '%20120220%'))
) D3
) D2
) D1
where (("Summe Betrag" >= 0) and ("Summe EK" > 0))
-- order by "Summe Standtage" desc,"Vin" asc