P_Matval_Manage_Xbew

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_Matval_Manage_Xbew.
-- 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: PMATVALMGMXBEW

CREATE VIEW P_Matval_Manage_Xbew AS
SELECT
  mb.kaln1 AS CostEstimate,
  mb.matnr AS Material,
  mb.bwkey AS ValuationArea,
  mb.bwtar AS InventoryValuationType,
  cast(mb.mlast as fml_abst preserving type) AS PriceDeterminationControl,
  cast('' as sobkz preserving type) AS InvtryValnSpecialStockType,
  cast(' ' as vbeln preserving type) AS SalesOrder,
  cast('000000' as posnr preserving type) AS SalesOrderItem,
  cast(' ' as lifnr preserving type) AS Supplier,
  cast('00000000' as ps_psp_pnr preserving type) AS WBSElementInternalID,
  mb.lvorm AS IsMatlOfValnTypeMarkedForDeltn,
  mb.bklas AS MaterialValuationClass,
  cast(mb.vmbkl as fml_vmbkl preserving type) AS ValuationClassInPrevPeriod,
  cast(mb.vjbkl as fml_vjbkl preserving type) AS ValuationClassInPrevYear,
  mb.bwtty AS InventoryValuationCategory,
  mb.laepr AS PriceLastChangeDate,
  cast(mb.bwprs as fml_bwprs) AS TaxPricel1InCoCodeCrcy,
  cast(mb.bwprh as fml_bwprh) AS CommercialPrice1InCoCodeCrcy,
  cast(mb.vjbws as fml_vjbws) AS TaxPrice3InCoCodeCrcy,
  cast(mb.vjbwh as fml_vjbwh) AS CommercialPrice3InCoCodeCrcy,
  mb.zplpr AS PlannedPriceInCoCodeCrcy,
  cast(mb.zplp1 as fml_dzplp1) AS PlannedPrice1InCoCodeCrcy,
  cast(mb.zplp2 as fml_dzplp2) AS PlannedPrice2InCoCodeCrcy,
  cast(mb.zplp3 as fml_dzplp3) AS PlannedPrice3InCoCodeCrcy,
  cast(mb.zpld1 as fml_dzpld1) AS FuturePlndPrice1ValdtyDate,
  cast(mb.zpld2 as fml_dzpld2) AS FuturePlndPrice2ValdtyDate,
  cast(mb.zpld3 as fml_dzpld3) AS FuturePlndPrice3ValdtyDate,
  mb.kalkz AS HasStdCostEstForFuturePeriod,
  mb.kalkl AS HasStdCostEstForCurrentPeriod,
  mb.kalkv AS HasStdCostEstForPreviousPeriod,
  cast(mb.xlifo as fml_is_lifo_fifo_relevant preserving type) AS IsLIFOAndFIFORelevant,
  mb.mypol AS LIFOValuationPoolNumber,
  cast(mb.bwph1 as fml_bwph1) AS CommercialPrice2InCoCodeCrcy,
  cast(mb.bwps1 as fml_bwps1) AS TaxPrice2InCoCodeCrcy,
  mb.abwkz AS DevaluationYearCount,
  mb.pstat AS MaintenanceStatus,
  mb.bwva1 AS FutrCostEstValuationVariant,
  mb.bwva2 AS CurCostEstValuationVariant,
  mb.bwva3 AS PrevCostEstValuationVariant,
  mb.vers1 AS FutureCostEstCostingVersion,
  mb.vers2 AS CurrentCostEstCostingVersion,
  mb.vers3 AS PreviousCostEstCostingVersion,
  mb.hrkft AS CostOriginGroup,
  mb.kosgr AS CostingOverheadGroup,
  mb.pprdz AS FutureCostEstimateFiscalPeriod,
  mb.pprdl AS CurrentCostEstFiscalPeriod,
  mb.pprdv AS PreviousCostEstFiscalPeriod,
  mb.pdatz AS FutureCostEstFiscalYear,
  mb.pdatl AS CurrentCostEstFiscalYear,
  mb.pdatv AS PreviousCostEstFiscalYear,
  mb.ekalr AS IsMaterialCostedWithQtyStruc,
  mb.vplpr AS PreviousPlanPriceInCoCodeCrcy,
  mb.lplpr AS CurrentPlanPriceInCoCodeCrcy,
  cast(mb.hkmat as fml_is_mat_rel_origin preserving type) AS IsMaterialRelatedOrigin,
  mb.sperw AS PhysicalInventoryBlockInd,
  mb.wlinl AS DateOfLastPostedCntUnRstrcdStk,
  mb.abciw AS InventoryForCycleCountInd,
  mb.bwspa AS ValuationMargin,
  mb.lplpx AS FxdPortnOfPlanPrcInCoCodeCrcy,
  mb.vplpx AS FxdPortOfPrevPlPrcInCoCodeCrcy,
  mb.fplpx AS FxdPortnOfFutPlPrcInCoCodeCrcy,
  mb.lbwst AS CurPlanProjSlsOrdValnStrategy,
  mb.vbwst AS PrevPlanProjSlsOrdValnStrategy,
  mb.fbwst AS FutrPlanProjSlsOrdValnStrategy,
  mb.eklas AS ValuationClassSalesOrderStock,
  mb.qklas AS ProjectStockValuationClass,
  mb.mtuse AS ProductUsageType,
  mb.mtorg AS ProductOriginType,
  mb.ownpr AS IsProducedInhouse,
  mb.xbewm AS ValnIsBsdOnBatchSpecificUnit,
  cast(mb.bwpei as fml_bwpei preserving type) AS TaxBasedPricesPriceUnitQty,
  mb.oklas AS ValnClsForSpclStkAtVndr,
  mb.mlmaa AS kaln1asCostEstimate,
  qb.mlmaa AS mlmaa
FROM v_mbew_md AS mb
-- UNION ALL with additional select branch(es): v_ebew_md, v_obew_md, v_qbew_md
;