P_MATLSTKPERDSBACKFRMKEYDTE

CDS View

Backward periods before key date

P_MATLSTKPERDSBACKFRMKEYDTE is a CDS View in S/4HANA. Backward periods before key date. 8 CDS views read from this table.

Used by 8 CDS view(s)

CDS Views using this table (8)

ViewTypeJoinVDMDescription
P_SlowMoMatPredMatDocUnion view_entity from COMPOSITE Material Document Union
P_SlowMoMatPredMatDocUnion view_entity union_all COMPOSITE Material Document Union
P_SlowMoMatPrMoMatDocUnion view_entity from COMPOSITE Material Document Union
P_SlowMoMatPrMoMatDocUnion view_entity union_all COMPOSITE Material Document Union
P_SlowMoMatTmeSersBOMCross view_entity from COMPOSITE SlowNonMovingMaterials: BOM Usage
P_SlowMoMatTmeSersBOMPlant view_entity from COMPOSITE SlowNonMovingMaterials: BOM Usage
P_SlowOrNonMovingMatlTme view_entity from COMPOSITE Slow or Non-Moving Materials Time Series (Union)
P_SlowOrNonMovingMatlTme view_entity union_all COMPOSITE Slow or Non-Moving Materials Time Series (Union) 
@AccessControl.authorizationCheck:#NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view entity P_MatlStkPerdsBackFrmKeyDte
  with parameters
    P_KeyDate : nsdm_reference_date
   as select from P_MatlStkPerdsInMonthRef(P_KeyDate: $parameters.P_KeyDate)
{
  key concat(CalendarYear, CalendarMonth) as YearPeriod,
  key CalendarYear,
  key CalendarMonth,   
  StartDate,  
  EndDate,
  KeyDatePlus1,
  ReferenceDate,
  StartDateOfReferencePeriod 
  
  }
  where EndDate < KeyDatePlus1
//where EndDate < $parameters.P_KeyDate 

  and EndDate >= ReferenceDate

Learn More