Is not initial

[Former Member]

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

[Former Member]

if not field-val is initial.

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

endif.

2.

check field is not initial.

in both ways u can do.

[Former Member]

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.

[venkata_ramisetti]

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

[RichHeilman]

You can also do this.

<b>report zrich_0004 .

tables: mara.

select single * from mara where not matnr is null.

write:/ mara-matnr.</b>

Regards,

Rich Heilman

[Former Member]

Hi Kunmar

<i>If IT_PA0000 has data then go further</i>

  IF NOT IT_PA0000[] IS INITIAL.

<i>Get Master Record (Personal Data) & (Org. Assignment)</i>

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.

ENDIF.

Thanks

Khimavath Vikranth