P_InvtryTransBsdWOMvtAggr

DDL: P_INVTRYTRANSBSDWOMVTAGGR Type: view_entity COMPOSITE Package: FCML4H_DISPLAY
27 Fields 1 Data Sources

Aggragated transactional based inventory without movement

P_InvtryTransBsdWOMvtAggr is a Composite CDS View that provides data about "Aggragated transactional based inventory without movement" in SAP S/4HANA. It reads from 1 data source (P_InvtryTransBsdWOMvt) and exposes 27 fields. Part of development package FCML4H_DISPLAY.

Data Sources (1)

SourceAliasJoin Type
P_InvtryTransBsdWOMvt P_InvtryTransBsdWOMvt from

Parameters (2)

NameTypeDefault
P_FromFiscalYearPeriod fml_fyearperiod_from
P_ToFiscalYearPeriod fml_fyearperiod_to

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (27)

KeyFieldSource TableSource FieldDescription
PriceDeterminationControl PriceDeterminationControl Price Determ.
CostEstimate CostEstimate Cost EstimateNo
Material Material Vehicle Model
FiscalYearPeriod FiscalYearPeriod Period/Year
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
InventorySpecialStockType InventorySpecialStockType Special Stock Type
Supplier Supplier Supplier
WBSElementExternalID WBSElementExternalID WBS Element External ID
CurrencyRole CurrencyRole Curr./Val. Type
Ledger Ledger Ledger
MaterialLedgerCategory MaterialLedgerCategory Category
MatlLdgrDocIsCostingRelevant MatlLdgrDocIsCostingRelevant Costing Doc.
ProcessCategory ProcessCategory
GLAccount GLAccount General Ledger
ProcurementAlternative ProcurementAlternative
ProductionProcess ProductionProcess
TotalVltdStockQuantity
ValuationQuantityUnit ValuationQuantityUnit
InvtryTransacAmtInDisplayCrcy
PriceDiffAmtInDisplayCrcy
ExchRateDiffAmtInDspCurrency
Currency Currency Valuation Crcy
CompanyCode CompanyCode Receiver Company Code
ControllingArea ControllingArea Controlling Area

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_InvtryTransBsdWOMvtAggr.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_FromFiscalYearPeriod : fml_fyearperiod_from, P_ToFiscalYearPeriod : fml_fyearperiod_to

CREATE VIEW P_InvtryTransBsdWOMvtAggr AS
SELECT
  PriceDeterminationControl,
  CostEstimate,
  Material,
  FiscalYearPeriod,
  ValuationArea,
  InventoryValuationType,
  SalesOrder,
  SalesOrderItem,
  InventorySpecialStockType,
  Supplier,
  WBSElementExternalID,
  CurrencyRole,
  Ledger,
  MaterialLedgerCategory,
  MatlLdgrDocIsCostingRelevant,
  ProcessCategory,
  GLAccount,
  ProcurementAlternative,
  ProductionProcess,
  sum( ValuationQuantity ) AS TotalVltdStockQuantity,
  ValuationQuantityUnit,
  sum( InventoryAmtInCCCrcy ) AS InvtryTransacAmtInDisplayCrcy,
  sum( PriceDifferenceAmtInCCCrcy ) AS PriceDiffAmtInDisplayCrcy,
  sum( ExchRateDiffAmtInCoCodeCrcy ) AS ExchRateDiffAmtInDspCurrency,
  Currency,
  CompanyCode,
  ControllingArea
FROM P_InvtryTransBsdWOMvt
;

Learn More