P_CostEstCostCompFiltered

DDL: P_COSTESTCOSTCOMPFILTERED Type: view_entity TRANSACTIONAL Package: FINS_PCP_COSTEST
16 Fields 2 Data Sources

Cost Estimate Cost Component Filtered

P_CostEstCostCompFiltered is a Transactional CDS View that provides data about "Cost Estimate Cost Component Filtered" in SAP S/4HANA. It reads from 2 data sources (I_CostComponentView, I_CostEstimateCostComponent) and exposes 16 fields with key fields CostComponentView, CostingReferenceObject, CostEstimate, CostingType, CostingDate. Part of development package FINS_PCP_COSTEST.

Data Sources (2)

SourceAliasJoin Type
I_CostComponentView CostComponentView inner
I_CostEstimateCostComponent CostEstimateCostComponent from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #TRANSACTIONAL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CostComponentView I_CostComponentView CostComponentView
KEY CostingReferenceObject I_CostEstimateCostComponent CostingReferenceObject
KEY CostEstimate I_CostEstimateCostComponent CostEstimate Cost EstimateNo
KEY CostingType I_CostEstimateCostComponent CostingType
KEY CostingDate I_CostEstimateCostComponent CostingDate
KEY CostingVersion I_CostEstimateCostComponent CostingVersion
KEY ValuationVariant I_CostEstimateCostComponent ValuationVariant
KEY CostIsEnteredManually I_CostEstimateCostComponent CostIsEnteredManually
KEY CostComponentStructure I_CostEstimateCostComponent CostComponentStructure
KEY CostComponent I_CostEstimateCostComponent CostComponent
CompanyCodeCurrency I_CostEstimateCostComponent CompanyCodeCurrency Local Currency
GlobalCurrency I_CostEstimateCostComponent GlobalCurrency GM Billing Element: Global Currency
TotalCostInCompanyCodeCurrency I_CostEstimateCostComponent TotalCostInCompanyCodeCurrency
FixedCostInCompanyCodeCurrency I_CostEstimateCostComponent FixedCostInCompanyCodeCurrency
TotalCostInCtrlgAreaCurrency I_CostEstimateCostComponent TotalCostInCtrlgAreaCurrency
FixedCostInCtrlgAreaCurrency I_CostEstimateCostComponent FixedCostInCtrlgAreaCurrency

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 P_CostEstCostCompFiltered.
-- 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 P_CostEstCostCompFiltered AS
SELECT
  CostComponentView.CostComponentView AS CostComponentView,
  CostEstimateCostComponent.CostingReferenceObject AS CostingReferenceObject,
  CostEstimateCostComponent.CostEstimate AS CostEstimate,
  CostEstimateCostComponent.CostingType AS CostingType,
  CostEstimateCostComponent.CostingDate AS CostingDate,
  CostEstimateCostComponent.CostingVersion AS CostingVersion,
  CostEstimateCostComponent.ValuationVariant AS ValuationVariant,
  CostEstimateCostComponent.CostIsEnteredManually AS CostIsEnteredManually,
  CostEstimateCostComponent.CostComponentStructure AS CostComponentStructure,
  CostEstimateCostComponent.CostComponent AS CostComponent,
  CostEstimateCostComponent.CompanyCodeCurrency AS CompanyCodeCurrency,
  CostEstimateCostComponent.GlobalCurrency AS GlobalCurrency,
  CostEstimateCostComponent.TotalCostInCompanyCodeCurrency AS TotalCostInCompanyCodeCurrency,
  CostEstimateCostComponent.FixedCostInCompanyCodeCurrency AS FixedCostInCompanyCodeCurrency,
  CostEstimateCostComponent.TotalCostInCtrlgAreaCurrency AS TotalCostInCtrlgAreaCurrency,
  CostEstimateCostComponent.FixedCostInCtrlgAreaCurrency AS FixedCostInCtrlgAreaCurrency
FROM I_CostEstimateCostComponent AS CostEstimateCostComponent
INNER JOIN I_CostComponentView AS CostComponentView ON /* join condition not captured in parsed metadata */
;

Learn More