P_StkOnIntervalBoundaryBasic11

DDL: P_STKONINTERVALBOUNDARYBASIC11 Type: view_entity COMPOSITE

Stock on interval boundry quantity basic view branch 1

P_StkOnIntervalBoundaryBasic11 is a Composite CDS View that provides data about "Stock on interval boundry quantity basic view branch 1" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 22 fields with key fields StockIdentifyingMaterial, Plant, StockIdfgStorageLocation, StockIdentifyingBatch, SpecialStockIdfgSupplier.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord I_MaterialDocumentRecord from

Parameters (1)

NameTypeDefault
P_StartDate sydate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Stock on interval boundry quantity basic view branch 1 view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY StockIdentifyingMaterial StockIdentifyingMaterial
KEY Plant Plant
KEY StockIdfgStorageLocation StockIdfgStorageLocation
KEY StockIdentifyingBatch StockIdentifyingBatch
KEY SpecialStockIdfgSupplier SpecialStockIdfgSupplier
KEY SpecialStockIdfgSalesOrder SpecialStockIdfgSalesOrder
KEY SpecialStockIdfgSalesOrderItem SpecialStockIdfgSalesOrderItem
KEY SpecialStockIdfgWBSElement SpecialStockIdfgWBSElement
KEY SpecialStockIdfgCustomer SpecialStockIdfgCustomer
KEY InventorySpecialStockType InventorySpecialStockType
KEY InventoryStockType InventoryStockType
KEY SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner
KEY ResourceID ResourceID
KEY CompanyCode CompanyCode
KEY CostEstimate CostEstimate
KEY InventoryValuationType InventoryValuationType
KEY IsSupplierStockValuation IsSupplierStockValuation
KEY InventorySpecialStockValnType InventorySpecialStockValnType
KEY MaterialBaseUnit MaterialBaseUnit
KEY Currency CompanyCodeCurrency
MatlWrhsStkQtyOnStartDate MatlStkChangeQtyInBaseUnit
MatlWrhsStkQtyOnEndDate MatlStkChangeQtyInBaseUnit 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Stock on interval boundry quantity basic view branch 1'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@VDM:
      {
        viewType: #COMPOSITE,
        private: true
      }
define view entity P_StkOnIntervalBoundaryBasic11
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_StartDate : sydate
  as select from I_MaterialDocumentRecord

{
  // Stock Identifier

  key StockIdentifyingMaterial,
  key Plant,
  key StockIdfgStorageLocation,
  key StockIdentifyingBatch,
  key SpecialStockIdfgSupplier,
  key SpecialStockIdfgSalesOrder,
  key SpecialStockIdfgSalesOrderItem,
  key SpecialStockIdfgWBSElement,
  key SpecialStockIdfgCustomer,
  key InventorySpecialStockType,
  key InventoryStockType,
  key SpecialStockIdfgStockOwner,
  key ResourceID,

  // Further Stock Groups

  key CompanyCode,
  key CostEstimate,

  // fields for derivation of stock values

  key InventoryValuationType,
  key IsSupplierStockValuation,
  key InventorySpecialStockValnType,

  // unit

  key MaterialBaseUnit,
  key CompanyCodeCurrency           as Currency,

  // Quantities

  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  MatlStkChangeQtyInBaseUnit as MatlWrhsStkQtyOnStartDate,

  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  MatlStkChangeQtyInBaseUnit as MatlWrhsStkQtyOnEndDate
  
}
where
      MaterialBaseUnit <> '' // value only material does not have meins

  and InventoryStockType <> ''
  and PostingDate      <= $parameters.P_StartDate

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

Learn More