error in report

[Former Member]

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

[Former Member]

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á

[Former Member]

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

[Former Member]

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

Regards,

Nikhil

[Former Member]

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

[Former Member]

P_PSPID is a PARAMETER? or a SELECT-OPTION?

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