P_InvtryTransBsdWOMvt

DDL: P_INVTRYTRANSBSDWOMVT Type: view_entity COMPOSITE Package: FCML4H_DISPLAY
27 Fields 2 Data Sources

Transactional based inventory without movement

P_InvtryTransBsdWOMvt is a Composite CDS View that provides data about "Transactional based inventory without movement" in SAP S/4HANA. It reads from 2 data sources (P_MaterialLedgerDocument, P_MaterialWithActualCosting) and exposes 27 fields with key fields PriceDeterminationControl, CostEstimate, ValuationArea, CurrencyRole, Ledger. Part of development package FCML4H_DISPLAY.

Data Sources (2)

SourceAliasJoin Type
P_MaterialLedgerDocument MaterialLedgerDocument from
P_MaterialWithActualCosting MaterialWithActualCosting inner

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
KEY PriceDeterminationControl P_MaterialWithActualCosting PriceDeterminationControl Price Determ.
KEY CostEstimate P_MaterialLedgerDocument CostEstimate Cost EstimateNo
KEY ValuationArea P_MaterialWithActualCosting ValuationArea Valuation Area
KEY CurrencyRole P_MaterialLedgerDocument LedgerValuationCurrencyRole Valuation Area
KEY Ledger P_MaterialLedgerDocument Ledger Ledger
KEY MaterialLedgerCategory P_MaterialLedgerDocument categ Category
KEY MatlLdgrDocIsCostingRelevant P_MaterialLedgerDocument xabr Costing Doc.
KEY ProcessCategory P_MaterialLedgerDocument ProcessCategory Visibility (I/E/V/C)
KEY GLAccount P_MaterialLedgerDocument kstar Settlement CE
KEY ProcurementAlternative P_MaterialLedgerDocument ProcurementAlternative PrcrmntAlt/Proc
KEY ProductionProcess P_MaterialLedgerDocument ProductionProcess Trans.
FiscalYearPeriod P_MaterialLedgerDocument FiscalYearPeriod Period/Year
Material P_MaterialWithActualCosting Material Vehicle Model
InventoryValuationType P_MaterialWithActualCosting InventoryValuationType Valuation Type
SalesOrder P_MaterialWithActualCosting SalesOrder SD Document
SalesOrderItem P_MaterialWithActualCosting SalesOrderItem Sales Order Item
InventorySpecialStockType P_MaterialWithActualCosting InventorySpecialStockType Special Stock Type
Supplier P_MaterialWithActualCosting Supplier Supplier
WBSElementExternalID
ValuationQuantity P_MaterialLedgerDocument ValuationQuantity Trans. Qty Val. Unit
ValuationQuantityUnit P_MaterialLedgerDocument ValuationQuantityUnit Valuation Unit
InventoryAmtInCCCrcy P_MaterialLedgerDocument InventoryAmtInCCCrcy Trs. Invent. Value
PriceDifferenceAmtInCCCrcy P_MaterialLedgerDocument PriceDifferenceAmtInCCCrcy Price Difference
ExchRateDiffAmtInCoCodeCrcy P_MaterialLedgerDocument ExchRateDiffAmtInCoCodeCrcy Exch.Rate Diff.
Currency P_MaterialLedgerDocument Currency Valuation Crcy
CompanyCode P_MaterialWithActualCosting CompanyCode Receiver Company Code
ControllingArea P_MaterialWithActualCosting 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_InvtryTransBsdWOMvt.
-- 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_InvtryTransBsdWOMvt AS
SELECT
  MaterialWithActualCosting.PriceDeterminationControl AS PriceDeterminationControl,
  MaterialLedgerDocument.CostEstimate AS CostEstimate,
  MaterialWithActualCosting.ValuationArea AS ValuationArea,
  MaterialLedgerDocument.LedgerValuationCurrencyRole AS CurrencyRole,
  MaterialLedgerDocument.Ledger AS Ledger,
  MaterialLedgerDocument.categ AS MaterialLedgerCategory,
  MaterialLedgerDocument.xabr AS MatlLdgrDocIsCostingRelevant,
  MaterialLedgerDocument.ProcessCategory AS ProcessCategory,
  MaterialLedgerDocument.kstar AS GLAccount,
  MaterialLedgerDocument.ProcurementAlternative AS ProcurementAlternative,
  MaterialLedgerDocument.ProductionProcess AS ProductionProcess,
  MaterialLedgerDocument.FiscalYearPeriod AS FiscalYearPeriod,
  MaterialWithActualCosting.Material AS Material,
  MaterialWithActualCosting.InventoryValuationType AS InventoryValuationType,
  MaterialWithActualCosting.SalesOrder AS SalesOrder,
  MaterialWithActualCosting.SalesOrderItem AS SalesOrderItem,
  MaterialWithActualCosting.InventorySpecialStockType AS InventorySpecialStockType,
  MaterialWithActualCosting.Supplier AS Supplier,
  MaterialWithActualCosting._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  MaterialLedgerDocument.ValuationQuantity AS ValuationQuantity,
  MaterialLedgerDocument.ValuationQuantityUnit AS ValuationQuantityUnit,
  MaterialLedgerDocument.InventoryAmtInCCCrcy AS InventoryAmtInCCCrcy,
  MaterialLedgerDocument.PriceDifferenceAmtInCCCrcy AS PriceDifferenceAmtInCCCrcy,
  MaterialLedgerDocument.ExchRateDiffAmtInCoCodeCrcy AS ExchRateDiffAmtInCoCodeCrcy,
  MaterialLedgerDocument.Currency AS Currency,
  MaterialWithActualCosting.CompanyCode AS CompanyCode,
  MaterialWithActualCosting.ControllingArea AS ControllingArea
FROM P_MaterialLedgerDocument AS MaterialLedgerDocument
INNER JOIN P_MaterialWithActualCosting AS MaterialWithActualCosting ON /* join condition not captured in parsed metadata */
;

Learn More