topic Re: regarding this select statement in Application Development and Automation Discussions

regarding this select statement

Former Member — Fri, 01 Aug 2008 15:32:17 GMT

hi,

i am not getting value i write like this select statement

plz check error in this code.

TABLES: VBAK,

vbrk.

TYPES: BEGIN OF TYP_VBAK,

VBELN TYPE VBELN_VA,

VBTYP TYPE VBTYP,

VGBEL TYPE VGBEL,

END OF TYP_VBAK,

BEGIN OF TYP_VBRK,

VBELN TYPE VBELN,

WAERK TYPE WAERK,

VKORG TYPE VKORG,

KNUMV TYPE KNUMV ,

FKDAT TYPE FKDAT,

LAND1 TYPE LLAND,

NETWR TYPE NETWR,

KUNRG TYPE KUNRG,

EXNUM TYPE EXNUM,

MWSBK TYPE MWSBP,

END OF TYP_VBRK.

DATA: GT_VBAK TYPE TABLE OF TYP_VBAK,

IT_VBRK TYPE standard TABLE OF TYP_VBRK WITH HEADER LINE.

LS_VBRK TYPE TYP_VBRK,

SELECT VBELN

WAERK

VKORG

KNUMV

FKDAT

LAND1

NETWR

KUNRG

EXNUM

FROM VBRK INTO CORRESPONDING FIELDS OF TABLE IT_VBRK

WHERE VBELN = '0090060045'.

Re: regarding this select statement

Former Member — Fri, 01 Aug 2008 15:36:37 GMT

check in vbrk for invoice 0090060045 is any entry there?

Re: regarding this select statement

Former Member — Fri, 01 Aug 2008 15:38:01 GMT

Check from SE16 whether vbeln = 0090060045 is present in VBRK or not.

Regards,

Joy.

Re: regarding this select statement

Former Member — Fri, 01 Aug 2008 15:39:59 GMT

Hi,

Please check the vbrk table for the vbeln value which you have given in where condition.

your code correct.

Regards

Adil

Re: regarding this select statement

amit_khare — Fri, 01 Aug 2008 15:44:05 GMT

I hope you are looping and then trying to get the data instead of directly displaying it from IT_VBRK (Like using a work area).

Re: regarding this select statement

Former Member — Wed, 17 Sep 2008 07:22:34 GMT

thanks