C_MaterialShortageDefinition

DDL: C_MATERIALSHORTAGEDEFINITION SQL: CMATSHORTDEF Type: view CONSUMPTION

MRP Material Shortage Definition

C_MaterialShortageDefinition is a Consumption CDS View that provides data about "MRP Material Shortage Definition" in SAP S/4HANA. It reads from 1 data source (I_MaterialShortageDefinition) and exposes 7 fields with key fields MaterialShortageProfile, MaterialShortageProfileCount. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialShortageDefinition I_MaterialShortageDefinition from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_MaterialShortageProfileUser _ProfileUser _ProfileUser.UserID = $session.user and _ProfileUser.MaterialShortageProfile = $projection.MaterialShortageProfile

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMATSHORTDEF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label MRP Material Shortage Definition view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.alternativeKey.uniqueness #UNIQUE view
VDM.viewType #CONSUMPTION view
Search.searchable true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MaterialShortageProfile MaterialShortageProfile
KEY MaterialShortageProfileCount MaterialShortageProfileCount
MaterialShortageDefinition
DemandCategoryGroup DemandCategoryGroup
ReceiptCategoryGroup ReceiptCategoryGroup
EvaluationHorizonInDays EvaluationHorizonInDays
MaterialShortageDefinitionName MaterialShortageDefinitionName 
@AbapCatalog.sqlViewName: 'CMATSHORTDEF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'MRP Material Shortage Definition'

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
    usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #CUSTOMIZING },
    semanticKey:  [ 'MaterialShortageDefinition' ],
    alternativeKey.uniqueness: #UNIQUE,
    alternativeKey.element:  [ 'MaterialShortageDefinition' ]
}

@VDM.viewType: #CONSUMPTION

@Search.searchable: true
define view C_MaterialShortageDefinition
  as select from I_MaterialShortageDefinition
  association [0..1] to P_MaterialShortageProfileUser  as _ProfileUser  on  _ProfileUser.UserID = $session.user and _ProfileUser.MaterialShortageProfile = $projection.MaterialShortageProfile

{
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #MEDIUM
      }
  key MaterialShortageProfile,
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #MEDIUM
      }
  key MaterialShortageProfileCount,
      @ObjectModel.text.element:  [ 'MaterialShortageDefinitionName' ]
      concat(MaterialShortageProfile, MaterialShortageProfileCount) as MaterialShortageDefinition,
      DemandCategoryGroup,
      ReceiptCategoryGroup,
      EvaluationHorizonInDays,
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
      MaterialShortageDefinitionName
}
where _ProfileUser.MaterialShortageProfile               = MaterialShortageProfile
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALSHORTAGEDEFINITION",
"P_MATERIALSHORTAGEPROFILEUSER"
],
"ASSOCIATED":
[
"P_MATERIALSHORTAGEPROFILEUSER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More