P_ActlCostgRunDetRsltTransDta

DDL: P_ACTLCOSTGRUNDETRSLTTRANSDTA Type: view_entity COMPOSITE Package: FCML4H_DISPLAY
55 Fields 2 Data Sources

Transactional Data

P_ActlCostgRunDetRsltTransDta is a Composite CDS View that provides data about "Transactional Data" in SAP S/4HANA. It reads from 2 data sources (P_ActlCostgRunTransWthoutMvtTp, P_ActlCostgTransaclWthMvtTpTxt) and exposes 55 fields with key fields CostEstimate, CurrencyRole, Ledger, MaterialLedgerCategory, ProcessCategory. Part of development package FCML4H_DISPLAY.

Data Sources (2)

SourceAliasJoin Type
P_ActlCostgRunTransWthoutMvtTp P_ActlCostgRunTransWthoutMvtTp union_all
P_ActlCostgTransaclWthMvtTpTxt P_ActlCostgTransaclWthMvtTpTxt from

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 (55)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate Cost EstimateNo
KEY CurrencyRole CurrencyRole Curr./Val. Type
KEY Ledger Ledger Ledger
KEY MaterialLedgerCategory MaterialLedgerCategory
KEY ProcessCategory ProcessCategory
KEY Material Material Vehicle Model
KEY ValuationArea ValuationArea Valuation Area
KEY InventoryValuationType InventoryValuationType Valuation Type
KEY SalesOrder SalesOrder SD Document
KEY SalesOrderItem SalesOrderItem Sales Order Item
KEY InventorySpecialStockType InventorySpecialStockType Special Stock Type
KEY WBSElementExternalID WBSElementExternalID WBS Element External ID
KEY Supplier Supplier Supplier
KEY MatlLdgrDocIsCostingRelevant MatlLdgrDocIsCostingRelevant
KEY ProcurementAlternative ProcurementAlternative
KEY ProductionProcess ProductionProcess
KEY MovementType MovementType Movement Type
KEY GLAccount GLAccount General Ledger
FiscalYearPeriod FiscalYearPeriod Period/Year
PriceDeterminationControl PriceDeterminationControl Price Determ.
GoodsMovementTypeName GoodsMovementTypeName
TotalVltdStockQuantity TotalVltdStockQuantity
ValuationQuantityUnit ValuationQuantityUnit
InventoryAmtInCCCrcy InventoryAmtInCCCrcy
PriceDiffAmtInDisplayCrcy PriceDiffAmtInDisplayCrcy
ExchRateDiffAmtInDspCurrency ExchRateDiffAmtInDspCurrency
P_CostingRunType
P_FiscalPeriod
P_FiscalYearkeyCostEstimate
KEY CurrencyRole CurrencyRole Curr./Val. Type
KEY Ledger Ledger Ledger
KEY MaterialLedgerCategory MaterialLedgerCategory
KEY ProcessCategory ProcessCategory
KEY Material Material Vehicle Model
KEY ValuationArea ValuationArea Valuation Area
KEY InventoryValuationType InventoryValuationType Valuation Type
KEY SalesOrder SalesOrder SD Document
KEY SalesOrderItem SalesOrderItem Sales Order Item
KEY InventorySpecialStockType InventorySpecialStockType Special Stock Type
KEY WBSElementExternalID WBSElementExternalID WBS Element External ID
KEY Supplier Supplier Supplier
KEY MatlLdgrDocIsCostingRelevant MatlLdgrDocIsCostingRelevant
KEY ProcurementAlternative ProcurementAlternative
KEY ProductionProcess ProductionProcess
KEY MovementType MovementType Movement Type
KEY GLAccount GLAccount General Ledger
FiscalYearPeriod FiscalYearPeriod Period/Year
PriceDeterminationControl PriceDeterminationControl Price Determ.
GoodsMovementTypeName
TotalVltdStockQuantity TotalVltdStockQuantity
ValuationQuantityUnit ValuationQuantityUnit
InventoryAmtInCCCrcy InventoryAmtInCCCrcy
PriceDiffAmtInDisplayCrcy PriceDiffAmtInDisplayCrcy
ExchRateDiffAmtInDspCurrency ExchRateDiffAmtInDspCurrency
Currency 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_ActlCostgRunDetRsltTransDta.
-- 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_ActlCostgRunDetRsltTransDta AS
SELECT
  CostEstimate,
  CurrencyRole,
  Ledger,
  MaterialLedgerCategory,
  ProcessCategory,
  Material,
  ValuationArea,
  InventoryValuationType,
  SalesOrder,
  SalesOrderItem,
  InventorySpecialStockType,
  WBSElementExternalID,
  Supplier,
  MatlLdgrDocIsCostingRelevant,
  ProcurementAlternative,
  ProductionProcess,
  MovementType,
  GLAccount,
  FiscalYearPeriod,
  PriceDeterminationControl,
  GoodsMovementTypeName,
  TotalVltdStockQuantity,
  ValuationQuantityUnit,
  InventoryAmtInCCCrcy,
  PriceDiffAmtInDisplayCrcy,
  ExchRateDiffAmtInDspCurrency,
  Currency AS P_CostingRunType,
  P_FiscalPeriod : $parameters.P_FiscalPeriod AS P_FiscalPeriod,
  Currency
FROM P_ActlCostgTransaclWthMvtTpTxt
-- UNION ALL with additional select branch(es): P_ActlCostgRunTransWthoutMvtTp
;

Learn More