I_ProductCostEstimate

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_ProductCostEstimate.
-- 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_ProductCostEstimate AS
SELECT
  bzobj AS CostingReferenceObject,
  cast( kalnr as fis_kalnr preserving type ) AS CostEstimate,
  kalka AS CostingType,
  kadky AS CostingDate,
  tvers AS CostingVersion,
  bwvar AS ValuationVariant,
  kkzma AS CostIsEnteredManually,
  cast( matnr as productnumber preserving type ) AS Product,
  werks AS Plant,
  bwkey AS ValuationArea,
  bwtar AS ValuationType,
  kokrs AS ControllingArea,
  _ValuationArea.CompanyCode AS CompanyCode,
  kadat AS CostEstimateValidityStartDate,
  bidat AS CostEstimateValidityEndDate,
  bwdat AS ValuationDate,
  aldat AS QuantityStructureDate,
  verid AS ProductionVersion,
  cast(stnum as ck_stnum preserving type ) AS BillOfMaterial,
  stlan AS ProductBOMUsage,
  stalt AS AlternativeBillOfMaterial,
  plnnr AS TaskListGroup,
  plnty AS TaskListType,
  plnal AS TaskListGroupCounter,
  kzroh AS CostingItemIsProductComp,
  loekz AS CostEstIsMarkedForDeletion,
  losgr AS CostingLotSize,
  meins AS ValuationQuantityUnit,
  erfnm AS CostEstimateCreatedByUser,
  erfma AS AdditiveCostCreatedByUser,
  cpudt AS CostEstimateCreationDate,
  feh_sta AS CostEstimateStatus,
  maxmsg AS CostingErrorMessageType,
  freig AS CostEstimateIsReleased,
  mkalk AS CostEstIsMixedCosting,
  baltkz AS CostEstimateIsForProcmtAltv,
  kalnr_ba AS ProcmtAltvCostEstimate,
  btyp AS ProcessCategory,
  misch_verh AS CostgMixingRatioValue,
  bwvar_ba AS ProcmtAltvValuationVariant,
  sobsl AS SpecialProcurementType,
  sobes AS ProductProcurementType,
  sowrk AS SpecialProcurementPlant,
  kalsm AS CostingSheet,
  aufza AS CostingOverheadType,
  bwsmr AS ProductValuationStrategy,
  substrat AS ProductValnPurgInfoRecdStrgy,
  klvar AS CostingVariant,
  rldnr AS Ledger,
  kosgr AS CostingOverheadGroup,
  zschl AS CostingOverhead,
  poper AS PostingPeriod,
  bdatj AS PostingFiscalYear,
  cmf_nr AS CostingErrorLogID,
  vormdat AS CostEstimateMarkingDate,
  vormusr AS CostEstimateMarkingUser,
  freidat AS CostEstimateReleaseDate,
  freiusr AS CostEstimateReleaseUser,
  uebid AS CostEstimateTransferControl,
  disst AS LowLevelCode,
  kalst AS CostEstimateCostingLevel,
  elehk AS CostComponentStructure,
  cast(elehkns as ck_elehkns preserving type) AS AuxiliaryCostCompStructure,
  gsber AS BusinessArea,
  prctr AS ProfitCenter,
  fwaer_kpf AS CompanyCodeCurrency,
  hwaer AS ControllingAreaCurrency,
  kurst AS ExchangeRateType,
  kalaid AS EstimatedCostCostingRun,
  kaladat AS EstimatedCostCostingRunDate,
  type AS ConfiguredProduct,
  cast(erzka as ck_ekalrel preserving type ) AS ProductIsCostedWithQtyStruc,
  _ValuationArea._CompanyCode AS _CompanyCode
FROM P_KEKO
LEFT OUTER JOIN I_ProductCostEstimateItem AS _ProductCostEstimateItem ON CostingReferenceObject = _ProductCostEstimateItem.CostingReferenceObject AND CostEstimate = _ProductCostEstimateItem.CostEstimate AND CostingType = _ProductCostEstimateItem.CostingType AND CostingDate = _ProductCostEstimateItem.CostingDate AND CostingVersion = _ProductCostEstimateItem.CostingVersion AND ValuationVariant = _ProductCostEstimateItem.ValuationVariant AND CostIsEnteredManually = _ProductCostEstimateItem.CostIsEnteredManually  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlant ON Product = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductValuationBasic AS _ProductValuation ON Plant = _ProductValuation.ValuationArea AND Product = _ProductValuation.Product AND ValuationType = _ProductValuation.ValuationType  -- association [0..1]
LEFT OUTER JOIN I_CostingType AS _CostingType ON CostingType = _CostingType.CostingType  -- association [1..1]
LEFT OUTER JOIN I_CostingVersion AS _CostingVersion ON CostingVersion = _CostingVersion.CostingVersion AND CostingType = _CostingVersion.CostingType AND ValuationVariant = _CostingVersion.ValuationVariant  -- association [0..1]
LEFT OUTER JOIN I_CostingVariant AS _CostingVariant ON CostingVariant = _CostingVariant.CostingVariant  -- association [1..1]
LEFT OUTER JOIN I_ValuationArea AS _ValuationArea ON ValuationArea = _ValuationArea.ValuationArea  -- association [1..1]
LEFT OUTER JOIN I_CostingValuationVariant AS _ValuationVariant ON ValuationVariant = _ValuationVariant.ValuationVariant  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _ControllingAreaCurrency ON ControllingAreaCurrency = _ControllingAreaCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON ValuationQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;