issues while technical upgrade of SAP ECC 6.0 from SPS-3 to SPS-9.

[Former Member]

Hello all

We are pursuing a technical upgrade of  SAP ECC 6.0 from service pack 3 to 9 for our client.

In a particular scenario after upgrading and appling the relevant notes (mainly note no:1614976 & 1592091), a wrong account number is being fetched .

The probable cause, that we think , for this is some change in the sort criteria of the internal table from where the account is being fetched.

Below is a better representation of the problem that we are facing:

The State of the internal table GT_BSEG before sorting  in the D system (which is upgraded) is as follows:

PS: the positions of accounts 200511 and 600001.

After the sorting ,which is based on the field WRBTR(which is similar to DMBTR), the table looks as follows.

FYI: the sort is as per the field WRBTR(which is similar to DMBTR)

As per the select query the account 200511 gets selected . (while buisness requires 600001).

Now to solve the issue we tested the same code in Quality system which is not upgraded that .

The State of the internal table GT_BSEG before sorting  in the Q system (not upgraded yet) is as follows:

While after sorting based on the same field (WRBTR), The Interal table looks as :

Kindly note the areas highlighted.

Now we dont understand why is the sort procedure working differently in D and Q systems.

While as far as we have checked there is no other deciding field(for sorting) in this internal table or otherwise.

FYI the piece of code responsible for sorting :

Kindly provide pointers if you have faced such an issue or otherwise.

Any help would be useful.

Thanks in advance.

Regards.

Prashant.

[Puneet_Gupta]

What is the business logic that you want to implement ? If you are trying to get the first row with the highest amount where the vendor and customer fields are blank, that is exaclty what the program is doing.

Reading your problem statement, tells me that there is one more criteria apart from the amount and blank lifnr & kunnr fields, the business logic to select account 60000 instead of 200511 ?

What is the condition to determine which account to pick if the amounts are the same and both vendor and customer are blank??

When you are trying to read the data from the gt_bseg internal table, the condition is incomplete to give you a unique record. So either build the condition to look at the right account number in the loop or build it into the sort statement to ensure the proper records is sorted to the top.

- Puneet

[Former Member]

Hi Puneet.

Thank you for teh helpful reply.

It turns out that the issue persisted not from our side but from the customer's side , today we got a response as

"Register C170 = we debugged and the field  has a Z function module after the standard code from your analysis  Z_BRF_GL703_GET_COD_CTA that is processing program /pws/zylfr99_999 from external bolt on that has a new version in D85 due to a project that is implementing a new process of fixed assets "

So the issue seems to be resolved.

Regards.

Prashant.