I_MatlTimeDependentStockList

DDL: I_MATLTIMEDEPENDENTSTOCKLIST SQL: IMRPMATTDSKLST Type: view BASIC

Material Time Dependent Stock List

I_MatlTimeDependentStockList is a Basic CDS View that provides data about "Material Time Dependent Stock List" in SAP S/4HANA. It reads from 1 data source (pph_dd_stk) and exposes 24 fields with key fields Material, MRPPlant, MRPArea, StockLevelValidityStartDate. It has 3 associations to related views.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
pph_dd_stk pph_dd_stk from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BufferedMaterialPlant _BufMatPlant $projection.Material = _BufMatPlant.Material and $projection.MRPPlant = _BufMatPlant.Plant
[1..1] I_MaterialMRPArea _MatMRPArea $projection.Material = _MatMRPArea.Material and $projection.MRPPlant = _MatMRPArea.Plant and $projection.MRPArea = _MatMRPArea.MRPArea
[0..1] I_ChangeModeText _ChgModeText $projection.ChangeMode = _ChgModeText.ChangeMode and _ChgModeText.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMRPMATTDSKLST view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material Time Dependent Stock List view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Material matnr
KEY MRPPlant werks
KEY MRPArea berid
KEY StockLevelValidityStartDate date_from
StockLevelValidityEndDate date_to
MaterialSafetyStockQty safety_stock
ReorderThresholdQuantity reorder_point
MaterialMaxStockLevelQuantity max_stock
MaterialTargetStockLvlQuantity target_stock
TargetSupplyDurationInDays target_dos
MaxSupplyDurationInDays max_dos
SafetySupplyDurationInDays safety_dos
BaseUnit stock_unit
ChangeMode change_mode
StockLevelProposalID proposal_id
ProposalVersion prop_ver
ProposalStartDate prop_date_from
CreatedByUser created_by
LastChangedByUser changed_by
CreationDateTime created_time
LastChangeDateTime changed_time
_BufMatPlant _BufMatPlant
_MatMRPArea _MatMRPArea
_ChgModeText _ChgModeText 
@AbapCatalog.sqlViewName: 'IMRPMATTDSKLST'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Material Time Dependent Stock List'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC

define view I_MatlTimeDependentStockList
  as select from pph_dd_stk


  association [1..1] to I_BufferedMaterialPlant as _BufMatPlant on  $projection.Material = _BufMatPlant.Material
                                                                and $projection.MRPPlant = _BufMatPlant.Plant

  association [1..1] to I_MaterialMRPArea       as _MatMRPArea  on  $projection.Material = _MatMRPArea.Material
                                                                and $projection.MRPPlant = _MatMRPArea.Plant
                                                                and $projection.MRPArea  = _MatMRPArea.MRPArea

  association [0..1] to I_ChangeModeText        as _ChgModeText on  $projection.ChangeMode = _ChgModeText.ChangeMode
                                                                and _ChgModeText.Language  = $session.system_language
{
  key matnr          as Material,
  key werks          as MRPPlant,
  key berid          as MRPArea,
  key date_from      as StockLevelValidityStartDate,
      date_to        as StockLevelValidityEndDate,
      safety_stock   as MaterialSafetyStockQty,
      reorder_point  as ReorderThresholdQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      max_stock      as MaterialMaxStockLevelQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      target_stock   as MaterialTargetStockLvlQuantity,
      target_dos     as TargetSupplyDurationInDays,
      max_dos        as MaxSupplyDurationInDays,
      safety_dos     as SafetySupplyDurationInDays,
      @Semantics.unitOfMeasure: true
      stock_unit     as BaseUnit,
      change_mode    as ChangeMode,
      proposal_id    as StockLevelProposalID,
      prop_ver       as ProposalVersion,
      prop_date_from as ProposalStartDate,
      created_by     as CreatedByUser,
      changed_by     as LastChangedByUser,
      created_time   as CreationDateTime,
      changed_time   as LastChangeDateTime,
      _BufMatPlant,
      _MatMRPArea,
      _ChgModeText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PPH_DD_STK"
],
"ASSOCIATED":
[
"I_BUFFEREDMATERIALPLANT",
"I_CHANGEMODETEXT",
"I_MATERIALMRPAREA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More