topic Re: NULL and SPACE in Application Development and Automation Discussions

NULL and SPACE

Former Member — Thu, 17 Mar 2005 17:15:23 GMT

Hello Gurus:

I have had to use BOTH 'null' and 'space' (ofcourse I tried 'initial' too...) when selecting data from PRPS table, otherwise all the required records were not fetched. I had to do this on two different occassions. The first is a SAP provided field and the other is customer's enhancement. I have cut-paste the two code blocks. Any ideas why?

Thanks in advance,

Sard.

***********(1)**************

select posid objnr func_area zzfunct from prps into

corresponding fields of table it_wbs

where func_area is null or

func_area eq space.

************(2)**************

select prps-pspnr prps-posid prps-post1

...

into (wa_test1-pspnr, wa_test1-posid, wa_test1-post1,

...)

from prps

where prps-posid in s_wbs and

... and

( prps-zzmlind is null or prps-zzmlind eq space ).

append wa_test1 to it_test1.

clear wa_test1.

endselect.

Re: NULL and SPACE

former_member183804 — Thu, 17 Mar 2005 17:47:00 GMT

Hello Richard,

the Requirement to check for NULL corresponds to the definition of the database (field) within the DDIC. Check the flag initialize (it has also some documentation).

This flag is intended to be used if the definition of the db table is changed at SAP while the table already is used at customer side.

After deploying the corresponding patch or upgrade such a changed definition may result into the need to convert all entries. For tables with many entries this would result into inacceptable downtime. So such changes are done without the initialiazation/conversion of existing entries.

The tradeoff is the syntax you noticed.

Kind regards

Klaus

Re: NULL and SPACE

Former Member — Thu, 17 Mar 2005 21:09:14 GMT

Klaus:

Thank you very much. YOU WERE PRECISE, func_area field was changed in the Enterprise version, and I noticed the problem during our upgrade.

Btw, is there a way for me to check the flag initialize for the customer field(zzmlind) added in structure CI_PRPS, without needing the access key to PRPS?

Thanks again for your time and the reply.

Re: NULL and SPACE

RichHeilman — Thu, 17 Mar 2005 21:15:51 GMT

No, by doing so, you are changing the definition of PRPS, hence the reason it is asking for access key.

Regards,

Rich Heilman