I_DARTMatlInvtryBalanceCube

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 I_DARTMatlInvtryBalanceCube.
-- 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.
-- SQL view name: IDZMIBALSUMC
-- Parameters: P_CalendarDate : fis_budat_to, P_Language : fac_audit_language

CREATE VIEW I_DARTMatlInvtryBalanceCube AS
SELECT
  cast($session.client as char3) AS SAPClient,
  CompanyCode,
  Ledger,
  ValuationArea,
  InventoryValuationType,
  FiscalYear,
  FiscalPeriod,
  InventoryValuationCategory,
  _InventoryValCategoryText.InventoryValuationCategoryName AS InventoryValuationCategoryName,
  MaterialValuationClass,
  _Matlvaluationclasstext.MaterialUsabilityProfileName AS MaterialUsabilityProfileName,
  GLAccount,
  _GLAccountInChartOfAccounts._Text[1: Language = $parameters.P_Language].GLAccountLongName AS GLAccountLongName,
  MaterialGroup,
  _Material._MaterialGroup._Text[1: Language = $parameters.P_Language].MaterialGroupName AS MaterialGroupName,
  Material,
  _Material._Text[1: Language = $parameters.P_Language].MaterialName AS MaterialName,
  Plant,
  _Plant.PlantName AS PlantName,
  InventoryQty,
  BaseUnit,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  _mbew.mypol AS LIFOValuationPoolNumber,
  _mbew.xlifo AS IsLIFOAndFIFORelevant
FROM I_ML_Balance
LEFT OUTER JOIN I_Matlvaluationclasstext AS _Matlvaluationclasstext ON MaterialValuationClass = _Matlvaluationclasstext.MaterialValuationClass AND _Matlvaluationclasstext.Language = $parameters.P_Language  -- association [0..1]
LEFT OUTER JOIN P_T149T AS _InventoryValCategoryText ON InventoryValuationCategory = _InventoryValCategoryText.InventoryValuationCategory AND _InventoryValCategoryText.Language = $parameters.P_Language  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;