CDS for extract record from Purchase Condition records APP "Create Price Condition"

[Daniele_Capra]

Hi all,

In our SAP Private Cloud, from the App "Create Price Condition" is possible to display the Condition Records. We need to have the CDSs for extract those records and to send them to Datasphere.

We found the CDS:  I_PURGPRCGCONDITIONRECORD

in that CDS is it possible to see the records with the Condition Table selection but is not possible to select record throught the parameters: Company Code, Supplier and Material.

Have you any suggest for to do the selection mentioned?

Thank you

Daniele 

[erickgoulardt]

Dear Daniele, I hope you find yourself well! Thank you for joining the community. As soon as possible, a technical expert will contact you to clarify your question. I am adjusting the tags to redirect the issue to the right team. Best Regards, Erick Goulardt SAP Support

[DequanXu]

Hello,

To extract condition records with criteria such as Company Code, Supplier, and Material, you might need to look into a combination of CDS views or enhance your current one if the standard CDS `I_PURGPRCGCONDITIONRECORD` does not directly support these parameters.

Here's what you can consider:

1. **Composite or Custom CDS Views**: If the standard CDS view does not meet your requirements, you might need to create custom CDS views that join the necessary tables or views to include the desired fields for selection. You can join `I_PURGPRCGCONDITIONRECORD` with other CDS views or tables that include Company Code, Supplier, and Material data.

2. **Finding Related CDS Views**: Sometimes there are other CDS views that already provide fields that might be related to your required fields. Check for CDS views related to Company Code (`I_CompanyCode`), Supplier (`I_Supplier`), or Material (`I_Material`) which you can integrate into your view logic.

3. **BAdI Enhancements**: Consider if any Business Add-ins (BAdIs) are available that can enhance data extraction capabilities to include additional selection criteria.

4. **Explore SAP API Hub**: Check if there are any existing APIs that cater to these needs, which can be directly consumed by your SAP Data Warehouse Cloud or SAP Datasphere.

5. **Use of Filter Expressions**: While creating or enhancing the CDS views, make use of filter expressions for better performance and extract efficiency.

Best regards,

Dequan Xu

[Daniele_Capra]

Hi Dequan,

[Daniele_Capra]

Hi Dequan, we would prefer to use a CDS, we tried to find a suitable one but could not find any. Would you guys have any suggestions on which CDS to use? Thank you Daniele