SAP Knowledge Base Article - Preview

2584290 - Initial Value in a Value Help of a CDS Query

Symptom

  • In a CDS query, a parameter is defined with a data type. 
  • The domain of the data type is defined with a list of possible values
  • Run the CDS query, call F4 help of the parameter, in addition of the values defined in the domain, initial value (#) is in the value list.

or

  • In a CDS query, a value help is associated to a field
  • The value help CDS is defined on a table T
  • When call F4 help, in addition of the values in the T, initial value (#) is in the value list

or

  • In a CDS query,  field A is the compounding parent of field B
  • There is a global filter on field A in the where clause
  • Call F4 help for field B, there is no initial value (#) in the value list

or

  • In a CDS query,  field A is the compounding parent of field B
  • There is a hierarchy node filter defined on field B. The hierarchy node (such as the 'not assigned' node) includes value 'a1/#', that is, A=a1 and B=#.
  • In the master data view of B, the value 'a1/#' is not available.
  • In the query result, the value booked to 'a1/#' is not included in the node level 


Read more...

Environment

SAP NetWeaver 750 SP4 and above

Product

SAP BW/4HANA 1.0 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

not assigned , KBA , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , BW-BEX-OT-F4 , MasterData read services , How To

About this page

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

Search for additional results

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