regarding this select statement

[Former Member]

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'.

[Former Member]

check in vbrk for invoice 0090060045 is any entry there?

[Former Member]

thanks

[Former Member]

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

Regards,

Joy.

[Former Member]

Hi,

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

your code correct.

Regards

Adil

[amit_khare]

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).