Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_UtilsDiscountVH

DDL: C_UTILSDISCOUNTVH SQL: CPSUTILDISCNTVH Type: view CONSUMPTION

Discount for UPIL Product Type Value Help

C_UtilsDiscountVH is a Consumption CDS View that provides data about "Discount for UPIL Product Type Value Help" in SAP S/4HANA. It reads from 1 data source (I_UtilsFact) and exposes 7 fields with key field UtilsOperandMappingID.

Data Sources (1)

SourceAliasJoin Type
I_UtilsFact I_UtilsFact from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPSUTILDISCNTVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
EndUserText.label Discount for UPIL Product Type Value Help view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey UtilsOperandMappingID view
VDM.lifecycle.status #DEPRECATED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY UtilsOperandMappingID UtilsOperandMappingID Mapping ID
UtilsProductType UtilsProductType Product Type Group
UtilsSemanticsName1 I_UtilsFact UtilsSemanticsName1 Semantics Name 1
UtilsSemanticsName2 I_UtilsFact UtilsSemanticsName2 Semantics Name 2
UtilsBillingOperandDesc _UtilsOperand UtilsBillingOperandDesc
UtilsMeasurementUnit _UtilsOperand UtilsMeasurementUnit
UtilsOperandCategory _UtilsOperand UtilsOperandCategory

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_UtilsDiscountVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CPSUTILDISCNTVH

CREATE VIEW C_UtilsDiscountVH AS
SELECT
  UtilsOperandMappingID,
  UtilsProductType,
  I_UtilsFact.UtilsSemanticsName1 AS UtilsSemanticsName1,
  I_UtilsFact.UtilsSemanticsName2 AS UtilsSemanticsName2,
  _UtilsOperand.UtilsBillingOperandDesc AS UtilsBillingOperandDesc,
  _UtilsOperand.UtilsMeasurementUnit AS UtilsMeasurementUnit,
  _UtilsOperand.UtilsOperandCategory AS UtilsOperandCategory
FROM I_UtilsFact
;