topic Issue In Production Server in Application Development and Automation Discussions

Issue In Production Server

former_member207873 — Tue, 17 Sep 2013 08:57:15 GMT

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/

Re: Issue In Production Server

Former Member — Tue, 17 Sep 2013 09:05:51 GMT

but which is the problem?

Max

Re: Issue In Production Server

former_member207873 — Tue, 17 Sep 2013 09:11:21 GMT

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

Re: Issue In Production Server

Former Member — Tue, 17 Sep 2013 09:16:44 GMT

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

Re: Issue In Production Server

former_member207873 — Tue, 17 Sep 2013 09:36:22 GMT

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

Re: Issue In Production Server

Former Member — Tue, 17 Sep 2013 09:39:40 GMT

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

Re: Issue In Production Server

madhu_vadlamani — Tue, 17 Sep 2013 09:47:42 GMT

Hi Marian,

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

Regards,

Madhu.

Re: Issue In Production Server

former_member207873 — Tue, 17 Sep 2013 10:12:20 GMT

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,

Re: Issue In Production Server

Former Member — Tue, 17 Sep 2013 10:17:37 GMT

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