06-18-2008 11:15 AM
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
06-18-2008 11:18 AM
hi
it might be becoz of u didnt created this field in field catalog
Cheers
Snehi Chouhan
06-18-2008 11:18 AM
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.
06-18-2008 11:19 AM
Hi
goto debugging initially check whether output table is initial or not and then check for the ALV.
06-18-2008 11:19 AM
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.
06-18-2008 11:30 AM
Hi
checked it and everything is fine.but i think the problem is in Select statement.the following is the select statement
SELECT VBRKVBELN VBRKKNUMV VBRKFKDAT VBRKWAERK
VBRKKURRF VBRKKUNAG VBRK~FKART
VBRPPOSNR VBRPNETWR VBRPFKIMG VBRPMATNR
VBRPMATKL VBRPVGBEL VBRPWERKS VBRPARKTX VBAK~AUART
INTO CORRESPONDING FIELDS OF TABLE ITAB
FROM VBRK
INNER JOIN VBRP
ON VBRKVBELN = VBRPVBELN
INNER JOIN VBAK
ON VBRKVBELN = VBAKVBELN
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' .
06-18-2008 11:39 AM
Hi,
Instead of so many joins
we can use view wb2_v_vbrk_vbrp
and then join the vbak table..