Skip to Content

C4C- Join Data Sources for External Pricing

Two data sources for external pricing are available:

  • Data source CODEPDOPCB, name “External Pricing Header Price Components”, description “Provides all header level price components determined with external pricing.”
  • Data source CODEPDOIPCB, name “External Pricing Item Price Components”, description “Provides all item level price components determined with external pricing.”

They can be found in Business Analytics -> Design Data Sources:

Goal of this blog is to demonstrate how to join data sources for external pricing that can be built based on these basic data sources. Sales Quote is used as an example. For other objects like Sales Order, Contract or Ticket it works similar.

Sales Quote Header Pricing

Go to New -> Joined Data Source:

Add data source CODEPDOPCB “External Pricing Header Price Components”:

Add data source CODCQTHB “Sales Quote Header”:

Set Access Context -> Sales Quote Header:

Maintain join conditions:

  • CODEPDOPCB-DOC_BASE_BTD_UUID = CODCQTHB-DOC_UUID
  • CODEPDOPCB-DOC_BASE_BTD_TYPE_CD = CODCQTHB-DOC_TYPE_CD (optional)

Attention: The system defaults other, not meaningful joined conditions.

Use preview to test the joined data source:

Sales Quote Item Pricing

Go to New -> Joined Data Source:

Add data source CODEPDOIPCB “External Pricing Item Price Components”:

Add data source CODCQTIB “Sales Quote Item”:

Set Access Context -> Sales Quote Item:

Maintain join conditions:

  • CODEPDOIPCB-ITM_BASE_BTD_ITEM_UUID = CODCQTIB-ITM_UUID
  • CODEPDOIPCB-DOC_BASE_BTD_TYPE_CD = CODCQTIB-DOC_TYPE_CD (optional)

Attention: The system defaults other, not meaningful joined conditions.

Use preview to test the joined data source:

1 Comment
You must be Logged on to comment or reply to a post.
  • Guenter Wilmer ,

    Nice Blog! I have one doubt, the Amount and For Key field displays only the value . It doesn’t show with the currency and the unit of measurement. Is this the standard behavior?
    Any workaround to overcome this issue. I know SAP has given the corresponding field , but it is the characterstic field.So, not able to arrange in logical order

    Regards,
    Bharathraj