Need help on data source for External Pricing

[indrapats2800]

Hi Team,

I have requirement to create report which shows external pricing at ticket item and header, in Business Analytics.

The data source for External pricing is "CODEPDOPCB" for header & "CODEPDOIPCB" for item .

But in order to create report i need to join this report with ticket data source which has object ID.

Can any one please help with what ticket data source i can create joint. Thanks in adavance.

[former_member226 · Accepted solution]

Hi,

You can use the standard data source CRMSRQHB in conjunction with "CODEPDOPCB" for header and "CODEPDOIPCB" for items. You will need to create an inner join with conditions as depicted below:

CRMSRQHB.Ticket == CRMSRQHB.Document == CODEPDOIPCB.Document

join.png

[indrapats2800 · Accepted solution]

Thanks Saurabh !

It worked.