I_SalesDocumentCostEstimate

DDL: I_SALESDOCUMENTCOSTESTIMATE Type: view_entity BASIC Package: FINS_PCP_COSTEST
61 Fields 1 Data Sources 10 Associations

Sales Document Cost Estimate

I_SalesDocumentCostEstimate is a Basic CDS View (Fact) that provides data about "Sales Document Cost Estimate" in SAP S/4HANA. It reads from 1 data source (P_KEKO) and exposes 61 fields with key fields CostingReferenceObject, CostEstimate, CostingType, CostingDate, CostingVersion. It has 10 associations to related views. Part of development package FINS_PCP_COSTEST.

Data Sources (1)

SourceAliasJoin Type
P_KEKO P_KEKO from

Associations (10)

CardinalityTargetAliasCondition
[0..*] I_SalesDocCostEstimateItem _SalesDocCostEstimateItem $projection.CostingReferenceObject = _SalesDocCostEstimateItem.CostingReferenceObject and $projection.CostEstimate = _SalesDocCostEstimateItem.CostEstimate and $projection.CostingType = _SalesDocCostEstimateItem.CostingType and $projection.CostingDate = _SalesDocCostEstimateItem.CostingDate and $projection.CostingVersion = _SalesDocCostEstimateItem.CostingVersion and $projection.ValuationVariant = _SalesDocCostEstimateItem.ValuationVariant and $projection.CostIsEnteredManually = _SalesDocCostEstimateItem.CostIsEnteredManually
[1..1] I_Product _Product $projection.Product = _Product.Product
[0..1] I_Currency _ControllingAreaCurrency $projection.ControllingAreaCurrency = _ControllingAreaCurrency.Currency
[0..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
[1..1] I_CostingType _CostingType $projection.CostingType = _CostingType.CostingType
[0..1] I_CostingVersion _CostingVersion $projection.CostingVersion = _CostingVersion.CostingVersion and $projection.CostingType = _CostingVersion.CostingType and $projection.ValuationVariant = _CostingVersion.ValuationVariant
[1..1] I_CostingVariant _CostingVariant $projection.CostingVariant = _CostingVariant.CostingVariant
[1..1] I_CostingValuationVariant _ValuationVariant $projection.ValuationVariant = _ValuationVariant.ValuationVariant
[1..1] I_ValuationArea _ValuationArea $projection.ValuationArea = _ValuationArea.ValuationArea
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.ValuationQuantityUnit = _UnitOfMeasure.UnitOfMeasure

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #FACT view
Analytics.internalName #LOCAL view
EndUserText.label Sales Document Cost Estimate view
Metadata.ignorePropagatedAnnotations true view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY CostingReferenceObject CostingReferenceObject Reference Obj.
KEY CostEstimate CostEstimate Cost EstimateNo
KEY CostingType CostingType Costing Type
KEY CostingDate CostingDate Costing Date
KEY CostingVersion CostingVersion Costing Version
KEY ValuationVariant ValuationVariant Valuation Variant
KEY CostIsEnteredManually CostIsEnteredManually Additive Costs
Product Product Product Sold
ValuationType ValuationType Valuation Type
CostingVariant CostingVariant Costing Variant
ControllingArea ControllingArea Controlling Area
Plant Plant Valuation Area
ValuationArea ValuationArea Valuation Area
CompanyCode _ValuationArea CompanyCode Receiver Company Code
Ledger Ledger Ledger
ProfitCenter ProfitCenter Profit Center
CostEstimateValidityStartDate CostEstimateValidityStartDate Cstg Date From
CostEstimateValidityEndDate CostEstimateValidityEndDate Costing Date To
ProductValuationDate ValuationDate Valuation Date
QuantityStructureDate QuantityStructureDate Qty Struc. Date
CostingLotSize CostingLotSize Cstg Lot Size
ValuationQuantityUnit ValuationQuantityUnit Valuation Unit
CostEstimateCreationDate CostEstimateCreationDate Imported On
CostEstimateStatus CostEstimateStatus Costing Status
ProductionVersion ProductionVersion Version ID
ProductValuationStrategy ProductValuationStrategy Material Vltn
ProductValnPurgInfoRecdStrgy ProductValnPurgInfoRecdStrgy Substr.InfoRec.
PostingPeriod PostingPeriod Posting Period
PostingFiscalYear PostingFiscalYear Fiscal Year
CostingItemIsProductComp CostingItemIsProductComp Material Comp.
CostEstimateTransferControl CostEstimateTransferControl Transfer Control
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
CostComponentStructure CostComponentStructure Reserve
BillOfMaterial BillOfMaterial BOM
ProductBOMUsage ProductBOMUsage Usage
AlternativeBillOfMaterial AlternativeBillOfMaterial Alternative
TaskListGroup TaskListGroup Group
AuxiliaryCostCompStructure AuxiliaryCostCompStructure
TaskListType TaskListType Task List Type
TaskListGroupCounter TaskListGroupCounter Group Counter
SpecialProcurementType SpecialProcurementType SpecProcurement
ProductProcurementType ProductProcurementType Spec. procuremt
SpecialProcurementPlant SpecialProcurementPlant SpclPrcmntPlant
CostingSheet CostingSheet Costing Sheet
CostingOverheadGroup CostingOverheadGroup Overhead Group
CostingOverhead CostingOverhead Overhead key
ConfiguredProduct ConfiguredProduct Worklist Type
CostEstimateCostingLevel CostEstimateCostingLevel Costing Level
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ControllingAreaCurrency ControllingAreaCurrency
_SalesDocCostEstimateItem _SalesDocCostEstimateItem
_Product _Product
_ControllingAreaCurrency _ControllingAreaCurrency
_CompanyCodeCurrency _CompanyCodeCurrency
_CostingType _CostingType
_CostingVersion _CostingVersion
_CostingVariant _CostingVariant
_ValuationVariant _ValuationVariant
_ValuationArea _ValuationArea
_UnitOfMeasure _UnitOfMeasure

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_SalesDocumentCostEstimate.
-- 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_SalesDocumentCostEstimate AS
SELECT
  CostingReferenceObject,
  CostEstimate,
  CostingType,
  CostingDate,
  CostingVersion,
  ValuationVariant,
  CostIsEnteredManually,
  Product,
  ValuationType,
  CostingVariant,
  ControllingArea,
  Plant,
  ValuationArea,
  _ValuationArea.CompanyCode AS CompanyCode,
  Ledger,
  ProfitCenter,
  CostEstimateValidityStartDate,
  CostEstimateValidityEndDate,
  ValuationDate AS ProductValuationDate,
  QuantityStructureDate,
  CostingLotSize,
  ValuationQuantityUnit,
  CostEstimateCreationDate,
  CostEstimateStatus,
  ProductionVersion,
  ProductValuationStrategy,
  ProductValnPurgInfoRecdStrgy,
  PostingPeriod,
  PostingFiscalYear,
  CostingItemIsProductComp,
  CostEstimateTransferControl,
  SalesDocument,
  SalesDocumentItem,
  CostComponentStructure,
  BillOfMaterial,
  ProductBOMUsage,
  AlternativeBillOfMaterial,
  TaskListGroup,
  AuxiliaryCostCompStructure,
  TaskListType,
  TaskListGroupCounter,
  SpecialProcurementType,
  ProductProcurementType,
  SpecialProcurementPlant,
  CostingSheet,
  CostingOverheadGroup,
  CostingOverhead,
  ConfiguredProduct,
  CostEstimateCostingLevel,
  CompanyCodeCurrency,
  ControllingAreaCurrency
FROM P_KEKO
LEFT OUTER JOIN I_SalesDocCostEstimateItem AS _SalesDocCostEstimateItem ON CostingReferenceObject = _SalesDocCostEstimateItem.CostingReferenceObject AND CostEstimate = _SalesDocCostEstimateItem.CostEstimate AND CostingType = _SalesDocCostEstimateItem.CostingType AND CostingDate = _SalesDocCostEstimateItem.CostingDate AND CostingVersion = _SalesDocCostEstimateItem.CostingVersion AND ValuationVariant = _SalesDocCostEstimateItem.ValuationVariant AND CostIsEnteredManually = _SalesDocCostEstimateItem.CostIsEnteredManually  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _ControllingAreaCurrency ON ControllingAreaCurrency = _ControllingAreaCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CostingType AS _CostingType ON CostingType = _CostingType.CostingType  -- association [1..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_CostingVariant AS _CostingVariant ON CostingVariant = _CostingVariant.CostingVariant  -- association [1..1]
LEFT OUTER JOIN I_CostingValuationVariant AS _ValuationVariant ON ValuationVariant = _ValuationVariant.ValuationVariant  -- association [1..1]
LEFT OUTER JOIN I_ValuationArea AS _ValuationArea ON ValuationArea = _ValuationArea.ValuationArea  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON ValuationQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;

Learn More