I_MATERIALSHORTAGEDEFINITION

CDS View

MRP Material Shortage Definition

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

Used by 7 CDS view(s) 3 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_MaterialShortageDefinition view from CONSUMPTION MRP Material Shortage Definition
C_MRPExternalRequirement view_entity inner CONSUMPTION MRP External Requirement
C_MRPInternalRequirement view_entity inner CONSUMPTION MRP Internal Requirement
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 Production Demand Aggregation

Fields (3)

KeyField CDS FieldsUsed in Views
KEY MaterialShortageProfile MaterialShortageProfile 2
KEY MaterialShortageProfileCount MaterialShortageProfileCount 2
MaterialShortageDefinitionName MaterialShortageDefinitionName 1 
@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,
      sdm_msh_prof01.uncovereddemandiscalculated                                                            as UncoveredDemandIsCalculated
}
where
     _ProfileUser.sdm_profile               = sdm_msh_prof01.materialshortageprofile
  or _ProfileStar.sdm_profile               = sdm_msh_prof01.materialshortageprofile
  or sdm_msh_prof01.materialshortageprofile = 'SAP000000001'

Learn More