P_InventoryRevaluationPosting

DDL: P_INVENTORYREVALUATIONPOSTING Type: view_entity COMPOSITE Package: FCML4H_DISPLAY
26 Fields 2 Data Sources 2 Associations

Inventory revaluation posting

P_InventoryRevaluationPosting is a Composite CDS View that provides data about "Inventory revaluation posting" in SAP S/4HANA. It reads from 2 data sources (P_InvtryLdgrMatlLedgerDocument, P_MaterialWithActualCosting) and exposes 26 fields. It has 2 associations to related views. Part of development package FCML4H_DISPLAY.

Data Sources (2)

SourceAliasJoin Type
P_InvtryLdgrMatlLedgerDocument MaterialLedgerDocument from
P_MaterialWithActualCosting MaterialWithActualCosting inner

Parameters (1)

NameTypeDefault
P_FromFiscalYearPeriod fml_fyearperiod_from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MaterialLedgerCategoryTxt _MaterialLedgerCategory $projection.MaterialLedgerCategory = _MaterialLedgerCategory.MaterialLedgerCategory and _MaterialLedgerCategory.Language = $session.system_language
[0..1] P_MLProcessCategoryText _MLProcessCategory $projection.ProcessCategory = _MLProcessCategory.ProcessCategory and _MLProcessCategory.Language = $session.system_language

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 (26)

KeyFieldSource TableSource FieldDescription
PriceDeterminationControl P_MaterialWithActualCosting PriceDeterminationControl Price Determ.
CostEstimate P_InvtryLdgrMatlLedgerDocument CostEstimate Cost EstimateNo
Material P_MaterialWithActualCosting Material Vehicle Model
ValuationArea P_MaterialWithActualCosting ValuationArea Valuation Area
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
InventorySpecialStockTypeName P_MaterialWithActualCosting InventorySpecialStockTypeName
Supplier P_MaterialWithActualCosting Supplier Supplier
WBSElementExternalID
CurrencyRole P_InvtryLdgrMatlLedgerDocument CurrencyRole Curr./Val. Type
Ledger P_InvtryLdgrMatlLedgerDocument Ledger Ledger
MaterialLedgerCategory P_InvtryLdgrMatlLedgerDocument MaterialLedgerCategory Category
MaterialLedgerCategoryText _MaterialLedgerCategory MaterialLedgerCategoryText
ProcessCategory P_InvtryLdgrMatlLedgerDocument ProcessCategory Visibility (I/E/V/C)
ProcessCategoryName _MLProcessCategory ProcessCategoryName
TotalVltdStockQuantity
ValuationQuantityUnit P_InvtryLdgrMatlLedgerDocument ValuationQuantityUnit Valuation Unit
InvtryTransacAmtInDisplayCrcy
PriceDiffAmtInDisplayCrcy
ExchRateDiffAmtInDspCurrency
Currency P_InvtryLdgrMatlLedgerDocument Currency Valuation Crcy
CompanyCode P_MaterialWithActualCosting CompanyCode Receiver Company Code
ControllingArea P_MaterialWithActualCosting ControllingArea Controlling Area
FiscalYearPeriod P_InvtryLdgrMatlLedgerDocument FiscalYearPeriod Period/Year

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_InventoryRevaluationPosting.
-- 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

CREATE VIEW P_InventoryRevaluationPosting AS
SELECT
  MaterialWithActualCosting.PriceDeterminationControl AS PriceDeterminationControl,
  MaterialLedgerDocument.CostEstimate AS CostEstimate,
  MaterialWithActualCosting.Material AS Material,
  MaterialWithActualCosting.ValuationArea AS ValuationArea,
  MaterialWithActualCosting.InventoryValuationType AS InventoryValuationType,
  MaterialWithActualCosting.SalesOrder AS SalesOrder,
  MaterialWithActualCosting.SalesOrderItem AS SalesOrderItem,
  MaterialWithActualCosting.InventorySpecialStockType AS InventorySpecialStockType,
  MaterialWithActualCosting.InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  MaterialWithActualCosting.Supplier AS Supplier,
  MaterialWithActualCosting._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  MaterialLedgerDocument.CurrencyRole AS CurrencyRole,
  MaterialLedgerDocument.Ledger AS Ledger,
  MaterialLedgerDocument.MaterialLedgerCategory AS MaterialLedgerCategory,
  _MaterialLedgerCategory.MaterialLedgerCategoryText AS MaterialLedgerCategoryText,
  MaterialLedgerDocument.ProcessCategory AS ProcessCategory,
  _MLProcessCategory.ProcessCategoryName AS ProcessCategoryName,
  sum( MaterialLedgerDocument.TotalVltdStockQuantity ) AS TotalVltdStockQuantity,
  MaterialLedgerDocument.ValuationQuantityUnit AS ValuationQuantityUnit,
  sum( MaterialLedgerDocument.InventoryAmtInCCCrcy ) AS InvtryTransacAmtInDisplayCrcy,
  sum( MaterialLedgerDocument.PriceDiffAmtInDisplayCrcy ) AS PriceDiffAmtInDisplayCrcy,
  sum( MaterialLedgerDocument.ExchRateDiffAmtInDspCurrency ) AS ExchRateDiffAmtInDspCurrency,
  MaterialLedgerDocument.Currency AS Currency,
  MaterialWithActualCosting.CompanyCode AS CompanyCode,
  MaterialWithActualCosting.ControllingArea AS ControllingArea,
  MaterialLedgerDocument.FiscalYearPeriod AS FiscalYearPeriod
FROM P_InvtryLdgrMatlLedgerDocument AS MaterialLedgerDocument
INNER JOIN P_MaterialWithActualCosting AS MaterialWithActualCosting ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialLedgerCategoryTxt AS _MaterialLedgerCategory ON MaterialLedgerCategory = _MaterialLedgerCategory.MaterialLedgerCategory AND _MaterialLedgerCategory.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_MLProcessCategoryText AS _MLProcessCategory ON ProcessCategory = _MLProcessCategory.ProcessCategory AND _MLProcessCategory.Language = $session.system_language  -- association [0..1]
;

Learn More