P_DMVCECNode

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_DMVCECNode.
-- 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_DMVCECNode AS
SELECT
  _ProdCostEst.CostingReferenceObject AS CostingReferenceObject,
  _ProdCostEst.CostEstimate AS ParentProdCostEstNumber,
  _ProdCostEst.TransferCostEstimate AS ProdCostEstNumber,
  _ProdCostEst.CostingType AS CostingType,
  _ProdCostEst.CostingDate AS CostingDate,
  _ProdCostEst.CostingVersion AS CostingVersion,
  _ProdCostEst.ValuationVariant AS ValuationVariant,
  _ProdCostEst.CostingItem AS CostingItem,
  _ProdCostEst.CostIsEnteredManually AS CostIsEnteredManually,
  _ProdCostEst.CostingItemCategory AS CostingItemCategory,
  _ProdCostEst.CostElement AS CostElement,
  _ProdCostEst.Product AS Material,
  _ProdCostEst.Plant AS Plant,
  _ProdCostEst._CostEstimate.ControllingArea AS ControllingArea,
  _CostingVariant.CostingVariant AS CostingVariant,
  case when _ProdCostEst.CostingItemCategory = 'M' then _ChildNode.CostComponent else _ProdCostEst.CostComponent end as CostComponent AS CostComponentendasCostComponent,
  _ProdCostEst._CostEstimate.ProductionVersion AS ProductionVersion,
  _ProdCostEst._CostEstimate.BillOfMaterial AS BillOfMaterial,
  _ProdCostEst._CostEstimate.TaskListType AS TaskListType,
  _ProdCostEst._CostEstimate.TaskListGroup AS TaskListGroup,
  _ProdCostEst._CostEstimate.CostEstimateCostingLevel AS CostEstimateCostingLevel,
  _ProdCostEst._CostEstimate.CostEstimateValidityStartDate AS CostEstimateValidityStartDate,
  _ProdCostEst._CostEstimate.CostEstimateValidityEndDate AS CostEstimateValidityEndDate,
  _ProdCostEst._CostEstimate.CostEstimateStatus AS CostEstimateStatus,
  _ProdCostEst._CostEstimate.CostEstIsMixedCosting AS CostEstIsMixedCosting,
  _ProdCostEst.QuantityInBaseUnit AS QuantityInBaseUnit,
  _ProdCostEst.BaseUnit AS BaseUnit,
  _ChildUnitCosting.CostingLotSize AS CostingLotSize,
  _ChildUnitCosting.ValuationQuantityUnit AS ValuationQuantityUnit,
  _ChildUnitCosting.TotalAmountInCoCodeCrcy AS TotalAmountInCoCodeCrcy,
  _ChildUnitCosting.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ChildUnitCosting.TotalAmountInGroupCrcy AS TotalAmountInGroupCrcy,
  _ChildUnitCosting.GroupCurrency AS GroupCurrency,
  cast( _ProdCostEst.Operation as fml_dmvcec_operation preserving type ) AS Operation,
  cast( _ParentText[1: Language = $session.system_language or Language = 'D' ].Description as fml_dmvcec_operation_name preserving type ) AS OperationName,
  _ProdCostEst.CostCenter AS CostCenter,
  _ProdCostEst.CostCtrActivityType AS CostCtrActivityType,
  _Supplier.Supplier AS Supplier,
  _ProdCostEst.PurchasingDocument AS PurchasingDocument,
  _ProdCostEst.PurchasingOrganization AS PurchasingOrganization,
  _ProdCostEst.CostingObject AS WorkCenterInternalID,
  _ProdCostEst.CostingValuationStrategy AS CostingValuationStrategy,
  _ProdCostEst.ProductValnPurgInfoRecdStrgy AS MaterialValnPurgInfoRecdStrgy,
  _ProdCostEst.TransferCostEstimate AS TransferCostEstimate,
  _ProdCostEst.TransferCostingType AS TransferCostingType,
  _ProdCostEst.TransferCostingDate AS TransferCostingDate,
  _ProdCostEst.TransferCostingVersion AS TransferCostingVersion,
  _ProdCostEst.TransferValuationVariant AS TransferValuationVariant,
  _ChildNode.TransferCostEstimate AS TransferProdCostEstNumber,
  _ChildNode.Product AS TransferMaterial,
  _ChildNode.Plant AS TransferPlant,
  _ChildNode.CostingItemCategory AS TransferCostingItemCategory,
  _ChildNode.CostingItem AS TransferCostingItem,
  _ChildNode._CostEstimate.BillOfMaterial AS TransferBillOfMaterial,
  _ChildNode._CostEstimate.TaskListType AS TransferTaskListType,
  _ChildNode._CostEstimate.TaskListGroup AS TransferTaskListGroup,
  _ChildUnitCosting.CostingLotSize AS TransferCostingLotSize,
  _ChildUnitCosting.ValuationQuantityUnit AS TransferValuationQuantityUnit,
  _ChildNode.CostElement AS TransferCostElement,
  _ProdCostEst._CostEstimate AS _CostEstimate,
  _ProdCostEst._CostEstimate AS _CostEstimateHead
