C11/System/WERWISO/IQD/Serv_Teile/Lagerbestand.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,werwiso
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\serv_teile\Lagerbestand.imr
TITLE,Lagerbestand.imr
BEGIN SQL
select T1."LagerNummer" as c1,
	   T1."ArtikelNummer" as c2,
	   T1."Bestand" as c3,
	   T1."LetzterAbgang" as c4,
	   T1."LetzterZugang" as c5,
	   T1."MindestBestand" as c6,
	   T1."MeldeBestand" as c7,
	   T1."HoechstBestand" as c8,
	   T1."Lagerort1" as c9,
	   T1."Lagerort2" as c10,
	   T1."Lagerort3" as c11,
	   T1."Kommissionsware" as c12,
	   T1."Agenturware" as c13,
	   T1."Lagerbestandsfuehrung" as c14,
	   T1."Dispofaehig" as c15,
	   T1."SaisonteilVon" as c16,
	   T1."SaisonteilBis" as c17,
	   T1."Ausloesefaktor" as c18,
	   T1."RenpartsMinBestand" as c19,
	   T1."RimCode" as c20,
	   T1."TBKennzeichen" as c21,
	   T1."PSABeschaffungscode" as c22,
	   T1."FordSprintBeschaffung" as c23,
	   T2."Bezeichnung1" as c24,
	   T2."Einheit" as c25,
	   T2."Erloeskonto" as c26,
	   T2."Warengruppe" as c27,
	   T2."Einkaufspreis" as c28,
	   T2."DurchnittsEinkaufspreis" as c29,
	   T2."DurchschnittsEKPreis" as c30,
	   T2."Listenverkaufspreis" as c31,
	   T2."Mindestbestand" as c32,
	   T2."Hoechstbestand" as c33,
	   T2."Meldebestand" as c34,
	   T2."Lagerbestand" as c35,
	   T2."Letzterzugang" as c36,
	   T2."Letzterabgang" as c37,
	   T1."Bestand" * T2."Einkaufspreis" as c38,
	   T3."Lager_Nr" as c39,
	   T3."Filial_Id" as c40,
	   T3."Bezeichnung" as c41,
	   (@CURRENT_DATE) as c42,
	   '1' as c43,
	   T3."Filial_Id" as c44,
	   T2."Lieferantennummer" as c45,
	   T2."Hersteller" as c46,
	   T2."Gaengigkeitsschluessel" as c47,
	   T2."Gaengigkeitsrang" as c48,
	   T1."Bestand" as c49,
	   (rtrim(T1."ArtikelNummer")) || ' - ' || T2."Bezeichnung1" as c50
from (("\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."LagerBestand" T1 left outer join "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."ARTIKEL" T2 on T1."ArtikelNummer" = T2."Artikelnummer") left outer join "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."Lager" T3 on T1."LagerNummer" = T3."Lager_Nr")
where (T1."Bestand" > 0)

END SQL
COLUMN,0,Lagernummer
COLUMN,1,Artikelnummer
COLUMN,2,Bestand
COLUMN,3,Letzterabgang
COLUMN,4,Letzterzugang
COLUMN,5,Mindestbestand
COLUMN,6,Meldebestand
COLUMN,7,Hoechstbestand
COLUMN,8,Lagerort1
COLUMN,9,Lagerort2
COLUMN,10,Lagerort3
COLUMN,11,Kommissionsware
COLUMN,12,Agenturware
COLUMN,13,Lagerbestandsfuehrung
COLUMN,14,Dispofaehig
COLUMN,15,Saisonteilvon
COLUMN,16,Saisonteilbis
COLUMN,17,Ausloesefaktor
COLUMN,18,Renpartsminbestand
COLUMN,19,Rimcode
COLUMN,20,Tbkennzeichen
COLUMN,21,Psabeschaffungscode
COLUMN,22,Fordsprintbeschaffung
COLUMN,23,Bezeichnung1_Artikel
COLUMN,24,Einheit
COLUMN,25,Erloeskonto
COLUMN,26,Warengruppe
COLUMN,27,Einkaufspreis
COLUMN,28,Durchnittseinkaufspreis
COLUMN,29,Durchschnittsekpreis
COLUMN,30,Listenverkaufspreis
COLUMN,31,Mindestbestand
COLUMN,32,Hoechstbestand
COLUMN,33,Meldebestand
COLUMN,34,Lagerbestand
COLUMN,35,Letzterzugang
COLUMN,36,Letzterabgang
COLUMN,37,Lagerwert
COLUMN,38,Lager Nr
COLUMN,39,Filial Id
COLUMN,40,Bezeichnung
COLUMN,41,Datum
COLUMN,42,Hauptbetrieb_ID
COLUMN,43,Standort_ID
COLUMN,44,Lieferantennummer
COLUMN,45,Hersteller
COLUMN,46,Gaengigkeitsschluessel
COLUMN,47,Gaengigkeitsrang
COLUMN,48,Menge Bestand
COLUMN,49,Artikel