Missing data in my report

[Former Member]

Hi all;

Here is my Issue; I am running a report which has 0project and 0app_requ as an attribute of 0project. In my update rule, I have mapped the 0app_requ with a routine.

select single * from /BI0/PPROJECT

where /BIC/WPSPRJPRO = 'Z_DD_AT' and

PROJECT = COMM_STRUCTURE-PROJECT.

if sy-subrc = 0.

RESULT = /BI0/PPROJECT-APPR_REQU.

ELSE.

RESULT = ''.

ENDIF.

-

---

But, In my report eventhough the project is under 'Z_DD_AT' , for some of the project I am getting '# ' for 0appr_requ. ; pls anyone tell me what am I missing here.

This is a production issue. ..so pls help.

Krishma.

[Former Member]

Any Gurus please !! give me some lights.

[kumar_gudiseva2]

question: do you have 0app_requ and wpsprjpro defined as attributes of 0project?. In BCt version I don't see them.

observation: a better code would be:

select single APPR_REQU from /BI0/MPROJECT

where /BIC/WPSPRJPRO = 'Z_DD_AT' and

PROJECT = COMM_STRUCTURE-PROJECT AND

OBJVERS = 'A'.

if sy-subrc = 0.

RESULT = /BI0/PPROJECT-APPR_REQU.

ELSE.

CLEAR RESULT.

ENDIF.

Kumar Gudiseva.