code correction

[Former Member]

hi,

What is wrong in my code ie internal table assignment, I am getting the error

DATA: IT_INBAL type STANDARD TABLE OF YMTID_C102_INVBL WITH HEADER LINE,

WA_INBAL type YMTID_C102_INVBL.

loop at i_data.

move i_data to wa_data.

select * from YMTID_C102_INVBL INTO table wa_INBAL WHERE YWRHOUSE = wa_data-whnum

AND YLOCATION = wa_data-locno.

*wa_outfile-source = 'prism'.

*wa_outfile-sscc = it_outfile-sscc.

*wa_outfile-pcmat = it_outfile-pcmat.

*wa_outfile-imtyp =

wa_outfile-whnum = wa_INBAL-s_wrhouse.

*wa_outfile-pltyp = IT_INBAL-l_pltyp.

*wa_outfile-sttyp = it_inbal-l_sttyp.

*wa_outfile-stsec = it_inbal-l_stsec.

wa_outfile-stbin = wa_data-locno.

*wa_outfile-ssino =

*wa_outfile-ssnno

wa_outfile-qunty = wa_data-qnloc.

SELECT MSEHI FROM YCAD_UOM INTO WA_outfile-unitm where LEG_MSEHI = wa_data-stdum.

ENDSELECT.

wa_outfile-unitm = wa_outfile-unitm.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

INPUT = wa_data-resno

IMPORTING

OUTPUT = wa_data-resno.

.

wa_outfile-matno = wa_data-resno.

wa_outfile-batch = wa_data-lotno.

wa_outfile-plant = it_inbal-s_plant.

*wa_outfile-stats

wa_outfile-grdat = wa_data-ffdat.

wa_outfile-stloc = it_inbal-s_stor_loc.

wa_outfile-sldat = wa_data-sldat.

*wa_outfile-wmtyp = const(561)

wa_outfile-tickt = wa_data-lotno.

wa_outfile-UCOST = wa_data-UCOST.

wa_outfile-TCOST = wa_data-TCOST.

append wa_outfile to it_outfile.

endloop.

it giving me the error like wa_inbal is not an internal table occurs n is missing

If i declare it_inbal in the select statement it is not assigning the values to the fields

Can any one guide me how to solve this

plz its bit urgent

Nisha

[Former Member]

Well, you have to:

select * from YMTID_C102_INVBL
  INTO table IT_INBAL 
  WHERE YWRHOUSE = wa_data-whnum
    AND YLOCATION = wa_data-locno.

If you don't get values, it's because there are no values in the table that meet the selection criteria.

Rob

[Former Member]

Try this:

DATA: IT_INBAL type STANDARD TABLE OF YMTID_C102_INVBL INITIAL SIZE 0,

WA_INBAL type YMTID_C102_INVBL.

I think this should solve it.

Sri