2588590 - Error 'Variable xxx could not be replaced' in a CDS Query (BRAIN 641 or BRAIN632)

Symptom

A CDS query uses @Consumption.derivation to fill a variable/parameter value

Variable XXX could not be replaced. (BRAIN 641)
No value could be determined for variable xxx. (BRAIN 632)

Sample Queries/Variables this is happening for:

BRAIN 641 for Query C_SALESORDERQ2301 with variable !CDS_P_P_LEDGER
BRAIN 641 for Query C_PROFITANDLOSSQ2901 with variable !CDS_P_P_LEDGER
BRAIN 641 for Query C_PROFITCENTERQ2701 with variable !CDS_P_P_LEDGER
BRAIN 641 for Query C_COSTCENTERQ2001 with variable !CDS_P_P_LEDGER

... (See other CDS queries listed in Note 2535903)

BRAIN 632 for Query C_OVERDUEACCTRBLS with variable !CDS_P_P_KEYDATE
No value could be determined for variable !CDS_P_P_STARTDATE (BRAIN632) in C_PurchaseOrderValue and C_PURCHASEORDERVALUEQUERY
...

Environment

SAP NetWeaver 750 SP4 and above

S/4HANA

Product

SAP BW/4HANA all versions ; SAP NetWeaver 7.5 ; SAP S/4HANA 1610 ; SAP S/4HANA 1709 ; SAP S/4HANA 1809 ; SAP S/4HANA 1909 ; SAP S/4HANA, on-premise edition 1511

Keywords

BRAIN641, BRAIN 641, C_SALESORDERQ2301, variable, cds, !CDS_P_P_LEDGER, BRAIN629, C_PROFITANDLOSSQ2901, C_PROFITCENTERQ2701, A000, FINS_FIS_FICO_APPS, BRAIN632, !CDS_P_P_KEYDATE, !CDS_P_P_STARTDATE , KBA , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , CO-OM , Overhead Cost Controlling , BW-BEX-OT-OLAP-VAR , Using Variables , CO-FIO , Fiori UI for Overhead Cost Controlling , CA-FLP-FE-UI , SAP Fiori Launchpad User Interface , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.