C11/System/NAVISION/IQD/Serv_Teile/reifen_service_interne_auftraege.sql

select "Document Type_2",
	   "No",
	   "Sell-to Customer No",
	   "Bill-to Customer No",
	   "Bill-to Name",
	   "Bill-to Name 2",
	   "Order Date",
	   "Posting Date_2",
	   "Posting Description",
	   "Location Code_2",
	   "Department Code_2",
	   "Make Code",
	   "Customer Posting Group",
	   "Salesperson Code",
	   "Order Class",
	   "Sell-to Customer Name",
	   "Sell-to Customer Name 2",
	   "Document Date",
	   "No Series",
	   "Posting No Series",
	   "Shipping No Series",
	   "Date Archived",
	   "Archived By User",
	   "Reason For Archiving",
	   "Service Posting Group",
	   "Vin",
	   "License No",
	   "Mileage",
	   "Model Code",
	   "Model No",
	   "Prod Year",
	   "Model_ori",
	   "Initial Registration",
	   "No Of Cylinders",
	   "Cylinder Capacity (ccm)" as "Cylinder Capacity (ccm)",
	   "Power (kw)" as "Power (kw)",
	   "Power (hp)" as "Power (hp)",
	   "Book No",
	   "Branch Book No",
	   "Sales Department Code_2",
	   "Item Sales Pr Grp Int Chrg",
	   "Int Charg Labor Price Group",
	   "Ext Serv Int Charging Pr Grp",
	   "Post With Book No",
	   "Internal Order",
	   "Branch Code",
	   "Work Completed",
	   "Sales Branch Code_2",
	   "Vehicle Status",
	   "Entry No",
	   "Order No",
	   "Posting Date",
	   "Document No",
	   "Type",
	   "No_Arbeit_Teil",
	   "Description",
	   "Quantity",
	   "Direct Unit Cost",
	   "Unit Cost",
	   "Total Cost",
	   "Unit Price",
	   "Total Price",
	   "Location Code",
	   "Department Code",
	   "Work Type Code",
	   "User Id",
	   "Amt To Post To G L",
	   "Amt Posted To G L",
	   "Entry Type",
	   "Positive",
	   "Quantity (base)" as "Quantity (base)",
	   "Time Type",
	   "Service Job No",
	   "Sales Department Code",
	   "Qty Per Hour",
	   "Qty (hour)" as "Qty (hour)",
	   "Document Type",
	   "Customer Group Code",
	   "Standard Time",
	   "Standard Time Type",
	   "Order Line No",
	   "Order Completed",
	   "Sales Branch Code",
	   "Hauptbetrieb",
	   "Standort_Department",
	   "Code_Salesperson",
	   "Name_Salesperson",
	   "Name_Salesperson" as "Serviceberater_falsch",
	   "Menge_ori",
	   "Einstandsbetrag",
	   "Verkaufsbetrag",
	   "Gen Bus Posting Group",
	   "Gen Prod Posting Group",
	   "Source Type",
	   "Source No",
	   "Source No (payment)" as "Source No (payment)",
	   "Umsatzart",
	   "Make Code" as "Marke",
	   "Customer Group Code" as "Kundenart_ori",
	   "Fabrikat",
	   "Model_ori" as "Model",
	   "Fahrzeug",
	   "Vehicle Type",
	   "Market Segment Code",
	   "Charging Group No",
	   "Cust_No",
	   "Cust_Name",
	   "Kunde",
	   "Cust_Gr_Code",
	   "Cust_Gr_Description",
	   "Kundenart",
	   "Order Number",
	   "Verkaufsbetrag" as "Lines Net Value_inklType2",
	   "Name_Employee",
	   "Function Code",
	   "Name_Employee" as "Monteur",
	   "Function Code" as "Funktion Monteur",
	   "Order Date" as "Auftragsdatum",
	   "Posting Date_2" as "Invoice Date",
	   "Service Posting Group" as "Auftragsart",
	   1 as "DG_1",
	   COUNT("No") OVER (partition by "Order Number") as "DG_2",
	   "Standort",
	   'Öldosen' as "Auftragsart_1",
	   "Menge (Base)_ori" as "Menge (Base)_ori",
	   "Standard Zeit_ori",
	   "Order Number_Rg_Ausg_ori",
	   "Lines Net Value",
	   "Service Advisor No",
	   "First Name",
	   "Last Name",
	   "Serviceberater",
	   "Qty Evaluated",
	   "Rg_Ausgang_Arb_Pos",
	   "Monteur_Anzeige",
	   "Serviceberater_Monteur",
	   "Order Number_Rg_Ausg_1",
	   "No_7+" as "No_7+",
	   "Description_7+" as "Description_7+",
	   "Order Number_Rg_Ausg_2",
	   "No_GWL",
	   "Order Number_Rg_Ausg_",
	   "Menge_ori" as "Menge Öldosen",
	   1 / (COUNT("No") OVER (partition by "Order Number")) as "Durchgänge Öldosen",
	   "No_Arbeit_Teil" as "Teilenummer",
	   "Bezeichnung_Teil",
	   "Teilenummer_Bezeichnung",
	   "Parts Family_Item_ori",
	   "Menge",
	   "Umsatz Teile Service",
	   "Einsatz Teile Service",
	   "Inventory Posting Group_Item",
	   "Parts Family_Item_alt",
	   "Parts Family_Item",
	   "Menge_final",
	   "Kundennummern_Ausschluss",
	   "Hauptbetrieb" as "Hauptbetrieb_ID",
	   "Hauptbetrieb_Name",
	   "Standort" as "Standort_ID",
	   "Standort_Name"
