SAP Knowledge Base Article - Public

3634778 - CDS view to retrieve scale prices from Purchasing Info Records (PIR)

Symptom

Requirement to retrieve scale price information from Purchasing Info Records using a CDS view. 

Note: "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Open "View Browser" app.
  2. Check CDS view for Purchasing Info records - Scale Price.

Cause

There is no direct CDS view available to retrieve scale prices, as scale pricing depends on the condition record number associated with a condition type in the Purchasing Info Record.

Resolution

There is no direct CDS view available to retrieve scale prices directly from the Purchasing Info Record, but this can be achieved using a combination of two CDS views:

  1. C_PURCHASINGINFORECORDDEX – Data Extraction for Purchasing Info Record

  2. I_PURGPRCGCNDNRECORDSCALE – Pricing Scale in Purchasing

To retrieve the condition record number and its associated scale pricing, follow these steps:

  1. Use the CDS view C_PURGINFORECDPRICECNDNDEX.

    • Input the Purchasing Info Record number.

    • This view will return the relevant Condition Record Number associated with the price condition.

  2. After obtaining the Condition Record Number, use the CDS view I_PURGPRCGCNDNRECORDSCALE.

    • Pass the retrieved Condition Record Number as input.

    • This view will provide the corresponding scale pricing details.

See Also

https://api.sap.com/products/SAPS4HANACloud/onstackextensibility/cdsviews

Keywords

CDS View, Scale Price, CDS, Purchasing Info Records, PIR, Condition Scale Price, Scale , KBA , MM-FIO-PUR-IR-2CL , Fiori UI for Manage Info Records (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions