cannot filter on project defination in a z-table

[Former Member]

Hi all,

I have inserted a record in the Z-table using the insert statement from my program.

The record also contains Project Defination.

The record is succesfully getting created in the Z-table but when I try to filter it through the selection screen on project defination it does not retrieve any record.

The record is getting retrived if I dont use project defination as a selection criteria.

Please let me know what can be the issue.

Thanks,

Mohammed.

[Former Member]

Hi all,

I have inserted a record in the Z-table using the insert statement from my program.

The record also contains Project Defination.

The record is succesfully getting created in the Z-table but when I try to filter it through the selection screen on project defination it does not retrieve any record.

The record is getting retrived if I dont use project defination as a selection criteria.

Please let me know what can be the issue.

Thanks,

Mohammed.

[messier31]

Hi,

How have you define this project definition selection parameter? Please show your code. And also let us knw the data type for project def field in yor Z table.

[Former Member]

a) Just check what the data type of the screen field...wheather it is internally converting.. is so use conversionexits

CONVERSION_EXIT_(FIELD)_INPUT

CONVERSION_EXIT_(FIELD)_OUTPUT

b) If the screen field is

parameter

field = p_screenfield

for select-option use

field in s_csreenfield

Vishwa.

Edited by: Vishwa Sri Hari on Aug 26, 2009 4:14 PM

[Former Member]

I have used standard data element PS_PSPID.

[Former Member]

I have checked all the conversion exits.

The problem only arises if I insert through the program.

It is filtring perfectly if I insert the entries manually into the Z-table.

[Former Member]

Just check with your selection screen field ie : the data type of the screen field.

Vishwa

[Former Member]

I have checked that, its not even getting filtered at the database level

i.e. from se11 if I enter the Project defination it does not get the value pertaining to that project no. if I just execute without entering the project no then I can see all the entries in the table.

I have checked everything, I dun know what can the issue be.

[Former Member]

Hi,

this would happen because of the conversion exits in the domain for field PROJ-PSPNR, if you ahve taken reference from this field you have to suitable convert the project defination to the correct format using conversion exits

CONVERSION_EXIT_KONPD_INPUT

CONVERSION_EXIT_KONPD_OUTPUT

Regards,

Himanshu