topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Fri, 08 May 2009 09:09:17 GMT

Hi,

i need to fetch data using select statement.

SELECT VBELN INTO CORRESPONDING FIELDS OF TABLE IT_LIPS FROM LIPS FOR ALL ENTRIES IN IT_VBRK_VBRP

WHERE VBELN = IT_VBRK_VBRP-VGBEL AND MATNR = IT_VBRK_VBRP-MATNR

AND WERKS = IT_VBRK_VBRP-WERKS AND PSTYV = 'NLN'.

SELECT BELNR BUDAT XBLNR MATNR BWART INTO CORRESPONDING FIELDS OF TABLE IT_EKBE FROM EKBE

FOR ALL ENTRIES IN IT_LIPS WHERE MATNR = IT_LIPS-MATNR

AND XBLNR = IT_LIPS-VBELN AND BWART = '101'.

wat's the issue is XBLNR and VBELN contains the same data but the data element length is different

XBLNR is character with length 10 and

VBELN is character with length 16 .

so its giving a error..

please help me with this..

Regards,

Dippy

Re: select statement

Former Member — Fri, 08 May 2009 09:11:30 GMT

SELECT BELNR BUDAT XBLNR MATNR BWART INTO CORRESPONDING FIELDS OF TABLE IT_EKBE FROM EKBE
FOR ALL ENTRIES IN IT_LIPS WHERE MATNR = IT_LIPS-MATNR
AND XBLNR = IT_LIPS-VBELN+0(10) AND BWART = '101'.

Re: select statement

Former Member — Fri, 08 May 2009 09:13:25 GMT

hi:

you have to use offset in where condition like

XBLNR = IT_LIPS-VBELN+0(10)

Regards

Shashi

Re: select statement

Former Member — Fri, 08 May 2009 09:14:48 GMT

HI,

take on field XBELNR_VBELN of type EKBE-XBLNR at the end of the table IT_LIPS.

then do below

loop at IT_LIPS into WA_LIPS.
WA_LIPS-XBELNR_VBELN = WA_LIPS-VBELN.
MODIFY IT_LIPS FROM WA_LIPS index sy-tabix tranporting XBELNR_VBELN.
enloop.

SELECT BELNR BUDAT XBLNR MATNR BWART INTO CORRESPONDING FIELDS OF TABLE IT_EKBE FROM EKBE
FOR ALL ENTRIES IN IT_LIPS WHERE MATNR = IT_LIPS-MATNR
AND XBLNR = IT_LIPS-XBELNR_VBELN  AND BWART = '101'.

It works.

Thanks!!

Edited by: Prasanth Maddela on May 8, 2009 2:54 PM

Re: select statement

Former Member — Fri, 08 May 2009 09:21:35 GMT

in declaration of IT_LIPS

change VBELN type as following

VBELN TYPE EKBE-XBLNR.

Re: select statement

Former Member — Fri, 08 May 2009 09:28:34 GMT

You can use FM to convert VBELN into XBLNR format before second select statement

FM : 'CONVERSION_EXIT_ALPHA_INPUT'

Hope this Help ful

Re: select statement

Former Member — Fri, 08 May 2009 09:41:55 GMT

Hi Shashi,

Iam getting error by using offset n 1 more thing

XBLNR length is 16 and vbeln length is 10.

but i interchanged then also its giving error.

Regards,

Dippy

Re: select statement

Former Member — Fri, 08 May 2009 10:07:09 GMT

HI,

Try this way..

Declare the VBELN with refrence to XBLNR in IT_LIPS


BEGIN OF IT_LIPS OCCURS 0.
 VBELN TYPE EKBE-XBLNR.           " Check this declaration
.....
END OF IT_LIPS.

SELECT VBELN INTO CORRESPONDING FIELDS OF TABLE IT_LIPS FROM LIPS FOR ALL ENTRIES IN IT_VBRK_VBRP
WHERE VBELN = IT_VBRK_VBRP-VGBEL AND MATNR = IT_VBRK_VBRP-MATNR
AND WERKS = IT_VBRK_VBRP-WERKS AND PSTYV = 'NLN'.


SELECT BELNR BUDAT XBLNR MATNR BWART INTO CORRESPONDING FIELDS OF TABLE IT_EKBE FROM EKBE
FOR ALL ENTRIES IN IT_LIPS WHERE MATNR = IT_LIPS-MATNR
AND XBLNR = IT_LIPS-VBELN AND BWART = '101'.

Re: select statement

Former Member — Fri, 08 May 2009 10:09:50 GMT

check my reply which i have given it works 100%.

Re: select statement

Former Member — Fri, 08 May 2009 10:37:19 GMT

Thanks guys...