P_MatlDocByInvtryTimeSeriesKey

DDL: P_MATLDOCBYINVTRYTIMESERIESKEY SQL: PMATBINVTMSERK Type: view CONSUMPTION

MATDOC keys for inventory time series

P_MatlDocByInvtryTimeSeriesKey is a Consumption CDS View that provides data about "MATDOC keys for inventory time series" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 8 fields with key fields Plant, StockIdentifyingMaterial, InventoryValuationType, InventoryStockType, InventorySpecialStockType.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord I_MaterialDocumentRecord from

Parameters (2)

NameTypeDefault
P_StartDate vdm_v_start_date
P_EndDate vdm_v_end_date

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PMATBINVTMSERK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label MATDOC keys for inventory time series view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Plant Plant
KEY StockIdentifyingMaterial StockIdentifyingMaterial
KEY InventoryValuationType InventoryValuationType
KEY InventoryStockType InventoryStockType
KEY InventorySpecialStockType InventorySpecialStockType
KEY MaterialBaseUnit MaterialBaseUnit
KEY CompanyCode CompanyCode
KEY FiscalYearVariant FiscalYearVariant 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PMATBINVTMSERK'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'MATDOC keys for inventory time series'
@VDM.private: true
@VDM.viewType: #CONSUMPTION
define view P_MatlDocByInvtryTimeSeriesKey
with parameters
    P_StartDate:     vdm_v_start_date,
    @Environment.systemField: #SYSTEM_DATE
    P_EndDate:     vdm_v_end_date
as select from I_MaterialDocumentRecord {
    key Plant,
    key StockIdentifyingMaterial,
    key InventoryValuationType,
    key InventoryStockType,
    key InventorySpecialStockType,
    key MaterialBaseUnit,
    key CompanyCode,
    key FiscalYearVariant
}
where PostingDate >= $parameters.P_StartDate and PostingDate <= $parameters.P_EndDate
group by Plant, StockIdentifyingMaterial, InventoryValuationType, InventoryStockType,
InventorySpecialStockType, MaterialBaseUnit, CompanyCode, FiscalYearVariant

Learn More