I_CostEstimateItem

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_CostEstimateItem.
-- 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_CostEstimateItem AS
SELECT
  CostingReferenceObject,
  CostEstimate,
  CostingType,
  CostingDate,
  CostingVersion,
  ValuationVariant,
  CostIsEnteredManually,
  CostingItem,
  CostingItemCategory,
  CostElement,
  CostOriginGroup,
  Plant,
  Product,
  ValuationType,
  Creditor,
  _CostEstimate.GlobalCurrency AS GlobalCurrency,
  cast(TotalPriceInInCtrlgAreaCrcy as fpc_total_price_global_crcy preserving type) AS TotalPriceInGlobalCurrency,
  cast(FixedPriceInCtrlgAreaCrcy as fpc_fixed_price_global_crcy preserving type) AS FixedPriceInGlobalCurrency,
  cast(TotalAmountInCtrlgAreaCrcy as fis_ksl) AS TotalAmountInGlobalCurrency,
  cast(FixedAmountInCtrlgAreaCrcy as fis_kfsl) AS FixedAmountInGlobalCrcy,
  CompanyCodeCurrency,
  TotalPriceInCompanyCodeCrcy,
  FixedPriceInCompanyCodeCrcy,
  TotalAmountInCoCodeCrcy,
  FixedAmountInCoCodeCrcy,
  cast(BaseUnit as fpc_item_quantity_unit preserving type) AS CostEstimateItemQuantityUnit,
  cast(QuantityInBaseUnit as fpc_item_quantity preserving type) AS CostEstimateItemQuantity,
  CostingPriceQtyUnit,
  CostingPriceUnitQty,
  CostingValuationStrategy,
  ProductValnPurgInfoRecdStrgy,
  BillOfMaterialItemNumber,
  CostingItemIsAssembly,
  CostCtrActivityType,
  CostCenter,
  ProfitCenter,
  Operation,
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchasingInfoRecordCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  IsLotSizeIndependent,
  HasError,
  TransferCostEstimate,
  TransferCostingType,
  TransferCostingDate,
  TransferCostingVersion,
  TransferValuationVariant
FROM P_CKIS
LEFT OUTER JOIN I_CostEstimate 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_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_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON globalcurrency = _GlobalCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CostingUnitOfMeasure ON CostingPriceQtyUnit = _CostingUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON CostEstimateItemQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;