on 06-16-2009 10:20 PM
Anyone know how to check for a NULL value and apply blanks
in a formula in a transformation using the IF statement
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here's some sample code that you can add and modify to test:
CONSTANTS: c_null(10) TYPE c VALUE '', c_space(10) TYPE c VALUE SPACE. IF l_value EQ c_null. l_vlaue = c_space. ENDIF.
Can this be added to the formula or routine?
This can be added to a routine, since a routine is basically a snippet of ABAP code that you're adding to the transformation.
OK..Thanks for your guidance. I was hoping that I didn't have to use a routine for the logic below.
/BIC/ZVXPRODH1 & IF( /BIC/ZVXPRODH2 = '', '', /BIC/ZVXPRODH2 )
But I have to b/c the spaces are not getting recognized in the formula.
Hi Ladygt
Statements such as the following do work in formulas.
IF( /BIC/ZFIELD = '', 'Y', 'N' )
What are you trying to achieve ?
Asif
I was able to add the statement below to a routine and works fine.
IF SOURCE_FIELDS-/BIC/ZVXPRODH2 is INITIAL.
RESULT = SOURCE_FIELDS-/BIC/ZVXPRODH2.
ELSE.
CONCATENATE SOURCE_FIELDS-/BIC/ZVXPRODH1 SOURCE_FIELDS-/BIC/ZVXPRODH2 INTO RESULT.
ENDIF.
You might want to try this in a formula if you are feeling couragous
IF (/BIC/ZVXPRODH2 = '', /BIC/ZVXPRODH2 , CONCATENATE(/BIC/ZVXPRODH1, /BIC/ZVXPRODH2))
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.