from 
(select (T1."No_" + ' - ' + T4."Name") as "Order Number",
	   CASE WHEN (((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END)) IN ('10')) THEN ('MM') WHEN (((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END)) IN ('30')) THEN ('KRU') WHEN (((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END)) IN ('40')) THEN ('ULM') WHEN (((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END)) IN ('50')) THEN ('LL') WHEN (((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END)) IN ('55')) THEN ('GZ') WHEN (((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END)) IN ('60')) THEN ('AAM') WHEN (((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END)) IN ('70')) THEN ('LEH') WHEN (((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END)) IN ('80')) THEN ('WTB') ELSE null END as "Standort_Name",
	   (CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) as "Standort",
	   CASE WHEN (T1."Client_DB" = '1') THEN ('AHR') WHEN (T1."Client_DB" = '2') THEN ('AAM') ELSE null END as "Hauptbetrieb_Name",
	   T1."Client_DB" as "Hauptbetrieb",
	   CASE WHEN (T4."No_" IN ('022350','036287','205744')) THEN ('raus') ELSE ('rein') END as "Kundennummern_Ausschluss",
	   CASE WHEN (T11."Parts Family" IN ('369011','369012','369022')) THEN ((CASE WHEN ((T11."Parts Family" IN ('369011','GBWR','369012','369022')) and (((convert(float, T2."Quantity"))) BETWEEN 0.5 AND 1)) THEN (4) WHEN ((T11."Parts Family" IN ('369011','GBWR','369012','369022')) and (((convert(float, T2."Quantity"))) = -1)) THEN (-4) ELSE (((convert(float, T2."Quantity")))) END) / 4) ELSE (((convert(float, T2."Quantity")))) END as "Menge_final",
	   CASE WHEN (not (CASE WHEN ((T2."Gen_ Prod_ Posting Group" = '678_ART') and (T11."Inventory Posting Group" = 'T_SONST')) THEN ('GBWR') WHEN (T11."Inventory Posting Group" = 'R_FR_PKW') THEN ('Reifen fremd') ELSE (T11."Parts Family") END) IN ('36907111','36907112','36907113','36907114','36907115','Reifen fremd')) THEN ((substring((CASE WHEN ((T2."Gen_ Prod_ Posting Group" = '678_ART') and (T11."Inventory Posting Group" = 'T_SONST')) THEN ('GBWR') WHEN (T11."Inventory Posting Group" = 'R_FR_PKW') THEN ('Reifen fremd') ELSE (T11."Parts Family") END), 1, 6))) ELSE ((CASE WHEN ((T2."Gen_ Prod_ Posting Group" = '678_ART') and (T11."Inventory Posting Group" = 'T_SONST')) THEN ('GBWR') WHEN (T11."Inventory Posting Group" = 'R_FR_PKW') THEN ('Reifen fremd') ELSE (T11."Parts Family") END)) END as "Parts Family_Item",
	   CASE WHEN ((T2."Gen_ Prod_ Posting Group" = '678_ART') and (T11."Inventory Posting Group" = 'T_SONST')) THEN ('GBWR') WHEN (T11."Inventory Posting Group" = 'R_FR_PKW') THEN ('Reifen fremd') ELSE (T11."Parts Family") END as "Parts Family_Item_alt",
	   T11."Inventory Posting Group" as "Inventory Posting Group_Item",
	   CASE WHEN (T2."Type" = 1) THEN ((CASE WHEN (((T1."No_" IN ('WAU12105302','WAU12107303','WAU12105478','WAU12302117')) and (T2."No_" = '83220144137'))) THEN (((convert(float, ((convert(float, T2."Quantity")))))) * 12.41) ELSE ((convert(float, T2."Total Cost"))) END)) ELSE (0) END as "Einsatz Teile Service",
	   CASE WHEN (T2."Type" = 1) THEN (((convert(float, T2."Total Price")))) ELSE (0) END as "Umsatz Teile Service",
	   CASE WHEN ((T11."Parts Family" IN ('369011','GBWR','369012','369022')) and (((convert(float, T2."Quantity"))) BETWEEN 0.5 AND 1)) THEN (4) WHEN ((T11."Parts Family" IN ('369011','GBWR','369012','369022')) and (((convert(float, T2."Quantity"))) = -1)) THEN (-4) ELSE (((convert(float, T2."Quantity")))) END as "Menge",
	   T11."Parts Family" as "Parts Family_Item_ori",
	   T2."No_" + ' - ' + (CASE WHEN (T2."No_" = '83212365929') THEN ('BMW Motoröl Longlife 04 0W30') ELSE (T2."Description") END) as "Teilenummer_Bezeichnung",
	   CASE WHEN (T2."No_" = '83212365929') THEN ('BMW Motoröl Longlife 04 0W30') ELSE (T2."Description") END as "Bezeichnung_Teil",
	   T2."No_" as "No_Arbeit_Teil",
	   ((convert(float, ((convert(float, T2."Quantity")))))) as "Menge_ori",
	   CASE WHEN (T10."No_" IS NOT NULL) THEN ('GWL ' + (CASE WHEN (T9."No_2" IS NOT NULL) THEN ('7+ ' + (CASE WHEN (((datediff(day, T1."Posting Date", (getdate()))) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NOT NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") ELSE null END)) ELSE ((CASE WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NOT NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") ELSE null END)) END)) ELSE ((CASE WHEN (T9."No_2" IS NOT NULL) THEN ('7+ ' + (CASE WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NOT NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") ELSE null END)) ELSE ((CASE WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NOT NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") ELSE null END)) END)) END as "Order Number_Rg_Ausg_",
	   T10."No_" as "No_GWL",
	   CASE WHEN (T9."No_2" IS NOT NULL) THEN ('7+ ' + (CASE WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NOT NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") ELSE null END)) ELSE ((CASE WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NOT NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") ELSE null END)) END as "Order Number_Rg_Ausg_2",
	   T9."Description" as "Description_7+",
	   T9."No_2" as "No_7+",
	   CASE WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NOT NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END) IS NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") ELSE null END as "Order Number_Rg_Ausg_1",
	   CASE WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NOT NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name") + ' / ' + T8."Last Name") WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL) and (T8."Last Name" IS NULL)) THEN ((T7."First Name" + ' ' + T7."Last Name")) WHEN (((T7."First Name" + ' ' + T7."Last Name") IS NULL) and (T8."Last Name" IS NOT NULL)) THEN ('SB fehlt / ' + T8."Last Name") ELSE null END as "Serviceberater_Monteur",
	   T8."Last Name" as "Monteur_Anzeige",
	   CASE WHEN (((CASE WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (T7."First Name" + ' ' + T7."Last Name") + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((T7."First Name" + ' ' + T7."Last Name") IS NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), day(T1."Posting Date"))) + ' - ' + T4."Name") ELSE null END) IS NOT NULL) and ((CASE WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'MECH')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('10','40'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (8.15) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'MECH')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('30'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (7.00) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'MECH')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('50'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (7.67) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'KARO')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('10','40'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (9.41) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'KARO')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('30'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (8.70) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'KARO')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('50'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (8.99) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'ELEK')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('10','40'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (9.07) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'ELEK')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('30'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (7.70) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'ELEK')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('50'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (8.99) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'MECH')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('10','40'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (7.00) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'MECH')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('30'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (7.00) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'MECH')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('50'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (7.00) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'KARO')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('10','40'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (8.20) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'KARO')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('30'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (8.20) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'KARO')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('50'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (8.20) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'ELEK')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('10','40'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (7.70) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'ELEK')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('30'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (7.70) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'ELEK')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('50'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (7.70) ELSE (0) END) <> 0)) THEN (T2."Charging Group No_" + ' - ' + (left((((T2."Order Line No_"))),9)) + ' - ' + T2."Description") WHEN (((CASE WHEN (((datediff(day, T1."Posting Date", (getdate()))) <= 7) and ((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (T7."First Name" + ' ' + T7."Last Name") + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((T7."First Name" + ' ' + T7."Last Name") IS NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), day(T1."Posting Date"))) + ' - ' + T4."Name") ELSE null END) IS NOT NULL) and ((CASE WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'MECH')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('10','40'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (8.15) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'MECH')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('30'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (7.00) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'MECH')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('50'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (7.67) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'KARO')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('10','40'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (9.41) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'KARO')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('30'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (8.70) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'KARO')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('50'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (8.99) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'ELEK')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('10','40'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (9.07) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'ELEK')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('30'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (7.70) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'ELEK')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('50'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('Extern','Intern'))) THEN (8.99) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'MECH')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('10','40'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (7.00) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'MECH')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('30'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (7.00) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'MECH')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('50'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (7.00) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'KARO')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('10','40'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (8.20) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'KARO')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('30'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (8.20) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'KARO')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('50'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (8.20) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'ELEK')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('10','40'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (7.70) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'ELEK')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('30'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (7.70) WHEN (((((T2."Type" = 4) and (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) <> 0)) and (T2."Charging Group No_" = 'ELEK')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) IN ('50'))) and ((CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) IN ('GWL'))) THEN (7.70) ELSE (0) END) = 0)) THEN ('Monteur: ' + T6."Name") ELSE null END as "Rg_Ausgang_Arb_Pos",
	   T2."Qty_ Evaluated" as "Qty Evaluated",
	   T7."First Name" + ' ' + T7."Last Name" as "Serviceberater",
	   T7."Last Name" as "Last Name",
	   T7."First Name" as "First Name",
	   T1."Service Advisor No_" as "Service Advisor No",
	   CASE WHEN (T2."Type" = 2) THEN (0) ELSE (((convert(float, T2."Total Price")))) END as "Lines Net Value",
	   CASE WHEN (((datediff(day, T1."Posting Date", (getdate()))) <= 7) and ((T7."First Name" + ' ' + T7."Last Name") IS NOT NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (T7."First Name" + ' ' + T7."Last Name") + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), datediff(day, ' + T4."Name") WHEN (((day((getdate(, T1."Posting Date"))) + ')) - T1."Posting Date")) <= 7) and ((T7."First Name" + ' ' + T7."Last Name") IS NULL)) THEN (T1."No_" + ' - ' + T1."Service Posting Group" + ' - ' + (convert(varchar(50), year(T1."Posting Date")) + '-' + convert(varchar(50), month(T1."Posting Date")) + '-' + convert(varchar(50), day(T1."Posting Date"))) + ' - ' + T4."Name") ELSE null END as "Order Number_Rg_Ausg_ori",
	   CASE WHEN (((CASE WHEN (T2."Type" = 4) THEN ((convert(float, T2."Qty_ (Hour)"))) ELSE (0) END) * ((convert(float, T2."Qty_ per Hour")))) < 0) THEN ((convert(float, T2."Standard Time" * -1))) ELSE ((convert(float, T2."Standard Time"))) END as "Standard Zeit_ori",
	   (convert(float, T2."Quantity (Base)")) as "Menge (Base)_ori",
	   T1."Service Posting Group" as "Service Posting Group",
	   T1."Posting Date" as "Posting Date_2",
	   T1."Order Date" as "Order Date",
	   T6."Function Code" as "Function Code",
	   T6."Name" as "Name_Employee",
	   ((convert(float, T2."Total Price"))) as "Verkaufsbetrag",
	   CASE WHEN (T4."No_" LIKE 'INT%') THEN ('Intern') ELSE (T5."Description") END as "Kundenart",
	   T5."Description" as "Cust_Gr_Description",
	   T5."Code" as "Cust_Gr_Code",
	   T4."No_" + ' - ' + T4."Name" as "Kunde",
	   T4."Name" as "Cust_Name",
	   T4."No_" as "Cust_No",
	   T2."Charging Group No_" as "Charging Group No",
	   T2."Market Segment Code" as "Market Segment Code",
	   T2."Vehicle Type" as "Vehicle Type",
	   T1."VIN" + ' - ' + T1."Model" as "Fahrzeug",
	   T1."Model" as "Model_ori",
	   CASE WHEN (T1."Make Code" IN ('BMW','BMW-MINI')) THEN (T1."Make Code") ELSE ('Fremdfabrikat') END as "Fabrikat",
	   T2."Customer Group Code" as "Customer Group Code",
	   T1."Make Code" as "Make Code",
	   CASE WHEN ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1)) THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END as "Umsatzart",
	   T2."Source No_ (Payment)" as "Source No (payment)",
	   T2."Source No_" as "Source No",
	   T2."Source Type" as "Source Type",
	   T2."Gen_ Prod_ Posting Group" as "Gen Prod Posting Group",
	   T2."Gen_ Bus_ Posting Group" as "Gen Bus Posting Group",
	   CASE WHEN (((T1."No_" IN ('WAU12105302','WAU12107303','WAU12105478','WAU12302117')) and (T2."No_" = '83220144137'))) THEN (((convert(float, ((convert(float, T2."Quantity")))))) * 12.41) ELSE ((convert(float, T2."Total Cost"))) END as "Einstandsbetrag",
	   T3."Name" as "Name_Salesperson",
	   T3."Code" as "Code_Salesperson",
	   (left(T2."Department Code",2)) as "Standort_Department",
	   T2."Sales Branch Code" as "Sales Branch Code",
	   T2."Order Completed" as "Order Completed",
	   T2."Order Line No_" as "Order Line No",
	   T2."Standard Time Type" as "Standard Time Type",
	   T2."Standard Time" as "Standard Time",
	   T2."Document Type" as "Document Type",
	   T2."Qty_ (Hour)" as "Qty (hour)",
	   T2."Qty_ per Hour" as "Qty Per Hour",
	   T2."Sales Department Code" as "Sales Department Code",
	   T2."Service Job No_" as "Service Job No",
	   T2."Time Type" as "Time Type",
	   T2."Quantity (Base)" as "Quantity (base)",
	   T2."Positive" as "Positive",
	   T2."Entry Type" as "Entry Type",
	   T2."Amt_ Posted to G_L" as "Amt Posted To G L",
	   T2."Amt_ to Post to G_L" as "Amt To Post To G L",
	   T2."User ID" as "User Id",
	   T2."Work Type Code" as "Work Type Code",
	   T2."Department Code" as "Department Code",
	   T2."Location Code" as "Location Code",
	   T2."Total Price" as "Total Price",
	   T2."Unit Price" as "Unit Price",
	   T2."Total Cost" as "Total Cost",
	   T2."Unit Cost" as "Unit Cost",
	   T2."Direct Unit Cost" as "Direct Unit Cost",
	   (convert(float, T2."Quantity")) as "Quantity",
	   T2."Description" as "Description",
	   T2."Type" as "Type",
	   T2."Document No_" as "Document No",
	   T2."Posting Date" as "Posting Date",
	   T2."Order No_" as "Order No",
	   T2."Entry No_" as "Entry No",
	   T1."Vehicle Status" as "Vehicle Status",
	   T1."Sales Branch Code" as "Sales Branch Code_2",
	   T1."Work Completed" as "Work Completed",
	   T1."Branch Code" as "Branch Code",
	   T1."Internal Order" as "Internal Order",
	   T1."Post with Book No_" as "Post With Book No",
	   T1."Ext Serv Int Charging Pr Grp" as "Ext Serv Int Charging Pr Grp",
	   T1."Int_ Charg_ Labor Price Group" as "Int Charg Labor Price Group",
	   T1."Item Sales Pr_ Grp_ Int_ Chrg_" as "Item Sales Pr Grp Int Chrg",
	   T1."Sales Department Code" as "Sales Department Code_2",
	   T1."Branch Book No_" as "Branch Book No",
	   T1."Book No_" as "Book No",
	   T1."Power (hp)" as "Power (hp)",
	   T1."Power (kW)" as "Power (kw)",
	   T1."Cylinder Capacity (ccm)" as "Cylinder Capacity (ccm)",
	   T1."No_ of Cylinders" as "No Of Cylinders",
	   T1."Initial Registration" as "Initial Registration",
	   T1."Prod_ Year" as "Prod Year",
	   T1."Model No_" as "Model No",
	   T1."Model Code" as "Model Code",
	   T1."Mileage" as "Mileage",
	   T1."License No_" as "License No",
	   T1."VIN" as "Vin",
	   T1."Reason for Archiving" as "Reason For Archiving",
	   T1."Archived by User" as "Archived By User",
	   T1."Date Archived" as "Date Archived",
	   T1."Shipping No_ Series" as "Shipping No Series",
	   T1."Posting No_ Series" as "Posting No Series",
	   T1."No_ Series" as "No Series",
	   T1."Document Date" as "Document Date",
	   T1."Sell-to Customer Name 2" as "Sell-to Customer Name 2",
	   T1."Sell-to Customer Name" as "Sell-to Customer Name",
	   T1."Order Class" as "Order Class",
	   T1."Salesperson Code" as "Salesperson Code",
	   T1."Customer Posting Group" as "Customer Posting Group",
	   T1."Department Code" as "Department Code_2",
	   T1."Location Code" as "Location Code_2",
	   T1."Posting Description" as "Posting Description",
	   T1."Bill-to Name 2" as "Bill-to Name 2",
	   T1."Bill-to Name" as "Bill-to Name",
	   T1."Bill-to Customer No_" as "Bill-to Customer No",
	   T1."Sell-to Customer No_" as "Sell-to Customer No",
	   T1."No_" as "No",
	   T1."Document Type" as "Document Type_2"
