Data is not coming in internal table

[Former Member]

Hello Abapers,

Data is not coming in my internal table.

Plz tell me where I m wrong

SELECTION-SCREEN BEGIN OF BLOCK blk.

PARAMETERS: compcode LIKE vbrk-bukrs OBLIGATORY.

PARAMETERS: billtype LIKE vbrk-fkart OBLIGATORY.

SELECT-OPTIONS: billdate FOR vbrk-fkdat OBLIGATORY.

PARAMETERS : acgrpc LIKE vbrk-ktgrd OBLIGATORY.

PARAMETERS: acgrpm LIKE vbrp-ktgrm OBLIGATORY.

PARAMETERS: taxcode LIKE konv-mwsk1 OBLIGATORY.

SELECT-OPTIONS: plant FOR vbrp-werks .

SELECT-OPTIONS: bussarea FOR vbrp-gsber .

SELECTION-SCREEN END OF BLOCK blk.

START-OF-SELECTION.

SELECT a_{vbeln a}fkart a_{knumv a}fkdat a_{belnr a}ktgrd a_{bukrs a}xblnr

a_{mwsbk b}gsber b_{werks b}ktgrm

FROM ( vbrk AS a INNER JOIN vbrp AS b ON

a_{vbeln EQ b}vbeln )

INTO CORRESPONDING FIELDS OF TABLE vbrk_vbrp

WHERE ( a~fkart EQ billtype ) AND

( a~fkdat IN billdate ) AND

( a~ktgrd EQ acgrpc ) AND

( a~bukrs EQ compcode ) AND

( b~gsber EQ bussarea ) and

( b~werks EQ plant ) AND

( b~ktgrm EQ acgrpm ) .

Ravi

[Former Member]

SELECT a~vbeln a~fkart a~knumv a~fkdat a~belnr a~ktgrd a~bukrs a~xblnr a~mwsbk b~gsber b~werks b~ktgrm
FROM  vbrk AS a INNER JOIN vbrp AS b ON a~vbeln EQ b~vbeln
INTO CORRESPONDING FIELDS OF TABLE vbrk_vbrp
WHERE ( a~fkart EQ billtype ) AND
( a~fkdat IN billdate ) AND
( a~ktgrd EQ acgrpc ) AND
( a~bukrs EQ compcode ) AND
( b~gsber IN bussarea ) and
( b~werks IN plant ) AND
( b~ktgrm EQ acgrpm ) .

[Former Member]

Hi,

Try this.

Since you have corresponding fields of , check whether the internal table fields name and the database field names are the same.

Sharin.

[Former Member]

Hi,

write ur query this way :

SELECT a_{vbeln a}fkart a_{knumv a}fkdat a_{belnr a}ktgrd a_{bukrs a}xblnr a_{mwsbk b}gsber b_{werks b}ktgrm

FROM ( vbrk AS a INNER JOIN vbrp AS b ON

a_{vbeln EQ b}vbeln )

INTO CORRESPONDING FIELDS OF TABLE vbrk_vbrp

WHERE ( a~fkart EQ billtype ) AND

( a~fkdat IN billdate ) AND

( a~ktgrd EQ acgrpc ) AND

( a~bukrs EQ compcode ) AND

( b~gsber IN bussarea ) and

( b~werks IN plant ) AND

( b~ktgrm EQ acgrpm ) .

even plz check then internal table ' vbrk_vbrp ' if they have all the fields of select query and even the order is same as select , since you are using ' into corresponding fields of table ' clause in select statement.

hope this helps.

thanx,

dhanashri.

Edited by: Dhanashri Pawar on Aug 26, 2008 6:14 AM

[Former Member]

hi,

you have declared selection screen field plant with select options.

so pass this field as IN in select query

WHERE ( a~fkart EQ billtype ) AND

( a~fkdat IN billdate ) AND

( a~ktgrd EQ acgrpc ) AND

( a~bukrs EQ compcode ) AND

( b~gsber EQ bussarea ) and

( b~werks IN plant ) AND

( b~ktgrm EQ acgrpm ) .

Regards,

kushagra Sharma

[Former Member]

Hi

When ever you use select-options in select statement on where condition you need to use IN operator

In your case you have used ( b~werks EQ plant ) AND

( b~ktgrm EQ acgrpm ) . EQ OPERATOR USE IN OPERATOR

Regards

Murali Papana.

[Former Member]

Hi,

try this

START-OF-SELECTION.

SELECT a_{vbeln a}fkart a_{knumv a}fkdat a_{belnr a}ktgrd a_{bukrs a}xblnr

a_{mwsbk b}gsber b_{werks b}ktgrm

FROM ( vbrk AS a INNER JOIN vbrp AS b ON

a_{vbeln EQ b}vbeln )

INTO CORRESPONDING FIELDS OF TABLE vbrk_vbrp

WHERE ( a~fkart EQ billtype ) AND

( a~fkdat IN billdate ) AND

( a~ktgrd EQ acgrpc ) AND

( a~bukrs EQ compcode ) AND

( b~gsber IN bussarea ) AND

( b~werks IN plant ) AND

( b~ktgrm EQ acgrpm ) .