P_MatlInvtryLdgrQtyStructure

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

Inventory Ledger View

P_MatlInvtryLdgrQtyStructure is a Composite CDS View that provides data about "Inventory Ledger View" in SAP S/4HANA. It reads from 1 data source (P_InventoryLedger) and exposes 29 fields. It has 1 association to related views. Part of development package FCML4H_DISPLAY.

Data Sources (1)

SourceAliasJoin Type
P_InventoryLedger P_InventoryLedger from

Parameters (2)

NameTypeDefault
P_FromFiscalYearPeriod fml_fyearperiod_from
P_ToFiscalYearPeriod fml_fyearperiod_to

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_MatlLedgerValnCrcyRole _LedgerValuationCrcyRole $projection.CurrencyRole = _LedgerValuationCrcyRole.CurrencyRole and $projection.Ledger = _LedgerValuationCrcyRole.Ledger and $projection.CompanyCode = _LedgerValuationCrcyRole.CompanyCode

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED 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
FromFiscalYearPeriod FromFiscalYearPeriod
ToFiscalYearPeriod ToFiscalYearPeriod
PriceDeterminationControl PriceDeterminationControl Price Determ.
CostEstimate CostEstimate Cost EstimateNo
Material Material Vehicle Model
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
InventorySpecialStockType InventorySpecialStockType Special Stock Type
InventorySpecialStockTypeName InventorySpecialStockTypeName
Supplier Supplier Supplier
WBSElementExternalID WBSElementExternalID WBS Element External ID
CurrencyRole CurrencyRole Curr./Val. Type
Ledger Ledger Ledger
MaterialLedgerCategory MaterialLedgerCategory
MaterialLedgerCategoryText MaterialLedgerCategoryText
ProcessCategory ProcessCategory
ProcessCategoryName ProcessCategoryName
TotalVltdStockQuantity TotalVltdStockQuantity
ValuationQuantityUnit ValuationQuantityUnit
InventoryAmtInDspCrcy InventoryAmtInDspCrcy
InvtryTransacAmtInDisplayCrcy InvtryTransacAmtInDisplayCrcy
PriceDiffAmtInDisplayCrcy PriceDiffAmtInDisplayCrcy
ExchRateDiffAmtInDspCurrency ExchRateDiffAmtInDspCurrency
Currency Currency Valuation Crcy
CompanyCode CompanyCode Receiver Company Code
ControllingArea ControllingArea Controlling Area
ControllingValuationType _LedgerValuationCrcyRole AccountingValuationView

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_MatlInvtryLdgrQtyStructure.
-- 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_MatlInvtryLdgrQtyStructure AS
SELECT
  FromFiscalYearPeriod,
  ToFiscalYearPeriod,
  PriceDeterminationControl,
  CostEstimate,
  Material,
  ValuationArea,
  InventoryValuationType,
  SalesOrder,
  SalesOrderItem,
  InventorySpecialStockType,
  InventorySpecialStockTypeName,
  Supplier,
  WBSElementExternalID,
  CurrencyRole,
  Ledger,
  MaterialLedgerCategory,
  MaterialLedgerCategoryText,
  ProcessCategory,
  ProcessCategoryName,
  TotalVltdStockQuantity,
  ValuationQuantityUnit,
  InventoryAmtInDspCrcy,
  InvtryTransacAmtInDisplayCrcy,
  PriceDiffAmtInDisplayCrcy,
  ExchRateDiffAmtInDspCurrency,
  Currency,
  CompanyCode,
  ControllingArea,
  _LedgerValuationCrcyRole.AccountingValuationView AS ControllingValuationType
FROM P_InventoryLedger
LEFT OUTER JOIN R_MatlLedgerValnCrcyRole AS _LedgerValuationCrcyRole ON CurrencyRole = _LedgerValuationCrcyRole.CurrencyRole AND Ledger = _LedgerValuationCrcyRole.Ledger AND CompanyCode = _LedgerValuationCrcyRole.CompanyCode  -- association [0..1]
;

Learn More