I_ProdCostEstCostCompRawDEX
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
| Category | Basic |
|---|---|
| State | C1 |
| Line of Business | Accounting and Financial Close |
| Application Component | CO-PC-PCP-2CL |
| Capabilities | Data Source for Data Extraction |
| Extensible (Key User) | No |
| Extensible (Developer) | No |
| Release State (Key User) | Released |
| Release State (Developer) | Released |
| Package | Accounting 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
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_KEPH | keph | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA