P_DMVCECNodeAttribute

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

CREATE VIEW P_DMVCECNodeAttribute AS
SELECT
  CostingReferenceObject,
  ParentProdCostEstNumber,
  ProdCostEstNumber,
  CostingType,
  CostingDate,
  CostingVersion,
  ValuationVariant,
  CostIsEnteredManually,
  CostingItem,
  CostingItemCategory,
  ControllingArea,
  CostingVariant,
  CostComponent,
  Plant,
  P_DMVCECNode.CostElement AS CostElement,
  cast(_CostElement._Text[ 1: Language = $session.system_language ].CostElementName as fml_dmvcec_cost_element_name ) AS CostElementName,
  Material,
  _MaterialText[1:Language = $session.system_language].MaterialName AS MaterialName,
  CostingLotSize,
  ValuationQuantityUnit AS ValuationQuantityUnitInternal,
  P_DMVCECNode._ChildUnitCosting._UnitOfMeasure.UnitOfMeasure_E AS ValuationQuantityUnit,
  cast( TotalAmountInCoCodeCrcy as fml_dmvcec_total_costs ) AS TotalAmountInCoCodeCrcy,
  CompanyCodeCurrency,
  cast( TotalAmountInGroupCrcy as fml_dmvcec_total_costs ) AS TotalAmountInGroupCrcy,
  GroupCurrency,
  CostCenter,
  _CostCenterText[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  CostCtrActivityType,
  cast( _ActivityText[1:Language = $session.system_language].CostCtrActivityTypeName as fco_activity_type_name ) AS CostCtrActivityTypeName,
  Operation,
  OperationName,
  _WorkCenter.WorkCenter AS WorkCenter,
  cast( _WorkCenter._Text[1:Language = $session.system_language].WorkCenterText as fml_dmvcec_work_center_name ) AS WorkCenterName,
  QuantityInBaseUnit,
  BaseUnit AS BaseUnitInternal,
  _BaseUoM.UnitOfMeasure_E AS BaseUnit,
  PurchasingDocument,
  cast( '' as ckml_btyp ) AS ProcessCategory,
  cast( '' as abap.char( 40 ) ) AS NodeIcon,
  PurchasingOrganization,
  Supplier,
  P_DMVCECNode.ProductionVersion AS ProductionVersion,
  cast( _ProductionVersion.ProductionVersionText as fml_dmvcec_production_v_name ) AS ProductionVersionName,
  TransferBillOfMaterial AS BillOfMaterial,
  TransferTaskListType AS TaskListType,
  TransferTaskListGroup AS TaskListGroup,
  TransferCostingType,
  TransferCostingDate,
  TransferCostingVersion,
  TransferValuationVariant,
  cast(CostingValuationStrategy as fml_dmvcec_price_strategy ) AS CostingValuationStrategy,
  cast( '' as fml_dmvcec_price_strategy_name ) AS CostingValuationStrategyName,
  MaterialValnPurgInfoRecdStrgy
FROM P_DMVCECNode
LEFT OUTER JOIN P_DMVCECCostElement AS _CostElement ON P_DMVCECNode.ControllingArea = _CostElement.ControllingArea AND P_DMVCECNode.CostElement = _CostElement.CostElement  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON P_DMVCECNode.Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _ActivityText ON P_DMVCECNode.ControllingArea = _ActivityText.ControllingArea AND P_DMVCECNode.CostCtrActivityType = _ActivityText.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON P_DMVCECNode.CostCenter = _CostCenterText.CostCenter AND P_DMVCECNode.ControllingArea = _CostCenterText.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUoM ON BaseUnitInternal = _BaseUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON P_DMVCECNode.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_ProductionVersion AS _ProductionVersion ON Material = _ProductionVersion.Material AND Plant = _ProductionVersion.Plant AND ProductionVersion = _ProductionVersion.ProductionVersion  -- association [0..1]
;