Information Required PROJ & PRPS tables for fetching data

[Former Member]

Hi,

From ztable which is a custom table I am taking a project code which is 24 characters,

After this I am passing this project code as input to

CONVERSION_EXIT_ABPSP_INPUT

and getting output as pspnr.

With his pspnr I am selecting PSPHI from PRPS table.

Till this point every thing is fine.

But my problem is that how get the Details from PROJ table based on this PSPHI which is taken out from PRPS table.

Pelase help me out.

Thanks in Advance

Irfan Hussain

[former_member181962 · Accepted solution]

pass the psphi field to the pspnr of proj table.

select single * from prps into prps

select single * from PROJ into proj

where pspnr = prps-psphi.

[Former Member]

From ztable which is a custom table I am taking a project code which is 24 characters,

After this I am passing this project code as input to

CONVERSION_EXIT_ABPSP_INPUT and getting output as pspnr.

With his pspnr I am selecting PSPHI from PRPS table.

Till this point every thing is fine.

After this try to use the follwoing code.

select * from PROJ into <int'table>

where PRPS-PSPNR = PROJ-PSPNR

and PRPS-PSPHI = PROJ-SPSNR.

Use this <int'table> for further processing.

PL. AWARD POINTS FOR THIS QUESTION.

[Former Member]

Hoe this may be or not a solution. Try try this. After selecting PSPHI from PRPS table, goto table PROJ to fecth the data. Here pass PSPNR & SPSNR. Use PRPS-PSPNR = PROJ-PSPNR & PRPS-PSPHI = PROJ-SPSNR.

PRPS-PSPHI is Current number of the project & PROJ-SPSNR is Current number for standard project.

[Former Member]

Hi,

Ramesh could you be more clear on it.

I am new to project sysytems.

Regards,

Irfan

[Former Member]

Hi Irfan,

get the details from PROJ table comparing PROJ-PSPNR with PRPS-PSPHI...

thanks,

mahesh.

pls award points if its useful..

[andreas_mann3]

hi,

try:

   SELECT * FROM PROJ 
                  WHERE PSPNR EQ I_PSP-PSPHI AND
                        LOEVM EQ SPACE.                    

....

Andreas