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

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