from ((((((("NAVISION"."import"."Archived_Service_Header" T1 left outer join "NAVISION"."import"."Salesperson_Purchaser" T3 on (T1."Salesperson Code" = T3."Code") and (T1."Client_DB" = T3."Client_DB")) left outer join "NAVISION"."import"."Customer" T4 on (T1."Sell-to Customer No_" = T4."No_") and (T1."Client_DB" = T4."Client_DB")) left outer join "NAVISION"."import"."Customer_Group" T5 on (T4."Customer Group Code" = T5."Code") and (T4."Client_DB" = T5."Client_DB")) left outer join "NAVISION"."import"."Employee" T7 on (T1."Service Advisor No_" = T7."No_") and (T1."Client_DB" = T7."Client_DB")) left outer join "ims"."Monteure_fuer_Anzeige" T8 on T1."No_" = T8."Order No_") left outer join "ims"."Service_Archiv_Rg_Ausgang_7+" T9 on T1."No_" = T9."Order No_") left outer join "ims"."Service_Archiv_Rg_Ausgang_GWL" T10 on T1."No_" = T10."Order No_"),
	(("NAVISION"."import"."Service_Ledger_Entry" T2 left outer join "NAVISION"."import"."Employee" T6 on (T6."No_" = T2."No_") and (T6."Client_DB" = T2."Client_DB")) left outer join "NAVISION"."import"."Item" T11 on (T11."No_" = T2."No_") and (T11."Client_DB" = T2."Client_DB"))
