C_PFMProductStockDEX

DDL: C_PFMPRODUCTSTOCKDEX Type: view CONSUMPTION

CDI Data Provider for stock inventory BAM data extraction

C_PFMProductStockDEX is a Consumption CDS View (Fact) that provides data about "CDI Data Provider for stock inventory BAM data extraction" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 20 fields with key fields MaterialDocumentKey1, MaterialDocumentKey2, MaterialDocumentKey3, MaterialDocumentKey4, MaterialDocumentKey5.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord I_MaterialDocumentRecord from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CPFMMATSTCKDEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name MaterialDocument view
ObjectModel.modelingPattern #NONE view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #FACT view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label CDI Data Provider for stock inventory BAM data extraction view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocumentKey1 MaterialDocumentKey1
KEY MaterialDocumentKey2 MaterialDocumentKey2
KEY MaterialDocumentKey3 MaterialDocumentKey3
KEY MaterialDocumentKey4 MaterialDocumentKey4
KEY MaterialDocumentKey5 MaterialDocumentKey5
KEY MaterialDocumentKey6 MaterialDocumentKey6
CompanyCode CompanyCode
Plant Plant
Material StockIdentifyingMaterial
StorageLocation StockIdfgStorageLocation
Supplier SpecialStockIdfgSupplier
Customer SpecialStockIdfgCustomer
InventoryStockType InventoryStockType
InventorySpecialStockType InventorySpecialStockType
PostingDate PostingDate
MaterialBaseUnit MaterialBaseUnit
MaterialDocumentYear MaterialDocumentYear
CalendarMonth CalendarMonth
MaterialGroup _StockIdentifyingMaterial MaterialGroup
MatlWrhsStkQtyInMatlBaseUnit 
@AbapCatalog: {
    sqlViewName: 'CPFMMATSTCKDEX',
    compiler.compareFilter: true,
    preserveKey: true
}
@AccessControl: {
     authorizationCheck: #PRIVILEGED_ONLY,
     personalData.blocking: #NOT_REQUIRED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
      usageType: {
         sizeCategory: #XXL,
         serviceQuality: #C,
         dataClass:#TRANSACTIONAL
      },
      sapObjectNodeType.name: 'MaterialDocument',
      supportedCapabilities: [#EXTRACTION_DATA_SOURCE],
      modelingPattern: #NONE
}
@VDM: {
      viewType: #CONSUMPTION,
      lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@Analytics: {
        dataCategory: #FACT,
        internalName: #LOCAL,
        dataExtraction.enabled: true

        //Currently no delta support (change data capture) is required, since this view data is only used via the

        //OData V4 aggregation extension, which always aggregates over the whole dataset.

}
@Metadata: {
        ignorePropagatedAnnotations: true
}

@EndUserText.label: 'CDI Data Provider for stock inventory BAM data extraction'

define view C_PFMProductStockDEX
  as select from I_MaterialDocumentRecord
{
      // Technical key fields

      @Consumption.hidden: true
  key MaterialDocumentKey1,
      @Consumption.hidden: true
  key MaterialDocumentKey2,
      @Consumption.hidden: true
  key MaterialDocumentKey3,
      @Consumption.hidden: true
  key MaterialDocumentKey4,
      @Consumption.hidden: true
  key MaterialDocumentKey5,
      @Consumption.hidden: true
  key MaterialDocumentKey6,

      // Stock Identifier

      CompanyCode,
      Plant,
      StockIdentifyingMaterial                                           as Material,
      StockIdfgStorageLocation                                           as StorageLocation,
      SpecialStockIdfgSupplier                                           as Supplier,
      SpecialStockIdfgCustomer                                           as Customer,
      InventoryStockType,
      InventorySpecialStockType,

      @Semantics.businessDate.at: true
      PostingDate,

      // Units

      @Semantics.unitOfMeasure: true
      MaterialBaseUnit,

      @Semantics.calendar.year: true
      MaterialDocumentYear,
      @Semantics.calendar.month: true
      CalendarMonth,
      _StockIdentifyingMaterial.MaterialGroup,

      // Quantities

      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      @DefaultAggregation : #SUM
      cast(MatlStkChangeQtyInBaseUnit as nsdm_stock_qty preserving type) as MatlWrhsStkQtyInMatlBaseUnit

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

Learn More