topic error in report in Application Development and Automation Discussions

error in report

Former Member — Thu, 22 Jul 2010 11:09:12 GMT

hi experts,

plz solve my problem, i mention below my coding...

SELECT PSPID POST1 FROM

PROJ INTO TABLE

IT_PROJ WHERE

PSPID = P_PSPID.

SELECT PSPHI POSID OBJNR '' here only i am getting error.

FROM PRPS INTO TABLE

IT_PRPS WHERE PSPHI = P_PSPID.

SELECT PS_PSP_PNR NETWR WAERK

FROM VBAP INTO TABLE IT_VBAP

FOR ALL ENTRIES IN IT_PRPS

WHERE PS_PSP_PNR = IT_PRPS-POSID.

SELECT OBJNR VORGA WTP00 VERSN

FROM RPSCO INTO TABLE

IT_RPSCO FOR ALL ENTRIES IN

IT_PRPS WHERE OBJNR = IT_PRPS-OBJNR AND

VERSN = '0' AND VORGA = 'KSTP'.

this is my coding..

while excute time i am getting run time error in second select query(it_prps )

regards

guna

Re: error in report

Former Member — Thu, 22 Jul 2010 11:19:50 GMT

Hi!

Try out this way:

SELECT PSPHI POSID OBJNR '' here only i am getting error.

FROM PRPS INTO CORRESPONDING FIELDS OF TABLE "match by name, not by structure

IT_PRPS WHERE PSPHI = P_PSPID.

Regards

Tamá

Re: error in report

Former Member — Thu, 22 Jul 2010 11:20:22 GMT

Hi,

How can you match PSPHI with P_PSPID in your 2nd Select?

Please correct your where clause in the 2nd select.

Regards,

Ankur Parab

Re: error in report

Former Member — Thu, 22 Jul 2010 11:21:12 GMT

Please let me know the declaration of internal table IT_PROJ , IT_PRPS . also the type of P_PSPID.

Regards,

Nikhil

Re: error in report

Former Member — Thu, 22 Jul 2010 11:21:29 GMT

Hi,

Seems to be a data type mismatch problem.

What is the data type of P_PSPID ? As per the first select query, you would have defined P_PSPID as CHAR(24).

In Second Query you are comparing the value of P_PSPID with PRPS-PSPHI which is having data type NUMC(8).

Regards

Vinod

Re: error in report

Former Member — Thu, 22 Jul 2010 11:53:09 GMT

P_PSPID is a PARAMETER? or a SELECT-OPTION?

Check that the data element of both fields be the same..