P_MaterialCostEstCostingRun

DDL: P_MATERIALCOSTESTCOSTINGRUN SQL: PMATESTCOSTRUN Type: view BASIC
15 Fields 1 Data Sources

P_MaterialCostEstCostingRun is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (kala) and exposes 15 fields with key fields EstimatedCostCostingRun, EstimatedCostCostingRunDate, CostingVersion.

Data Sources (1)

SourceAliasJoin Type
kala kala from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMATESTCOSTRUN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view
VDM.private true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY EstimatedCostCostingRun kala kalaid Costing Run
KEY EstimatedCostCostingRunDate kala kaladat Cstg Run Date
KEY CostingVersion kala tvers Costing Version
CostingRunStatus kala feh_status Costing Status
CostEstimateValidityStartDate kala kadat Cstg Date From
MaterialValuationDate kala bwdat Valuation Date
QuantityStructureDate kala aldat Qty Struc. Date
CostEstimateValidityEndDate kala bidat Costing Date To
CostingVariant kala klvaf Costing Variant
CostingType kala kalka Costing Type
CompanyCode kala bukrs Value
ControllingArea kala kokrs Org. Value
CreatedByUser kala erfnm Created By
CreationDate kala cpudt Imported On
CostEstimateTransferControl kala uebid Transfer Control

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_MaterialCostEstCostingRun.
-- 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.
-- SQL view name: PMATESTCOSTRUN

CREATE VIEW P_MaterialCostEstCostingRun AS
SELECT
  kala.kalaid AS EstimatedCostCostingRun,
  kala.kaladat AS EstimatedCostCostingRunDate,
  kala.tvers AS CostingVersion,
  kala.feh_status AS CostingRunStatus,
  kala.kadat AS CostEstimateValidityStartDate,
  kala.bwdat AS MaterialValuationDate,
  kala.aldat AS QuantityStructureDate,
  kala.bidat AS CostEstimateValidityEndDate,
  kala.klvaf AS CostingVariant,
  kala.kalka AS CostingType,
  kala.bukrs AS CompanyCode,
  kala.kokrs AS ControllingArea,
  kala.erfnm AS CreatedByUser,
  kala.cpudt AS CreationDate,
  kala.uebid AS CostEstimateTransferControl
FROM kala
;

Learn More