I_TimeDependentStockLevel

DDL: I_TIMEDEPENDENTSTOCKLEVEL Type: view_entity BASIC

Time Dependent Stock Level

I_TimeDependentStockLevel is a Basic CDS View that provides data about "Time Dependent Stock Level" in SAP S/4HANA. It reads from 1 data source (pph_dd_stk) and exposes 22 fields with key fields Product, Plant, MRPArea, StockLevelValidityStartDate. It has 1 association to related views.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
pph_dd_stk pph_dd_stk from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Product _Product _Product.Product = $projection.Product

Annotations (9)

NameValueLevelField
EndUserText.label Time Dependent Stock Level view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Product matnr
KEY Plant werks
KEY MRPArea berid
KEY StockLevelValidityStartDate date_from
StockLevelValidityEndDate date_to
ProductSafetyStockLvlQuantity safety_stock
ReorderThresholdQuantity reorder_point
ProductMaxStockLevelQuantity max_stock
ProductTargetStockLvlQuantity target_stock
BaseUnit stock_unit
TargetSupplyDurationInDays target_dos
MaxSupplyDurationInDays max_dos
SafetySupplyDurationInDays safety_dos
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
_Product _Product 
@EndUserText.label: 'Time Dependent Stock Level'
@AccessControl: {authorizationCheck: #CHECK,
                personalData.blocking: #NOT_REQUIRED}
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE,
                                      #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET]
@ObjectModel.modelingPattern: #NONE

define view entity I_TimeDependentStockLevel
  as select from pph_dd_stk
  
  association [1..1] to I_Product  as _Product on _Product.Product = $projection.Product
{

  key matnr          as Product,
  key werks          as Plant,
  key berid          as MRPArea,
  key date_from      as StockLevelValidityStartDate,
      date_to        as StockLevelValidityEndDate,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      safety_stock   as ProductSafetyStockLvlQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      reorder_point  as ReorderThresholdQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      max_stock      as ProductMaxStockLevelQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      target_stock   as ProductTargetStockLvlQuantity,
      //@Semantics.unitOfMeasure: true

      stock_unit     as BaseUnit,
      
       /* PP/DS specific fields */
      target_dos     as TargetSupplyDurationInDays,
      max_dos        as MaxSupplyDurationInDays,
      safety_dos     as SafetySupplyDurationInDays,

       /* Decribes how the entry got created*/
      change_mode    as ChangeMode,
      
      /* DDMRP specific fields */
      proposal_id    as StockLevelProposalID,
      prop_ver       as ProposalVersion,
      prop_date_from as ProposalStartDate,
      
       /* Administrative fields */
      created_by     as CreatedByUser,
      changed_by     as LastChangedByUser,
      created_time   as CreationDateTime,
      changed_time   as LastChangeDateTime,
      
      _Product                                          //exposed for DCL purpose


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

Learn More