P_ActualCostingRunResult

DDL: P_ACTUALCOSTINGRUNRESULT Type: view_entity COMPOSITE Package: FCML4H_DISPLAY
22 Fields 1 Data Sources

Actual Costing Run Result

P_ActualCostingRunResult is a Composite CDS View that provides data about "Actual Costing Run Result" in SAP S/4HANA. It reads from 1 data source (P_ActlCostgRunRsltAggregation) and exposes 22 fields with key fields CostEstimate, CurrencyRole, Ledger, MaterialLedgerCategory, ProcessCategory. Part of development package FCML4H_DISPLAY.

Data Sources (1)

SourceAliasJoin Type
P_ActlCostgRunRsltAggregation P_ActlCostgRunRsltAggregation from

Parameters (3)

NameTypeDefault
P_CostingRunType ckml_run_type
P_FiscalPeriod fins_fiscalperiod
P_FiscalYear fis_gjahr_no_conv

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate Cost EstimateNo
KEY CurrencyRole CurrencyRole Curr./Val. Type
KEY Ledger Ledger Ledger
KEY MaterialLedgerCategory
KEY ProcessCategory
ValuationArea ValuationArea Valuation Area
Material Material Vehicle Model
InventoryValuationType InventoryValuationType Valuation Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
InventorySpecialStockType InventorySpecialStockType Special Stock Type
WBSElementExternalID WBSElementExternalID WBS Element External ID
Supplier Supplier Supplier
TotalVltdStockQuantity
ValuationQuantityUnit
InventoryAmtInDspCrcy
InvtryTransacAmtInDisplayCrcy
PriceDiffAmtInDisplayCrcy
ExchRateDiffAmtInDspCurrency
Currency Currency Valuation Crcy
CompanyCode P_ActlCostgRunRsltAggregation CompanyCode Receiver Company Code
ControllingArea ControllingArea Controlling Area

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_ActualCostingRunResult.
-- 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.
-- Parameters: P_CostingRunType : ckml_run_type, P_FiscalPeriod : fins_fiscalperiod, P_FiscalYear : fis_gjahr_no_conv

CREATE VIEW P_ActualCostingRunResult AS
SELECT
  CostEstimate,
  CurrencyRole,
  Ledger,
  cast( MaterialLedgerCategory as fml_material_ledger_category preserving type ) AS MaterialLedgerCategory,
  cast( ProcessCategory as fml_process_category preserving type ) AS ProcessCategory,
  ValuationArea,
  Material,
  InventoryValuationType,
  SalesOrder,
  SalesOrderItem,
  InventorySpecialStockType,
  WBSElementExternalID,
  Supplier,
  sum(TotalVltdStockQuantity) AS TotalVltdStockQuantity,
  cast( ValuationQuantityUnit as ml4h_meins preserving type ) AS ValuationQuantityUnit,
  ( sum(InvtryTransacAmtInDisplayCrcy) + sum(PriceDiffAmtInDisplayCrcy) + sum(ExchRateDiffAmtInDspCurrency) ) AS InventoryAmtInDspCrcy,
  sum(InvtryTransacAmtInDisplayCrcy) AS InvtryTransacAmtInDisplayCrcy,
  sum(PriceDiffAmtInDisplayCrcy) AS PriceDiffAmtInDisplayCrcy,
  sum(ExchRateDiffAmtInDspCurrency) AS ExchRateDiffAmtInDspCurrency,
  Currency,
  P_ActlCostgRunRsltAggregation.CompanyCode AS CompanyCode,
  ControllingArea
FROM P_ActlCostgRunRsltAggregation
;

Learn More