where ((T1."No_" = T2."Order No_") and (T1."Client_DB" = T2."Client_DB"))
and (((((((T1."Document Type" <> 0) and (T1."Posting Date" >= convert(datetime, '2021-01-01 00:00:00.000'))) and (T2."Entry Type" = 0)) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') WHEN (T1."Location Code" = 'GZ') THEN ('55') ELSE null END) <> '20')) and ((T1."Bill-to Customer No_" LIKE 'INT%') or (T1."Internal Order" = 1))) and (((((((CASE WHEN ((T2."Gen_ Prod_ Posting Group" = '678_ART') and (T11."Inventory Posting Group" = 'T_SONST')) THEN ('GBWR') WHEN (T11."Inventory Posting Group" = 'R_FR_PKW') THEN ('Reifen fremd') ELSE (T11."Parts Family") END) LIKE '3690%') or ((CASE WHEN ((T2."Gen_ Prod_ Posting Group" = '678_ART') and (T11."Inventory Posting Group" = 'T_SONST')) THEN ('GBWR') WHEN (T11."Inventory Posting Group" = 'R_FR_PKW') THEN ('Reifen fremd') ELSE (T11."Parts Family") END) LIKE '8545%')) or ((CASE WHEN ((T2."Gen_ Prod_ Posting Group" = '678_ART') and (T11."Inventory Posting Group" = 'T_SONST')) THEN ('GBWR') WHEN (T11."Inventory Posting Group" = 'R_FR_PKW') THEN ('Reifen fremd') ELSE (T11."Parts Family") END) LIKE '8550%')) or ((CASE WHEN ((T2."Gen_ Prod_ Posting Group" = '678_ART') and (T11."Inventory Posting Group" = 'T_SONST')) THEN ('GBWR') WHEN (T11."Inventory Posting Group" = 'R_FR_PKW') THEN ('Reifen fremd') ELSE (T11."Parts Family") END) LIKE '8555%')) or ((T2."Gen_ Prod_ Posting Group" = '678_ART') and (T11."Inventory Posting Group" = 'T_SONST'))) or ((T11."Inventory Posting Group" = 'R_FR_PKW') and (not T11."No_" IN ('00004'))))) and ((CASE WHEN (T4."No_" IN ('022350','036287','205744')) THEN ('raus') ELSE ('rein') END) = 'rein'))
) D1
-- order by "Service Advisor No" asc,"No" asc,"Order Line No" asc