C11/System/ARI/IQD/NW_GW/NW_GW_BE_neu.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_FIBU" as "Standort_FIBU",
	   "Make Code_Vehicle" as "Make Code_Vehicle",
	   "Fabrikat_ori" as "Fabrikat_ori",
	   "Model_alt" as "Model_alt",
	   "Market Segment Code" as "Market Segment Code",
	   "Modellbez" as "Modellbez",
	   "Fahrzeugart" as "Fahrzeugart",
	   "Vat Prod Posting Group" as "Vat Prod Posting Group",
	   "Fahrzeugtyp_ori" as "Fahrzeugtyp_ori",
	   "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_ori" as "Standtagestaffel_ori",
	   "Initial Registration" as "Initial Registration",
	   "EZ/Eingang" as "EZ/Eingang",
	   "Option Type_Polster" as "Option Type_Polster",
	   "Polster" as "Polster",
	   "Option Type_Farbe" as "Option Type_Farbe",
	   "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",
	   "Current Price Sticker" as "Current Price Sticker",
	   "Manual Price Calculation" as "Manual Price Calculation",
	   "Total Quote Amount" as "Total Quote Amount",
	   "Price Sticker Date" as "Price Sticker Date",
	   "gepl. VK" as "gepl. VK",
	   "Datum letzte Änderung" as "Datum letzte Änderung",
	   "FZG-Kosten" as "FZG-Kosten",
	   "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",
	   "EZ_Zeichen" as "EZ_Zeichen",
	   "Abmeldung_Zeichen" as "Abmeldung_Zeichen",
	   "Dat_letzte_Änderung_Zeichen" as "Dat_letzte_Änderung_Zeichen",
	   "Bemerkung" as "Bemerkung",
	   "UPE" as "UPE",
	   "Fahrzeugtyp_alt" as "Fahrzeugtyp_alt",
	   "Model_alt_1" as "Model_alt_1",
	   "kundenbelegt ja/nein" as "kundenbelegt ja/nein",
	   "Standtagestaffel" as "Standtagestaffel",
	   "No_Item" as "No_Item",
	   "Description_Item" as "Description_Item",
	   "Vehicle Type Code_Item" as "Vehicle Type Code_Item",
	   "Vehicle Category Code_Item" as "Vehicle Category Code_Item",
	   "Modell_zwischen" as "Modell_zwischen",
	   "Fabrikat" as "Fabrikat",
	   "Modell_final" as "Modell_final",
	   "Model" as "Model",
	   "Fahrzeugtyp" as "Fahrzeugtyp",
	   "Tage letzte Preisänderung_ori" as "Tage letzte Preisänderung_ori",
	   "Tage letzte Preisänderung" as "Tage letzte Preisänderung"
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_FIBU" as "Standort_FIBU",
	   "Make Code_Vehicle" as "Make Code_Vehicle",
	   "Fabrikat_ori" as "Fabrikat_ori",
	   "Model_alt" as "Model_alt",
	   "Market Segment Code" as "Market Segment Code",
	   "Modellbez" as "Modellbez",
	   "Fahrzeugart" as "Fahrzeugart",
	   "Vat Prod Posting Group" as "Vat Prod Posting Group",
	   "Fahrzeugtyp_ori" as "Fahrzeugtyp_ori",
	   "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_ori" as "Standtagestaffel_ori",
	   "Initial Registration" as "Initial Registration",
	   "EZ/Eingang" as "EZ/Eingang",
	   "Option Type_Polster" as "Option Type_Polster",
	   "Polster" as "Polster",
	   "Option Type_Farbe" as "Option Type_Farbe",
	   "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",
	   "Current Price Sticker" as "Current Price Sticker",
	   "Manual Price Calculation" as "Manual Price Calculation",
	   "Total Quote Amount" as "Total Quote Amount",
	   "Price Sticker Date" as "Price Sticker Date",
	   "gepl. VK" as "gepl. VK",
	   "Datum letzte Änderung" as "Datum letzte Änderung",
	   "FZG-Kosten" as "FZG-Kosten",
	   "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",
	   "EZ_Zeichen" as "EZ_Zeichen",
	   "Abmeldung_Zeichen" as "Abmeldung_Zeichen",
	   "Dat_letzte_Änderung_Zeichen" as "Dat_letzte_Änderung_Zeichen",
	   "Bemerkung" as "Bemerkung",
	   "UPE" as "UPE",
	   "Fahrzeugtyp_alt" as "Fahrzeugtyp_alt",
	   "Model_alt_1" as "Model_alt_1",
	   "kundenbelegt ja/nein" as "kundenbelegt ja/nein",
	   "Standtagestaffel" as "Standtagestaffel",
	   "No_Item" as "No_Item",
	   "Description_Item" as "Description_Item",
	   "Vehicle Type Code_Item" as "Vehicle Type Code_Item",
	   "Vehicle Category Code_Item" as "Vehicle Category Code_Item",
	   "Modell_zwischen" as "Modell_zwischen",
	   "Fabrikat" as "Fabrikat",
	   "Modell_final" as "Modell_final",
	   "Model" as "Model",
	   "Fahrzeugtyp" as "Fahrzeugtyp",
	   "Tage letzte Preisänderung_ori" as "Tage letzte Preisänderung_ori",
	   "Tage letzte Preisänderung" as "Tage letzte Preisänderung"
