topic Re: I am getting run time error showing to correct select statement while joining two tables with vebln.Please let me know the solution. in Application Development and Automation Discussions

I am getting run time error showing to correct select statement while joining two tables with vebln.Please let me know the solution.

rajeshpulime — Mon, 15 Dec 2014 08:17:14 GMT

*&---------------------------------------------------------------------*

*& Report ZIT_3TABLESR

*&---------------------------------------------------------------------*

REPORT zit_3tablesr.

DATA : vbeln TYPE vbeln_va,

audat TYPE audat,

kunnr TYPE kunag,

matnr TYPE matnr,

netwr TYPE netwr.

TYPES : BEGIN OF st_table,

vbeln TYPE vbeln_va,

audat TYPE audat,

kunnr TYPE kunag,

matnr TYPE matnr,

netwr TYPE netwr,

END OF st_table.

DATA : w_area TYPE st_table.

TYPES : tt_vbak TYPE TABLE OF st_table,

tt_vbap TYPE TABLE OF st_table.

DATA : tm_vbak TYPE tt_vbak,

tm_vbap TYPE tt_vbap.

PARAMETERS : my_vbeln TYPE vbeln.

START-OF-SELECTION.

SELECT vbeln audat kunnr FROM vbak INTO TABLE tm_vbak WHERE vbeln = my_vbeln.

SELECT vbeln matnr netwr FROM vbap INTO TABLE tm_vbap for all entries in tm_vbak WHERE vbap~vbeln = tm_vbak-vbeln.

END-OF-SELECTION.

WHILE ( sy-subrc = 0 ).

READ TABLE tm_vbak INTO w_area INDEX sy-index.

READ TABLE tm_vbap INTO w_area INDEX sy-index.

WRITE : / w_area-vbeln,

w_area-audat,

w_area-kunnr,

w_area-matnr,

w_area-netwr.

ENDWHILE.

Re: I am getting run time error showing to correct select statement while joining two tables with vebln.Please let me know the solution.

Former Member — Mon, 15 Dec 2014 08:21:07 GMT

Hi,

your fields are not matching the structures of the tables. Please try

INTO CORRESPONDING FIELDS OF TABLE

instead OF INTO TABLE.

Regards,

Klaus

Re: I am getting run time error showing to correct select statement while joining two tables with vebln.Please let me know the solution.

Former Member — Mon, 15 Dec 2014 08:21:34 GMT

This message was moderated.

Re: I am getting run time error showing to correct select statement while joining two tables with vebln.Please let me know the solution.

kabil_g — Mon, 15 Dec 2014 08:25:34 GMT

Hi Rajesh,

you can do inner join as these example method....

SELECT-OPTIONS: s_vbeln FOR vbap-vbeln no intervals

DATA:BEGIN OF x_vbakvbap,

vbeln TYPE vbak-vbeln,

kunnr TYPE vbak-kunnr,

netwr TYPE vbak-netwr,

posnr TYPE vbap-posnr,

matnr TYPE vbap-matnr,

kwmeng TYPE vbap-kwmeng,

arktx TYPE vbap-arktx,

netpr TYPE vbap-netpr,

END OF x_vbakvbap,

it_vbakvbap LIKE TABLE OF x_vbakvbap.

SELECT vbak~vbeln vbak~kunnr vbak~netwr

vbap~posnr vbap~matnr vbap~kwmeng

vbap~arktx vbap~netpr

INTO TABLE it_vbakvbap

FROM vbak

INNER JOIN vbap

ON vbak~vbeln = vbap~vbeln

WHERE vbak~vbeln IN s_vbeln

AND vbap~matnr IN s_matnr.

LOOP AT it_vbakvbap INTO x_vbakvbap.

WRITE:/ x_vbakvbap-vbeln, x_vbakvbap-posnr,

x_vbakvbap-matnr, x_vbakvbap-kwmeng,

x_vbakvbap-arktx, x_vbakvbap-kunnr,

x_vbakvbap-netpr, x_vbakvbap-netwr.

ENDLOOP.

Regards,

Kabil

Re: I am getting run time error showing to correct select statement while joining two tables with vebln.Please let me know the solution.

archanapawar — Mon, 15 Dec 2014 08:25:59 GMT

Hi Rajesh,

You are writing second select query incorrectly.

SELECT vbeln matnr netwr FROM vbap INTO TABLE tm_vbap for all entries in tm_vbak WHEREvbap~vbeln = tm_vbak-vbeln.

change this query to

SELECT vbeln matnr netwr FROM vbap INTO TABLE tm_vbap for all entries in tm_vbak WHERE vbeln = tm_vbak-vbeln.

Also, you need to define types for tm_vbap with required fields.

Re: I am getting run time error showing to correct select statement while joining two tables with vebln.Please let me know the solution.

Lakshmipathi — Mon, 15 Dec 2014 08:41:22 GMT

What is the Business requirement and what exactly you were trying to do ? You should be aware many reports can be fetched via Logical Database or Table join in SQVI and I am not sure whether you have explored this option.

G. Lakshmipathi

Re: I am getting run time error showing to correct select statement while joining two tables with vebln.Please let me know the solution.

Former Member — Mon, 15 Dec 2014 08:49:39 GMT

Hi Rajesh,

Try below code. It will work.

SELECT vbeln
                audat
               kunnr
     FROM vbak
     INTO TABLE tm_vbak
     WHERE vbeln = my_vbeln.

IF tm_vbak[] IS NOT INITIAL.
     SELECT vbeln
                     matnr
                    netwr
       FROM vbap
       INTO TABLE tm_vbap
       FOR ALL ENTRIES IN tm_vbak
       WHERE vbeln = tm_vbak-vbeln.
ENDIF.

Regards,

Pravin

Re: I am getting run time error showing to correct select statement while joining two tables with vebln.Please let me know the solution.

rajeshpulime — Mon, 15 Dec 2014 09:19:01 GMT

Thanks for all

Re: I am getting run time error showing to correct select statement while joining two tables with vebln.Please let me know the solution.

rajeshpulime — Mon, 15 Dec 2014 09:23:48 GMT

yeah i got executed but its showing the document created (audat) all columns as 00.00.0000 what i have you do

I am new to abap prgraminng.

thanks in advance

Re: I am getting run time error showing to correct select statement while joining two tables with vebln.Please let me know the solution.

kabil_g — Mon, 15 Dec 2014 12:17:59 GMT

Hi Rajesh,

Try these below code do innerjoin as i did below

TABLES:vbap.

DATA:BEGIN OF x_vbakvbap,

vbeln TYPE vbak-vbeln,

audat TYPE vbak-audat,

kunnr TYPE vbak-kunnr,

matnr TYPE vbap-matnr,

netwr TYPE vbak-netwr,

END OF x_vbakvbap,

it_vbakvbap LIKE TABLE OF x_vbakvbap.

SELECT-OPTIONS: s_vbeln FOR vbap-vbeln no intervals.

SELECT vbak~vbeln vbak~audat vbak~kunnr vbap~matnr vbak~netwr

INTO TABLE it_vbakvbap

FROM vbak

INNER JOIN vbap

ON vbak~vbeln = vbap~vbeln

WHERE vbak~vbeln IN s_vbeln.

LOOP AT it_vbakvbap INTO x_vbakvbap.

WRITE:/ x_vbakvbap-vbeln,

x_vbakvbap-audat,

x_vbakvbap-matnr,

x_vbakvbap-kunnr,

x_vbakvbap-netwr.

ENDLOOP.