cancel
Showing results for 
Search instead for 
Did you mean: 

Need Table for Net Value or Gross from Header GUID

Former Member
0 Kudos

Hi Gurus,

Can someone help me find the net value of a complaint object? I have sorted out all OPEN returns in our system and now I want to find out what the net or gross values of them are so I can filter based on biggest to smallest so we can fix the biggest first.

We tried table CRMD_CUMULAT_H but this contained sales header guids but not complaint GUIDS. I have searched as much as I can and cannot find this. I am looking for header as I want the cumulative from all the lines. See screenshot for more info.

HELP!

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

    you can try to use the function named 'CRM_CUMULAT_H _READ_OW' OR ‘CRM_ORDER_READ’  and use the header guid to find it.Hope it can help you.

REGARDS.

Jinbin

Former Member
0 Kudos

Thanks Jinbin,

I am lacking some access in our PRD ENV. to run the CRM_ORDER_READ but I will be trying this one I can get access. thank you!

Do you happen to know any tables with that information?

- Matt

Former Member
0 Kudos

Hi JinBin,

I was able to finally run CRM_ORDER_READ but ET_CUMULAT_H is Zero although the complaint in CRMD_ORDER has a value under pricing.

Thanks for the help though!

- Matt

Former Member
0 Kudos

Hi,

In CRMD_ORDER_INDEX table you can find the Net Value field, apart from this cumulative data is stored in table "CRMD_CUMULAT_H",

With Regards

Ankush Rai

Former Member
0 Kudos

It must be our pricing procedure because this is blank for complaints. so odd.

Thanks Ankush!

Answers (0)