P_DMVCNodeAttribute

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

CREATE VIEW P_DMVCNodeAttribute AS
SELECT
  CostEstimate,
  DMVCNodeType,
  case when _Node.NodeName is null or _Node.NodeName = '' then _ProcessCategoryText.ProcessCategoryName else _Node.NodeName end as NodeName AS NodeNameendasNodeName,
  ProcessCategory,
  Shape,
  Plant,
  ValuationArea,
  InventoryValuationType,
  CompanyCode,
  MaterialName AS MaterialDescription,
  MaterialProcurementType,
  _ProcurementTypeText.MaterialProcurementTypeName AS MaterialProcurementTypeName,
  MaterialType,
  MaterialTypeName,
  MaterialValuationClass,
  cast( MaterialConsumptionQty as fml_dmvc_shown_cons_qty) AS ShownConsumptionQty,
  _Node.ValuationQuantityUnit AS ValuationQuantityUnitInternal,
  _UoM.UnitOfMeasure_E AS ValuationQuantityUnit,
  cast( MaterialConsumptionValue as fml_dmvc_shown_cons_value) AS ShownConsumptionValue,
  Currency,
  LedgerValuationCurrencyRole,
  max(ProfitCenter) AS ProfitCenter,
  ProfitCenterMD,
  SalesDocument,
  SalesDocumentItem,
  WBSElement,
  Supplier,
  SourceLedger,
  SourceCompanyCode,
  max( all AccountingDocument) AS AccountingDocument,
  max( all LedgerGLLineItem) AS LedgerGLLineItem,
  max(Timestamp) AS Timestamp
FROM P_DMVCMaterialActivityNode
LEFT OUTER JOIN P_MLProcessCategoryText AS _ProcessCategoryText ON _ProcessCategoryText.ProcessCategory = _Node.DMVCNodeType AND _ProcessCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MatlProcurementTypeText AS _ProcurementTypeText ON _ProcurementTypeText.MaterialProcurementType = _Node.MaterialProcurementType AND _ProcurementTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UoM ON ValuationQuantityUnitInternal = _UoM.UnitOfMeasure  -- association [0..1]
;