I_ProductProjectStockValuation

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 I_ProductProjectStockValuation.
-- 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 I_ProductProjectStockValuation AS
SELECT
  ProjectStockValuation.matnr AS Product,
  ProjectStockValuation.bwkey AS ValuationArea,
  ProjectStockValuation.bwtar AS ValuationType,
  ProjectStockValuation.sobkz AS InventorySpecialStockType,
  cast( ProjectStockValuation.pspnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  ProjectStockValuation.vprsv AS InventoryValuationProcedure,
  t001.waers AS Currency,
  _Product.BaseUnit AS BaseUnit,
  ProjectStockValuation.verpr AS MovingAveragePrice,
  ProjectStockValuation.stprs AS StandardPrice,
  ProjectStockValuation.peinh AS ProductPriceUnitQuantity,
  ProjectStockValuation.bklas AS ValuationClass,
  cast ( ProjectStockValuation.vmvpr as cmd_prd_vmvpr_prev_perd preserving type ) AS ProdPrcControlInPreviousPeriod,
  cast ( ProjectStockValuation.vmver as cmd_prd_vmver_prev_perd preserving type ) AS MvgAvgPriceInPreviousPeriod,
  cast(ProjectStockValuation.vmstp as cmd_prd_vmstp_prev_perd preserving type ) AS StandardPriceInPreviousPeriod,
  cast( ProjectStockValuation.vmpei as cmd_prd_vmpei_prev_perd preserving type ) AS ProdPrcUntQtyInPreviousPeriod,
  cast( ProjectStockValuation.vmbkl as fml_vmbkl preserving type ) AS ValuationClassPreviousPeriod,
  cast( ProjectStockValuation.vjvpr as cmd_prd_vjvpr_prev_year preserving type ) AS ProdPriceControlInPreviousYear,
  cast ( ProjectStockValuation.vjver as cmd_prd_vjver_prev_year preserving type ) AS MvgAveragePriceInPreviousYear,
  cast ( ProjectStockValuation.vjstp as cmd_prd_vjstp_prev_year preserving type ) AS StandardPricePrevYear,
  cast ( ProjectStockValuation.vjpei as cmd_prd_vjpei_prev_year preserving type ) AS ProdPrcUntQtyInPreviousYear,
  cast( ProjectStockValuation.vjbkl as fml_vjbkl preserving type ) AS ValuationClassPreviousYear,
  ProjectStockValuation.lfgja AS FiscalYearCurrentPeriod,
  cast ( ProjectStockValuation.lfmon as cmd_prd_lfmon_cur_perd preserving type ) AS FiscalMonthCurrentPeriod,
  ProjectStockValuation.bwtty AS ValuationCategory,
  ProjectStockValuation.stprv AS PrevInvtryPriceInCoCodeCrcy,
  ProjectStockValuation.laepr AS PriceLastChangeDate,
  ProjectStockValuation.zkprs AS FuturePrice,
  ProjectStockValuation.zkdat AS FuturePriceValidityStartDate,
  ProjectStockValuation.kalkz AS ProdHasStdCostEstForFutrPeriod,
  ProjectStockValuation.kalkl AS ProdHasStdCostEstForCurPeriod,
  ProjectStockValuation.kalkv AS ProdHasStdCostEstForPrevPeriod,
  ProjectStockValuation.kaln1 AS ProdCostEstNumber,
  cast ( ProjectStockValuation.bwva1 as cmd_prd_bwva1_futr_cost_est preserving type ) AS FutrCostEstValuationVariant,
  cast ( ProjectStockValuation.bwva2 as cmd_prd_bwva2_cur_cost_est preserving type ) AS CurCostEstValuationVariant,
  cast ( ProjectStockValuation.bwva3 as cmd_prd_bwva3_prev_cost_est preserving type ) AS PrevCostEstValuationVariant,
  cast ( ProjectStockValuation.vers1 as cmd_prd_vers1_futr_cost_est preserving type ) AS FutureCostEstCostingVersion,
  cast ( ProjectStockValuation.vers2 as cmd_prd_vers2_cur_cost_est preserving type ) AS CurrentCostEstCostingVersion,
  cast ( ProjectStockValuation.vers3 as cmd_prd_vers3_prev_cost_est preserving type ) AS PreviousCostEstCostingVersion,
  ProjectStockValuation.hrkft AS CostOriginGroup,
  ProjectStockValuation.kosgr AS CostingOverheadGroup,
  ProjectStockValuation.pprdz AS FutureCostEstimateFiscalPeriod,
  cast ( ProjectStockValuation.pprdl as cmd_prd_pprdl_std_cost_est preserving type ) AS CurrentCostEstFiscalPeriod,
  ProjectStockValuation.pprdv AS PreviousCostEstFiscalPeriod,
  ProjectStockValuation.pdatz AS FutureCostEstFiscalYear,
  ProjectStockValuation.pdatl AS CurrentCostEstFiscalYear,
  ProjectStockValuation.pdatv AS PreviousCostEstFiscalYear,
  ProjectStockValuation.ekalr AS ProductIsCostedWithQtyStruc,
  ProjectStockValuation.vplpr AS PreviousPlanPriceInCoCodeCrcy,
  ProjectStockValuation.mlmaa AS MLIsActiveAtProductLevel,
  ProjectStockValuation.mlast AS PriceDeterminationControl,
  ProjectStockValuation.lplpr AS CurrentPlanPriceInCoCodeCrcy,
  ProjectStockValuation.hkmat AS ProductHasRelatedOrigin,
  ProjectStockValuation.bwspa AS ValuationMarginPercent,
  ProjectStockValuation.lplpx AS FxdPortnOfPlanPrcInCoCodeCrcy,
  ProjectStockValuation.vplpx AS FxdPortOfPrevPlPrcInCoCodeCrcy,
  ProjectStockValuation.fplpx AS FxdPortnOfFutPlPrcInCoCodeCrcy,
  ProjectStockValuation.lbwst AS CurPlanProjSlsOrdValnStrategy,
  ProjectStockValuation.vbwst AS PrevPlanProjSlsOrdValnStrategy,
  ProjectStockValuation.fbwst AS FutrPlanProjSlsOrdValnStrategy,
  ProjectStockValuation.oklas AS ValnClsForSpclStkAtVndr
FROM qbew AS ProjectStockValuation
INNER JOIN t001k ON /* join condition not captured in parsed metadata */
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InventoryValuationType AS _InventoryValuationType ON ValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_ProdValnPriceControl AS _InventoryValnProcedure ON InventoryValuationProcedure = _InventoryValnProcedure.InventoryValuationProcedure  -- association [0..1]
LEFT OUTER JOIN I_ProdValnPriceControlText AS _InventoryValnProcedureText ON InventoryValuationProcedure = _InventoryValnProcedureText.InventoryValuationProcedure  -- association [0..*]
LEFT OUTER JOIN I_Prodvaluationclass AS _ValuationClass ON ValuationClass = _ValuationClass.ValuationClass  -- association [0..1]
LEFT OUTER JOIN I_Prodvaluationclasstxt AS _ValuationClassText ON ValuationClass = _ValuationClassText.ValuationClass  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnitOfMeasure ON baseunit = _BaseUnitOfMeasure.UnitOfMeasure  -- association [1..1]
;