C_BufferedMRPTypeVH

DDL: C_BUFFEREDMRPTYPEVH SQL: CBUFMRPTYPEVH Type: view CONSUMPTION

MRP Type Value Help for Buffered Materials

C_BufferedMRPTypeVH is a Consumption CDS View that provides data about "MRP Type Value Help for Buffered Materials" in SAP S/4HANA. It reads from 1 data source (I_MRPType) and exposes 5 fields with key field MRPType. It has 3 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_MRPType I_MRPType from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_MRPTypeText _MRPText $projection.MRPType = _MRPText.MRPType and _MRPText.Language = $session.system_language
[0..1] I_MRPProcedure _MRPProcedure $projection.MRPProcedure = _MRPProcedure.MRPProcedure
[1..1] I_MRPProcedureText _MRPProcedureText $projection.MRPProcedure = _MRPProcedureText.MRPProcedure and _MRPProcedureText.Language = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CBUFMRPTYPEVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label MRP Type Value Help for Buffered Materials view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey MRPType view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
Search.searchable true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY MRPType I_MRPType MRPType
MRPTypeName _MRPText MRPTypeName
MRPProcedure I_MRPType MRPProcedure
MRPProcedureName _MRPProcedureText MRPProcedureName
_MRPProcedure _MRPProcedure 
@AbapCatalog.sqlViewName:'CBUFMRPTYPEVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:  #NOT_REQUIRED
@EndUserText.label: 'MRP Type Value Help for Buffered Materials'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@ObjectModel.representativeKey: 'MRPType'

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C
@Search.searchable: true
define view C_BufferedMRPTypeVH 
 as select from I_MRPType
  association [1..1] to I_MRPTypeText      as _MRPText          on  $projection.MRPType = _MRPText.MRPType
                                                                and _MRPText.Language   = $session.system_language
  association [0..1] to I_MRPProcedure     as _MRPProcedure     on  $projection.MRPProcedure = _MRPProcedure.MRPProcedure
  association [1..1] to I_MRPProcedureText as _MRPProcedureText on  $projection.MRPProcedure   = _MRPProcedureText.MRPProcedure
                                                                and _MRPProcedureText.Language = $session.system_language
{

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.3
  key I_MRPType.MRPType,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.3
      _MRPText.MRPTypeName,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.3
      I_MRPType.MRPProcedure,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.3
      _MRPProcedureText.MRPProcedureName,
      
      @UI.hidden: true
      @Consumption.filter.hidden: true
      _MRPProcedure
} where I_MRPType.MRPProcedure = 'C'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MRPPROCEDURETEXT",
"I_MRPTYPE",
"I_MRPTYPETEXT"
],
"ASSOCIATED":
[
"I_MRPPROCEDURE",
"I_MRPPROCEDURETEXT",
"I_MRPTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More