R_CostEstPreparedItmznJob

DDL: R_COSTESTPREPAREDITMZNJOB Type: view_entity BASIC
6 Fields 1 Data Sources

Prepared Cost Estimate Itemization Job

R_CostEstPreparedItmznJob is a Basic CDS View that provides data about "Prepared Cost Estimate Itemization Job" in SAP S/4HANA. It reads from 1 data source (finplan_pcc_cehd) and exposes 6 fields with key fields CostEstPrepConfiguration, CostEstPrprdConfignJobDateTime.

Data Sources (1)

SourceAliasJoin Type
finplan_pcc_cehd finplan_pcc_cehd from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Prepared Cost Estimate Itemization Job view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CostEstPrepConfiguration confid Privacy Level
KEY CostEstPrprdConfignJobDateTime timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
CostEstPrprdConfignJobStatus status Workflow Status
CostEstPrepConfignNmbrOfItems no_of_items Number of Items
CostEstPrepConfignNmbrOfPlants no_of_plants
CostEstPrepConfignNmbrOfProds no_of_products

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 R_CostEstPreparedItmznJob.
-- 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 R_CostEstPreparedItmznJob AS
SELECT
  confid AS CostEstPrepConfiguration,
  timestamp AS CostEstPrprdConfignJobDateTime,
  status AS CostEstPrprdConfignJobStatus,
  no_of_items AS CostEstPrepConfignNmbrOfItems,
  no_of_plants AS CostEstPrepConfignNmbrOfPlants,
  no_of_products AS CostEstPrepConfignNmbrOfProds
FROM finplan_pcc_cehd
;

Learn More