P_ActualCostRateDEX

DDL: P_ACTUALCOSTRATEDEX Type: view_entity BASIC Package: RAP_FIN_CO_COST_RATE
22 Fields 1 Data Sources

Data Extraction for Actual Cost Rate - Private

P_ActualCostRateDEX is a Basic CDS View that provides data about "Data Extraction for Actual Cost Rate - Private" in SAP S/4HANA. It reads from 1 data source (accostrate) and exposes 22 fields with key field AccountingCostRateUUID. Part of development package RAP_FIN_CO_COST_RATE.

Data Sources (1)

SourceAliasJoin Type
accostrate accostrate from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY AccountingCostRateUUID rateuuid Cost Rate UUID
CurrencyRole cvtyp Crcy/Valuation
Ledger ledger Ledger
CompanyCode bukrs Value
CostCenter kostl Substitute CC
ActivityType activity_type Inward/Outward Acty
ValidityStartFiscalYear gjahrfrom From Year
ValidityStartFiscalPeriod periodfrom From Period
ValidityStartDate datefrom Valid From
ValidityEndFiscalYear gjahrto Year To
ValidityEndFiscalPeriod periodto To Period
ValidityEndDate dateto Valid-To Date
ControllingArea kokrs Org. Value
Currency currency Valuation Crcy
CostRateTotalAmount totalamount Total Rate
CostRateFixedAmount fixedamount Fixed Rate
CostRateVarblAmount
CostRateScaleFactor scalefactor Per
CostCtrActivityTypeQtyUnit activity_unit Activity Unit
PlanningCategory category Violation Category
BusinessTransactionType bttype Business Transaction Type
ComponentBreakdown ucb_id Breakdown ID

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_ActualCostRateDEX.
-- 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.

CREATE VIEW P_ActualCostRateDEX AS
SELECT
  rateuuid AS AccountingCostRateUUID,
  cvtyp AS CurrencyRole,
  Ledger,
  bukrs AS CompanyCode,
  kostl AS CostCenter,
  activity_type AS ActivityType,
  gjahrfrom AS ValidityStartFiscalYear,
  periodfrom AS ValidityStartFiscalPeriod,
  datefrom AS ValidityStartDate,
  gjahrto AS ValidityEndFiscalYear,
  periodto AS ValidityEndFiscalPeriod,
  dateto AS ValidityEndDate,
  kokrs AS ControllingArea,
  Currency,
  totalamount AS CostRateTotalAmount,
  fixedamount AS CostRateFixedAmount,
  cast( totalamount - fixedamount as fco_rate_varbl_amount ) AS CostRateVarblAmount,
  scalefactor AS CostRateScaleFactor,
  activity_unit AS CostCtrActivityTypeQtyUnit,
  category AS PlanningCategory,
  bttype AS BusinessTransactionType,
  ucb_id AS ComponentBreakdown
FROM accostrate
;

Learn More