C_MatlValnManage

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 C_MatlValnManage.
-- 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: CMATLVALNMANAGE

CREATE VIEW C_MatlValnManage AS
SELECT
  mv.CostEstimate AS CostEstimate,
  mv.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  mv.LegalCurrencyRole AS LegalCurrencyRole,
  mv.Ledger AS Ledger,
  mv.AccountingValuationView AS AccountingValuationView,
  mv.AccountingValuationViewName AS AccountingValuationViewName,
  mv.AccountingValuationSubview AS AccountingValuationSubview,
  mv.AccountingValuationSubviewName AS AccountingValuationSubviewName,
  mv.AcctgValnVwSubviewCombinedName AS AcctgValnVwSubviewCombinedName,
  mv.LedgerName AS LedgerName,
  mv.LegalCurrencyRoleName AS LegalCurrencyRoleName,
  mv.CurrencyRole AS CurrencyRole,
  Material,
  ValuationArea,
  Plant,
  PlantName,
  InventoryValuationType,
  InvtryValnSpecialStockType,
  SalesOrder,
  SalesOrderItem,
  Supplier,
  WBSElementExternalID,
  WBSElementInternalID,
  ControllingArea,
  InventoryValuationCategory,
  MaterialValuationClass,
  ValuationClassSalesOrderStock,
  cast(ProjectStockValuationClass as fml_valuationclassprojectstock preserving type) AS ProjectStockValuationClass,
  PriceDeterminationControl,
  ProfitCenter,
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  CurrentFiscalYear,
  CurrentFiscalPeriod,
  MaterialName,
  cast( '' as productimageurl ) AS ProductImageURL,
  BaseUnit,
  ValuationQuantityUnit,
  CompanyCode,
  cast('' as fis_hryid_ccode_42) AS CompanyCodeHierarchy,
  cast('' as fis_hrynid_ccode_50) AS CompanyCodeHierarchyNode,
  CompanyCodeName,
  cast ( TotalValuatedStockAmount as fml_salk3 ) AS TotalValuatedStockAmount,
  TotalVltdStockQuantity,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  Currency,
  MaterialPriceUnitQty,
  ValuationClassInPrevPeriod,
  ValuationClassInPrevYear,
  FuturePrice,
  FuturePriceValidityStartDate,
  cast(FuturePlannedPrice as fml_futureplannedprice preserving type) AS FuturePlannedPrice,
  TaxPricel1InCoCodeCrcy,
  TaxPrice2InCoCodeCrcy,
  TaxPrice3InCoCodeCrcy,
  TaxBasedPricesPriceUnitQty,
  CommercialPrice1InCoCodeCrcy,
  CommercialPrice2InCoCodeCrcy,
  CommercialPrice3InCoCodeCrcy,
  PlannedPrice1InCoCodeCrcy,
  FuturePlndPrice1ValdtyDate,
  PlannedPrice2InCoCodeCrcy,
  FuturePlndPrice2ValdtyDate,
  PlannedPrice3InCoCodeCrcy,
  FuturePlndPrice3ValdtyDate,
  IsBlockedForCosting,
  CostingLotSize,
  IsMaterialCostedWithQtyStruc,
  IsMaterialRelatedOrigin,
  CostOriginGroup,
  CostingOverheadGroup,
  MaterialUsabilityProfile,
  IsCoProduct,
  IsFixedPriceCoProduct,
  AlternativeBillOfMaterial,
  BillOfMaterialVariantUsage
FROM I_CurrentMaterialValuations AS mv
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ProfitCenter = _ProfitCenterText.ProfitCenter AND ControllingArea = _ProfitCenterText.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_PriceDeterminationControlTxt AS _PriceDeterminationControlText ON PriceDeterminationControl = _PriceDeterminationControlText.PriceDeterminationControl  -- association [0..*]
LEFT OUTER JOIN C_InvtryValnCatTextTemp AS _InventoryValCategoryText ON InventoryValuationCategory = _InventoryValCategoryText.InventoryValuationCategory  -- association [0..*]
LEFT OUTER JOIN I_Matlvaluationclasstext AS _MatlValuationClassText ON MaterialValuationClass = _MatlValuationClassText.MaterialValuationClass  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesOrder = _SalesDocumentItem.SalesDocument AND SalesOrderItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN C_MatlValnManageInvtryValn AS _MatlValnManageInvtryValn ON CostEstimate = _MatlValnManageInvtryValn.CostEstimate AND Material = _MatlValnManageInvtryValn.Material AND ValuationArea = _MatlValnManageInvtryValn.ValuationArea  -- association [0..*]
LEFT OUTER JOIN C_MatlValnManageCostEst AS _MatlValnManageCostEst ON CostEstimate = _MatlValnManageCostEst.CostEstimate AND Material = _MatlValnManageCostEst.Material AND ValuationArea = _MatlValnManageCostEst.ValuationArea  -- association [0..*]
LEFT OUTER JOIN C_MatlLdgrPrSalesOrderCostEst AS _MatlValnMngSalesOrderCostEst ON CostEstimate = _MatlValnMngSalesOrderCostEst.CostEstimate AND Material = _MatlValnMngSalesOrderCostEst.Material AND ValuationArea = _MatlValnMngSalesOrderCostEst.ValuationArea  -- association [0..*]
LEFT OUTER JOIN C_ValnPriceCategoryPrice AS _ValnPriceCategoryPrice ON CostEstimate = _ValnPriceCategoryPrice.CostEstimate AND Material = _ValnPriceCategoryPrice.Material AND ValuationArea = _ValnPriceCategoryPrice.ValuationArea  -- association [0..*]
;