Select Query Needed

[Former Member]

Hi Friends,

Can anyone give me a select query to get the child nodes for a given parent-id vice-versa.

Thanks & Regards

Satish

[Former Member]

Hi,

Try using Joins in select query

DATA: CARRID LIKE SFLIGHT-CARRID,

CONNID LIKE SFLIGHT-CONNID,

DATE LIKE SFLIGHT-FLDATE,

NAME LIKE SCARR-CARRNAME.

SELECT F_{CARRID F}CONNID F_{FLDATE C}CARRNAME

INTO (CARRID, CONNID, DATE, NAME)

FROM ( SFLIGHT AS F INNER JOIN SPFLI AS P

ON F_{CARRID = P}CARRID AND

F_{CONNID = P}CONNID )

INNER JOIN SCARR AS C

ON F_{CARRID = C}CARRID

WHERE P~CITYFROM = 'FRANKFURT'

AND P~CITYTO = 'NEW YORK'

AND F~FLDATE BETWEEN '19970910' AND '19970920'

AND F_{SEATSOCC < F}SEATSMAX.

WRITE: / NAME, DATE, CARRID, CONNID.

ENDSELECT.

Thanks & Regards,

Judith.

[Former Member]

Hi Satish,

It would be great if you could be more specific.

1. What tables are you dealing with

2. What data do you have to test for a condition (for the WHERE clause)

3. What data do you want to retrieve

Regards,

Anand Mandalika.

[jayanthi_jayaraman]

Hi,

You can use FOR ALL ENTRIES .

TYPES : BEGIN OF TY_EDIDC ,

DOCNUM TYPE EDIDC-DOCNUM , "IDoc number

END OF TY_EDIDC.

• Type Holding EDID4

TYPES : BEGIN OF TY_EDID4 ,

DOCNUM TYPE EDID4-DOCNUM , "IDoc number

SEGNAM TYPE EDID4-SEGNAM , "Name of SAP segment

SDATA TYPE EDID4-DATA , "Application data

END OF TY_EDID4.

DATA : I_EDIDC TYPE STANDARD TABLE OF TY_EDIDC ,

I_EDID4 TYPE STANDARD TABLE OF TY_EDID4 .

SELECT DOCNUM FROM EDIDC

INTO TABLE I_EDIDC.

IF SY-SUBRC = 0.

SORT I_EDIDC BY DOCNUM ASCENDING.

DELETE ADJACENT DUPLICATES FROM I_EDIDC COMPARING ALL FIELDS.

*Selecting from EDID4

SELECT DOCNUM SEGNAM SDATA

INTO TABLE I_EDID4

FROM EDID4

FOR ALL ENTRIES IN I_EDIDC

WHERE DOCNUM = I_EDIDC-DOCNUM.

Endif.

Regards,

J.Jayanthi

[Former Member]

This message was moderated.