topic Re: Is not initial in Application Development and Automation Discussions

Is not initial

Former Member — Wed, 08 Mar 2006 15:57:25 GMT

Hi All!

I want to check before if the field is initial or not in a select statement.How can i achieve this.

regards

Pavan

Re: Is not initial

Former Member — Wed, 08 Mar 2006 15:59:11 GMT

if not field-val is initial.

select ................

endif.

check field is not initial.

in both ways u can do.

Re: Is not initial

Former Member — Wed, 08 Mar 2006 15:59:34 GMT

Sorry i don't you get your question....But...it shouldn't be like this???


IF NOT MY_FIELD IS INITIAL.
SELECT *
INTO TABLE MY_TABLE
FROM ZTABLE
WHERE FIELD EQ MY_FIELD.
ENDIF.

Greetings,

Blag.

Re: Is not initial

venkata_ramisetti — Wed, 08 Mar 2006 15:59:47 GMT

Hi ,

yuou can do like below.

if field is a character type field:

SELECT ... FROM TABLE WHERE FIELD NE SPACE.

if field is a numeric type field:

SELECT ... FROM TABLE WHERE FIELD NE 0.

THanks,

ramakrishna

Re: Is not initial

RichHeilman — Wed, 08 Mar 2006 16:06:43 GMT

You can also do this.

report zrich_0004 .

tables: mara.

select single * from mara where not matnr is null.

write:/ mara-matnr.

Regards,

Rich Heilman

Re: Is not initial

Former Member — Wed, 08 Mar 2006 16:23:56 GMT

Hi Kunmar

If IT_PA0000 has data then go further

  IF NOT IT_PA0000[] IS INITIAL.

Get Master Record (Personal Data) & (Org. Assignment)

SELECT PERNR

SUBTY

BEGDA

ENDDA

WERKS

BTRTL

PERSK

INTO CORRESPONDING FIELDS OF TABLE IT_PA0001

FROM PA0001

FOR ALL ENTRIES IN IT_PA0000

WHERE PERNR = IT_PA0000-PERNR AND

ENDDA = V_DATE.

*Check Sy-subrc and then sort by PERNR

IF SY-SUBRC = 0.

SORT IT_PA0001 BY PERNR WERKS.

ENDIF.

Thanks

Khimavath Vikranth