P_ActlCostgRunDetRsltSetlDta

DDL: P_ACTLCOSTGRUNDETRSLTSETLDTA Type: view_entity COMPOSITE Package: FCML4H_DISPLAY
76 Fields 12 Data Sources

Actual Costing Settlement Data

P_ActlCostgRunDetRsltSetlDta is a Composite CDS View that provides data about "Actual Costing Settlement Data" in SAP S/4HANA. It reads from 12 data sources and exposes 76 fields with key fields CostEstimate, CurrencyRole, Ledger, MaterialLedgerCategory, ProcessCategory. Part of development package FCML4H_DISPLAY.

Data Sources (12)

SourceAliasJoin Type
P_MaterialLedgerCostingRun CostingRun inner
P_MaterialLedgerCostingRun CostingRun inner
P_MaterialLedgerCostingRun CostingRun inner
P_InvtryLdgrMatlLedgerDocument MatlLedgerDocument inner
P_InvtryLdgrMatlLedgerDocument MatlLedgerDocument inner
P_InvtryLdgrMatlLedgerDocument MatlLedgerDocument inner
P_MaterialLedgerHeaderData MatlLedgerHeaderData inner
P_MaterialLedgerHeaderData MatlLedgerHeaderData inner
P_MaterialLedgerHeaderData MatlLedgerHeaderData inner
P_MatLedgerCostingRunPerPeriod PerPeriod from
P_MatLedgerCostingRunPerPeriod PerPeriod union_all
P_MatLedgerCostingRunPerPeriod PerPeriod union_all

Parameters (3)

NameTypeDefault
P_CostingRunType ckml_run_type
P_FiscalPeriod fins_fiscalperiod
P_FiscalYear fis_gjahr_no_conv

Annotations (7)

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
Metadata.ignorePropagatedAnnotations true view

