credit memo issue with 2lis_13_vditm

[Former Member]

Hi all,

We are having a critical problem at work. I hope I could get some help resolving this issue.

The problem is with 2LIS_13_VDITM datasource and is as follows:

On Dec'18, a 3.4 million dollar credit was entered and cancelled 3 times. and entered again the 4th time. The net value result in the ODS is showing correctly.

However, the result of the Credit column in the cube is showing approx. 10Million more than it should.

We have 2 key figure in the InfoCube, Billing Credit and Billing revenue. When I checked the results in the cube, I observed that c"ancellation of Creit memo" was not being posted to the Billing Credit Key figure and also the cancellation of Invoices was not being posted to the Net revenue.

When I looked for the Update rules in the Cube, there is a routine for the Billig Credit and Net Revenue. I need some help with the code. The code is as below;

For Billing Credit

• result value of the routine

IF COMM_STRUCTURE-DOC_CATEG = 'O' OR

COMM_STRUCTURE-DOC_CATEG = 'P'.

RESULT = COMM_STRUCTURE-/BIC/ZZFIREV.

ELSEIF COMM_STRUCTURE-DOC_CATEG = 'M'.

RESULT = 0.

ENDIF.

• result value of the unit

UNIT = COMM_STRUCTURE-DOC_CURRCY.

• if the returncode is not equal zero, the result will not be updated

RETURNCODE = 0.

• if abort is not equal zero, the update process will be canceled

ABORT = 0.

Can some one tell me what is the output of this code.

"O" is for Credit memos. I am not sure what does "P" or "M" in the code do.

Could some one please help me out. We need to fix this issue to eradicate the Billing Credit Issue.

I look forward to hearing from the experts.

Regards,

S.P

[Private_Member_9643 · Accepted solution]

You just go and cross check value of DOC_CATEG in ur ODS for the records for which u r missing data.

What is ur change log for that records? Could you copy-paste all ur key fields with doc_categ, and record mode value from ODS change log for more analysis.

[Former Member · Accepted solution]

Hi Kamaljeet,

Thank you for your quick response. I just checked the change log for the record and the DOC_CATEG for the missing records is "K" and from the code, it is eveident that the DOC_CATEG with value K is not filled into Billing credit key figure.

So inorder to populate the field, should I just include another statement with DOC_CATEG=K. Will it work.

Your input will be very helpful.

Regards,

Sumana

[Private_Member_9643 · Accepted solution]

yup...add it in or condition.

And also confirm from ur functional team about understanding of this field values, so in future it will help you in debugging things.

Let us know if it solves ur problem?

[Former Member · Accepted solution]

Thanks for your help Kamaljeet. I sure will give it a try and let you know if it solves the problem.

Regards,

Sumana