FROM I_ProductCostEstimateItem AS _ProdCostEst
LEFT OUTER JOIN I_ProductCostEstimateItem AS _ChildNode ON _ProdCostEst.TransferCostEstimate = _ChildNode.CostEstimate AND _ProdCostEst.TransferCostingType = _ChildNode.CostingType AND _ProdCostEst.TransferCostingDate = _ChildNode.CostingDate AND _ProdCostEst.TransferCostingVersion = _ChildNode.CostingVersion AND _ProdCostEst.TransferValuationVariant = _ChildNode.ValuationVariant AND _ProdCostEst.CostingObject = _ChildNode.CostingObject  -- association [0..*]
LEFT OUTER JOIN P_CKHS AS _ParentUnitCosting ON _ProdCostEst.CostEstimate = _ParentUnitCosting.ProdCostEstNumber AND _ProdCostEst.CostingType = _ParentUnitCosting.CostingType AND _ProdCostEst.CostingDate = _ParentUnitCosting.CostingDate AND _ProdCostEst.CostingVersion = _ParentUnitCosting.CostingVersion AND _ProdCostEst.ValuationVariant = _ParentUnitCosting.ValuationVariant  -- association [0..*]
LEFT OUTER JOIN P_CKHS AS _ChildUnitCosting ON _ProdCostEst.TransferCostEstimate = _ChildUnitCosting.ProdCostEstNumber AND _ProdCostEst.TransferCostingType = _ChildUnitCosting.CostingType AND _ProdCostEst.TransferCostingDate = _ChildUnitCosting.CostingDate AND _ProdCostEst.TransferCostingVersion = _ChildUnitCosting.CostingVersion AND _ProdCostEst.TransferValuationVariant = _ChildUnitCosting.ValuationVariant  -- association [0..*]
LEFT OUTER JOIN P_ProductCostEstimateItemText AS _ParentText ON _ProdCostEst.CostEstimate = _ParentText.ProdCostEstNumber AND _ProdCostEst.CostingType = _ParentText.CostingType AND _ProdCostEst.CostingDate = _ParentText.CostingDate AND _ProdCostEst.CostingVersion = _ParentText.CostingVersion AND _ProdCostEst.ValuationVariant = _ParentText.ValuationVariant AND _ProdCostEst.CostingItem = _ParentText.CostingItem  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _ProdCostEst.Creditor = _Supplier.Supplier AND _Supplier.IsBusinessPurposeCompleted <> 'X'  -- association [0..1]
LEFT OUTER JOIN I_CostingVariant AS _CostingVariant ON _ProdCostEst.CostingType = _CostingVariant.CostingType AND _ProdCostEst.ValuationVariant = _CostingVariant.ValuationVariant AND _CostingVariant.CostEstimateReferenceVariant = '00'  -- association [0..1]
;