P_ActlCostgRunRsltTransaclDta

DDL: P_ACTLCOSTGRUNRSLTTRANSACLDTA Type: view_entity COMPOSITE Package: FCML4H_DISPLAY
19 Fields 4 Data Sources

Transactional data

P_ActlCostgRunRsltTransaclDta is a Composite CDS View that provides data about "Transactional data" in SAP S/4HANA. It reads from 4 data sources (P_MaterialLedgerCostingRun, P_InvtryLdgrMatlLedgerDocument, P_MaterialLedgerHeaderData, P_MatLedgerCostingRunPerPeriod) and exposes 19 fields with key fields CostEstimate, CurrencyRole, Ledger, MaterialLedgerCategory, ProcessCategory. Part of development package FCML4H_DISPLAY.

Data Sources (4)

SourceAliasJoin Type
P_MaterialLedgerCostingRun CostingRun inner
P_InvtryLdgrMatlLedgerDocument MatlLedgerDocument inner
P_MaterialLedgerHeaderData MatlLedgerHeaderData inner
P_MatLedgerCostingRunPerPeriod PerPeriod 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 (19)

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
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_ActlCostgRunRsltTransaclDta.
-- 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_ActlCostgRunRsltTransaclDta 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,
  sum(MatlLedgerDocument.TotalVltdStockQuantity) 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
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 */
;

Learn More