P_DMVCNode

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_DMVCNode.
-- 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: PDMVCNODEDATA
-- Parameters: P_DateFrom : calendardate, P_DateTo : calendardate, P_CurrencyType : curtp, P_Ledger : rldnr

CREATE VIEW P_DMVCNode AS
SELECT
  _MaterialValuation.CostEstimate AS CostEstimate,
  ProcessCategory,
  _MaterialValuation.Material AS Material,
  _MaterialValuation.Plant AS Plant,
  _MaterialValuation.InventoryValuationType AS InventoryValuationType,
  _MaterialValuation.CompanyCode AS CompanyCode,
  _MaterialValuation.MaterialName AS MaterialName,
  _MaterialValuation.MaterialProcurementType AS MaterialProcurementType,
  _MaterialValuation.MaterialType AS MaterialType,
  _MaterialValuation.MaterialTypeName AS MaterialTypeName,
  _MaterialValuation.MaterialValuationClass AS MaterialValuationClass,
  cast('' as nodename) AS ObjectInternalID,
  _MaterialValuation.ValuationQuantity AS ValuationQuantity,
  _MaterialValuation.ValuationQuantityUnit AS ValuationQuantityUnit,
  _MaterialValuation.InventoryAmtInCCCrcy AS InventoryAmtInCCCrcy,
  _MaterialValuation.Currency AS Currency,
  _MaterialValuation.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  _MaterialValuation.ProfitCenter AS ProfitCenter,
  _MaterialValuation.ProfitCenterMD AS ProfitCenterMD,
  _MaterialValuation.ValuationArea AS ValuationArea,
  cast('' as awref) AS ReferenceDocument,
  _MaterialValuation.MaterialConsumptionQty AS MaterialConsumptionQty,
  _MaterialValuation.MaterialConsumptionValue AS MaterialConsumptionValue,
  cast('' as rldnr) AS Ledger,
  _MaterialValuation.SalesDocument AS SalesDocument,
  cast(_MaterialValuation.SalesDocumentItem as posnr_char) AS SalesDocumentItem,
  cast(_MaterialValuation.WBSElement as ps_posid) AS WBSElement,
  _MaterialValuation.Supplier AS Supplier,
  SourceLedger,
  SourceCompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Timestamp,
  cast('' as fis_kostl_name ) AS CostCenterName,
  cast('' as ktext) AS CostCtrActivityTypeName,
  cast('' as ktext) as BusinessProcessName AS P_DateFrom,
  P_DateTo :$parameters.P_DateTo AS P_DateTo,
  P_CurrencyType :$parameters.P_CurrencyType AS P_CurrencyType,
  case when _Activity.CostCtrActivityTypeName is not initial then cast (concat (concat (_Activity.CostCenter, '/'), _Activity.CostCtrActivityType ) as nodename) when _Activity.BusinessProcessName is not initial then _Activity.BusinessProcessName end as ObjectInternalID AS BusinessProcessNameendasObjectInternalID,
  cast('' as ktext) AS BusinessProcessName
;