I_ProdCostEstCostCompRawDEX

DDL: I_PRODCOSTESTCOSTCOMPRAWDEX Type: view_entity BASIC Package: FINS_PCP_COSTEST

Prod Cost Est Cost Comp Raw Data Ext

I_ProdCostEstCostCompRawDEX (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Product Cost Estimate · Accounting and Financial Close

I_ProdCostEstCostCompRawDEX is a Basic CDS View (Fact) that provides data about "Prod Cost Est Cost Comp Raw Data Ext" in SAP S/4HANA. It reads from 1 data source (P_KEPH) and exposes 135 fields with key fields CostingReferenceObject, CostEstimate, CostingType, CostingDate, CostingVersion. It has 1 association to related views. Part of development package FINS_PCP_COSTEST.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentCO-PC-PCP-2CL
CapabilitiesData Source for Data Extraction
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view enables you to extract and replicate costs by cost component.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_KEPH keph from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ProductCostEstimate _ProductCostEstimate $projection.CostingReferenceObject = _ProductCostEstimate.CostingReferenceObject and $projection.CostEstimate = _ProductCostEstimate.CostEstimate and $projection.CostingType = _ProductCostEstimate.CostingType and $projection.CostingDate = _ProductCostEstimate.CostingDate and $projection.CostingVersion = _ProductCostEstimate.CostingVersion and $projection.ValuationVariant = _ProductCostEstimate.ValuationVariant and $projection.CostIsEnteredManually = _ProductCostEstimate.CostIsEnteredManually

Annotations (13)

NameValueLevelField
EndUserText.label Prod Cost Est Cost Comp Raw Data Ext view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name ProductCostEstimate view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Analytics.dataCategory #FACT view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (135)

KeyFieldSource TableSource FieldDescription
KEY CostingReferenceObject P_KEPH CostingReferenceObject Reference Object
KEY CostEstimate P_KEPH CostEstimate Cost Estimate Number for Cost Est. w/o Qty Structure
KEY CostingType P_KEPH CostingType Costing Type
KEY CostingDate P_KEPH CostingDate Costing Date (Key)
KEY CostingVersion P_KEPH CostingVersion Costing Version
KEY ValuationVariant P_KEPH ValuationVariant Valuation Variant in Costing
KEY CostIsEnteredManually P_KEPH CostIsEnteredManually Costs Entered Manually in Additive or Automatic Cost Est.
KEY CostingPartnerNumber P_KEPH CostingPartnerNumber Partner number for costing
KEY CostComponentSplitType P_KEPH CostComponentSplitType Type of Cost Component Split for Product Costing
KEY CostIsInCtrlgAreaCrcy P_KEPH CostIsInCtrlgAreaCrcy Link Field for Currency Type
KEY IsCostComponentSplitLowerLevel P_KEPH IsCostComponentSplitLowerLevel Indicator Lower Level/Level
KEY CostEstWQSIsInclAdditiveCosts P_KEPH CostEstWQSIsInclAdditiveCosts Costs Were Entered Manually in an Additive Cost Estimate
KEY CostCompSpltDrctPrtnCharc P_KEPH CostCompSpltDrctPrtnCharc Direct Partner Characteristic
CompanyCodeCurrencyendaswaersasCurrency
CostComponentCostField1Amt P_KEPH CostComponentCostField1Amt Cost Field
CostComponentCostField2Amt P_KEPH CostComponentCostField2Amt Cost Field
CostComponentCostField3Amt P_KEPH CostComponentCostField3Amt Cost Field
CostComponentCostField4Amt P_KEPH CostComponentCostField4Amt Cost Field
CostComponentCostField5Amt P_KEPH CostComponentCostField5Amt Cost Field
CostComponentCostField6Amt P_KEPH CostComponentCostField6Amt Cost Field
CostComponentCostField7Amt P_KEPH CostComponentCostField7Amt Cost Field
CostComponentCostField8Amt P_KEPH CostComponentCostField8Amt Cost Field
CostComponentCostField9Amt P_KEPH CostComponentCostField9Amt Cost Field
CostComponentCostField10Amt P_KEPH CostComponentCostField10Amt Cost Field
CostComponentCostField11Amt P_KEPH CostComponentCostField11Amt Cost Field
CostComponentCostField12Amt P_KEPH CostComponentCostField12Amt Cost Field
CostComponentCostField13Amt P_KEPH CostComponentCostField13Amt Cost Field
CostComponentCostField14Amt P_KEPH CostComponentCostField14Amt Cost Field
CostComponentCostField15Amt P_KEPH CostComponentCostField15Amt Cost Field
CostComponentCostField16Amt P_KEPH CostComponentCostField16Amt Cost Field
CostComponentCostField17Amt P_KEPH CostComponentCostField17Amt Cost Field
CostComponentCostField18Amt P_KEPH CostComponentCostField18Amt Cost Field
CostComponentCostField19Amt P_KEPH CostComponentCostField19Amt Cost Field
CostComponentCostField20Amt P_KEPH CostComponentCostField20Amt Cost Field
CostComponentCostField21Amt P_KEPH CostComponentCostField21Amt Cost Field
CostComponentCostField22Amt P_KEPH CostComponentCostField22Amt Cost Field
CostComponentCostField23Amt P_KEPH CostComponentCostField23Amt Cost Field
CostComponentCostField24Amt P_KEPH CostComponentCostField24Amt Cost Field
CostComponentCostField25Amt P_KEPH CostComponentCostField25Amt Cost Field
CostComponentCostField26Amt P_KEPH CostComponentCostField26Amt Cost Field
CostComponentCostField27Amt P_KEPH CostComponentCostField27Amt Cost Field
CostComponentCostField28Amt P_KEPH CostComponentCostField28Amt Cost Field
CostComponentCostField29Amt P_KEPH CostComponentCostField29Amt Cost Field
CostComponentCostField30Amt P_KEPH CostComponentCostField30Amt Cost Field
CostComponentCostField31Amt P_KEPH CostComponentCostField31Amt Cost Field
CostComponentCostField32Amt P_KEPH CostComponentCostField32Amt Cost Field
CostComponentCostField33Amt P_KEPH CostComponentCostField33Amt Cost Field
CostComponentCostField34Amt P_KEPH CostComponentCostField34Amt Cost Field
CostComponentCostField35Amt P_KEPH CostComponentCostField35Amt Cost Field
CostComponentCostField36Amt P_KEPH CostComponentCostField36Amt Cost Field
CostComponentCostField37Amt P_KEPH CostComponentCostField37Amt Cost Field
CostComponentCostField38Amt P_KEPH CostComponentCostField38Amt Cost Field
CostComponentCostField39Amt P_KEPH CostComponentCostField39Amt Cost Field
CostComponentCostField40Amt P_KEPH CostComponentCostField40Amt Cost Field
CostComponentCostField41Amt P_KEPH CostComponentCostField41Amt Cost Field
CostComponentCostField42Amt P_KEPH CostComponentCostField42Amt Cost Field
CostComponentCostField43Amt P_KEPH CostComponentCostField43Amt Cost Field
CostComponentCostField44Amt P_KEPH CostComponentCostField44Amt Cost Field
CostComponentCostField45Amt P_KEPH CostComponentCostField45Amt Cost Field
CostComponentCostField46Amt P_KEPH CostComponentCostField46Amt Cost Field
CostComponentCostField47Amt P_KEPH CostComponentCostField47Amt Cost Field
CostComponentCostField48Amt P_KEPH CostComponentCostField48Amt Cost Field
CostComponentCostField49Amt P_KEPH CostComponentCostField49Amt Cost Field
CostComponentCostField50Amt P_KEPH CostComponentCostField50Amt Cost Field
CostComponentCostField51Amt P_KEPH CostComponentCostField51Amt Cost Field
CostComponentCostField52Amt P_KEPH CostComponentCostField52Amt Cost Field
CostComponentCostField53Amt P_KEPH CostComponentCostField53Amt Cost Field
CostComponentCostField54Amt P_KEPH CostComponentCostField54Amt Cost Field
CostComponentCostField55Amt P_KEPH CostComponentCostField55Amt Cost Field
CostComponentCostField56Amt P_KEPH CostComponentCostField56Amt Cost Field
CostComponentCostField57Amt P_KEPH CostComponentCostField57Amt Cost Field
CostComponentCostField58Amt P_KEPH CostComponentCostField58Amt Cost Field
CostComponentCostField59Amt P_KEPH CostComponentCostField59Amt Cost Field
CostComponentCostField60Amt P_KEPH CostComponentCostField60Amt Cost Field
CostComponentCostField61Amt P_KEPH CostComponentCostField61Amt Cost Field
CostComponentCostField62Amt P_KEPH CostComponentCostField62Amt Cost Field
CostComponentCostField63Amt P_KEPH CostComponentCostField63Amt Cost Field
CostComponentCostField64Amt P_KEPH CostComponentCostField64Amt Cost Field
CostComponentCostField65Amt P_KEPH CostComponentCostField65Amt Cost Field
CostComponentCostField66Amt P_KEPH CostComponentCostField66Amt Cost Field
CostComponentCostField67Amt P_KEPH CostComponentCostField67Amt Cost Field
CostComponentCostField68Amt P_KEPH CostComponentCostField68Amt Cost Field
CostComponentCostField69Amt P_KEPH CostComponentCostField69Amt Cost Field
CostComponentCostField70Amt P_KEPH CostComponentCostField70Amt Cost Field
CostComponentCostField71Amt P_KEPH CostComponentCostField71Amt Cost Field
CostComponentCostField72Amt P_KEPH CostComponentCostField72Amt Cost Field
CostComponentCostField73Amt P_KEPH CostComponentCostField73Amt Cost Field
CostComponentCostField74Amt P_KEPH CostComponentCostField74Amt Cost Field
CostComponentCostField75Amt P_KEPH CostComponentCostField75Amt Cost Field
CostComponentCostField76Amt P_KEPH CostComponentCostField76Amt Cost Field
CostComponentCostField77Amt P_KEPH CostComponentCostField77Amt Cost Field
CostComponentCostField78Amt P_KEPH CostComponentCostField78Amt Cost Field
CostComponentCostField79Amt P_KEPH CostComponentCostField79Amt Cost Field
CostComponentCostField80Amt P_KEPH CostComponentCostField80Amt Cost Field
CostComponentCostField81Amt P_KEPH CostComponentCostField81Amt Cost Field
CostComponentCostField82Amt P_KEPH CostComponentCostField82Amt Cost Field
CostComponentCostField83Amt P_KEPH CostComponentCostField83Amt Cost Field
CostComponentCostField84Amt P_KEPH CostComponentCostField84Amt Cost Field
CostComponentCostField85Amt P_KEPH CostComponentCostField85Amt Cost Field
CostComponentCostField86Amt P_KEPH CostComponentCostField86Amt Cost Field
CostComponentCostField87Amt P_KEPH CostComponentCostField87Amt Cost Field
CostComponentCostField88Amt P_KEPH CostComponentCostField88Amt Cost Field
CostComponentCostField89Amt P_KEPH CostComponentCostField89Amt Cost Field
CostComponentCostField90Amt P_KEPH CostComponentCostField90Amt Cost Field
CostComponentCostField91Amt P_KEPH CostComponentCostField91Amt Cost Field
CostComponentCostField92Amt P_KEPH CostComponentCostField92Amt Cost Field
CostComponentCostField93Amt P_KEPH CostComponentCostField93Amt Cost Field
CostComponentCostField94Amt P_KEPH CostComponentCostField94Amt Cost Field
CostComponentCostField95Amt P_KEPH CostComponentCostField95Amt Cost Field
CostComponentCostField96Amt P_KEPH CostComponentCostField96Amt Cost Field
CostComponentCostField97Amt P_KEPH CostComponentCostField97Amt Cost Field
CostComponentCostField98Amt P_KEPH CostComponentCostField98Amt Cost Field
CostComponentCostField99Amt P_KEPH CostComponentCostField99Amt Cost Field
CostComponentCostField100Amt P_KEPH CostComponentCostField100Amt Cost Field
CostComponentCostField101Amt P_KEPH CostComponentCostField101Amt Cost Field
CostComponentCostField102Amt P_KEPH CostComponentCostField102Amt Cost Field
CostComponentCostField103Amt P_KEPH CostComponentCostField103Amt Cost Field
CostComponentCostField104Amt P_KEPH CostComponentCostField104Amt Cost Field
CostComponentCostField105Amt P_KEPH CostComponentCostField105Amt Cost Field
CostComponentCostField106Amt P_KEPH CostComponentCostField106Amt Cost Field
CostComponentCostField107Amt P_KEPH CostComponentCostField107Amt Cost Field
CostComponentCostField108Amt P_KEPH CostComponentCostField108Amt Cost Field
CostComponentCostField109Amt P_KEPH CostComponentCostField109Amt Cost Field
CostComponentCostField110Amt P_KEPH CostComponentCostField110Amt Cost Field
CostComponentCostField111Amt P_KEPH CostComponentCostField111Amt Cost Field
CostComponentCostField112Amt P_KEPH CostComponentCostField112Amt Cost Field
CostComponentCostField113Amt P_KEPH CostComponentCostField113Amt Cost Field
CostComponentCostField114Amt P_KEPH CostComponentCostField114Amt Cost Field
CostComponentCostField115Amt P_KEPH CostComponentCostField115Amt Cost Field
CostComponentCostField116Amt P_KEPH CostComponentCostField116Amt Cost Field
CostComponentCostField117Amt P_KEPH CostComponentCostField117Amt Cost Field
CostComponentCostField118Amt P_KEPH CostComponentCostField118Amt Cost Field
CostComponentCostField119Amt P_KEPH CostComponentCostField119Amt Cost Field
CostComponentCostField120Amt P_KEPH CostComponentCostField120Amt Cost Field
_ProductCostEstimate _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_ProdCostEstCostCompRawDEX.
-- 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_ProdCostEstCostCompRawDEX AS
SELECT
  keph.CostingReferenceObject AS CostingReferenceObject,
  keph.CostEstimate AS CostEstimate,
  keph.CostingType AS CostingType,
  keph.CostingDate AS CostingDate,
  keph.CostingVersion AS CostingVersion,
  keph.ValuationVariant AS ValuationVariant,
  keph.CostIsEnteredManually AS CostIsEnteredManually,
  keph.CostingPartnerNumber AS CostingPartnerNumber,
  keph.CostComponentSplitType AS CostComponentSplitType,
  keph.CostIsInCtrlgAreaCrcy AS CostIsInCtrlgAreaCrcy,
  keph.IsCostComponentSplitLowerLevel AS IsCostComponentSplitLowerLevel,
  keph.CostEstWQSIsInclAdditiveCosts AS CostEstWQSIsInclAdditiveCosts,
  keph.CostCompSpltDrctPrtnCharc AS CostCompSpltDrctPrtnCharc,
  cast ( case when keph.CostIsInCtrlgAreaCrcy = 'X' then _ProductCostEstimate.ControllingAreaCurrency when keph.CostIsInCtrlgAreaCrcy = ' ' then _ProductCostEstimate.CompanyCodeCurrency end as waers ) as Currency AS CompanyCodeCurrencyendaswaersasCurrency,
  keph.CostComponentCostField1Amt AS CostComponentCostField1Amt,
  keph.CostComponentCostField2Amt AS CostComponentCostField2Amt,
  keph.CostComponentCostField3Amt AS CostComponentCostField3Amt,
  keph.CostComponentCostField4Amt AS CostComponentCostField4Amt,
  keph.CostComponentCostField5Amt AS CostComponentCostField5Amt,
  keph.CostComponentCostField6Amt AS CostComponentCostField6Amt,
  keph.CostComponentCostField7Amt AS CostComponentCostField7Amt,
  keph.CostComponentCostField8Amt AS CostComponentCostField8Amt,
  keph.CostComponentCostField9Amt AS CostComponentCostField9Amt,
  keph.CostComponentCostField10Amt AS CostComponentCostField10Amt,
  keph.CostComponentCostField11Amt AS CostComponentCostField11Amt,
  keph.CostComponentCostField12Amt AS CostComponentCostField12Amt,
  keph.CostComponentCostField13Amt AS CostComponentCostField13Amt,
  keph.CostComponentCostField14Amt AS CostComponentCostField14Amt,
  keph.CostComponentCostField15Amt AS CostComponentCostField15Amt,
  keph.CostComponentCostField16Amt AS CostComponentCostField16Amt,
  keph.CostComponentCostField17Amt AS CostComponentCostField17Amt,
  keph.CostComponentCostField18Amt AS CostComponentCostField18Amt,
  keph.CostComponentCostField19Amt AS CostComponentCostField19Amt,
  keph.CostComponentCostField20Amt AS CostComponentCostField20Amt,
  keph.CostComponentCostField21Amt AS CostComponentCostField21Amt,
  keph.CostComponentCostField22Amt AS CostComponentCostField22Amt,
  keph.CostComponentCostField23Amt AS CostComponentCostField23Amt,
  keph.CostComponentCostField24Amt AS CostComponentCostField24Amt,
  keph.CostComponentCostField25Amt AS CostComponentCostField25Amt,
  keph.CostComponentCostField26Amt AS CostComponentCostField26Amt,
  keph.CostComponentCostField27Amt AS CostComponentCostField27Amt,
  keph.CostComponentCostField28Amt AS CostComponentCostField28Amt,
  keph.CostComponentCostField29Amt AS CostComponentCostField29Amt,
  keph.CostComponentCostField30Amt AS CostComponentCostField30Amt,
  keph.CostComponentCostField31Amt AS CostComponentCostField31Amt,
  keph.CostComponentCostField32Amt AS CostComponentCostField32Amt,
  keph.CostComponentCostField33Amt AS CostComponentCostField33Amt,
  keph.CostComponentCostField34Amt AS CostComponentCostField34Amt,
  keph.CostComponentCostField35Amt AS CostComponentCostField35Amt,
  keph.CostComponentCostField36Amt AS CostComponentCostField36Amt,
  keph.CostComponentCostField37Amt AS CostComponentCostField37Amt,
  keph.CostComponentCostField38Amt AS CostComponentCostField38Amt,
  keph.CostComponentCostField39Amt AS CostComponentCostField39Amt,
  keph.CostComponentCostField40Amt AS CostComponentCostField40Amt,
  keph.CostComponentCostField41Amt AS CostComponentCostField41Amt,
  keph.CostComponentCostField42Amt AS CostComponentCostField42Amt,
  keph.CostComponentCostField43Amt AS CostComponentCostField43Amt,
  keph.CostComponentCostField44Amt AS CostComponentCostField44Amt,
  keph.CostComponentCostField45Amt AS CostComponentCostField45Amt,
  keph.CostComponentCostField46Amt AS CostComponentCostField46Amt,
  keph.CostComponentCostField47Amt AS CostComponentCostField47Amt,
  keph.CostComponentCostField48Amt AS CostComponentCostField48Amt,
  keph.CostComponentCostField49Amt AS CostComponentCostField49Amt,
  keph.CostComponentCostField50Amt AS CostComponentCostField50Amt,
  keph.CostComponentCostField51Amt AS CostComponentCostField51Amt,
  keph.CostComponentCostField52Amt AS CostComponentCostField52Amt,
  keph.CostComponentCostField53Amt AS CostComponentCostField53Amt,
  keph.CostComponentCostField54Amt AS CostComponentCostField54Amt,
  keph.CostComponentCostField55Amt AS CostComponentCostField55Amt,
  keph.CostComponentCostField56Amt AS CostComponentCostField56Amt,
  keph.CostComponentCostField57Amt AS CostComponentCostField57Amt,
  keph.CostComponentCostField58Amt AS CostComponentCostField58Amt,
  keph.CostComponentCostField59Amt AS CostComponentCostField59Amt,
  keph.CostComponentCostField60Amt AS CostComponentCostField60Amt,
  keph.CostComponentCostField61Amt AS CostComponentCostField61Amt,
  keph.CostComponentCostField62Amt AS CostComponentCostField62Amt,
  keph.CostComponentCostField63Amt AS CostComponentCostField63Amt,
  keph.CostComponentCostField64Amt AS CostComponentCostField64Amt,
  keph.CostComponentCostField65Amt AS CostComponentCostField65Amt,
  keph.CostComponentCostField66Amt AS CostComponentCostField66Amt,
  keph.CostComponentCostField67Amt AS CostComponentCostField67Amt,
  keph.CostComponentCostField68Amt AS CostComponentCostField68Amt,
  keph.CostComponentCostField69Amt AS CostComponentCostField69Amt,
  keph.CostComponentCostField70Amt AS CostComponentCostField70Amt,
  keph.CostComponentCostField71Amt AS CostComponentCostField71Amt,
  keph.CostComponentCostField72Amt AS CostComponentCostField72Amt,
  keph.CostComponentCostField73Amt AS CostComponentCostField73Amt,
  keph.CostComponentCostField74Amt AS CostComponentCostField74Amt,
  keph.CostComponentCostField75Amt AS CostComponentCostField75Amt,
  keph.CostComponentCostField76Amt AS CostComponentCostField76Amt,
  keph.CostComponentCostField77Amt AS CostComponentCostField77Amt,
  keph.CostComponentCostField78Amt AS CostComponentCostField78Amt,
  keph.CostComponentCostField79Amt AS CostComponentCostField79Amt,
  keph.CostComponentCostField80Amt AS CostComponentCostField80Amt,
  keph.CostComponentCostField81Amt AS CostComponentCostField81Amt,
  keph.CostComponentCostField82Amt AS CostComponentCostField82Amt,
  keph.CostComponentCostField83Amt AS CostComponentCostField83Amt,
  keph.CostComponentCostField84Amt AS CostComponentCostField84Amt,
  keph.CostComponentCostField85Amt AS CostComponentCostField85Amt,
  keph.CostComponentCostField86Amt AS CostComponentCostField86Amt,
  keph.CostComponentCostField87Amt AS CostComponentCostField87Amt,
  keph.CostComponentCostField88Amt AS CostComponentCostField88Amt,
  keph.CostComponentCostField89Amt AS CostComponentCostField89Amt,
  keph.CostComponentCostField90Amt AS CostComponentCostField90Amt,
  keph.CostComponentCostField91Amt AS CostComponentCostField91Amt,
  keph.CostComponentCostField92Amt AS CostComponentCostField92Amt,
  keph.CostComponentCostField93Amt AS CostComponentCostField93Amt,
  keph.CostComponentCostField94Amt AS CostComponentCostField94Amt,
  keph.CostComponentCostField95Amt AS CostComponentCostField95Amt,
  keph.CostComponentCostField96Amt AS CostComponentCostField96Amt,
  keph.CostComponentCostField97Amt AS CostComponentCostField97Amt,
  keph.CostComponentCostField98Amt AS CostComponentCostField98Amt,
  keph.CostComponentCostField99Amt AS CostComponentCostField99Amt,
  keph.CostComponentCostField100Amt AS CostComponentCostField100Amt,
  keph.CostComponentCostField101Amt AS CostComponentCostField101Amt,
  keph.CostComponentCostField102Amt AS CostComponentCostField102Amt,
  keph.CostComponentCostField103Amt AS CostComponentCostField103Amt,
  keph.CostComponentCostField104Amt AS CostComponentCostField104Amt,
  keph.CostComponentCostField105Amt AS CostComponentCostField105Amt,
  keph.CostComponentCostField106Amt AS CostComponentCostField106Amt,
  keph.CostComponentCostField107Amt AS CostComponentCostField107Amt,
  keph.CostComponentCostField108Amt AS CostComponentCostField108Amt,
  keph.CostComponentCostField109Amt AS CostComponentCostField109Amt,
  keph.CostComponentCostField110Amt AS CostComponentCostField110Amt,
  keph.CostComponentCostField111Amt AS CostComponentCostField111Amt,
  keph.CostComponentCostField112Amt AS CostComponentCostField112Amt,
  keph.CostComponentCostField113Amt AS CostComponentCostField113Amt,
  keph.CostComponentCostField114Amt AS CostComponentCostField114Amt,
  keph.CostComponentCostField115Amt AS CostComponentCostField115Amt,
  keph.CostComponentCostField116Amt AS CostComponentCostField116Amt,
  keph.CostComponentCostField117Amt AS CostComponentCostField117Amt,
  keph.CostComponentCostField118Amt AS CostComponentCostField118Amt,
  keph.CostComponentCostField119Amt AS CostComponentCostField119Amt,
  keph.CostComponentCostField120Amt AS CostComponentCostField120Amt
FROM P_KEPH AS keph
LEFT OUTER JOIN I_ProductCostEstimate AS _ProductCostEstimate ON CostingReferenceObject = _ProductCostEstimate.CostingReferenceObject AND CostEstimate = _ProductCostEstimate.CostEstimate AND CostingType = _ProductCostEstimate.CostingType AND CostingDate = _ProductCostEstimate.CostingDate AND CostingVersion = _ProductCostEstimate.CostingVersion AND ValuationVariant = _ProductCostEstimate.ValuationVariant AND CostIsEnteredManually = _ProductCostEstimate.CostIsEnteredManually  -- association [0..1]
;