from 
(select c226 as "No",
	   c225 as "Name",
	   c224 as "Account Type",
	   c223 as "Department Code",
	   c222 as "Make Code",
	   c221 as "Income Balance",
	   c220 as "Entry No",
	   c219 as "G L Account No",
	   c218 as "Posting Date",
	   c217 as "Document Type",
	   c216 as "Document No",
	   c215 as "Description",
	   c214 as "Amount",
	   c213 as "Bal Account No",
	   c212 as "Department Code",
	   c211 as "Make Code",
	   c210 as "User Id",
	   c209 as "Source Code",
	   c208 as "Quantity",
	   c207 as "Debit Amount",
	   c206 as "Credit Amount",
	   c205 as "Document Date",
	   c204 as "Source Type",
	   c203 as "Source No",
	   c202 as "No Series",
	   c201 as "Branch Code",
	   c200 as "Main Area",
	   c126 as "Vin",
	   c199 as "Book No",
	   c198 as "Veh Source Code",
	   c176 as "Betrag",
	   c197 as "Vin_Vehicle",
	   c196 as "Vehicle Status",
	   c189 as "Model_ori",
	   c195 as "Type",
	   c194 as "Class",
	   c193 as "Model No",
	   '1' as "Hauptbetrieb",
	   c192 as "Standort_FIBU",
	   c191 as "Make Code_Vehicle",
	   c191 as "Fabrikat_ori",
	   c190 as "Model_alt",
	   c190 as "Market Segment Code",
	   c189 as "Modellbez",
	   c188 as "Fahrzeugart",
	   c187 as "Vat Prod Posting Group",
	   c186 as "Fahrzeugtyp_ori",
	   c185 as "FZG",
	   c184 as "Location Code",
	   '' as "VB_Einkauf",
	   c183 as "Purchase Receipt Date",
	   c174 as "Standtage_ori",
	   c182 as "Standtagestaffel_ori",
	   c149 as "Initial Registration",
	   c181 as "EZ/Eingang",
	   c180 as "Option Type_Polster",
	   c179 as "Polster",
	   c178 as "Option Type_Farbe",
	   c177 as "Farbe",
	   c176 as "Einsatz",
	   (getdate()) as "Heute",
	   'Bestand' as "Fahrzeugstatus",
	   c175 as "FZG-Liste",
	   COUNT(c174) OVER (partition by c126) as "Anzahl",
	   (c174) / (COUNT(c174) OVER (partition by c126)) as "Standtage",
	   1 / (COUNT(c174) OVER (partition by c126)) as "Menge_FZG",
	   c173 as "Inventory Posting Group",
	   SUM(c176) OVER (partition by c126) as "Summe Betrag",
	   c172 as "Fzg_Typ_Herkunft",
	   c171 as "Current Price Sticker",
	   c170 as "Manual Price Calculation",
	   c169 as "Total Quote Amount",
	   c167 as "Price Sticker Date",
	   (c168) / (COUNT(c174) OVER (partition by c126)) as "gepl. VK",
	   c167 as "Datum letzte Änderung",
	   c166 as "FZG-Kosten",
	   c165 as "EK FZG",
	   c141 as "Text 3",
	   c164 as "Bestand/reserviert",
	   c163 as "Ort_B_R_Dat_Änd",
	   c162 as "Date Of Sale",
	   SUM(c165) OVER (partition by c126) as "Summe EK",
	   c161 as "Standort",
	   c160 as "Dealer Status_ori",
	   c159 as "Transmission Type Code",
	   c158 as "Key No",
	   c157 as "Mileage",
	   c156 as "License No",
	   c155 as "Händlerstatus_Text",
	   c154 as "Händlerstatus",
	   c153 as "Händlerstatus Gruppe",
	   c152 as "Dealer Status",
	   c151 as "Extra Code 1",
	   c150 as "Text 1_Vorbesitzer",
	   c149 as "Initial Registration",
	   c148 as "Deregistration Date",
	   c147 as "VFW zugel./abgem",
	   c146 as "EK erh. Pos.",
	   c145 as "Name_Vorbesitzer",
	   c144 as "EZ_Zeichen",
	   c143 as "Abmeldung_Zeichen",
	   c142 as "Dat_letzte_Änderung_Zeichen",
	   c141 as "Bemerkung",
	   (c140) / (COUNT(c174) OVER (partition by c126)) as "UPE",
	   c139 as "Fahrzeugtyp_alt",
	   c138 as "Model_alt_1",
	   c137 as "kundenbelegt ja/nein",
	   c136 as "Standtagestaffel",
	   c135 as "No_Item",
	   c134 as "Description_Item",
	   c133 as "Vehicle Type Code_Item",
	   c132 as "Vehicle Category Code_Item",
	   c131 as "Modell_zwischen",
	   c130 as "Fabrikat",
	   c129 as "Modell_final",
	   c129 as "Model",
	   c128 as "Fahrzeugtyp",
	   c127 as "Tage letzte Preisänderung_ori",
	   (c127) / (COUNT(c174) OVER (partition by c126)) as "Tage letzte Preisänderung"
from 
(select T2."VIN" as c126,
	   (day((now()) - T6."Price Sticker Date")) as c127,
	   CASE WHEN ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'GA') THEN (T3."Inventory Posting Group") 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."Inventory Posting Group" IN ('GW_DW_PKW'))) 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','BMW-MOT','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-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','BMW-MOT','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-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)) END as c128,
	   (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 ((T3."Make Code" = 'BMW') and ((left(T8."Description",1)) BETWEEN '1' AND '9')) THEN ((left(T8."Description",1)) + 'er') WHEN ((T3."Make Code" = 'BMW') and ((left(T8."Description",1)) BETWEEN 'A' AND 'Z')) THEN ((left(T8."Description",2))) WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%3-T%') or (T3."Model" LIKE '%3-T%'))) THEN ('3-Türer') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%5-T%') or (T3."Model" LIKE '%5-T%'))) THEN ('5-Türer') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Club%') or (T3."Model" LIKE '%Club%'))) THEN ('Clubman') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Count%') or (T3."Model" LIKE '%Count%'))) THEN ('Countryman') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Cou%') or (T3."Model" LIKE '%Cou%'))) THEN ('Coupe') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Hatch%') or (T3."Model" LIKE '%Hatch%'))) THEN ('Hatch') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Pace%') or (T3."Model" LIKE '%Pace%'))) THEN ('Paceman') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Road%') or (T3."Model" LIKE '%Road%'))) THEN ('Roadster') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Cab%') or (T3."Model" LIKE '%Cab%'))) THEN ('Cabrio') ELSE (T8."Description") END)) ELSE ('Fremd') END) as c129,
	   CASE WHEN (T3."Make Code" IN ('BMW','BMW I','BMWI','BMW-MINI','BMW-MOT')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END as c130,
	   CASE WHEN ((T3."Make Code" = 'BMW') and ((left(T8."Description",1)) BETWEEN '1' AND '9')) THEN ((left(T8."Description",1)) + 'er') WHEN ((T3."Make Code" = 'BMW') and ((left(T8."Description",1)) BETWEEN 'A' AND 'Z')) THEN ((left(T8."Description",2))) WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%3-T%') or (T3."Model" LIKE '%3-T%'))) THEN ('3-Türer') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%5-T%') or (T3."Model" LIKE '%5-T%'))) THEN ('5-Türer') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Club%') or (T3."Model" LIKE '%Club%'))) THEN ('Clubman') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Count%') or (T3."Model" LIKE '%Count%'))) THEN ('Countryman') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Cou%') or (T3."Model" LIKE '%Cou%'))) THEN ('Coupe') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Hatch%') or (T3."Model" LIKE '%Hatch%'))) THEN ('Hatch') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Pace%') or (T3."Model" LIKE '%Pace%'))) THEN ('Paceman') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Road%') or (T3."Model" LIKE '%Road%'))) THEN ('Roadster') WHEN ((T3."Make Code" = 'BMW-MINI') and ((T8."Description" LIKE '%Cab%') or (T3."Model" LIKE '%Cab%'))) THEN ('Cabrio') ELSE (T8."Description") END as c131,
	   T8."Vehicle Category Code" as c132,
	   T8."Vehicle Type Code" as c133,
	   T8."Description" as c134,
	   T8."No_" as c135,
	   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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - T3."Purchase Receipt Date"))) > 360)) THEN ('> 360 Tage') ELSE null END as c136,
	   CASE WHEN (T3."Vehicle Status" = 3) THEN ('kundenbelegt') ELSE ('nicht kundenbelegt') END as c137,
	   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 c138,
	   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_DW_PKW'))) 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','BMW-MOT','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-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','BMW-MOT','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-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 c139,
	   convert(float, T6."List Price Incl_ VAT") as c140,
	   T3."Text 3" as c141,
	   (convert(varchar(50), year(T6."Price Sticker Date")) + '-' + convert(varchar(50), month(T6."Price Sticker Date")) + '-' + convert(varchar(50), day(T6."Price Sticker Date"))) as c142,
	   (convert(varchar(50), year(T3."Deregistration Date")) + '-' + convert(varchar(50), month(T3."Deregistration Date")) + '-' + convert(varchar(50), day(T3."Deregistration Date"))) as c143,
	   (convert(varchar(50), year(T3."Initial Registration")) + '-' + convert(varchar(50), month(T3."Initial Registration")) + '-' + convert(varchar(50), day(T3."Initial Registration"))) as c144,
	   T7."Name" as c145,
	   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 c146,
	   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 c147,
	   T3."Deregistration Date" as c148,
	   T3."Initial Registration" as c149,
	   T3."Text 1" as c150,
	   T3."Extra Code 1" as c151,
	   CASE WHEN (T3."Dealer Status" IN ('000','')) THEN ('005') ELSE (T3."Dealer Status") END as c152,
	   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 c153,
	   (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 c154,
	   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 c155,
	   T3."License No_" as c156,
	   (convert(float, T3."Mileage")) as c157,
	   T3."Key No_" as c158,
	   T3."Transmission Type Code" as c159,
	   T3."Dealer Status" as c160,
	   CASE WHEN (T3."Location Code" = 'BUR') THEN ('10') WHEN (T3."Location Code" = 'MUE') THEN ('20') ELSE ('10') END as c161,
	   T3."Date of Sale" as c162,
	   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(T6."Price Sticker Date")) + '-' + convert(varchar(50), month(T6."Price Sticker Date")) + '-' + convert(varchar(50), day(T6."Price Sticker Date"))) as c163,
	   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 c164,
	   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 c165,
	   CASE WHEN (T1."No_" LIKE '4%') THEN (((convert(float, T2."Amount")))) ELSE (0) END as c166,
	   T6."Price Sticker Date" as c167,
	   convert(float, T6."Total Quote Amount") as c168,
	   T6."Total Quote Amount" as c169,
	   T3."Manual Price Calculation" as c170,
	   T3."Current Price Sticker" as c171,
	   (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 c172,
	   T3."Inventory Posting Group" as c173,
	   (day((now()) - T3."Purchase Receipt Date")) as c174,
	   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 ((od_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 ((od_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 ((od_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 c175,
	   ((convert(float, T2."Amount"))) as c176,
	   T5."Description" as c177,
	   T5."Option Type" as c178,
	   T4."Description" as c179,
	   T4."Option Type" as c180,
	   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 c181,
	   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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - 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 (((day((now()) - T3."Purchase Receipt Date"))) > 180)) THEN ('> 180 Tage') ELSE null END as c182,
	   T3."Purchase Receipt Date" as c183,
	   T3."Location Code" as c184,
	   CASE WHEN ((CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END) = 'NA') THEN ((od_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') THEN (T3."Inventory Posting Group") 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."Inventory Posting Group" IN ('GW_DW_PKW'))) 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','BMW-MOT','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-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','BMW-MOT','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-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)) END) + ' / ' + T3."Location Code" + ' / ' + T3."Dealer Status") ELSE ((od_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') THEN (T3."Inventory Posting Group") 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."Inventory Posting Group" IN ('GW_DW_PKW'))) 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','BMW-MOT','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-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','BMW-MOT','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-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)) END) + ' / ' + T3."Location Code" + ' / ' + T3."Dealer Status") END as c185,
	   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 c186,
	   T3."VAT Prod_ Posting Group" as c187,
	   CASE WHEN (T3."Vehicle Status" = 1) THEN ('GA') WHEN (T3."Vehicle Status" IN (0,2)) THEN ('NA') ELSE null END as c188,
	   T3."Model" as c189,
	   T3."Market Segment Code" as c190,
	   T3."Make Code" as c191,
	   CASE WHEN ((T2."Branch Code" = 'FIL1') or (T2."Branch Code" = '')) THEN ('10') WHEN (T2."Branch Code" = 'FIL2') THEN ('20') ELSE ((left(T1."Global Dimension 1 Code",2))) END as c192,
	   T3."Model No_" as c193,
	   T3."Class" as c194,
	   T3."Type" as c195,
	   T3."Vehicle Status" as c196,
	   T3."VIN" as c197,
	   T2."Veh_ Source Code" as c198,
	   T2."Book No_" as c199,
	   T2."Main Area" as c200,
	   T2."Branch Code" as c201,
	   T2."No_ Series" as c202,
	   T2."Source No_" as c203,
	   T2."Source Type" as c204,
	   T2."Document Date" as c205,
	   T2."Credit Amount" as c206,
	   T2."Debit Amount" as c207,
	   T2."Quantity" as c208,
	   T2."Source Code" as c209,
	   T2."User ID" as c210,
	   T2."Global Dimension 2 Code" as c211,
	   T2."Global Dimension 1 Code" as c212,
	   T2."Bal_ Account No_" as c213,
	   T2."Amount" as c214,
	   T2."Description" as c215,
	   T2."Document No_" as c216,
	   T2."Document Type" as c217,
	   T2."Posting Date" as c218,
	   T2."G_L Account No_" as c219,
	   T2."Entry No_" as c220,
	   T1."Income_Balance" as c221,
	   T1."Global Dimension 2 Code" as c222,
	   T1."Global Dimension 1 Code" as c223,
	   T1."Account Type" as c224,
	   T1."Name" as c225,
	   T1."No_" as c226
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$Vehicle Option" T4 on ((T3."VIN" = T4."VIN") and (T4."Option Type" = 2)) and (T4."Built-in Date" <> convert(datetime, '1753-01-01 00:00:00.000'))) left outer join "Vogl7x"."dbo"."BMW AH Vogl$Vehicle Option" T5 on ((T3."VIN" = T5."VIN") and (T5."Option Type" = 1)) and (T5."Built-in Date" <> convert(datetime, '1753-01-01 00:00:00.000'))) left outer join "Vogl7x"."dbo"."BMW AH Vogl$Veh_ Price Sticker Header" T6 on ((T3."VIN" = T6."VIN") and (T3."Current Price Sticker" = T6."Line No_")) and (T3."Current Book No_" = T6."Vehicle Book No_")) left outer join "Vogl7x"."dbo"."BMW AH Vogl$Customer" T7 on T7."No_" = T3."Old Customer No_") left outer join "Vogl7x"."dbo"."BMW AH Vogl$Item" T8 on T8."No_" = T3."Model No_")
where (T1."No_" = T2."G_L Account No_")
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'))
) D3
) D2
) D1
where (("Summe Betrag" >= 0) and ("Summe EK" > 0))
-- order by "Summe Standtage" desc,"Vin" asc