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:
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
Very useful blog! Thank you a lot for the information
One question related to join external pricing awith sales orders. I was trying to join CODEPDOIPCB - External Pricing Item Price Components and CODCOIB - Sales Order Item. I can join the Item with Sales order Item however the Document type field is not available in Sales Order Item data source.
How do you recommend to do this join?
Thank you,
Best regards,