CREATE PROCEDURE gp_Materialbuchungen AS
 
---Löscht die Tabelle DISOBuchungen
delete from tbDISOBuchungen
 
insert into tbDISOBuchungen
select * from 
openquery(DISO_IBM,'
SELECT * 
FROM LDATA.DMPMB00 
WHERE XFINR=''900'' 
AND MMBJH = 20
AND MMBJJ >= 5
AND MMBMM >= 5 
AND MMBTT >= 1  
AND (MMBAT = ''AB''
OR MMBAT = ''AS''
OR MMBAT = ''ID''
OR MMBAT = ''LF''
OR MMBAT = ''LS''
OR MMBAT = ''ZU''
OR MMBAT = ''ZS'')
')
GO

AND MMBJH = '' + @JH + ''