C4C- Join Data Sources for External Pricing

[guenter_wilmer]

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: