sales document type in ALV

[Former Member]

Hi

i created a ALV and the output is displayed properly .then i added a field sales document type ,the problem i face is that after declaring, the output is displayed without any values

i like to know how to solve the problem

[Former Member]

hi

it might be becoz of u didnt created this field in field catalog

Cheers

Snehi Chouhan

[Former Member]

Hi,

Check whether you have added that field in the structure of final int.table and filled the field catalog correctly.Aslo check select query.

[Former Member]

Hi

goto debugging initially check whether output table is initial or not and then check for the ALV.

[Former Member]

check wether it is populated or not.

see the field catalog if this is included or not.

check the table name assigned in field catalog.

[Former Member]

Hi

checked it and everything is fine.but i think the problem is in Select statement.the following is the select statement

SELECT VBRK_{VBELN VBRK}KNUMV VBRK_{FKDAT VBRK}WAERK

VBRK_{KURRF VBRK}KUNAG VBRK~FKART

VBRP_{POSNR VBRP}NETWR VBRP_{FKIMG VBRP}MATNR

VBRP_{MATKL VBRP}VGBEL VBRP_{WERKS VBRP}ARKTX VBAK~AUART

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM VBRK

INNER JOIN VBRP

ON VBRK_{VBELN = VBRP}VBELN

INNER JOIN VBAK

ON VBRK_{VBELN = VBAK}VBELN

WHERE VBRK~VBELN IN VBELN

AND VBRK~FKART IN FKART

AND VBRK~FKDAT IN FKDAT

AND VBAK~AUART IN AUART

AND VBRP~MATKL IN MATKL

AND VBRP~WERKS IN WERKS

AND VBRK~FKSTO NE 'X' .

[Former Member]

Hi,

Instead of so many joins

we can use view wb2_v_vbrk_vbrp

and then join the vbak table..