P_ProductVariantCharcValuation

DDL: P_PRODUCTVARIANTCHARCVALUATION SQL: PPRDVARCHARCVALN Type: view BASIC

P_ProductVariantCharcValuation is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (mara) and exposes 9 fields with key fields Product, CharacteristicInternalID.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
mara mara from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPRDVARCHARCVALN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Product
KEY CharacteristicInternalID ibsymbol atinn
CharacteristicValue ibsymbol atwrt
CharacteristicMinimumValue ibsymbol atflv
CharacteristicMinimumValueUnit ibinvalues msehi_low
CharacteristicMaximumValue ibsymbol atflb
CharacteristicMaximumValueUnit ibinvalues msehi_high
CharacteristicValueDpndcyCode ibsymbol atcod
CrossPlantConfigurableProduct 
@AbapCatalog.sqlViewName: 'PPRDVARCHARCVALN'

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

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

@VDM.viewType: #BASIC
@VDM.private: true

define view P_ProductVariantCharcValuation
  as select from mara
    join         ibinown    on ibinown.instance = mara.cuobf
    join         ibin       on ibin.instance = ibinown.instance
    join         ibinvalues on ibinvalues.in_recno = ibin.in_recno
    join         ibsymbol   on ibsymbol.symbol_id = ibinvalues.symbol_id
{
  key cast(mara.matnr as productnumber preserving type)                    as Product,
  key ibsymbol.atinn                                                       as CharacteristicInternalID,

      ibsymbol.atwrt                                                       as CharacteristicValue,
      ibsymbol.atflv                                                       as CharacteristicMinimumValue,
      ibinvalues.msehi_low                                                 as CharacteristicMinimumValueUnit,
      ibsymbol.atflb                                                       as CharacteristicMaximumValue,
      ibinvalues.msehi_high                                                as CharacteristicMaximumValueUnit,
      ibsymbol.atcod                                                       as CharacteristicValueDpndcyCode,

      cast(mara.satnr as crossplantconfigurableproduct preserving type)    as CrossPlantConfigurableProduct
}
where
  satnr != ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"IBIN",
"IBINOWN",
"IBINVALUES",
"IBSYMBOL",
"MARA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More