C_ProdPlntProcmtProfileVH

DDL: C_PRODPLNTPROCMTPROFILEVH Type: view CONSUMPTION

VH for Special Procurement Profile

C_ProdPlntProcmtProfileVH is a Consumption CDS View that provides data about "VH for Special Procurement Profile" in SAP S/4HANA. It reads from 1 data source (I_MatlProcurementProfile) and exposes 4 fields with key fields CostingSpecialProcurementType, Plant. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_MatlProcurementProfile I_MatlProcurementProfile from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_ProdPlntProcmtProfileText _Text $projection.CostingSpecialProcurementType = _Text.CostingSpecialProcurementType and $projection.Plant = _Text.Plant

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPLNTPROCMPRFL view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label VH for Special Procurement Profile view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
ObjectModel.representativeKey CostingSpecialProcurementType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CostingSpecialProcurementType
KEY Plant Plant
_Text _Text
_Plant _Plant 
@AbapCatalog: {
  sqlViewName: 'CPLNTPROCMPRFL',
  preserveKey: true,
  compiler.compareFilter: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'VH for Special Procurement Profile'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@ObjectModel: {
  representativeKey: 'CostingSpecialProcurementType',
  usageType: {
     dataClass: #CUSTOMIZING,
     serviceQuality: #A,
     sizeCategory: #S
  },
  dataCategory: #VALUE_HELP
}
@Consumption.ranked: true 
define view C_ProdPlntProcmtProfileVH
  as select from I_MatlProcurementProfile
  association [0..*] to C_ProdPlntProcmtProfileText as _Text on  $projection.CostingSpecialProcurementType = _Text.CostingSpecialProcurementType
                                                             and $projection.Plant                         = _Text.Plant
{
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
      @ObjectModel.text.association: '_Text'
  key cast(MaterialProcurementProfile as sobsl preserving type ) as CostingSpecialProcurementType,
      @ObjectModel.foreignKey.association: '_Plant'
  key Plant                                                      as Plant,

      _Text,
      _Plant

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATLPROCUREMENTPROFILE"
],
"ASSOCIATED":
[
"C_PRODPLNTPROCMTPROFILETEXT",
"I_PLANT"
],
"BASE":
[
"I_MATLPROCUREMENTPROFILE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More