problem in compairing the fields

[Former Member]

hi expert...

1. selection criteria is only one

table for selection criteria-PROJ

field for selection criteria is -PSPID.

2.in mseg table we have to obtain the values of fields -ebeln and lifnr by the help of field mat_pspnr.

Feld mat_pspnr which is not used in output ,but the main paart of output..mat_pspnr is numc type .

3.there is table prps .

and given proj-pspid = prps-psphi.

and psphi is numc type...

4. in mat_pspnr the values is like abc/111.p&m ...

and in fields pspid ,psphi the values is like abc/111 only 7 digits

5.we have to compari the field mat_pspnr with the pspid or psphi ....so that if we got some common values ..

then for this common values we check the values of ebeln and lifner .

6 there is another table ekpo in which a field ebeln which is equal to the field of mseg-ebeln...

and by the values of mseg-ebeln we have to get the values of corresponding fields ekpo......

Edited by: krishna007pant on May 12, 2009 8:11 AM

[Former Member]

plz reply

Edited by: krishna007pant on May 12, 2009 8:21 AM

[Former Member]

hell kris,

it is due to the external definition and internal definition of project and wbs element

external will be 24 char and internal wil be 8 char

so u have to convert the external number into internal number for comparision

so what eever valeu ur giving in external use conervsion exits and then compare

CONVERSION_EXIT_KONPD_INPUT

CONVERSION_EXIT_KONPD_OUTPUT

these are the exits which u cna use to convert into itnenal format and external format

it will resolve ur issue

regards

afzal

[Former Member]

hi afzal ..

thanks for your reply ..

but problem is not that they are 24 char or 8 char ..

there is a field psphi in table prps which is equal to field pspid in table proj .

and psphi is 8 char...

so i can compair mat_pspnr with psphi ..

but the problem is little different

the format of mat_pspnr is like abc/111.p&m

and the format of psphi and pspid is abc/111 so how i compair this .

[Former Member]

hi kris,

format is different means may be the wbs element for that material is this abc/111.p&m

if u want to check how the wbs elemenets ro porject is formatted u can see the transaction

OPSJ transaction for codign mask here they are maitned , u cna chekc the masking for the letter a where u cn know how it can be maitained

regards

afzal

[Former Member]

Hi,

You can convert the field mat_pspnr using the FM

CONVERSION_EXIT_ABPSP_INPUT

CONVERSION_EXIT_ABPSP_OUTPUT

and compare the fields.

Regards

Sabu

[Former Member]

thanks afzal ..

i will try

Edited by: krishna007pant on May 12, 2009 9:22 AM