topic Re: INNERJOINS in Application Development and Automation Discussions

INNERJOINS

Former Member — Wed, 04 Apr 2007 18:36:00 GMT

Hi all ,

i need to retrieve INFNR(purchasing info record number) using tables EINA and EINE using EINA-MATNR, EINE-EKORG, AND EINA-LIFNR.

Re: INNERJOINS

RaymondGiuseppi — Wed, 04 Apr 2007 18:40:59 GMT

Try this code (and adapt)

SELECT F1~LIFNR  F1~MATNR  F2~MATKL  F1~INFNR  F3~EKORG
    INTO CORRESPONDING FIELDS OF JOIN
    FROM EINA AS F1  JOIN MARA AS F2
           ON F1~MATNR = F2~MATNR
           JOIN EINE AS F3
           ON F1~INFNR = F3~INFNR
    WHERE F1~LIFNR = O_LIFNR AND
          F2~MATKL = O_MATKL AND
          F3~EKORG = O_EKORG

Look at <a href="http://jplamontre.free.fr/SAP/TrucAstuceSAP.htm">Trucs et Astuces ABAP et SapScripts</a>

Regards

Re: INNERJOINS

Former Member — Wed, 04 Apr 2007 18:52:18 GMT

Hi,

No need inner join.

You can read directly from database view V_EINA.


REPORT ZTEST.
               
TABLES: V_EINA.
               
DATA: BEGIN OF ITAB OCCURS 0,
        INFNR LIKE EINA-INFNR.
DATA: END OF ITAB.
               
SELECT-OPTIONS: S_MATNR FOR V_EINA-MATNR,
                S_EKORG FOR V_EINA-EKORG,
                S_LIFNR FOR V_EINA-LIFNR.
               
SELECT INFNR
INTO TABLE ITAB
FROM V_EINA
WHERE MATNR IN S_MATNR
  AND EKORG IN S_EKORG
  AND LIFNR IN S_LIFNR.
             
LOOP AT ITAB.
  WRITE: / ITAB-INFNR.
ENDLOOP.

Regards,

Ferry Lianto

Re: INNERJOINS

Former Member — Thu, 27 Mar 2008 12:42:47 GMT

how can we know the database view for respective tables.

For the question below :

i need to retrieve INFNR(purchasing info record number) using tables EINA and EINE using EINA-MATNR, EINE-EKORG, AND EINA-LIFNR.

you valuabel advise is perectly right:

No need inner join.

You can read directly from database view V_EINA.

can i please know the related database view for other tabels also.

Thanks In advance

Re: INNERJOINS

Former Member — Thu, 27 Mar 2008 12:46:11 GMT

how can we know the database view for respective tables.

For the question below :

i need to retrieve INFNR(purchasing info record number) using tables EINA and EINE using EINA-MATNR, EINE-EKORG, AND EINA-LIFNR.

you valuabel advise is perectly right:

No need inner join.

You can read directly from database view V_EINA.

can i please know the related database view for other tabels also.

Thanks In advance