Fields (76)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate P_InvtryLdgrMatlLedgerDocument CostEstimate Cost EstimateNo
KEY CurrencyRole P_InvtryLdgrMatlLedgerDocument CurrencyRole Curr./Val. Type
KEY Ledger P_InvtryLdgrMatlLedgerDocument Ledger Ledger
KEY MaterialLedgerCategory P_InvtryLdgrMatlLedgerDocument MaterialLedgerCategory Category
KEY ProcessCategory P_InvtryLdgrMatlLedgerDocument ProcessCategory Visibility (I/E/V/C)
KEY Material P_MaterialLedgerHeaderData Material Vehicle Model
KEY ValuationArea P_MaterialLedgerHeaderData ValuationArea Valuation Area
KEY InventoryValuationType P_MaterialLedgerHeaderData InventoryValuationType Valuation Type
KEY SalesOrder P_MaterialLedgerHeaderData SalesOrder SD Document
KEY SalesOrderItem P_MaterialLedgerHeaderData SalesOrderItem Sales Order Item
KEY InventorySpecialStockType P_MaterialLedgerHeaderData InventorySpecialStockType Special Stock Type
KEY WBSElementExternalID
KEY Supplier P_MaterialLedgerHeaderData Supplier Supplier
KEY MatlLdgrDocIsCostingRelevant
KEY ProcurementAlternative P_InvtryLdgrMatlLedgerDocument ProcurementAlternative PrcrmntAlt/Proc
KEY ProductionProcess P_InvtryLdgrMatlLedgerDocument ProductionProcess Trans.
KEY MovementType
KEY GLAccount
FiscalYearPeriod P_InvtryLdgrMatlLedgerDocument FiscalYearPeriod Period/Year
PriceDeterminationControl P_MaterialLedgerHeaderData PriceDeterminationControl Price Determ.
TotalVltdStockQuantity
ValuationQuantityUnit P_InvtryLdgrMatlLedgerDocument ValuationQuantityUnit Valuation Unit
InventoryAmtInCCCrcy
PriceDiffAmtInDisplayCrcy
ExchRateDiffAmtInDspCurrency
CostEstimateasCostEstimate
KEY CurrencyRole P_InvtryLdgrMatlLedgerDocument CurrencyRole Curr./Val. Type
KEY Ledger P_InvtryLdgrMatlLedgerDocument Ledger Ledger
KEY MaterialLedgerCategory P_InvtryLdgrMatlLedgerDocument MaterialLedgerCategory Category
KEY ProcessCategory P_InvtryLdgrMatlLedgerDocument ProcessCategory Visibility (I/E/V/C)
KEY Material P_MaterialLedgerHeaderData Material Vehicle Model
KEY ValuationArea P_MaterialLedgerHeaderData ValuationArea Valuation Area
KEY InventoryValuationType P_MaterialLedgerHeaderData InventoryValuationType Valuation Type
KEY SalesOrder P_MaterialLedgerHeaderData SalesOrder SD Document
KEY SalesOrderItem P_MaterialLedgerHeaderData SalesOrderItem Sales Order Item
KEY InventorySpecialStockType P_MaterialLedgerHeaderData InventorySpecialStockType Special Stock Type
KEY WBSElementExternalID
KEY Supplier P_MaterialLedgerHeaderData Supplier Supplier
KEY MatlLdgrDocIsCostingRelevant
KEY ProcurementAlternative P_InvtryLdgrMatlLedgerDocument ProcurementAlternative PrcrmntAlt/Proc
KEY ProductionProcess P_InvtryLdgrMatlLedgerDocument ProductionProcess Trans.
KEY MovementType
KEY GLAccount
FiscalYearPeriod P_InvtryLdgrMatlLedgerDocument FiscalYearPeriod Period/Year
PriceDeterminationControl P_MaterialLedgerHeaderData PriceDeterminationControl Price Determ.
TotalVltdStockQuantity
ValuationQuantityUnit P_InvtryLdgrMatlLedgerDocument ValuationQuantityUnit Valuation Unit
InventoryAmtInCCCrcy
PriceDiffAmtInDisplayCrcy
ExchRateDiffAmtInDspCurrency
CostEstimateasCostEstimate
KEY CurrencyRole P_InvtryLdgrMatlLedgerDocument CurrencyRole Curr./Val. Type
KEY Ledger P_InvtryLdgrMatlLedgerDocument Ledger Ledger
KEY MaterialLedgerCategory P_InvtryLdgrMatlLedgerDocument MaterialLedgerCategory Category
KEY ProcessCategory P_InvtryLdgrMatlLedgerDocument ProcessCategory Visibility (I/E/V/C)
KEY Material P_MaterialLedgerHeaderData Material Vehicle Model
KEY ValuationArea P_MaterialLedgerHeaderData ValuationArea Valuation Area
KEY InventoryValuationType P_MaterialLedgerHeaderData InventoryValuationType Valuation Type
KEY SalesOrder P_MaterialLedgerHeaderData SalesOrder SD Document
KEY SalesOrderItem P_MaterialLedgerHeaderData SalesOrderItem Sales Order Item
KEY InventorySpecialStockType P_MaterialLedgerHeaderData InventorySpecialStockType Special Stock Type
KEY WBSElementExternalID
KEY Supplier P_MaterialLedgerHeaderData Supplier Supplier
KEY MatlLdgrDocIsCostingRelevant
KEY ProcurementAlternative P_InvtryLdgrMatlLedgerDocument ProcurementAlternative PrcrmntAlt/Proc
KEY ProductionProcess P_InvtryLdgrMatlLedgerDocument ProductionProcess Trans.
KEY MovementType
KEY GLAccount
FiscalYearPeriod P_InvtryLdgrMatlLedgerDocument FiscalYearPeriod Period/Year
PriceDeterminationControl P_MaterialLedgerHeaderData PriceDeterminationControl Price Determ.
TotalVltdStockQuantity
ValuationQuantityUnit P_InvtryLdgrMatlLedgerDocument ValuationQuantityUnit Valuation Unit
InventoryAmtInCCCrcy
PriceDiffAmtInDisplayCrcy
ExchRateDiffAmtInDspCurrency
Currency P_InvtryLdgrMatlLedgerDocument Currency Valuation Crcy

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_ActlCostgRunDetRsltSetlDta.
-- 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_ActlCostgRunDetRsltSetlDta AS
SELECT
  MatlLedgerDocument.CostEstimate AS CostEstimate,
  MatlLedgerDocument.CurrencyRole AS CurrencyRole,
  MatlLedgerDocument.Ledger AS Ledger,
  MatlLedgerDocument.MaterialLedgerCategory AS MaterialLedgerCategory,
  MatlLedgerDocument.ProcessCategory AS ProcessCategory,
  MatlLedgerHeaderData.Material AS Material,
  MatlLedgerHeaderData.ValuationArea AS ValuationArea,
  MatlLedgerHeaderData.InventoryValuationType AS InventoryValuationType,
  MatlLedgerHeaderData.SalesOrder AS SalesOrder,
  MatlLedgerHeaderData.SalesOrderItem AS SalesOrderItem,
  MatlLedgerHeaderData.InventorySpecialStockType AS InventorySpecialStockType,
  MatlLedgerHeaderData._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  MatlLedgerHeaderData.Supplier AS Supplier,
  cast ( 'X' as ml4h_xabr preserving type ) AS MatlLdgrDocIsCostingRelevant,
  MatlLedgerDocument.ProcurementAlternative AS ProcurementAlternative,
  MatlLedgerDocument.ProductionProcess AS ProductionProcess,
  cast ( ' ' as mmim_movement_type preserving type ) AS MovementType,
  cast ( CnsmpnAltv.ActiveGLAccount as saknr preserving type ) AS GLAccount,
  MatlLedgerDocument.FiscalYearPeriod AS FiscalYearPeriod,
  MatlLedgerHeaderData.PriceDeterminationControl AS PriceDeterminationControl,
  cast( 0 as ml4h_quantity ) AS TotalVltdStockQuantity,
  MatlLedgerDocument.ValuationQuantityUnit AS ValuationQuantityUnit,
  sum(MatlLedgerDocument.InventoryAmtInCCCrcy) AS InventoryAmtInCCCrcy,
  sum(MatlLedgerDocument.PriceDiffAmtInDisplayCrcy) AS PriceDiffAmtInDisplayCrcy,
  sum(MatlLedgerDocument.ExchRateDiffAmtInDspCurrency) AS ExchRateDiffAmtInDspCurrency,
  MatlLedgerDocument.Currency as Currency AS CostEstimateasCostEstimate,
  MatlLedgerDocument.Currency AS Currency
FROM P_MatLedgerCostingRunPerPeriod AS PerPeriod
INNER JOIN P_MaterialLedgerCostingRun AS CostingRun ON /* join condition not captured in parsed metadata */
INNER JOIN P_InvtryLdgrMatlLedgerDocument AS MatlLedgerDocument ON /* join condition not captured in parsed metadata */
INNER JOIN P_MaterialLedgerHeaderData AS MatlLedgerHeaderData ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_MatLedgerCostingRunPerPeriod
;

Learn More