I_ProductCostEstimateItem

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_ProductCostEstimateItem.
-- 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_ProductCostEstimateItem 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,
  posnr AS CostingItem,
  typps AS CostingItemCategory,
  werks AS Plant,
  cast( matnr as productnumber preserving type ) AS Product,
  bwtar AS ValuationType,
  hwaer AS ControllingAreaCurrency,
  cast(gpreis as fpc_vdm_totpr_ca preserving type ) AS TotalPriceInInCtrlgAreaCrcy,
  cast(fpreis as fpc_vdm_fxdpr_ca preserving type ) AS FixedPriceInCtrlgAreaCrcy,
  cast(wertn as fpc_vdm_cawaer_total preserving type ) AS TotalAmountInCtrlgAreaCrcy,
  cast(wrtfx as fpc_vdm_cawaer_fixed preserving type ) AS FixedAmountInCtrlgAreaCrcy,
  cast( opreis as fpc_vdm_totpr_cc preserving type ) AS TotalPriceInCompanyCodeCrcy,
  cast( opreifx as fpc_vdm_fxdpr_cc preserving type ) AS FixedPriceInCompanyCodeCrcy,
  fwaer_kpf AS CompanyCodeCurrency,
  cast(wrtfw_kpf as ck_gwbk preserving type) AS TotalAmountInCoCodeCrcy,
  cast(wrtfw_kfx as ck_fwbk preserving type ) AS FixedAmountInCoCodeCrcy,
  meeht AS BaseUnit,
  menge AS QuantityInBaseUnit,
  ausmg AS AssyScrapQuantityInValnQtyUnit,
  ausmgko AS CompScrapQuantityInValnQtyUnit,
  peinh AS CostingPriceUnitQty,
  pmeht AS CostingPriceQtyUnit,
  kstar AS CostElement,
  hrkft AS CostOriginGroup,
  elemt AS CostComponent,
  cast (elemtns as ck_elemns preserving type ) AS AuxiliaryCostComponent,
  lifnr AS Creditor,
  mkalk AS CostEstIsMixedCosting,
  misch_verh AS CostgMixingRatioValue,
  kalnr_ba AS ProcmtAltvCostEstimate,
  ukaln AS TransferCostEstimate,
  ukalka AS TransferCostingType,
  ukadky AS TransferCostingDate,
  utvers AS TransferCostingVersion,
  ubwvar AS TransferValuationVariant,
  kostl AS CostCenter,
  prctr AS ProfitCenter,
  gsber AS BusinessArea,
  lstar AS CostCtrActivityType,
  arbid AS CostingObject,
  cast( vornr as vdm_vornr preserving type ) AS Operation,
  infnr AS PurchasingInfoRecord,
  ekorg AS PurchasingOrganization,
  esokz AS PurchasingInfoRecordCategory,
  ebeln AS PurchasingDocument,
  ebelp AS PurchasingDocumentItem,
  cast(strat as ck_bwsma preserving type ) AS CostingValuationStrategy,
  substrat AS ProductValnPurgInfoRecdStrgy,
  cast(sposn as ck_sposn preserving type ) AS BillOfMaterialItemNumber,
  cast(baugr as ck_baukz preserving type) AS CostingItemIsAssembly,
  cast( pspnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  schkz AS CostCompSplitIsExisting,
  fehlkz AS HasError
FROM P_CKIS
LEFT OUTER JOIN I_ProductCostEstimate AS _CostEstimate ON CostingReferenceObject = _CostEstimate.CostingReferenceObject AND CostEstimate = _CostEstimate.CostEstimate AND CostingType = _CostEstimate.CostingType AND CostingDate = _CostEstimate.CostingDate AND CostingVersion = _CostEstimate.CostingVersion AND ValuationVariant = _CostEstimate.ValuationVariant AND CostIsEnteredManually = _CostEstimate.CostIsEnteredManually  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_CostingType AS _CostingType ON CostingType = _CostingType.CostingType  -- association [0..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_CostingValuationVariant AS _ValuationVariant ON ValuationVariant = _ValuationVariant.ValuationVariant  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _ControllingAreaCurrency ON ControllingAreaCurrency = _ControllingAreaCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnitOfMeasure ON BaseUnit = _BaseUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CostingUnitOfMeasure ON CostingPriceQtyUnit = _CostingUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;