C_ProductObjPgVariantCharcValn

DDL: C_PRODUCTOBJPGVARIANTCHARCVALN SQL: CPRODOBJPGVARCHV Type: view CONSUMPTION

Product Object Page - Variant Characteristic Valuation

C_ProductObjPgVariantCharcValn is a Consumption CDS View that provides data about "Product Object Page - Variant Characteristic Valuation" in SAP S/4HANA. It reads from 1 data source (I_ProductVariantCharcValuation) and exposes 13 fields with key fields CrossPlantConfigurableProduct, Product, CharacteristicInternalID. It has 2 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductVariantCharcValuation I_ProductVariantCharcValuation from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_ProductObjPg _ProductObjPg $projection.crossplantconfigurableproduct = _ProductObjPg.Product
[1..1] C_ProductObjPgVariant _ProductObjPgVariant $projection.crossplantconfigurableproduct = _ProductObjPgVariant.CrossPlantConfigurableProduct and $projection.Product = _ProductObjPgVariant.Product

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPRODOBJPGVARCHV view
EndUserText.label Product Object Page - Variant Characteristic Valuation view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CrossPlantConfigurableProduct _Product CrossPlantConfigurableProduct
KEY Product Product
KEY CharacteristicInternalID
CharacteristicValue CharacteristicValue
CharacteristicMinimumValue CharacteristicMinimumValue
CharacteristicMinimumValueUnit CharacteristicMinimumValueUnit
CharacteristicMaximumValue CharacteristicMaximumValue
CharacteristicMaximumValueUnit CharacteristicMaximumValueUnit
CharacteristicValueDpndcyCode CharacteristicValueDpndcyCode
CharacteristicBaseUnit CharacteristicBaseUnit
CharacteristicDescription
_ProductObjPg _ProductObjPg
_ProductObjPgVariant _ProductObjPgVariant 
@AbapCatalog.sqlViewName: 'CPRODOBJPGVARCHV'
@EndUserText.label: 'Product Object Page - Variant Characteristic Valuation'

@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
    usageType: {
        serviceQuality: #C,
        sizeCategory: #XXL,
        dataClass: #MASTER
   }
}

define view C_ProductObjPgVariantCharcValn
  as select from I_ProductVariantCharcValuation
  association [1..1] to C_ProductObjPg        as _ProductObjPg        on  $projection.crossplantconfigurableproduct = _ProductObjPg.Product
  association [1..1] to C_ProductObjPgVariant as _ProductObjPgVariant on  $projection.crossplantconfigurableproduct = _ProductObjPgVariant.CrossPlantConfigurableProduct
                                                                      and $projection.Product                       = _ProductObjPgVariant.Product
{
  key _Product.CrossPlantConfigurableProduct,
  key Product,
  key cast(CharacteristicInternalID as numc10 preserving type)                               as CharacteristicInternalID, // avoid output conversion routine in odata service


      CharacteristicValue,
      CharacteristicMinimumValue,
      CharacteristicMinimumValueUnit,
      CharacteristicMaximumValue,
      CharacteristicMaximumValueUnit,
      CharacteristicValueDpndcyCode,
      CharacteristicBaseUnit,

      _CharacteristicText[1: Language=$session.system_language].CharacteristicDescription,
      case when _RetailCharacteristicValue._Text[1: Language=$session.system_language].RetailCharacteristicValueDesc is not null and
                _RetailCharacteristicValue._Text[1: Language=$session.system_language].RetailCharacteristicValueDesc <> ''
           then _RetailCharacteristicValue._Text[1: Language=$session.system_language].RetailCharacteristicValueDesc
           else _CharacteristicValueText[1: Language=$session.system_language].CharacteristicValueDescription
      end                                                                                    as CharacteristicValueDescription,

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _ProductObjPg,
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _ProductObjPgVariant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHARACTERISTICTEXT",
"I_CHARACTERISTICVALUETEXT",
"I_PRODUCT",
"I_PRODUCTVARIANTCHARCVALUATION",
"I_RETAILCHARACTERISTICVALUE",
"I_RETAILCHARACTERISTICVALUET"
],
"ASSOCIATED":
[
"C_PRODUCTOBJPG",
"C_PRODUCTOBJPGVARIANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More