topic Re: READ DATASET populating some blank values in a numc variable in Application Development and Automation Discussions

READ DATASET populating some blank values in a numc variable

Former Member — Wed, 05 Jan 2011 18:58:07 GMT

Hi Experts,

I am facing an issue with one of the very complex programs running in Production System of my Client. The Issue goes like this:

The program is reading a file on application server using READ DATASET and then splitting the records and assigning it to particular itab's field. The structure of a record of the file is as below(arranged horizontally)

Record type (NUMC)

ID (CHAR (26)

Date (SY-DATUM)

Sequence Number (NUMC)

Now for some of the files we receive a number in the sequence number field and for some files we dont. Now when the program is reading the record, for the files with sequence number it is updating the particular number with leading zeroes in the variable where we are assigning the value. But for the files where we dont have any sequence number it is updating the variable with some blank. In debug mode if I clear the values of the field, then automatically it becomes 00000000, the default value of any NUMC field. Now this data is updated again in a database table where the field is of type NUMC and the table is also getting populated with spaces. If I try maintaining the database table via SM30 then even if I keep the sequence number field blank it picks up 00000000 on its own which is quite normal for any NUMV field. As far I know in ABAP editor if we try populating a NUMC variable with 8 spaces or any other value it gives us a syntax error.

If anybosy had faced such kind of issues in the past with NUMC variables and read dataset please provide some inputs.

PS: Being a banking client I am not able to post the code in this open forum. i will try to provide you guys a sample code how this problem is occuring in next couple of days. I have checked all the variable and the related field's data type and they are all NUMC. There is abolutely no data type mismatch with any of the fields wherever this Sequence Number field is passed.

Re: READ DATASET populating some blank values in a numc variable

kesavadas_thekkillath — Wed, 05 Jan 2011 21:10:19 GMT

So you need zeros in that particular field when there is no sequence numbers. currently its saving as space in db ... is this the problem ???

Re: READ DATASET populating some blank values in a numc variable

Clemenss — Wed, 05 Jan 2011 23:26:48 GMT

Hi Manuish,

I guess you are not yet on ECC 600 unicode. Anyway, just try to detect the missing data

IF <struc>-sequence_Number = space.         " Check
IF <struc>-sequence_Number = 0.             " which condition
IF <struc>-sequence_Number na '0123456789'. " is met
  CLEAR <struc>-sequence_Number.
ENDIF.

Regards,

Clemens

Re: READ DATASET populating some blank values in a numc variable

Subhankar — Thu, 06 Jan 2011 01:32:24 GMT

Hi Manuish ,

I also faced the same problem. It's really peculiar that in NUMC field you can put char value. Just run the below code. You will get the answer.

TYPES: BEGIN OF x_struct,

f1_c TYPE char10,

f2_n TYPE n LENGTH 10,

f3_c TYPE char10,

f4_n TYPE n LENGTH 10,

END OF x_struct.

DATA: wa_struct TYPE x_struct.

SPLIT 'abcd, , hgsafd,a' AT ',' INTO wa_struct-f1_c wa_struct-f2_n wa_struct-f3_c wa_struct-f4_n.

BREAK-POINT. " Check wa_struct-f2_n wa_struct-f4_n

IF wa_struct-f2_n CO '0123456789'.

ELSE.

CLEAR wa_struct-f2_n.

ENDIF.

IF wa_struct-f4_n CO '0123456789'.

ELSE.

CLEAR wa_struct-f4_n.

ENDIF.

BREAK-POINT. " Check wa_struct-f2_n wa_struct-f4_n

Thanks

Subhankar

Re: READ DATASET populating some blank values in a numc variable

Former Member — Fri, 07 Jan 2011 16:53:12 GMT

yup....that i can do by clearing the field by ....but the problem is that if i put a check like if var1 is initiasl or var1 >0 it doesnt work.....

Re: READ DATASET populating some blank values in a numc variable

Clemenss — Fri, 07 Jan 2011 23:23:20 GMT

Hi Manuish,

this just came to my mind: Try ABAP command UNPACK <field> TO <field> on the field in question. Honestly spoken I never fully understood the necessity and function of statement ->[UNPACK|http://help.sap.com/abapdocu_702/en/index.htm] but I'm convinced it would do exactly what you need: If no digit is present, you get all zeros, if leading zeros are missing, they will be created, if digits with leading zeros are already there, nothing changes.

Regards,

Clemens

Re: READ DATASET populating some blank values in a numc variable

SuhaSaha — Sat, 08 Jan 2011 03:50:20 GMT

Hello Clemens,

For UNPACK the value should be TYPE p, we can't use a NUMC field.

@OP: What exactly is your problem? You want the Sequence Number field to be populated with zeroes or space?

BR,

Suhas

Re: READ DATASET populating some blank values in a numc variable

Clemenss — Sat, 08 Jan 2011 12:18:16 GMT

Hi Suhas,

please try the following code:

DATA:
    lv_numc(26) TYPE n.
  FIELD-SYMBOLS:
    <any> TYPE c.
  ASSIGN lv_numc TO <any> CASTING. "Look at lv_numc as a character field
  <any> = '                          '. "This way put spaces into NUMC field (>=ECC600)
  UNPACK   lv_numc TO lv_numc."Now we 'convert' spaces to all Zeros
  <any> = '                       abc'."What happens with invalid non-numeric value?
  TRY.
      UNPACK   lv_numc TO lv_numc.
    CATCH cx_root."Conversion error is raised
      CLEAR lv_numc. "Fills with zeros
  ENDTRY.

You might have come to the same conclusion if you folowed my link to UNPACK documentation (see above).

The statement "For UNPACK the value should be TYPE p, we can't use a NUMC field." is just incorrect.

You do not help anyone by issuing false statements without reading documentation and without verifying in an ABAP AS.

Regards,

Clemens

Re: READ DATASET populating some blank values in a numc variable

SuhaSaha — Sat, 08 Jan 2011 15:29:10 GMT

Hello Clemens,

Unfortunately this is what SAP documentation on [UNPACK|http://help.sap.com/abapdocu_70/en/ABAPUNPACK_SHORTREF.htm] has to say:

UNPACK source TO destination.
Assigns the digits of a packed number source to the character-type variables destination.

BR,

Suhas

Re: READ DATASET populating some blank values in a numc variable

Clemenss — Sat, 08 Jan 2011 22:00:59 GMT

Thank you Suhas,

thanks for the link on [Short reference documentation|http://help.sap.com/abapdocu_70/en/ABAPUNPACK_SHORTREF.htm]. If you click on the [Reference|http://help.sap.com/abapdocu_70/en/ABAPUNPACK.htm], you can read the full documentation and see what SAP unfortunately has to say here:

...

For source, the data type p of length 16 without decimal places is expected

and in 702 documentation continued and an operand of data type decfloat16 or decfloat34 must not be specified.

And then:

If the data type of source is not of the type p with length 16 and without decimal places, then the content of source is converted to this data type.

...

The digits of the interim result are assigned to data object destination right-aligned and without +/- sign. Any additional places in destination are filled with leading zeros. If the length of destination is not sufficient, the assigned variable is truncated from the left.

You can use UNPACK statement if you read not only the short reference, excuse me for assaulting you without reason

I hope you will soon have the chance to try my sample code.

Regards,

Clemens

Re: READ DATASET populating some blank values in a numc variable

SuhaSaha — Mon, 10 Jan 2011 04:45:59 GMT

Hello Clemens,

If we want to replace the zeroes in the NUMC field with space we can use NO-ZERO addition. Why ASSIGN to a CHAR variable?

DATA: lv_numc(26) TYPE n.

CLEAR lv_numc. WRITE: lv_numc.

* You can suppress the zeroes with NO-ZERO adddition
IF lv_numc IS INITIAL.
  WRITE lv_numc TO lv_numc NO-ZERO.
  WRITE: / lv_numc.
ENDIF.

Frankly i didn't understand the OP's requirement. Does he want to replace the zeroes in NUMC field with blanks or otherwise?

BR,

Suhas

Re: READ DATASET populating some blank values in a numc variable

Clemenss — Mon, 10 Jan 2011 11:01:34 GMT

Yess. I'm out.

Clemens