P_Matval_Manage_Md

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_Md.
-- 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: PMATVALMGMMD

CREATE VIEW P_Matval_Manage_Md AS
SELECT
  CostEstimate,
  Material,
  ValuationArea,
  InventoryValuationType,
  InvtryValnSpecialStockType,
  SalesOrder,
  SalesOrderItem,
  Supplier,
  WBSElementInternalID,
  ps.posid AS WBSElement,
  cast (tk.bukrs as fis_bukrs preserving type ) AS CompanyCode,
  ma.meins AS BaseUnit,
  ma.matkl AS MaterialGroup,
  ma.mtart AS MaterialType,
  ma./cwm/xcwmat AS cwmxcwmat,
  mc.lvorm AS PlntMatlIsMarkedForDeletion,
  mc.mmsta AS MaterialUsabilityProfile,
  mc.mmstd AS mmstd,
  mc.ausss AS AssemblyScrapPercent,
  mc.beskz AS MaterialProcurementCategory,
  mc.sobsl AS MaterialProcurementProfile,
  mc.prctr AS ProfitCenter,
  mc.verkz AS HasProductionVersion,
  mc.stlal AS AlternativeBillOfMaterial,
  mc.stlan AS BillOfMaterialVariantUsage,
  mc.plnnr AS TaskListGroup,
  mc.aplal AS TaskListGroupCounter,
  mc.losgr AS CostingLotSize,
  mc.sobsk AS CostingMatProcurementProfile,
  mc.kausf AS ComponentScrapInPercent,
  mc.kzkup AS IsCoProduct,
  mc.awsls AS awsls,
  mc.stdpd AS stdpd,
  mc.schgt AS IsBulkMaterial,
  mc.plnty AS BillOfOperationsType,
  mc.fvidk AS CostingProductionVersion,
  mc.fxpru AS IsFixedPriceCoProduct,
  mc.ncost AS IsBlockedForCosting,
  IsMatlOfValnTypeMarkedForDeltn,
  MaterialValuationClass,
  ValuationClassInPrevPeriod,
  ValuationClassInPrevYear,
  PriceDeterminationControl,
  cast(mv.lfgja as bdatj) AS CurrentFiscalYear,
  cast(concat ('0',mv.lfmon) as poper) AS CurrentFiscalPeriod,
  cast(mv.vmgja as bdatj) AS PreviousFiscalPeriodFiscalYear,
  cast(concat ('0',mv.vmmon) as poper) AS PreviousFiscalPeriod,
  cast(mv.vjgja as bdatj) AS PreviousFiscalYear,
  cast(concat ('0',mv.vjmon) as poper) AS PreviousFiscalYearPeriod,
  InventoryValuationCategory,
  PriceLastChangeDate,
  TaxPricel1InCoCodeCrcy,
  CommercialPrice1InCoCodeCrcy,
  TaxPrice3InCoCodeCrcy,
  CommercialPrice3InCoCodeCrcy,
  PlannedPriceInCoCodeCrcy,
  PlannedPrice1InCoCodeCrcy,
  PlannedPrice2InCoCodeCrcy,
  PlannedPrice3InCoCodeCrcy,
  FuturePlndPrice1ValdtyDate,
  FuturePlndPrice2ValdtyDate,
  FuturePlndPrice3ValdtyDate,
  HasStdCostEstForFuturePeriod,
  HasStdCostEstForCurrentPeriod,
  HasStdCostEstForPreviousPeriod,
  IsLIFOAndFIFORelevant,
  LIFOValuationPoolNumber,
  CommercialPrice2InCoCodeCrcy,
  TaxPrice2InCoCodeCrcy,
  DevaluationYearCount,
  MaintenanceStatus,
  FutrCostEstValuationVariant,
  CurCostEstValuationVariant,
  PrevCostEstValuationVariant,
  FutureCostEstCostingVersion,
  CurrentCostEstCostingVersion,
  PreviousCostEstCostingVersion,
  CostOriginGroup,
  CostingOverheadGroup,
  FutureCostEstimateFiscalPeriod,
  CurrentCostEstFiscalPeriod,
  PreviousCostEstFiscalPeriod,
  FutureCostEstFiscalYear,
  CurrentCostEstFiscalYear,
  PreviousCostEstFiscalYear,
  IsMaterialCostedWithQtyStruc,
  PreviousPlanPriceInCoCodeCrcy,
  CurrentPlanPriceInCoCodeCrcy,
  IsMaterialRelatedOrigin,
  PhysicalInventoryBlockInd,
  DateOfLastPostedCntUnRstrcdStk,
  InventoryForCycleCountInd,
  ValuationMargin,
  FxdPortnOfPlanPrcInCoCodeCrcy,
  FxdPortOfPrevPlPrcInCoCodeCrcy,
  FxdPortnOfFutPlPrcInCoCodeCrcy,
  CurPlanProjSlsOrdValnStrategy,
  PrevPlanProjSlsOrdValnStrategy,
  FutrPlanProjSlsOrdValnStrategy,
  ValuationClassSalesOrderStock,
  ProjectStockValuationClass,
  ProductUsageType,
  ProductOriginType,
  IsProducedInhouse,
  ValnIsBsdOnBatchSpecificUnit,
  TaxBasedPricesPriceUnitQty,
  ValnClsForSpclStkAtVndr,
  xb.mlmaa AS mlmaa
FROM P_Matval_Manage_Xbew AS xb
INNER JOIN t001k AS tk ON /* join condition not captured in parsed metadata */
INNER JOIN marv AS mv ON /* join condition not captured in parsed metadata */
INNER JOIN mara AS ma ON /* join condition not captured in parsed metadata */
;