A_CostEstPreparedItemization

DDL: A_COSTESTPREPAREDITEMIZATION Type: view_entity CONSUMPTION Package: ODATA_FINPLAN_COST_EST_ITEMS
34 Fields 2 Data Sources 1 OData Services

Prepared Cost Estimate Itemization

A_CostEstPreparedItemization is a Consumption CDS View that provides data about "Prepared Cost Estimate Itemization" in SAP S/4HANA. It reads from 2 data sources (R_CostEstPrprdConfignForImport, R_CostEstPreparedItemization) and exposes 34 fields with key fields CostEstPrepConfiguration, CostEstPrprdConfignRecord. It is exposed through 1 OData service (API_COSTESTPREPAREDITEMIZATION). Part of development package ODATA_FINPLAN_COST_EST_ITEMS.

Data Sources (2)

SourceAliasJoin Type
R_CostEstPrprdConfignForImport ConfignReady inner
R_CostEstPreparedItemization PrepItmzn from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Prepared Cost Estimate Itemization view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name CostEstPreparedItemization_Type view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.query.implementedBy ABAP:CL_FCOM_PCC_QRY_PRPR_ITMZN view

OData Services (1)

ServiceBindingVersionContractRelease
API_COSTESTPREPAREDITEMIZATION API_COSTESTPREPITEMIZATION V2 C2 NOT_RELEASED

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY CostEstPrepConfiguration R_CostEstPreparedItemization CostEstPrepConfiguration Privacy Level
KEY CostEstPrprdConfignRecord R_CostEstPreparedItemization CostEstPrprdConfignRecord Object GUID
ProdCostEstNumber R_CostEstPreparedItemization ProdCostEstNumber ProdCostEst.No.
CostingType R_CostEstPreparedItemization CostingType Costing Type
EstimatedCostCostingRunDate R_CostEstPreparedItemization EstimatedCostCostingRunDate Costing Date
CostingVersion R_CostEstPreparedItemization CostingVersion Costing Version
ValuationVariant R_CostEstPreparedItemization ValuationVariant Valuation Variant
CostComponentView R_CostEstPreparedItemization CostComponentView Cost Comp. View
CostingVariant R_CostEstPreparedItemization CostingVariant Costing Variant
CostEstimateStatus R_CostEstPreparedItemization CostEstimateStatus Costing Status
CostComponentStructure R_CostEstPreparedItemization CostComponentStructure Cost Comp. Str.
ValuationType R_CostEstPreparedItemization ValuationType Valuation Type
Plant R_CostEstPreparedItemization Plant Valuation Area
SoldProduct R_CostEstPreparedItemization SoldProduct Product Sold
ComponentPlant R_CostEstPreparedItemization ComponentPlant Plant
ComponentProduct R_CostEstPreparedItemization ComponentProduct Vehicle Model
ChartOfAccounts R_CostEstPreparedItemization ChartOfAccounts Node Class
GLAccount R_CostEstPreparedItemization GLAccount General Ledger
PartnerCostCenter R_CostEstPreparedItemization PartnerCostCenter Sender Cost Ctr
PartnerCostCtrActivityType R_CostEstPreparedItemization PartnerCostCtrActivityType Partner Cost Center Activity Type
ControllingArea R_CostEstPreparedItemization ControllingArea Controlling Area
ProfitCenter R_CostEstPreparedItemization ProfitCenter Profit Center
CompanyCode R_CostEstPreparedItemization CompanyCode Receiver Company Code
Ledger R_CostEstPreparedItemization Ledger Ledger
CostComponent R_CostEstPreparedItemization CostComponent Cost Component
ValuationQuantity R_CostEstPreparedItemization ValuationQuantity Value
ValuationQuantityUnit R_CostEstPreparedItemization ValuationQuantityUnit Valuation UoM
CostingLotSize R_CostEstPreparedItemization CostingLotSize Quantity
LotSizeUnit R_CostEstPreparedItemization LotSizeUnit Lot Size Unit
FixedVariableType R_CostEstPreparedItemization FixedVariableType Fixed Variable Type
AmountInGlobalCurrency R_CostEstPreparedItemization AmountInGlobalCurrency Amount in Global Currency
GlobalCurrency R_CostEstPreparedItemization GlobalCurrency GM Billing Element: Global Currency
AmountInCompanyCodeCurrency R_CostEstPreparedItemization AmountInCompanyCodeCurrency Local Crcy Amt
CompanyCodeCurrency R_CostEstPreparedItemization CompanyCodeCurrency Local Currency

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 A_CostEstPreparedItemization.
-- 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 A_CostEstPreparedItemization AS
SELECT
  PrepItmzn.CostEstPrepConfiguration AS CostEstPrepConfiguration,
  PrepItmzn.CostEstPrprdConfignRecord AS CostEstPrprdConfignRecord,
  PrepItmzn.ProdCostEstNumber AS ProdCostEstNumber,
  PrepItmzn.CostingType AS CostingType,
  PrepItmzn.EstimatedCostCostingRunDate AS EstimatedCostCostingRunDate,
  PrepItmzn.CostingVersion AS CostingVersion,
  PrepItmzn.ValuationVariant AS ValuationVariant,
  PrepItmzn.CostComponentView AS CostComponentView,
  PrepItmzn.CostingVariant AS CostingVariant,
  PrepItmzn.CostEstimateStatus AS CostEstimateStatus,
  PrepItmzn.CostComponentStructure AS CostComponentStructure,
  PrepItmzn.ValuationType AS ValuationType,
  PrepItmzn.Plant AS Plant,
  PrepItmzn.SoldProduct AS SoldProduct,
  PrepItmzn.ComponentPlant AS ComponentPlant,
  PrepItmzn.ComponentProduct AS ComponentProduct,
  PrepItmzn.ChartOfAccounts AS ChartOfAccounts,
  PrepItmzn.GLAccount AS GLAccount,
  PrepItmzn.PartnerCostCenter AS PartnerCostCenter,
  PrepItmzn.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  PrepItmzn.ControllingArea AS ControllingArea,
  PrepItmzn.ProfitCenter AS ProfitCenter,
  PrepItmzn.CompanyCode AS CompanyCode,
  PrepItmzn.Ledger AS Ledger,
  PrepItmzn.CostComponent AS CostComponent,
  PrepItmzn.ValuationQuantity AS ValuationQuantity,
  PrepItmzn.ValuationQuantityUnit AS ValuationQuantityUnit,
  PrepItmzn.CostingLotSize AS CostingLotSize,
  PrepItmzn.LotSizeUnit AS LotSizeUnit,
  PrepItmzn.FixedVariableType AS FixedVariableType,
  PrepItmzn.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  PrepItmzn.GlobalCurrency AS GlobalCurrency,
  PrepItmzn.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  PrepItmzn.CompanyCodeCurrency AS CompanyCodeCurrency
FROM R_CostEstPreparedItemization AS PrepItmzn
INNER JOIN R_CostEstPrprdConfignForImport AS ConfignReady ON /* join condition not captured in parsed metadata */
;

Learn More