I_MATERIALSHORTAGEDEFINITION

CDS View

MRP Material Shortage Definition

I_MATERIALSHORTAGEDEFINITION is a CDS View in S/4HANA. MRP Material Shortage Definition. It contains 2 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 2 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_MaterialShortageDefinition view from CONSUMPTION MRP Material Shortage Definition
I_CacheMRPMfgOrder view left_outer COMPOSITE Cache MRP Manufacturing Orders
I_MaterialCoverage view left_outer COMPOSITE MRP Material Coverage
I_MaterialSelectionVH view_entity inner COMPOSITE Material Selection ID
P_MRPProdDemandAggregation view left_outer COMPOSITE

Fields (2)

KeyField CDS FieldsUsed in Views
KEY MaterialShortageProfile MaterialShortageProfile 2
KEY MaterialShortageProfileCount MaterialShortageProfileCount 2 
@AbapCatalog.sqlViewName: 'IMATSHORTDEF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'MRP Material Shortage Definition'

@ClientHandling.algorithm: #SESSION_VARIABLE


@ObjectModel: {
    usageType: {serviceQuality: #B, sizeCategory: #M, dataClass: #CUSTOMIZING }
}

@VDM.viewType: #BASIC

define view I_MaterialShortageDefinition
  as select from sdm_msh_prof01

  association [0..1] to sdm_aor_profile  as _ProfileUser             on  _ProfileUser.uname = $session.user   and _ProfileUser.sdm_profile =  $projection.MaterialShortageProfile
  association [0..1] to sdm_aor_profile  as _ProfileStar             on  _ProfileStar.uname = '*'             and _ProfileStar.sdm_profile =  $projection.MaterialShortageProfile
  association [0..*] to sdm_msh_prof01_t as _MaterialShortageDefText on  $projection.MaterialShortageProfile      = _MaterialShortageDefText.materialshortageprofile
                                                                     and $projection.MaterialShortageProfileCount = _MaterialShortageDefText.materialshortageprof_cnt
{
  key sdm_msh_prof01.materialshortageprofile                                                                as MaterialShortageProfile,
  key cast (sdm_msh_prof01.materialshortageprof_cnt as materialshortageprofilecount preserving type)        as MaterialShortageProfileCount,
      sdm_msh_prof01.demandcategorygroup                                                                    as DemandCategoryGroup,
      sdm_msh_prof01.receiptcategorygroup                                                                   as ReceiptCategoryGroup,
      sdm_msh_prof01.sdivevaluationhorizonindays                                                            as EvaluationHorizonInDays,
      _MaterialShortageDefText[ 1: spras = $session.system_language ].materialshortagedefinitionname        as MaterialShortageDefinitionName,
      sdm_msh_prof01.mfgordercomponentcheckrule                                                             as HasMfgOrderComponentCheckRule
}
where
     _ProfileUser.sdm_profile               = sdm_msh_prof01.materialshortageprofile
  or _ProfileStar.sdm_profile               = sdm_msh_prof01.materialshortageprofile
  or sdm_msh_prof01.materialshortageprofile = 'SAP000000001'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SDM_AOR_PROFILE",
"SDM_MSH_PROF01",
"SDM_MSH_PROF01_T"
],
"ASSOCIATED":
[
"SDM_AOR_PROFILE",
"SDM_MSH_PROF01_T"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More