topic Re: Data is not coming in internal table in Application Development and Automation Discussions

Data is not coming in internal table

Former Member — Tue, 26 Aug 2008 03:23:21 GMT

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

Re: Data is not coming in internal table

Former Member — Tue, 26 Aug 2008 03:36:19 GMT



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

Re: Data is not coming in internal table

Former Member — Tue, 26 Aug 2008 03:53:14 GMT

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.

Re: Data is not coming in internal table

Former Member — Tue, 26 Aug 2008 04:08:56 GMT

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

Re: Data is not coming in internal table

Former Member — Tue, 26 Aug 2008 04:13:16 GMT

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

Re: Data is not coming in internal table

Former Member — Tue, 26 Aug 2008 04:38:43 GMT

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.

Re: Data is not coming in internal table

Former Member — Tue, 26 Aug 2008 05:53:36 GMT

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