P_InvtryTransBsdWithMvtAggr

DDL: P_INVTRYTRANSBSDWITHMVTAGGR Type: view_entity COMPOSITE Package: FCML4H_DISPLAY
29 Fields 1 Data Sources

Aggragated transactional based inventory with movement

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

Data Sources (1)

SourceAliasJoin Type
P_InvtryTransBsdWithMvt P_InvtryTransBsdWithMvt 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 (29)

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
MovementType MovementType Movement Type
GoodsMovementTypeName GoodsMovementTypeName
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_InvtryTransBsdWithMvtAggr.
-- 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_InvtryTransBsdWithMvtAggr AS
SELECT
  PriceDeterminationControl,
  CostEstimate,
  Material,
  FiscalYearPeriod,
  ValuationArea,
  InventoryValuationType,
  SalesOrder,
  SalesOrderItem,
  InventorySpecialStockType,
  Supplier,
  WBSElementExternalID,
  CurrencyRole,
  Ledger,
  MaterialLedgerCategory,
  MatlLdgrDocIsCostingRelevant,
  ProcessCategory,
  MovementType,
  GoodsMovementTypeName,
  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_InvtryTransBsdWithMvt
;

Learn More