Issue In Production Server

[former_member207873]

Hi Experts,

The report I developed is showing the expected output in development and quality server. But it is showing the proper output in production server. The issue seems to be with customers with alpha numeric number. Any tips tp sort out the issue/

[former_member207873]

Hi Experts,

The report I developed is showing the expected output in development and quality server. But it is showing the proper output in production server. The issue seems to be with customers with alpha numeric number. Any tips tp sort out the issue/

[Former Member]

Hi

but which is the problem?

Max

[former_member207873]

I am getting customer numbers like in the snap shot. It take year 2013 as some other figure (0010)...

[Former Member]

Hi

if it was a generic problem of convertion routine alpha you should have the same behavior in all reports, have you checked some other reports?

Max

[former_member207873]

In SAP reports, the customer numbers are coming as it should be. I havent developed any other custom report which is having customer number.

[Former Member]

Hi

It seems you're using the ALV grid in order to display your output, this fm is standard and many std reports use it,

Anyway try to post your code:

- Post how you've defined the internal table for output

- Post how you set and call the ALV

..and try to check if the definition of field used for customer is different in Production system

Max

[madhu_vadlamani]

Hi Marian,

Please check once in debug . If you get the same issue in standard other programs then post to sap.

Regards,

Madhu.

[former_member207873]

Hi Max,

I found out that the conversion happens after append lines of statement. After the append lines statement it is converting the values.

SELECT
         BUKRS
         KUNNR
         UMSKZ
         GJAHR
         MONAT
         DMBTR
         SHKZG FROM BSID
         INTO CORRESPONDING FIELDS OF TABLE IT_BSID
         WHERE KUNNR IN SO_KUNNR AND BUKRS IN SO_BUKRS AND GJAHR = P_GJAHR AND MONAT BETWEEN '1' AND SO_MONAT-HIGH AND UMSKZ NE ''.

   SELECT
         BUKRS
         KUNNR
         UMSKZ
         GJAHR
         MONAT
         DMBTR
         SHKZG FROM BSAD
         INTO CORRESPONDING FIELDS OF TABLE IT_BSAD
         WHERE KUNNR IN SO_KUNNR AND BUKRS IN SO_BUKRS AND GJAHR = P_GJAHR AND MONAT BETWEEN '1' AND SO_MONAT-HIGH AND UMSKZ NE ''.

APPEND LINES OF IT_BSAD TO IT_BSID.

I need to add the lines of BSAD internal table to BSID internal table. Any other way to do this.

Regards,

[Former Member]

Hi

Something doesn't sound good....anyway BSID and BSAD have the same structure, so you can use the option APPENDING in the second selection:

SELECT
         BUKRS
         KUNNR
         UMSKZ
         GJAHR
         MONAT
         DMBTR
         SHKZG FROM BSID
         INTO CORRESPONDING FIELDS OF TABLE IT_BSID
         WHERE KUNNR IN SO_KUNNR AND BUKRS IN SO_BUKRS ANDGJAHR = P_GJAHR AND MONAT BETWEEN '1' AND SO_MONAT-HIGH ANDUMSKZ NE ''.

   SELECT
         BUKRS
         KUNNR
         UMSKZ
         GJAHR
         MONAT
         DMBTR
         SHKZG FROM BSAD
         INTO CORRESPONDING FIELDS OF TABLE IT_BSAD

         APPENDING CORRESPONDING FIELDS OF TABLE IT_BSID

         WHERE KUNNR IN SO_KUNNR AND BUKRS IN SO_BUKRS ANDGJAHR = P_GJAHR AND MONAT BETWEEN '1' AND SO_MONAT-HIGH ANDUMSKZ NE ''.

APPEND LINES OF IT_BSAD TO IT_BSID.

Max