topic Re: Use two conditons for Same table in Application Development and Automation Discussions

Use two conditons for Same table

Former Member — Thu, 18 Feb 2010 13:00:42 GMT

I need to do the following :-

Pass machine serial no and inv date in table BSIS_{ZUONR and BSIS}BUDAT

to get BSIS_{DMBTR (Sum up the values of BSIS}DMBTR)

i am stuck up after this :-

SELECT BUKRS

HKONT

ZUONR

BUDAT

GSBER

DMBTR

FROM BSIS INTO TABLE IT_BSIS

FOR ALL ENTRIES IN IT_OBJK

WHERE ZUONR EQ IT_OBJK-SERNR.

i need to get value of DMBTR for this condn also BUDAT = VBRK-FKDAT along wid above where condn ZUONR EQ IT_OBJK-SERNR.

Pls assist.

Re: Use two conditons for Same table

Former Member — Thu, 18 Feb 2010 13:24:27 GMT

Use a join on both the tables!!

Re: Use two conditons for Same table

Former Member — Thu, 18 Feb 2010 13:33:47 GMT

Try this

select VBRK table data

loop at it_bsis ,read vbrk and remove the budat <> vbrk-fkdat

i think with in single for all entries not possible(may be try to use outer join and loop it)

Re: Use two conditons for Same table

Former Member — Thu, 18 Feb 2010 23:06:15 GMT


> I need to do the following :-
> 
> Pass machine serial no and inv date in table BSIS_{ZUONR and BSIS}BUDAT
>  to get BSIS_{DMBTR (Sum up the values of BSIS}DMBTR)
> 
> i am stuck up after this :-
> SELECT BUKRS
>            HKONT
>            ZUONR
>            BUDAT
>            GSBER
>            DMBTR
>            FROM BSIS INTO TABLE IT_BSIS
>            FOR ALL ENTRIES IN IT_OBJK
>            WHERE ZUONR EQ IT_OBJK-SERNR.
> 
> i need to get value of DMBTR for this condn also BUDAT = VBRK-FKDAT along wid above where condn ZUONR EQ IT_OBJK-SERNR.
> 
> Pls assist.

Try something like this:

SELECT BSIS~BUKRS
            BSIS~HKONT
            BSIS~ZUONR
            BSIS~BUDAT
            BSIS~GSBER
            BSIS~DMBTR
   FROM BSIS 
   JOIN VBRK ON BSIS~BUDAT = VBRK~FKDAT
   INTO TABLE IT_BSIS
   FOR ALL ENTRIES IN IT_OBJK
   WHERE ZUONR EQ IT_OBJK-SERNR.