SEPMRA_P_ALP_TotalSalesKPI

DDL: SEPMRA_P_ALP_TOTALSALESKPI Type: view Package: S_ODATA_EPMRA_SO_ANA
5 Fields 2 Data Sources

Fiori Ref Apps: KPI - Total Sales Revenue

SEPMRA_P_ALP_TotalSalesKPI is a CDS View that provides data about "Fiori Ref Apps: KPI - Total Sales Revenue" in SAP S/4HANA. It reads from 2 data sources (SEPMRA_I_SlsOrdItemCube, SEPMRA_I_CurrentUTCDate) and exposes 5 fields with key field CalendarMonth. Part of development package S_ODATA_EPMRA_SO_ANA.

Data Sources (2)

SourceAliasJoin Type
SEPMRA_I_SlsOrdItemCube Cube from
SEPMRA_I_CurrentUTCDate CurrentDate inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName SEPMRAPALPKPISAL view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CalendarMonth DeliveryCalendarMonth
_CalendarMonth _DeliveryCalendarMonth
NetAmount
Currency Currency Valuation Crcy
_Currency _Currency

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 SEPMRA_P_ALP_TotalSalesKPI.
-- 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 SEPMRA_P_ALP_TotalSalesKPI AS
SELECT
  DeliveryCalendarMonth AS CalendarMonth,
  cast( sum(Cube.NetAmount) as snwd_ttl_net_amount preserving type ) AS NetAmount,
  Currency
FROM SEPMRA_I_SlsOrdItemCube AS Cube
INNER JOIN SEPMRA_I_CurrentUTCDate AS CurrentDate ON /* join condition not captured in parsed metadata */
;

Learn More