[55327] in SAPr3-news

home	help	back	first	fref	pref	prev	next	nref	lref	last	post

Re: Selektion mit Periodenangaben

daemon@ATHENA.MIT.EDU (markus.horn@swissonline.ch)
Tue Aug 30 06:44:25 2005

To: sapr3-news@mit.edu
Date: 30 Aug 2005 03:44:12 -0700
From: markus.horn@swissonline.ch
Message-ID: <1125398652.458660.308240@g43g2000cwa.googlegroups.com>

Hallo Rapha=EBla

Im Moment sieht mein select folgendermassen aus:

  SELECT:
  mbewh~matnr
  mbewh~lfmon mbewh~lfgja
  mbewh~verpr mbewh~stprs
  mara~mtart   "Materialart
  makt~maktx   "Materialtext

  FROM mbewh
       INNER JOIN mara ON mbewh~matnr =3D mara~matnr
       INNER JOIN makt ON mbewh~matnr =3D makt~matnr
       AND                makt~spras  =3D sy-langu

INTO CORRESPONDING FIELDS OF wa1_matpreis

  WHERE mara~mtart  IN mtart
   AND  mbewh~matnr IN matnr
   AND  mbewh~bwkey IN bwkey
   AND  mbewh~lfmon IN lfmon
   AND  mbewh~lfgja IN lfgja.


Gru=DF
Markus

home	help	back	first	fref	pref	prev	next	nref	lref	last	post